Troubleshooting

Repair database schema

In some cases, problems with duplicating keys may occur when updating the database schema. In this case you can use the site_doctree_repair.pl script. It deletes the duplicated rows from the database.

So if the update script for the database schema site_doctree_admin.pl -U fails, you can see in the output of the script which table caused the error. Once you know the table, you can repair it with the site_doctree_repair.pl script:

perl /var/www/imperia/dev/site/bin/site_doctree_repair.pl --table=TABLE --repair

To view all available settings for the script, use

perl /var/www/imperia/dev/site/bin/site_doctree_repair.pl --help

Language support in the operating system

The reason that the UI translation does not work can be the language support of the operating system. On Linux systems this can be checked as follows:

locale -a

If the language (in this example English(de_DE.utf8)) is not installed, you need to install it. On DEBIAN systems this is done as follows:

dpkg-reconfigure locales

Rebuilding the SQLite Database

The SQLite database can be rebuilt with the script site_rebuild_db.pl, if you use "File65" as data storage. Serious errors in data storage can be corrected in this way as long as only the database is affected and data storage in the file system is still intact.

You carry out a complete rebuild with the following script call:

perl /var/www/imperia/dev/site/bin/site_rebuild_db.pl -t -b

Please note that this process may take several hours depending on the number of documents and the processing speed of your hardware. To better control this process, we recommend calling the script with -t (todo) first to create the todo list and then run it separately with -b (batch).

To perform only the minimal rebuild, which takes much less time, add the -m parameter:

perl /var/www/imperia/dev/site/bin/site_rebuild_db.pl -t -b -m

To synchronize only the documents and assets of a target system with the database, execute the following script call:

perl /var/www/imperia/dev/site/bin/site_rebuild_db.pl -t -b --only-targets mytarget