Check the site's /logs directory; there's a myDEBUG-*.log file that identifies what the issue is.
Check the site's /logs directory; there's a myDEBUG-*.log file that identifies what the issue is.
[26-Jul-2019 19:12:04 America/Chicago] Request URI: /studio/admin-1538838053/index.php, IP address: 97.103.136.248
#1 trigger_error() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/includes/classes/AdminNotifications.php:153]
#5 AdminNotifications->pruneSavedState() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/includes/classes/AdminNotifications.php:34]
#6 AdminNotifications->getNotifications() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/index_dashboard.php:14]
#7 require(/home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/index_dashboard.php) called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/index.php:26]
--> PHP Fatal error: 1146:Table 'boruma_zncr6.zc_admin_notifications' doesn't exist :: DELETE FROM zc_admin_notifications WHERE notification_key NOT IN ('square3v156') ==> (as called by) /home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/includes/classes/AdminNotifications.php on line 153 <== in /home2/boruma/public_html/earcandyaudiobooks.com/studio/includes/classes/db/mysql/query_factory.php on line 171.
Sorry, but I have absolutely no idea what to do with all that.
Last edited by DK_Scully; 27 Jul 2019 at 01:09 PM.
It "sounds like" you've specified (in your admin/storefront configure.php files) a DB_PREFIX of 'zc_' where the original store used a DB_PREFIX of ''.
Be sure to rename your admin directory name, since it's been posted as part of that log's information.
I haven't touched anything in the configure.php file. I touch the php files as little as possible because I never have understood php, and I never will.
Under admin-1538838053, there are only three directories: backups, images, and includes. And no configure.php file. Where's the file I need to modify? Under includes? I'm just trying to clarify because I don't want to screw this up even more than the upgrade process already did.
Check both the /admin/includes/configure.php and the /includes/configure.php to make sure that the DB_PREFIX constant is set to ''.
The good news is, I was able to find and modify both of those files. The bad news is, I keep getting an error when I try to upload the /includes file.
CuteFTP (or maybe the server) won't allow me to upload it. I was able to upload the admin-1538838053/includes/ file, though.
Last edited by DK_Scully; 27 Jul 2019 at 03:45 PM.
The CHMOD on /includes/ is 755. Do I need to change that...and then change it back?
What is the chmod on includes/configure.php ? Probably set to 0444, change it to 0644 and upload over it then change back to 0444
Mike
GeekHost - Zen Cart Certified & PCI Compliant Hosting
The Zen Cart Forum...Better than a monitor covered with post-it notes!
Okay, I did that and uploaded the file, then changed it back. Thanks for that.
Now I'm getting this error message: ERROR 0071: There appears to be a problem with the database. Maintenance is required.
And the log file says:
[26-Jul-2019 19:12:04 America/Chicago] Request URI: /studio/admin-1538838053/index.php, IP address: 97.103.136.248
#1 trigger_error() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/includes/classes/AdminNotifications.php:153]
#5 AdminNotifications->pruneSavedState() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/includes/classes/AdminNotifications.php:34]
#6 AdminNotifications->getNotifications() called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/index_dashboard.php:14]
#7 require(/home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/index_dashboard.php) called at [/home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/index.php:26]
--> PHP Fatal error: 1146:Table 'boruma_zncr6.zc_admin_notifications' doesn't exist :: DELETE FROM zc_admin_notifications WHERE notification_key NOT IN ('square3v156') ==> (as called by) /home2/boruma/public_html/earcandyaudiobooks.com/studio/admin-1538838053/includes/classes/AdminNotifications.php on line 153 <== in /home2/boruma/public_html/earcandyaudiobooks.com/studio/includes/classes/db/mysql/query_factory.php on line 171.
Nope, that's the same log that you posted earlier. The message you're receiving indicates that the database credentials are not correct.
Bookmarks