Getting SQL errors since upgrading

Hey,

I'm getting a lot of MySQL syntax errors since I upgraded to 1.3.9h. These are errors that weren't there when I used 1.3.9f.

Examples:

 
1064 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 r.`reviews_rating` DESC' at line 3
in:
[SELECT r.`reviews_rating` FROM reviews r WHERE r.`status` = 1 AND r.`products_id` = ORDER BY r.`reviews_rating` DESC]

1064 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 '' at line 1
in:
[select p.products_id,p.products_image,pd.products_name from products p, products_description pd where p.`products_id`=pd.`products_id` AND p.products_status =1 AND master_categories_id = ]

Can anyone tell me what I can do about this?

• Sorry, can't provide you with a link, as the website is under construction and still offline -

What debug errors are you seeing in the /cache directory? :unsure:

Those SQL errors both indicate that you're sending blank product numbers to the database.
Seems like something wrong in customized code or maybe a bad addon.

That's really strange, because it worked(partially, never got it entirely working) on 1.3.9f and originally came from 1.3.8a(fully operational.

As for the cache, it's empty, as there aren't any debug files created for MySQL errors.

Haven't got a clue of what to do...

Quite possible you've missed something during your upgrade.
I'd start with a brand new compare of everything: http://www.zen-cart.com/wiki/index.php/Troubleshoot_-_Diagnosing_Obscure_Issues