1
Upgrade / Unable to access admin of multi store after 1.2.7 upgrade
« on: May 18, 2016, 05:51:33 PM »
Hi all, I have a multi-store setup, default store and a second store working fine on version 1.2.6.
When I upgrade to 1.2.7 I can access admin of default store but when I try to and try to access the admin of the second store I a page showing this error:
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 ac_extensions)' at line 4
Error No: 1064
SQL: SELECT se.`key`, se.`value`, st.store_id FROM ac_settings se RIGHT JOIN ac_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 ac_extensions); in /home/tassieva/public_html/core/database/amysqli.php on line 106
The front end of the second store works fine, as does default.
I have tried the upgrade via Installatron, upgrade key, and ftp, cleared cache along the way, installed default htaccess, all with the same result.
Any Ideas to put me in the right direction?
Thanks in advance for any help with this
When I upgrade to 1.2.7 I can access admin of default store but when I try to and try to access the admin of the second store I a page showing this error:
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 ac_extensions)' at line 4
Error No: 1064
SQL: SELECT se.`key`, se.`value`, st.store_id FROM ac_settings se RIGHT JOIN ac_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 ac_extensions); in /home/tassieva/public_html/core/database/amysqli.php on line 106
The front end of the second store works fine, as does default.
I have tried the upgrade via Installatron, upgrade key, and ftp, cleared cache along the way, installed default htaccess, all with the same result.
Any Ideas to put me in the right direction?
Thanks in advance for any help with this