When a database query error occurs, the following error message is displayed:

The visual aspect of the message is defined by the contents of the file /bitrix/php_interface/dbquery_error.php.

Situations may happen when a site denies to reply and returns an empty page to visitors. In this case, open the file bitrix/php_interface/dbconn.php containing the database connection parameters, and set the parameter: $DBDebug = true;

<?
define("DBPersistent", true);
$DBType = "mysql";
$DBHost = "localhost:31006";
$DBLogin = "root";
$DBPassword = "";
$DBName = "bsm_demo";
$DBDebug = true;
$DBDebugToFile = false;

set_time_limit(60);

define("BX_FILE_PERMISSIONS", 0777);
define("BX_DIR_PERMISSIONS", 0777);
@ini_set("memory_limit", "64M");
?>

This will cause the error message to be printed. The message usually contains names of damaged tables.

Run perror.exe (can be found in /mysql/bin) with the error code to get the error description:

If the database damage is the case, you are recommended to use the built-in database check and repair tool. This will allow you to restore the site functionality in the shortest possible time.

• You can access the check and repair tool from the Control Panel:

  Settings -> Tools -> Database Check.

  

   

  If the statistics tables are damaged and you cannot open the Control Panel, you can disable gathering statistics by supplying the parameter ?no_keep_statistic_LICENSE-KEY=Y on the URL (substitute LICENSE-KEY with your license key).

• You can use the database check script without having to open the Control Panel.

  To do so, supply the database access login and password on the URL. For example:

  http://www.mysite.ru/bitrix/admin/repair_db.php?login=DB_Login&password=DB_Password

  By default, the database access parameters are stored in /bitrix/php_interface/dbconn.php.