Problem with database

[artuuuuuuuuuurs]

Hello!
I have a problem after importing a database. When I try to log in it goes back to the same log in section. Im running prestashop 1.7.7.8 version 

[michel123]

Bonjour,

1. c'est normal si votre base de donne au même utilisateur.
2. Avez-vous modifié le fichier de configuration de base de données pour pointer sur la nouvelle base de donnée importé ?

[artuuuuuuuuuurs]

On 6/8/2022 at 2:29 AM, michel123 said:

Bonjour,

1. c'est normal si votre base de donne au même utilisateur.
2. Avez-vous modifié le fichier de configuration de base de données pour pointer sur la nouvelle base de donnée importé ?

Hello!
As far as I know nothing else has changed. Database config stayed the same I just imported .sql file for database.

[AfterGlow93]

9 hours ago, artuuuuuuuuuurs said:

Hello!
As far as I know nothing else has changed. Database config stayed the same I just imported .sql file for database.

Hello, 

Can you enable DEBUG_MODE via FTP in config/defines.inc.php ?

Find those lines : 

/* Debug only */
if (!defined('_PS_MODE_DEV_')) {
define('_PS_MODE_DEV_', false);

Replace them with : 

/* Debug only */
if (!defined('_PS_MODE_DEV_')) {
define('_PS_MODE_DEV_', true);

Error will give you root cause of login failure.

When importing large database, do not use PhyMyAdmin interface. Use a third party tool like HeidiSQL instead. You will have less issues if database is large.

Why are you importing the whole database ? Server Upgrade ? New host ? Crash ? 

We need more informations to help.

[michel123]

Nous pouvons avoir une capture du fichier de configuration de base de donnée ?

Aussi une capture de l'arborescence du projet ?

Aussi une capture de l'arborescence de la base de donnée?

 

je veux vérifier la conformité

[michel123]

Nous pouvons avoir une capture du fichier de configuration de base de donnée ?

Aussi une capture de l'arborescence du projet ?

Aussi une capture de l'arborescence de la base de donnée?

 

je veux vérifier la conformité

[michel123]

Veuillez vérifier si ces paramètres correspondent bien au nom de la nouvelle base de donnée et autres

[artuuuuuuuuuurs]

On 6/17/2022 at 8:33 PM, AfterGlow93 said:

Hello, 

Can you enable DEBUG_MODE via FTP in config/defines.inc.php ?

Find those lines : 

/* Debug only */
if (!defined('_PS_MODE_DEV_')) {
define('_PS_MODE_DEV_', false);

Replace them with : 

/* Debug only */
if (!defined('_PS_MODE_DEV_')) {
define('_PS_MODE_DEV_', true);

Error will give you root cause of login failure.

When importing large database, do not use PhyMyAdmin interface. Use a third party tool like HeidiSQL instead. You will have less issues if database is large.

Why are you importing the whole database ? Server Upgrade ? New host ? Crash ? 

We need more informations to help.

I guess that was my mistake. Imported tables and replaced all of them with values from old backup. (Reason for it was a crash) when Debug is enabled it doesn't help as log in fields just disappear and nothing happens. Only thing in console it shows error 500 (Internal Server Error)

[AfterGlow93]

16 hours ago, artuuuuuuuuuurs said:

I guess that was my mistake. Imported tables and replaced all of them with values from old backup. (Reason for it was a crash) when Debug is enabled it doesn't help as log in fields just disappear and nothing happens. Only thing in console it shows error 500 (Internal Server Error)

Well, you need to find what's wrong.

A SQL error should trigger debug prompt. Error 500 without any other information is most likely due to something wrong with core files/server configuration.

Do you have the same config ? (PHP Version, Apache).

Did you do a fresh install or just a backup image from server ?

PS logs errors, you should take a look at it to understand root cause. Or ask for some help and give access to server.

 

Edited June 20, 2022 by AfterGlow93 (see edit history)

[artuuuuuuuuuurs]

6 hours ago, AfterGlow93 said:

Well, you need to find what's wrong.

A SQL error should trigger debug prompt. Error 500 without any other information is most likely due to something wrong with core files/server configuration.

Do you have the same config ? (PHP Version, Apache).

Did you do a fresh install or just a backup image from server ?

PS logs errors, you should take a look at it to understand root cause. Or ask for some help and give access to server.

 

Hello!
Actually PS log erros helped me get out of the log in loop as it showed that there was missing table PS_employee_session and that wasn't letting me log in. DB server config did not change 

[AfterGlow93]

5 hours ago, artuuuuuuuuuurs said:

Hello!
Actually PS log erros helped me get out of the log in loop as it showed that there was missing table PS_employee_session and that wasn't letting me log in. DB server config did not change 

Create the table manually using this code (can't paste it here due to Cloudflare security)

https://stackoverflow.com/questions/51943906/i-cant-login-to-my-e-shop-based-on-prestashop-1-7-no-ps-employee-table-in-db

Launch the query in first comment through PhpMyAdmin panel and try again

[artuuuuuuuuuurs]

1 minute ago, AfterGlow93 said:

Create the table manually using this code (can't paste it here due to Cloudflare security)

https://stackoverflow.com/questions/51943906/i-cant-login-to-my-e-shop-based-on-prestashop-1-7-no-ps-employee-table-in-db

Launch the query in first comment through PhpMyAdmin panel and try again

Already managed to do it. Thank you for help!

[AfterGlow93]

6 hours ago, artuuuuuuuuuurs said:

Already managed to do it. Thank you for help!

Okay, is it solved ? If so, please mark this post as solved 

Thanks