Print Page - Database query error

Title: Database query error
Post by: Bazzah on January 19, 2007, 04:45:13 PM

I recently noticed that when listing images in a SUB category by last uploaded or last commented, you were unable to click the thumbnail to view the intermediate image, as you would get the following error:

Fatal error: Call to undefined function: db_query() in /home/hiresco1/public_html/gallery/displayimage.php on line 259

I don't know anything about php, so I messed around to try and get it working. After removing line 257:

$res = db_query("SELECT COUNT(*) FROM {$CONFIG['TABLE_COMMENTS']} WHERE pid='{$CURRENT_PIC_DATA['pid']}' AND author_id = ".USER_ID);

it worked perfectly. Obviously I am a bit concerned about removing code, as I do not know what else it will affect. Can anyone help me?

Title: Re: Database query error
Post by: Nibbler on January 19, 2007, 04:56:49 PM

That is 1.3 code. Why is it in your 1.4 gallery? Replace displayimage.php with a clean copy from the download package.

Title: Re: Database query error
Post by: Bazzah on January 19, 2007, 07:57:18 PM

Thanks for the reply. I have no idea why it is in there. I will replace it. Thanks

Title: Re: Database query error
Post by: Bazzah on January 19, 2007, 08:00:04 PM

;D Thanks. Works perfectly now!

Title: Re: Database query error
Post by: Nibbler on January 20, 2007, 02:17:16 AM

If you updated your gallery from 1.3 to 1.4 then there may be other old files, use versioncheck.php.

coppermine-gallery.com/forum

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Bazzah on January 19, 2007, 04:45:13 PM