Unable to create new apikey for serveradmin account

Does anyone know how to fix it?
Happened after putting files from SERVER 64-BIT 3.13.3

2021-05-16 20:20:52.348976|INFO    |ServerLibPriv |   |TeamSpeak 3 Server 3.13.3 (2020-12-16 14:17:05)
2021-05-16 20:20:52.349110|INFO    |ServerLibPriv |   |SystemInformation: Linux 4.9.0-14-amd64 #1 SMP Debian 4.9.240-2 (2020-10-30) x86_64 Binary: 64bit
2021-05-16 20:20:52.349136|INFO    |ServerLibPriv |   |Using hardware aes
2021-05-16 20:20:52.349774|INFO    |DatabaseQuery |   |dbPlugin name:    SQLite3 plugin, Version 3, (c)TeamSpeak Systems GmbH
2021-05-16 20:20:52.349810|INFO    |DatabaseQuery |   |dbPlugin version: 3.11.1
2021-05-16 20:20:52.350066|INFO    |DatabaseQuery |   |checking database integrity (may take a while)
2021-05-16 20:20:52.385836|ERROR   |DatabaseQuery |   |sqlite3_prepare failed no such table: api_keys
2021-05-16 20:20:52.385904|ERROR   |DatabaseQuery |   |db_open() SELECT * FROM api_keys; error: no such table: api_keys
2021-05-16 20:20:52.386070|ERROR   |DatabaseQuery |   |db_exec failed no such table: api_keys
2021-05-16 20:20:52.386092|ERROR   |DatabaseQuery |   |db_exec() INSERT INTO api_keys (server_id, api_key_hash, api_key_owner_dbid, api error: no such table: api_keys
2021-05-16 20:20:52.386111|CRITICAL|ServerLibPriv |   |unable to create new apikey for serveradmin account

Did you extract and overwrite all files and directories the archive has in it?

It looks like you have updated your server and files incorrectly.

Just make sure (once again) to download the latest server archive and extract and replace all files from the archive.

Yes I’m 100% sure that I overwrite all files and directories.

Anyways I fixed it in different way, just added this table api_keys to ts3server.sqlitedb using DB Browser for SQLite. I found how table looks from file sql/create_tables.sql

So yeah fixed :slight_smile:

That’s why I asked.
The server should do it itself if the files are available.

It’s not only important to extract all files from the archive also make sure your user created for TeamSpeak has the permissions to read/execute the files.

Just to say for the next time.

twitch instagram twitter facebook