News:

AbanteCart v1.4.2 is released.

Main Menu

Do you like AbanteCart? Please rate AbanteCart or share your experience with other eCommerce entrepreneurs. Go to Softaculous rating page to add your rating or write a review

Database error

Started by Datafun, July 05, 2016, 02:17:12 PM

Previous topic - Next topic

Datafun

Exported database of 1.2.7 and imported successfully into a new cart setup on server (same version).  Storefront works great but admin was working and then started showing this error:

2016-07-05 16:28:21 - database error:  AbanteCart core v.1.2.7 SQL Error: 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 'AND st.status = 1
               AND se.`group` NOT IN (SELECT `key` FROM abwl_extensions)' at line 4<br />Error No: 1064<br />SQL: SELECT se.`key`, se.`value`, st.store_id
               FROM abwl_settings se
               RIGHT JOIN abwl_stores st ON se.store_id = st.store_id
               WHERE se.store_id =  AND st.status = 1
               AND se.`group` NOT IN (SELECT `key` FROM abwl_extensions); in <b>/home/MYUSERNAME/public_html/core/database/amysqli.php</b> on line <b>106</b>

Any suggestions?

abolabo

please replace core/lib/config.php with attached and let us know
"No one is useless in this world who lightens the burdens of another."
― Charles Dickens

epimadman

You guys are amazing as always - that fixed it!  Thanks!!

Forum Rules Code of conduct
AbanteCart.com 2010 -