Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Error code after upgrading to 1.1.8 in mysql
 
stuffwholesale
Jr. Member
 
Total Posts:  6
Joined:  2008-07-22
 

SQLSTATE[42000]Syntax error or access violation1064 You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

The above is the code I am receiving can anyone tell me how to fix this?
Thanks
Ron

 
Magento Community Magento Community
Magento Community
Magento Community
 
dfeng
Jr. Member
 
Total Posts:  1
Joined:  2008-11-30
 

I’m getting the same problem when I try to create a new product. When it tries to add the product to the database, the same error is returned.

 
Magento Community Magento Community
Magento Community
Magento Community
 
stuffwholesale
Jr. Member
 
Total Posts:  6
Joined:  2008-07-22
 

I have a teck looking into this for me when he find out I will l let you know what he did to fix it for me.

 
Magento Community Magento Community
Magento Community
Magento Community
 
shaun
Member
 
Avatar
Total Posts:  39
Joined:  2007-11-09
Todmorden, UK
 

Ditto this error on Duplicating a product.

 
Magento Community Magento Community
Magento Community
Magento Community
 
shaun
Member
 
Avatar
Total Posts:  39
Joined:  2007-11-09
Todmorden, UK
 

Which version of MySQL is everybody in this thread running?

Could this be a compatibility problem with MySQL 5.1 ??

 
Magento Community Magento Community
Magento Community
Magento Community
 
shaun
Member
 
Avatar
Total Posts:  39
Joined:  2007-11-09
Todmorden, UK
 

Or it could be that an extension isn’t compatible.

See http://www.magentocommerce.com/bug-tracking/issue?issue=4325

And See http://www.magentocommerce.com/boards/viewthread/24950/

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top