Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Database error  (Read 3875 times)

Offline Datafun

  • Newbie
  • *
  • Posts: 7
  • Karma: +3/-0
    • View Profile
Database error
« 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?

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 2046
  • Karma: +318/-13
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Database error
« Reply #1 on: July 06, 2016, 03:57:23 AM »
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

Offline epimadman

  • Newbie
  • *
  • Posts: 11
  • Karma: +2/-0
    • View Profile
Re: Database error
« Reply #2 on: July 06, 2016, 12:31:07 PM »
You guys are amazing as always - that fixed it!  Thanks!!

 

Powered by SMFPacks Social Login Mod