Getting SQL errors since upgrading

**bogyi** · 31 Oct 2010, 11:30 PM

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:

Code:

 
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]

Code:

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 -

**Ajeh** · 1 Nov 2010, 01:05 AM

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

**DrByte** · 1 Nov 2010, 04:52 AM

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.

**bogyi** · 1 Nov 2010, 08:45 AM

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...

**DrByte** · 1 Nov 2010, 09:32 AM

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.p...Obscure_Issues