AbanteCart Community

Shopping Cart Operations => Support => Topic started by: netprojections on July 09, 2017, 01:17:25 PM

Title: admin login page
Post 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

Title: Re: admin login page
Post by: abolabo on July 10, 2017, 07:29:26 AM

did you tried to run this query via phpMyAdmin? i don't see any problems in it.

Title: Re: admin login page
Post by: ExpertDeveloper on January 01, 2018, 02:25:18 AM

PhpMyAdmin is indeed a very useful tool to perform database related operations and resolve issues.