Database Issues

Do you have an error code?

Yes...

Go to the Error Codes Glossary

If not, use the following list of problems on this page to read about possible causes and resolutions.

Repair Database Entries

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.

Please consult with technical support before attempting these operations.

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:

extension=mongo.so

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.

In a command line, enter:
For Windows:

TEXT

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

For Linux:

TEXT

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

Then, for both Windows and Linux, enter:
To find and list errors in the databases from the default site:
TEXT
```
php scan.php -h default > report.html
```
To find and list errors in a multi-tenant site, provide the tenant URL:
TEXT
```
php scan.php -h tenant01.example.com > report.html
```
If there are errors found, run the repair operation.

Repair Errors

To repair errors found in the check process, run:

TEXT

php scan.php -h default -f True

Note

The above command needs sudo access, to have enough permissions to remove stray thumb and versioned files.
Previous versions of the script, checkfc.php and repairsfc.php, are deprecated.