AbanteCart Community

Shopping Cart Operations => Support => Topic started by: Datafun on July 05, 2016, 02:17:12 PM

Title: Database error
Post by: Datafun on July 05, 2016, 02:17:12 PM

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?

Title: Re: Database error
Post by: abolabo on July 06, 2016, 03:57:23 AM

please replace core/lib/config.php with attached and let us know

Title: Re: Database error
Post by: epimadman on July 06, 2016, 12:31:07 PM

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