Author Topic: db_mysql and double comment post error!!  (Read 4312 times)

0 Members and 1 Guest are viewing this topic.

Offline Legendary

  • Newbie
  • *
  • Posts: 24
    • View Profile
    • http://www.idols-unlimited.com
db_mysql and double comment post error!!
« on: July 09, 2005, 03:47:37 AM »
Hey, I'm not sure this falls under but I'm guessing most of the trouble shooting are here.  Anyhow, I'm running 1.71 and I'm having problem with the comment system.  I don't really know when this error started since someone just told me about two days ago.

If you go to my gallery: LINK TO GALLERY

and comment on any of the images in the gallery

You'll get this error:

Code: [Select]
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/idolsunl/public_html/includes/db_mysql.php on line 92

Where line 92 is this:
Code: [Select]
  function fetch_array($query_id = -1, $assoc = 0) {
    if ($query_id != -1) {
      $this->query_id = $query_id;
    }
    if ($this->query_id) {
      // BOTTOM IS THE LINE 92
      return ($assoc) ? mysql_fetch_assoc($this->query_id) : mysql_fetch_array($this->query_id);
    }
  }

Also, if you scroll down to the comment, you will see that there are two post instead of one.

Thanks for reading and any help would be appreciated..

Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: db_mysql and double comment post error!!
« Reply #1 on: July 09, 2005, 05:21:05 AM »
did u change anything in details.php?
if u did, try to restore your backups or replace details.php with a fresh one and see if it still shows the error.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)

Offline Legendary

  • Newbie
  • *
  • Posts: 24
    • View Profile
    • http://www.idols-unlimited.com
Re: db_mysql and double comment post error!!
« Reply #2 on: July 14, 2005, 09:07:50 PM »
I changed the details.php page, but I'm still getting the db_mysql error and the double posting. 


Offline V@no

  • If you don't tell me what to do, I won't tell you where you should go :)
  • Global Moderator
  • 4images Guru
  • *****
  • Posts: 17.849
  • mmm PHP...
    • View Profile
    • 4images MODs Demo
Re: db_mysql and double comment post error!!
« Reply #3 on: July 15, 2005, 12:23:39 AM »
* V@no found it hard to belive that with a fresh details.php it does the same thing.
Your first three "must do" before you ask a question:
Please do not PM me asking for help unless you've been specifically asked to do so. Such PMs will be deleted without answer. (forum rule #6)
Extension for Firefox/Thunderbird: Master Password+    Back/Forward History Tweaks (restartless)    Cookies Manager+    Fit Images (restartless for Thunderbird)