Quick Price Updates Error

[Noutje 0]

This conributions works great except for a small problem i cannot fix.

I get the error :

 

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

 

select manufacturers_name from manufacturers where manufacturers_id=

 

[TEP STOP]

 

Anyone has a clue to fix this?

[Guest]

It is because your products have no manufacturers, the manufacturer_id in the products table is NULL.

 

You can change the definition of the products table and put manufacturer_id NOT NULL DEFAULT '0'.

[Nocturnaloner 0]

It is because your products have no manufacturers, the manufacturer_id in the products table is NULL.

 

You can change the definition of the products table and put manufacturer_id NOT NULL DEFAULT '0'.

<{POST_SNAPBACK}>

 

Shazam! I hereby resurrect this thread, because not every case of the 1064 error is due to newer versions of MySQL or PHP.