SQL error

drare · May 1st, 2009, 03:48 AM

Today I got a lot of SQL errors and I don't know what it means and what to do, should I ignore these? Are they essential? Please advise.

An error was encountered during execution of the query:

SELECT p.id,p.title,p.userid,p.cat,p.approved,p.storecat,p.bigimage FROM pp_photos p LEFT JOIN pp_categories c ON p.cat=c.id WHERE p.userid= AND c.password='' ORDER BY p.date DESC LIMIT 5

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 c.password='' ORDER BY p.date DESC LIMIT 5' at line 1

Chuck S · May 1st, 2009, 08:20 AM

In member.php line 553 find this

Code:

Content visible to verified customers only.

replace with this

Code:

Content visible to verified customers only.

drare · May 1st, 2009, 08:49 AM

Thanks Chuck.

Chuck S · May 1st, 2009, 08:53 AM

have a good weekend.

drare · May 3rd, 2009, 02: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

Chuck S · May 3rd, 2009, 06:38 AM

Make sure the row noted below is this in member.php

Code:

Content visible to verified customers only.

drare · May 3rd, 2009, 08:12 AM

Thanks again Chuck, I replaced the line in member.php should be working because the other is not giving any errors anymore.

Have a nice day.
Gerard

Chuck S · May 3rd, 2009, 08:28 PM

Enjoy the rest of your weekend