Database Error in Time Tracker

The Database error - is usually displayed on top of the pages when something cannot be created or updated in Time Tracker database. The most common reason is inconsistency between database structure and code, for example, when you use an updated code with the older database structure. New code may require some fields, which do not exist, or are named differently in the older database. Another potential reason is using some older version of the code with a bug in it.

The message is displayed in user language as the value of error.db from a corresponding localization file.

'error.db' => 'Error de la Base de Dades.', // Català
'error.db' => 'Chyba databáze', // Česky
'error.db' => 'Database fejl.', // Dansk
'error.db' => 'Datenbankfehler.', // Deutsch
'error.db' => 'Database error.', // English
'error.db' => 'Error de la Base de Datos.', // Español
'error.db' => 'Andmebaasi viga.', // Eesti
'error.db' => 'خطا در پایگاه داده.', // Farsi
'error.db' => 'Tietokantavirhe.', // Suomi
'error.db' => 'Erreur de base de données.', // Français
'error.db' => 'שגיאה של בסיס הנתונים', // Hebrew
'error.db' => 'Adatbázis hiba', // Magyar
'error.db' => 'データベースのエラー', // 日本語
'error.db' => '데이터베이스 오류', // 한국어
'error.db' => 'Database fout.', // Nederlands
'error.db' => 'Databasefeil.', // Norsk
'error.db' => 'Błąd bazy danych.', // Polski
'error.db' => 'Erro no banco de dados.', // Português brasileiro
'error.db' => 'Eroare baza de date', // Română
'error.db' => 'Ошибка базы данных.', // Русский
'error.db' => 'Databázová chyba.', // Slovenčina
'error.db' => 'Greška u bazi podataka.', // Srpski
'error.db' => 'Databasfel.', // Svenska
'error.db' => 'Veritabanı hatası', // Türkçe
'error.db' => '数据库错误', // 简体中文
'error.db' => '資料庫錯誤', // 簡體中文

How to Fix

Make sure that you use the latest version of the code. Then, run dbinstall.php and execute the steps required to bring the database structure up to date. This normally means executing some steps at the end of the displayed table in dbinstall.php.

If you are a coder, try to look at source code to see if you can narrow the problem down to a specific area, then report it.

If the code and the database structure are properly updated and you still see the error, try to post a detailed message on Time Tracker forum to seek help from other users. Provide application version information, explain what you are doing when the error occurs, post web server error logs, along with other relevant information that may help others to reproduce the problem.

You can also open a support incident for immediate help.

Time Tracker FAQ