Syntax error or access violation: 1064 You have an error in your SQL syntax

Please LogIn to Reply!

Post By: admin | 26-01-2012 06:35 Reply

 

Hi, everything was working fine in the shop and looking good then out of no where this message now comes up anytime I try to access the shop front or admin area:

Error in file: “/home/skylant/public_html/shop/app/code/core/Mage/Sales/sql/sales_setup/mysql4-upgrade-1.3.99-1.4.0.0.php” - SQLSTATE[42000]: Syntax error or access violation: 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 ‘(
`entity_id` int(10) unsigned NOT NULL auto_increment,
`state` varchar(’ at line 2

Trace:
#0 /home/skylant/public_html/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(390): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /home/skylant/public_html/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(289): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’upgrade’, ‘0.9.56’, ‘1.4.0.15’)
#2 /home/skylant/public_html/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(233): Mage_Core_Model_Resource_Setup->_upgradeResourceDb(’0.9.56’, ‘1.4.0.15’)
#3 /home/skylant/public_html/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(161): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /home/skylant/public_html/shop/app/code/core/Mage/Core/Model/App.php(363): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /home/skylant/public_html/shop/app/code/core/Mage/Core/Model/App.php(295): Mage_Core_Model_App->_initModules()
#6 /home/skylant/public_html/shop/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#7 /home/skylant/public_html/shop/index.php(78): Mage::run(’’, ‘store’)
#8 {main}

Any help would be very much appreciated.

 

Are you sure you did not add, change or delete anything from your site or database?

 Signature 

Brent W. Peterson
Chief Magento Evangelist at Wagento.com a Magento Silver Partner
==========
Follow me on Twitter @brentwpeterson

**Always remember to backup before trying anything new

`Reply Or Comment!
Please LogIn to Reply!