AbanteCart Community
Shopping Cart Operations => Support => Topic started by: netprojections on July 09, 2017, 01:17:25 PM
-
No idea what happened. The shopping cart works fine but I can no longer access the login admin page. I received this error on the page.
Can you assist please?
Thank you,
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 abqw_extensions)' at line 4
Error No: 1064
SQL: SELECT se.`key`, se.`value`, st.store_id
FROM abqw_settings se
RIGHT JOIN abqw_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 abqw_extensions);
in /home/USERNAME/public_html/core/database/amysqli.php on line 106
-
did you tried to run this query via phpMyAdmin? i don't see any problems in it.
-
PhpMyAdmin is indeed a very useful tool to perform database related operations and resolve issues.