Syntax errors

[Marshal Halloway]

Several syntax errors came in today.

SELECT p.id,p.user,p.userid,p.cat,p.title,p.bigimage,p.views FROM cp_products p
LEFT JOIN cp_favorites f ON (f.product=p.id)
WHERE p.approved=1 AND f.userid=

ORDER BY date DESC
LIMIT 30

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 'ORDER BY date DESC
LIMIT 30' at line 5

SELECT msgid,datestamp,message,type,product FROM cp_messages WHERE userid= AND status=0 ORDER BY datestamp DESC LIMIT 15

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 status=0 ORDER BY datestamp DESC LIMIT 15' at line 1

SELECT userid,username,title,signature,avatar,usergroupid,homepage,icq,aim,yahoo,joindate,posts,birthday,location,interests,occupation,bio,offset FROM cp_users WHERE userid= 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

[Chuck S]

1. That error is on the recent products block a favorites case although I dont know how that would be triggered so might have to look and see how that case is called

2. The second one is in member.php and again your userid variable is empty just like the first error. My suggestion although again maybe its a bot doing it I would suggest in member.php line 518 this line making it this encapsulating the $uid variable just so it does not throw an error if its 0

Content visible to verified customers only.

3. Same thing line 355 in member.php try making the line this

Content visible to verified customers only.