Jump to content
Sign in to follow this  
Noutje

Quick Price Updates Error

Recommended Posts

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?

Share this post


Link to post
Share on other sites
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'.

Share this post


Link to post
Share on other sites
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'.

 

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×