Database Issues

Go to the Error Codes Glossary

Problem

Under certain conditions, database entries can get out of sync with physical file entries.

When this happens you may see the following issues:

• File sync errors

• Failure to download files that exist in the system

Cause

Many factors can cause this issue.

Resolution

Out-of-sync database issues can be fixed by using the Scan tool.

Prerequisite

To check/repair database errors, PHP CLI mode access must be enabled by adding the following line to the end of the PHP ini file:

In Windows, the PHP ini file is located at XAMPP\php\php.ini
In Linux, the PHP ini file is located at /etc/php5/cli/php.ini

Check for Errors

Once the CLI mode is enabled, follow these steps to check databases. 

A report of the errors found, report.html is listed.

1. In a command line, enter:
   For Windows:

   cd c:\xampp\htdocs\resources\tools\consistency
   PATH=%PATH%;C:\xampp\php
   

   For Linux:

   cd /var/www/html/resources/tools/consistency
   

2. Then, for both Windows and Linux, enter:
   

   To find and list errors in the databases from the default site:

   php scan.php -h default > report.html
   

   To find and list errors in a multi-tenant site, provide the tenant URL:
   

   php scan.php -h tenant01.example.com > report.html
   

3. If there are errors found, run the repair operation.

Repair Errors

To repair errors found in the check process, run:

php scan.php -h default -f True