ERROR 500

[monicaamb]

I made a serious mistake. I have downloaded the PrestaShop Database Management module to see my database and I didn't know where to get the data (user, password...) so I created a database on the server and now I get the error 500 because the server is pointed to that database which is empty.

How could I recover my website? I have made a backup but it still does not work

[elburgl69]

Put the original DB, username and password in:

/app/config/parameters.php

or restore that file from a backup from before you pointed the database else where.

If you like some verbose error reporting, edit the file:

/config/defines.inc.php

change the following (at the begin of the file):

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

To:

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

 

[monicaamb]

50 minutes ago, elburgl69 said:

Put the original DB, username and password in:

/app/config/parameters.php

or restore that file from a backup from before you pointed the database else where.

If you like some verbose error reporting, edit the file:

/config/defines.inc.php

change the following (at the begin of the file):

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

To:

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

 

Thank you very much.

The problem is that I don't have the original DB because I think that file (/app/config/parameters.php) changed automatically with new data.

I already restore that file from backup and the error 500 continues.

Where is the database of Prestashop by default? Because I didn't have any database and my website worked correctly before this mess.

Edited November 28, 2022 by monicaamb (see edit history)

[elburgl69]

You have a MySQL Database, otherwise Presatashop does not function. Your hosting provider for  your site must have the MySQL main user data for you and probably something like PhPMyAdmin access to your database. You the can reset de password for the user that has access to the Prestashop database.

 

Bij default this are the default DB Settings parameters.php:

<?php return array (
  'parameters' => 
  array (
    'database_host' => '127.0.0.1',
    'database_port' => '',
    'database_name' => 'prestashop',
    'database_user' => '???',
    'database_password' => '???',
    'database_prefix' => 'ps_',
    'database_engine' => 'InnoDB',   
  ),
);

the datbase_user and password you entered on install and were probably provided to you by your hosting provider.

Edited November 28, 2022 by elburgl69 (see edit history)