Jump to content

[Solved] Can't log in to Admin, no error message

ThudGames

By ThudGames
in General topics

 Share

Recommended Posts

ThudGames Newbie

ThudGames

Posted
Posted (edited)

Hello,

I recently updated to 1.7.6.7 and I have had nothing but issues with the back office/admin log in. I currently cannot log in, I put in the information, the page refreshes instead of logging in. I have cleared my browser cache/cookies/etc, I have turned off my ad blocker, I have deleted unused files in the PHP, I have changed my PHP version (although I can't remember how I did that now or how to check). I am NOT proficient with this, I usually just Google things and try and work out what people mean by the suggested solutions, but I haven't been able to find anything, any information. Please help.

 

The solution was to restore the backup of public_html from before the most recent update.

Edited by ThudGames (see edit history)
Link to comment
Share on other sites
Razi Apprentice

Razi

Posted
Posted
7 hours ago, ThudGames said:

Hello,

I recently updated to 1.7.6.7 and I have had nothing but issues with the back office/admin log in. I currently cannot log in, I put in the information, the page refreshes instead of logging in. I have cleared my browser cache/cookies/etc, I have turned off my ad blocker, I have deleted unused files in the PHP, I have changed my PHP version (although I can't remember how I did that now or how to check). I am NOT proficient with this, I usually just Google things and try and work out what people mean by the suggested solutions, but I haven't been able to find anything, any information. Please help.

Hello, you are using any VPN?

kindly try to login using private window.

Link to comment
Share on other sites
ThudGames Newbie

ThudGames

Posted
  • Author
Posted
18 hours ago, MichaelEZ said:

u coudnt find anything? i would argue that :D 

https://www.google.com/search?q=prestashop+1.7+unable+tyo+login+to+admin&oq=prestashop+1.7+unable+tyo+login+to+admin&aqs=chrome..69i57j33.19079j0j7&sourceid=chrome&ie=UTF-8

I didn't think that first result was quite the same because the login circle wasn't constantly spinning.

Link to comment
Share on other sites
ThudGames Newbie

ThudGames

Posted
  • Author
Posted
21 minutes ago, Guest said:

Function phpinfo is enabled in web host ?

I don't know.

18 minutes ago, Guest said:

Create file phpinfo.php

Add code and save to your prestashop root folder. 


<?php
echo phpinfo();
?>

 

I don't know how to do that. I use PHPMyAdmin and I can't see any way to create files.

Link to comment
Share on other sites
ThudGames Newbie

ThudGames

Posted
  • Author
Posted
8 minutes ago, Guest said:

You're a really tough case.
Files are saved on FTP !!!!

Sorry I'm not great with this stuff, but I did as you said, via FTP/file management, but it hasn't made any difference, I still can't log in.

Link to comment
Share on other sites
ThudGames Newbie

ThudGames

Posted
  • Author
Posted
7 hours ago, [email protected] said:

where do i go to restore the backup?

You might have to talk to your host provider. In my case, they use Acronis Backup and I selected that in cPanel then selected the date I wanted to restore to (the day before the update), then Files > public_html > Recover. Hope you can find yours!

Link to comment
Share on other sites
  • 4 months later...
Seppe Newbie

Seppe

Posted
Posted

Good morning

If I want to go to my adminpanel: www.domain.be/admin I get: "the page you are looking for was not found".

And there it stops. 

No idea to get back to the loginform

I'm running version 1.7.6.9 (I guess) on PHP 7.3
I tried to rename the "gamafication" folder, but no solution.

Link to comment
Share on other sites
  • 2 weeks later...
  • 2 years later...
Lulu007 Newbie

Lulu007

Posted
Posted
On 9/13/2023 at 11:34 AM, idnovate.com said:

Exactly which error do you have?

I have a blank page . See l file attached 

when I try to see the error from the browser network logs the https return request , it say error 500 account and password is I correct. 
 

i reset the password and still doesn’t work. 

958DAD49-5617-44C5-B75B-F647C2379AB9.jpeg

Link to comment
Share on other sites
  • 1 year later...
Alex Newbie

Alex

Posted
Posted (edited)

After incorrectly adjusting the data, I deleted all the tables and restored them from a backup.
At first, everything worked, but then strange glitches started to happen. And at some point, I stopped logging into the admin panel for no reason.
Dancing with tambourines and the proposed solutions did not lead to anything.


I found a quick intermediate solution - to replace the admin role in the ps_employe table with a logistician - after that I was able to log into the admin panel with limited functionality.
And before that, be sure to clear the cookies in the browser, not the cache, but the cookies


You can grant more permissions with a query, where 2 is the logistician profile:
INSERT INTO ps_access SELECT 2, `ar`.`id_authorization_role` FROM `ps_authorization_role` ar
LEFT JOIN ps_access a ON( ar.id_authorization_role = a.id_authorization_role AND a.id_profile = 2)
WHERE a.id_profile IS NULL

What happened in the end?
When I created a backup copy of the database from phpmyadmin, the information about the indexes was not saved. And I deleted all the tables and restored everything, but without indexes ((

After that, when the site was running, new records did not become unique (autoincrement, primary indexes fields) and when adding new records, everything stopped working correctly. As a rule, new index fields became 0, not autoincrement.

I had to manually create indexes for all tables, based on the installation files of Prestashop and modules.
If there are modules with non-critical information, it is easier to reinstall the modules after restoring access.

Due to the fact that some records in the tables ceased to have a unique field, to add an index it was necessary to either delete fields with the same values with a similar query:
delete from ps_lang where id_lang = 0;
Or do autoincrement field or use other script to make a field unique. Without uniqe values you can not create index and phpmyadmin will throw error.

After I corrected the indexes in ps_tab I was able to log in to the admin panel normally.
In total, 3 days were spent searching for the cause and eliminating the consequences on the working site.

Conclusion - when creating a backup copy of the database, check for the presence of information about the indexes. It is even better not to delete the tables completely, but to empty them and import new data - this way the indexes will definitely not be deleted. And it is best to carry out the operation on specific tables where there may be problems, and not all of them.

Example where there is information about index (PRIMARY)
CREATE TABLE IF NOT EXISTS `ps_access` (
`id_profile` int(10) UNSIGNED NOT NULL,
`id_authorization_role` int(10) UNSIGNED NOT NULL,
PRIMARY KEY (`id_profile`,`id_authorization_role`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

To simplify the work, use Notepad++ or an editor for large files.

Edited by Alex (see edit history)
  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...