SQL Error

cookie · February 11th, 2009, 10:51 AM

Today i'm getting some emails about an error in the MySQL.

Never had errors like this.

What do i need to do?

An error was encountered during execution of the query:

SELECT bigimage,approved,cat,storecat,title,userid,width,height,date,filesize,rating,views,user FROM pp_photos WHERE id= LIMIT 1

The query returned with an errorcode of:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

If you need assistence or feel this is a 'bug'; please report it to our support forums at: Photopost Pro Bug Reports - PhotoPost Community

To turn off these emails, set $debug=0 in your config-inc.php file

Chuck S · February 11th, 2009, 01:10 PM

In comshow.php try changing the query line to this

Code:

Content visible to verified customers only.

cookie · February 12th, 2009, 08:43 AM

Yeah, that works.

Thank you for your time and great support.

Chuck S · February 12th, 2009, 09:29 AM

have a great day.