Page 2 of 2
Re: [SOLVED] Can't login to admin panel
Posted: Sun Mar 21, 2021 12:50 pm
by golive69
sw!tch wrote: ↑Wed Feb 10, 2021 2:23 pm
yegary wrote: ↑Wed Feb 10, 2021 2:05 pm
thanks for the reply. any temp solution at the mean time? I check the thread. - viewtopic.php?f=201&t=222369 you posted but doesn't seem to work for me.
I haven't spent much time on 3.0.3.7 to look into it, but if you want to try the below feel free at your own risk.
In phpmyadmin go to your oc_setting table and under the key column look for config_timezone, you can try setting the value back to UTC
Once you do that try logging in. Keep it set to UTC until the bug is resolved.
YES, thank you
Re: [SOLVED] Can't login to admin panel
Posted: Sat Mar 27, 2021 7:19 am
by flywatches
I am trying to setup a new store and this just happened to me. You would think this kind of error is basic and should not happen. I cannot log back into the admin now. I've tried deleting sessions, changing timezone back to UTC and still nothing. Definitely frustrating a new user.
Re: [SOLVED] Can't login to admin panel
Posted: Sat Mar 27, 2021 7:25 am
by sw!tch
flywatches wrote: ↑Sat Mar 27, 2021 7:19 am
I am trying to setup a new store and this just happened to me. You would think this kind of error is basic and should not happen. I cannot log back into the admin now. I've tried deleting sessions, changing timezone back to UTC and still nothing. Definitely frustrating a new user.
Follow the steps here -
viewtopic.php?f=201&t=222369&start=20#p817086
Make sure you flush your browser cache.
Re: [SOLVED] Can't login to admin panel
Posted: Tue Mar 30, 2021 2:03 am
by flywatches
Thank you for the reply! I did try changing the zone back to UTC but now the store keeps locking me out for an hour and wont give me the "reset your password" option. Any suggestions for that?
Re: [SOLVED] Can't login to admin panel
Posted: Sat Apr 03, 2021 1:05 am
by caleb1
I am having this same problem. I also just changed timezone before this problem started.
I do not know what file to find the config_timezone mentioned, would someone mind providing more info on exactly where I go to set the timezone back?
Thanks.
Re: [SOLVED] Can't login to admin panel
Posted: Sat Apr 03, 2021 6:46 pm
by ADD Creative
config_timezone is a key in oc_setting table of your database. See theses posts.
viewtopic.php?f=201&t=222369#p813699
viewtopic.php?f=201&t=222369&start=20#p816440
Re: [SOLVED] Can't login to admin panel
Posted: Sun May 02, 2021 10:47 am
by imam.mushlihin
I have same issue on fresh installed OC 3.0.3.7 (can't login to admin. always going to login page with no error. If provide wrong password, there is an error)
PHP Version 7.4.8
Already try below list but not solve
1. already UTC
2. admin password is letters only
3. .htaccess is enable with default content
4. check table called oc_session, there is no record, already has primary key
Help me please...
Re: [SOLVED] Can't login to admin panel
Posted: Mon May 03, 2021 12:14 am
by ADD Creative
Have you tried setting session_engine to 'file' in system/config/default.php?
Also make sure you clear your browser cache and cookies.
Re: [SOLVED] Can't login to admin panel
Posted: Sun May 09, 2021 8:42 am
by sebadamus
sw!tch wrote: ↑Wed Feb 10, 2021 2:23 pm
yegary wrote: ↑Wed Feb 10, 2021 2:05 pm
thanks for the reply. any temp solution at the mean time? I check the thread. - viewtopic.php?f=201&t=222369 you posted but doesn't seem to work for me.
I haven't spent much time on 3.0.3.7 to look into it, but if you want to try the below feel free at your own risk.
In phpmyadmin go to your oc_setting table and under the key column look for config_timezone, you can try setting the value back to UTC
Once you do that try logging in. Keep it set to UTC until the bug is resolved.
Thanks man! I spend about 4 hours diving testing changing language deleting cache instaling untinstaling vqmod I did not realized this da#n BUG.
Thanks!
Re: [SOLVED] Can't login to admin panel
Posted: Tue Aug 31, 2021 8:37 am
by tobyhp
Yes, it works!!
use phpmyadmin to login the database admin,and find the OC_Setting table, and find config_timezone , set the value to : UTC
then the problem solved!!
very strange, not sure why the time zone setting affect the logiing to admin panel.
remark here. 2021-8-31
Re: [SOLVED] Can't login to admin panel
Posted: Thu Nov 18, 2021 11:40 pm
by kfkenshin
Changing (deleting) the timezone worked for me. Thank you.!!
Re: [SOLVED] Can't login to admin panel
Posted: Sun Nov 21, 2021 9:15 am
by jhisaza
Thank you very much, I got this problem in 3.0.3.8, after changing timezone to America/Bogota. I put the timezone back to UTC and function again. Please try to solve this bug
Re: [SOLVED] Can't login to admin panel
Posted: Fri Dec 10, 2021 6:33 am
by 21yanks
I also have issues with time zone. I currently installed a fresh copy of Opencart 3.0.3.8, I change the time zone from UTC to America/Los Angeles and after I couldn't log in back in the Admin Panel. I had to go to myPHP admin and change the timezone back to UTC. We need a fix ASAP.
Re: [SOLVED] Can't login to admin panel
Posted: Fri Dec 10, 2021 7:02 am
by ADD Creative
21yanks wrote: ↑Fri Dec 10, 2021 6:33 am
I also have issues with time zone. I currently installed a fresh copy of Opencart 3.0.3.8, I change the time zone from UTC to America/Los Angeles and after I couldn't log in back in the Admin Panel. I had to go to myPHP admin and change the timezone back to UTC. We need a fix ASAP.
Try the second suggestion in
viewtopic.php?f=201&t=222369&start=20#p817086.
Re: [SOLVED] Can't login to admin panel
Posted: Thu Jul 07, 2022 5:09 pm
by phpscript7
If it is solved now you write [Solved] in the title - Thank you
Re: [SOLVED] Can't login to admin panel
Posted: Tue Aug 09, 2022 7:35 pm
by haxcop
ISSUE Still appearing in latest Branch 3.0.3.8
Re: [SOLVED] Can't login to admin panel
Posted: Tue Sep 20, 2022 11:02 pm
by profful
Hello,
I have the same problem with logging in the admin panel.
I tried all the options in this topic, and I still have the same situation.
https://domain.ro/ocart2/admin/index.ph ... iZpsxW8Eyv
I changed hosting. The store is working, I receive orders but I can't see the orders.
thanks
Re: Can't login to admin panel
Posted: Sat Mar 04, 2023 11:28 pm
by cyberb
sergiomng wrote: ↑Wed May 13, 2020 1:59 pm
I finally solved it!!!
In case someone faces this problem, there's table called oc_session, which SHOULD have a primary key but it doesn't, since the session_id should not be duplicated.
I just delete all contents (truncate oc_session) and created a primary key index for session_id, and voilá!!!
Why it worked just fine for more than a year, I don't know, but now it's working like a charm.
Saved my day, not sure what happened but primary key was lost, you have to truncate before adding it
PHP: 7.4.3-4ubuntu2.18
OpenCart: 3.0.2
Not sure how mysql can lose a primary key and I hope it is the only key it lost
Code: Select all
truncate oc_session;
ALTER TABLE oc_session ADD PRIMARY KEY(session_id);
Re: Can't login to admin panel
Posted: Tue Mar 14, 2023 8:33 pm
by siteadvice
sergiomng wrote: ↑Wed May 13, 2020 1:59 pm
I finally solved it!!!
In case someone faces this problem, there's table called oc_session, which SHOULD have a primary key but it doesn't, since the session_id should not be duplicated.
I just delete all contents (truncate oc_session) and created a primary key index for session_id, and voilá!!!
Why it worked just fine for more than a year, I don't know, but now it's working like a charm.
I just wanted to say thanks for this post. I wasted about two hours this morning trying to solve this problem before stumbling on your solution.
Re: Can't login to admin panel
Posted: Thu Nov 02, 2023 11:26 am
by WebStone
sergiomng wrote: ↑Wed May 13, 2020 1:59 pm
I finally solved it!!!
In case someone faces this problem, there's table called oc_session, which SHOULD have a primary key but it doesn't, since the session_id should not be duplicated.
I just delete all contents (truncate oc_session) and created a primary key index for session_id, and voilá!!!
Why it worked just fine for more than a year, I don't know, but now it's working like a charm.
Can you show me the structure? same problem here!