Error during startup : db_CreateTables() unable to load instance default values

[toto313]

Hello,

My TS server was working like a charm since a few time, so I've decided to see logs files.

I did some search in this forum and I've read that since 3.0.12, we have to use ts3server.exe and not ts3server_win64.exe.

Unfortunately, I've used ts3server_win64.exe after the 3.0.12 update ; please don't hit me :-/

Since my bad utilization, I've got error in my logs files.
At the begining it was like that :

2016-02-18 01:57:16.658206|ERROR   |DatabaseQuery |   | invalid parameter found :value*:
2016-02-18 01:57:16.658206|ERROR   |DatabaseQuery |   | db_exec failed near ":tablename": syntax error
2016-02-18 01:57:16.658206|ERROR   |DatabaseQuery |   | db_exec() delete from :tablename: where id = :id: ;insert into :tablename: ( ser error: near ":tablename": syntax error
2016-02-18 01:57:16.658206|ERROR   |Variables     |   | unable to save ident: client_created value: 1455760636

After some times, now it's that :

2016-03-03 19:50:11.451612|INFO    |ServerLibPriv |   |TeamSpeak 3 Server 3.0.12.2 (2016-02-15 14:51:38)
2016-03-03 19:50:11.451612|INFO    |ServerLibPriv |   |SystemInformation: Windows Server 2008 R2 SP1 (7601) x64 (AMD or Intel) Binary: 64bit
2016-03-03 19:50:11.451612|INFO    |ServerLibPriv |   |Using hardware aes
2016-03-03 19:50:11.451612|INFO    |DatabaseQuery |   |dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2016-03-03 19:50:11.451612|INFO    |DatabaseQuery |   |dbPlugin version: 3.8.6
2016-03-03 19:50:11.451612|INFO    |DatabaseQuery |   |checking database integrity (may take a while)
2016-03-03 19:50:11.467212|CRITICAL|SQL           |   |db_CreateTables() unable to load instance default values

Is my db totally crashed because I not used the correct EXE ?

As you can see, I'm on Windows Server 2008 R2 SP1 x64, TS 3.0.12.2.

If you need some logs to analyze, no problems !

Thanks for your help.

Thomas

[dante696]

Yes, it can happen that you mess up the DB, when you use the old binary while all other files have been replaced in your server folder.
To fix this you need to use a working backup of this DB.

[toto313]

Hello,

Thanks for your response.

If i don't have db backup, can i do something to repair it ?

Thanks

[dante696]

No, because repairing means you modify the databse and this is not supported from us.

[sausje]

This happened to me too today. First the spamming of

2016-05-01 12:01:14.330137|ERROR   |DatabaseQuery |   | db_exec failed near ":tablename": syntax error
2016-05-01 12:01:14.330137|ERROR   |DatabaseQuery |   | db_exec() delete from :tablename: where id = :id: ;insert into :tablename: ( ser error: near ":tablename": syntax error
2016-05-01 12:01:14.330137|ERROR   |Variables     |   | unable to save ident: client_unread_messages value: 0
2016-05-01 12:01:14.351138|CRITICAL|Client        |  1| Assertion "m_ClientDBID != 0" failed at common\chanclients\client.cpp:239;

and then the same error as above when I try to start it.
A ~5 year old DB and settings just *poof* gone... Wish I never updated it seeing that's most likely the cause of this.

[SnowmanDK]

I have problems with a brand new installation of Windows with the latest MariaDB.
As you can see from the log below, then the server DOES connect and create the tables needed, but afterwards it produces an error and shuts down.

==================================================================================================================================

2016-05-04 22:58:23.328020|INFO    |ServerLibPriv |   |TeamSpeak 3 Server 3.0.12.4 (2016-04-25 15:16:45)
2016-05-04 22:58:23.329019|INFO    |ServerLibPriv |   |SystemInformation: Windows 10 (10586) x64 (AMD or Intel) Binary: 64bit
2016-05-04 22:58:23.329019|INFO    |ServerLibPriv |   |Using hardware aes
2016-05-04 22:58:23.330017|INFO    |DatabaseQuery |   |dbPlugin name:    MariaDB plugin, (c)TeamSpeak Systems GmbH
2016-05-04 22:58:23.330017|INFO    |DatabaseQuery |   |dbPlugin version: 1
2016-05-04 22:58:30.698141|INFO    |SQL           |   |db_CreateTables() tables created


==================================================================================================================================

2016-05-04 22:58:49.762893|INFO    |ServerLibPriv |   |TeamSpeak 3 Server 3.0.12.4 (2016-04-25 15:16:45)
2016-05-04 22:58:49.762893|INFO    |ServerLibPriv |   |SystemInformation: Windows 10 (10586) x64 (AMD or Intel) Binary: 64bit
2016-05-04 22:58:49.763886|INFO    |ServerLibPriv |   |Using hardware aes
2016-05-04 22:58:49.764886|INFO    |DatabaseQuery |   |dbPlugin name:    MariaDB plugin, (c)TeamSpeak Systems GmbH
2016-05-04 22:58:49.764886|INFO    |DatabaseQuery |   |dbPlugin version: 1
2016-05-04 22:58:49.823367|CRITICAL|DatabaseQuery |   |setSQLfromFile( file:sql/update_1.sql) failed
2016-05-04 22:59:00.218203|ERROR   |DatabaseQuery |   |invalid parameter found :value:
2016-05-04 22:59:00.218203|ERROR   |DatabaseQuery |   |db_exec() insert into :tablename: ( server_id, id, ident, value, string_id) valu error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ':tablename: ( server_id, id, ident, value, string_id) values (:server_id:, 0, :i' at line 1
2016-05-04 22:59:00.218203|ERROR   |              |   |unable to save properties to instance_properties
2016-05-04 22:59:00.218203|CRITICAL|SQL           |   |db_CreateTables() unable to save instance default values