Jump to content

Problem with database


Recommended Posts

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é ?

Share this post


Link to post
Share on other sites

  • 2 weeks later...
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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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é

Share this post


Link to post
Share on other sites

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é

Share this post


Link to post
Share on other sites

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)

Share this post


Link to post
Share on other sites

Posted (edited)
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 by AfterGlow93 (see edit history)

Share this post


Link to post
Share on other sites

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 

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
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

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More