[SOLVED] - Can´t access admin page after upgrade 3.0.3.8

Everything was working fine. I upgraded thru Softculous and tried to clear my cookies for Token errors and when I went back to log in, I cannot access the admin page. I see lots of remedies but, not sure which one to try.. Any help would be appreciated.

https://wickedstangsperformanceshop.com

What version did you upgrade from? What happens when you try to login?

ADD Creative wrote: ↑

Wed Nov 10, 2021 5:24 am

What version did you upgrade from? What happens when you try to login?

I get no error just stays on the same screen. Looks like it logs in but doesn't go to the OC dashboard.. updated from 3.0.3.1

Have you checked both your OpenCart and PHP errors logs?

ADD Creative wrote: ↑

Wed Nov 10, 2021 6:25 am

Have you checked both your OpenCart and PHP errors logs?

Can you guide on how to locate those?

ADD Creative wrote: ↑

Wed Nov 10, 2021 6:25 am

Have you checked both your OpenCart and PHP errors logs?

[09-Nov-2021 19:39:05 UTC] PHP Fatal error: Uncaught Exception: 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 ':00'' at line 1
Error No: 1064
SET time_zone = '+00:00'+00:00' in /home/..../public_html/cart/system/library/db/mysqli.php:48 Stack trace: #0 /home/...../public_html/cart/system/library/db.php(45): DB\MySQLi->query('SET time_zone =...') #1
/home/...../public_html/cart/system/framework.php(84): DB->query('SET time_zone =...') #2
/home/...../public_html/cart/system/startup.php(104): require_once('/home/...../pu...') #3
/home/....../public_html/cart/index.php(19): start('catalog') #4 {main} thrown in
/home/...../public_html/cart/system/library/db/mysqli.php on line 48

Does that error appear every time you login to admin or was it just once? Did you change the time zone setting in admin at all?

ADD Creative wrote: ↑

Wed Nov 10, 2021 8:02 am

Does that error appear every time you login to admin or was it just once? Did you change the time zone setting in admin at all?

Looks like it appears every time, I did change the time zone when I was in there. I was following the Check your server steps.

ADD Creative wrote: ↑

Wed Nov 10, 2021 8:02 am

Does that error appear every time you login to admin or was it just once? Did you change the time zone setting in admin at all?

Ok, I started a New Site and did the same thing changed the time zone and now my new site won't let me in...

try this
viewtopic.php?f=201&t=222369&start=20#p816440

https://github.com/opencart/opencart/issues/9237

by mona wrote: ↑

Wed Nov 10, 2021 10:43 am

try this
viewtopic.php?f=201&t=222369&start=20#p816440

https://github.com/opencart/opencart/issues/9237

Thank you very much everyone.. I did the below and I am now back in to my Dashboard...

sw!tch wrote: ↑
Wed Feb 10, 2021 4:06 am

If you get locked out or cannot login try setting the Timezone back to UTC

In phpmyadmin go to your oc_setting table and under the key column look for config_timezone, set the value back to UTC, clear your browser history and try to login again.

In phpmyadmin go to your oc_setting table and under the key column look for config_timezone, set the value back to UTC, clear your browser history and try to login again.

ADMIN MARK [SOLVED]

wickedstangs wrote: ↑

Wed Nov 10, 2021 10:21 pm

by mona wrote: ↑

Wed Nov 10, 2021 10:43 am

try this
viewtopic.php?f=201&t=222369&start=20#p816440

https://github.com/opencart/opencart/issues/9237

Thank you very much everyone.. I did the below and I am now back in to my Dashboard...

sw!tch wrote: ↑
Wed Feb 10, 2021 4:06 am

If you get locked out or cannot login try setting the Timezone back to UTC

In phpmyadmin go to your oc_setting table and under the key column look for config_timezone, set the value back to UTC, clear your browser history and try to login again.

In phpmyadmin go to your oc_setting table and under the key column look for config_timezone, set the value back to UTC, clear your browser history and try to login again.

Thank you so much! it was the timezone for me as well. Thank you, thank you, thank you!