SQL error
 

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

In member.php line 553 find this

replace with this

Thanks Chuck.

have a good weekend.

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

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

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

Enjoy the rest of your weekend