News:

AbanteCart v1.4.2 is released.

Main Menu
support

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 -