How to repair the database files

You might be OK

There might be nothing to worry about. Check these points:

• Did you come to this page because of a message you saw in the server console or logs?
• Is the following text at the start of the error message block?

   ERROR: near "3": syntax error

• If so, then everything is OK. You don't have to do anything written below and you can safely ignore the error message.

Warnings

Backup all files before attempting a repair!
Shutdown the server before attempting a repair!

Windows server

Easy way

• Download this
• Unzip and put the files into server/mods/deathmatch/
• Double click on sqlite_repair_internal_db.bat to repair internal.db
• Double click on sqlite_repair_registry_db.bat to repair registry.db

Hard way

• Download sqlite-tools-win32 from here. If that link fails, the main download page is here.
• Unzip and put sqlite3.exe into server/mods/deathmatch/
• Open command prompt the change directory to server/mods/deathmatch/
• To repair internal.db:
  • Copy internal.db to internal_original.db
  • Do this command: sqlite3.exe internal_original.db .dump | sqlite3.exe internal_repaired.db
  • Copy internal_repaired.db to internal.db

• To repair registry.db:
  • Copy registry.db to registry_original.db
  • Do this command: sqlite3.exe registry_original.db .dump | sqlite3.exe registry_repaired.db
  • Copy registry_repaired.db to registry.db

Linux server

Only way

(You can use the easy way by copying the DB from linux to windows, and use the method used on windows PC's)

• Download sqlite-shell-linux from here. If that link fails, the main download page is here.
• Unzip and put sqlite3 into server/mods/deathmatch/
• To repair internal.db:
  • Copy internal.db to internal_original.db
  • Do this command: ./sqlite3 internal_original.db .dump | ./sqlite3 internal_repaired.db
  • Copy internal_repaired.db to internal.db

Click to expand [+]

Commands

cp internal.db internal_original.db
./sqlite3 internal_original.db .dump | ./sqlite3 internal_repaired.db
cp internal_repaired.db internal.db

• To repair registry.db:
  • Copy registry.db to registry_original.db
  • Do this command: ./sqlite3 registry_original.db .dump | ./sqlite3 registry_repaired.db
  • Copy registry_repaired.db to registry.db

Click to expand [+]

Commands

cp registry.db registry_original.db
./sqlite3 registry_original.db .dump | ./sqlite3 registry_repaired.db
cp registry_repaired.db registry.db