PhotoPost Community - View Single Post

drare · May 3rd, 2009, 03:41 AM

Chuck,

I just turned on my computer and mailbox, I've got 19 emails with this error: An error was encountered during execution of the query:

SELECT photo,comment FROM pp_comments WHERE userid= AND comment != '' ORDER BY date DESC 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 'AND comment != '' ORDER BY date DESC LIMIT 1' at line 1

Is this something like the other, but how can it be I get this now and I've never got it before? I know my hoster, Midphase, have done a MySQL software update last week.

Thanks

May 3rd, 2009, 03:41 AM	#5 (permalink)
drare Member Verified Customer Join Date: Feb 2009 Location: Holland Posts: 116	Chuck, I just turned on my computer and mailbox, I've got 19 emails with this error: An error was encountered during execution of the query: SELECT photo,comment FROM pp_comments WHERE userid= AND comment != '' ORDER BY date DESC 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 'AND comment != '' ORDER BY date DESC LIMIT 1' at line 1 Is this something like the other, but how can it be I get this now and I've never got it before? I know my hoster, Midphase, have done a MySQL software update last week. Thanks