Teamspeak3 update_1.sql error

[IZZO]

2011-11-17 21:19:22.125000|INFO |ServerLibPriv | | Server Version: 3.0.0 [Build: 14957], Windows
2011-11-17 21:19:22.140625|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2011-11-17 21:19:22.140625|INFO |DatabaseQuery | | dbPlugin version: 3.7.3
2011-11-17 21:19:22.140625|INFO |DatabaseQuery | | checking database integrity (may take a while)
2011-11-17 21:19:22.609375|CRITICAL|DatabaseQuery | | setSQLfromFile( file:sql/update_1.sql) failed

Teamspeak 3 was running fine for the last couple of months then out of no where yesterday i started getting this error.
When i looked in the sql folder it doesn't even have a update_1.sql file in there.
It does have update_12 through 18 but I'm not really sure what to do to fix this.

[florian_fr40]

Hello

Seems your database is corrupted.
Please open your database, go to "instance_properties" and post here a screen shot from this table.

(You must find lines like
- 0 " " 0 serverinstance_database_version 18)

In some case the problem could be solved adding a new line : "0 NULL 0 serverinstance_database_version 18" => Don't forget to make a backup before
If you are not familar with SQL, send me your database in a private message.

[IZZO]

If you are not familar with SQL, send me your database in a private message.

I wasn't, but I figured out how to do what you said.

The line was missing for some reason so I adding it in and that fixed it.
Thank you!

[florian_fr40]

you're welcome

[Massivve]

Hi people. I have been runing Teamspeak 3 server for quite some time now and havent got any major problems until recently. I have noticed that my server is not reachable but was not giving much attention, since master admin of my VPS said that he will be conducting some maintenance to VPS and I assumed that it was the problem. I was wrong.
After inspecting logs I have found the a lot of logs generated in last few days and all of them contain the same message which is

2012-01-04 07:05:06.382354|INFO    |ServerLibPriv |   | TeamSpeak 3 Server 3.0.1 (2011-11-17 07:34:30)
2012-01-04 07:05:06.382354|INFO    |DatabaseQuery |   | dbPlugin name:    SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2012-01-04 07:05:06.382354|INFO    |DatabaseQuery |   | dbPlugin version: 3.7.3
2012-01-04 07:05:06.382354|INFO    |DatabaseQuery |   | checking database integrity (may take a while)
2012-01-04 07:05:06.507154|CRITICAL|DatabaseQuery |   | setSQLfromFile( file:sql/update_1.sql) failed

I have checked my /sql folder and that file is not there. Teamspeak server is updated to latest version and all files were replaced. Im runnning on Windows 2008 standard r2 and server is launching from Firedaemon 3.5 GA.

My ini file contains following

machine_id=
default_voice_port=9987
voice_ip=xxx.xxx.xxx.xx
licensepath=
filetransfer_port=30033
filetransfer_ip=xxx.xxx.xxx.xx
query_port=10011
query_ip=xxx.xxx.xxx.xx
query_ip_whitelist=query_ip_whitelist.txt
query_ip_blacklist=query_ip_blacklist.txt
dbplugin=ts3db_sqlite3
dbpluginparameter=
dbsqlpath=sql/
dbsqlcreatepath=create_sqlite/
dblogkeepdays=90
logpath=logs
logquerycommands=0
dbclientkeepdays=30

and it worked in that way a long time.



Nothing has been worked on it recently and I have no idea what could cause this to happen. I have people from my community screaming on me asking when will it work, so please help me asap. I hope my database is not damaged, and starting from begining should not be and option. Dont suggest me to drop or prune my database, I simply cant do it, but if its only option I will understand.

This is exported Firedaemon service, and you can see launch parameters there.
ts3server.zip

Regards, MaSS

*** Thread Merged ***

[florian_fr40]

Hello

Look at the top if this thread.
For the 3.0.1 version, the database_version value must be 19.

[Massivve]

Sorry for double posting I forgot to add screenshot of instance_properties and I cant see my first post.

Here it is

http://i39.tinypic.com/sy4kg8.png

I cant seem to add value there. Im trying it with Sqlite browser but it throws me error. Any recommendation on what program should I use for it?

[florian_fr40]

Hum from your screenshot I see : serverinstance_permissions_version = 10
Very old server version.

I would suggest you to make a new server (dowloading the last version), but I guess you will answer me "I don't want recreate all channels/permission"

Send me your database in private message I'll try to clean it and update it from your version to the last version.

[Massivve]

Thanks, PM sent. Is it possible to switch from Sqlite to MySQL? In my case what would I have to do? I have Mysql server already ( latest ) and full access to it.

[florian_fr40]

New database sent in pm.

About the database type switch, you could find several tutos/infos on this forum

[Massivve]

Works fine, many thanks!

[florian_fr40]

Works fine, many thanks!

You're welcome

[TheReelaatiiv]

Hello,

today i installed a new teamspeak3 server (3.0.1) on my dedicated server (debian squeeze 6.0.3 64bit).
After extracting, i executed the following commands:

./ts3server_startscript.sh start <- Server works
./ts3server_startscript.sh stop <- Server stopped successfully
./ts3server_startscript.sh serveradmin_password=xxx <- After this, server crashed immediately
./ts3server_startscript.sh start <- After this, the error message comes up

The error message is as follows:

2012-01-04 09:45:45.788508|CRITICAL|DatabaseQuery |   | setSQLfromFile (file:sql/update_1.sql) failed

I looked into the directory sql/ but there isn't any file named "update_1.sql".
I already searched google for this issue, but they are all saying "after reinstalling it works". But not on my server. After reinstalling the complete(!) dedicated server, extracting the teamspeak3 server and starting the server as i've done it the first time, it crashes again and again and again ... How can i fix this? It already worked previously (~ 2 weeks before) and there wasn't any change on the server, because the server was not online in that time!

Thank you very much,

TheReelaatiiv [Sorry for my not so good english ]

Additional information: The owner/group of the files is ts3/ts3 and i am running the server with that user.
On my other 10 servers there is the same issue. :-(

*** Thread Merged ***

[Vlavv]

Hello,

Same problem there. No matter how many times I clean and reinstall the TS 3 server, I first get this error:

2012-05-01 17:34:33.336144|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.5 (2012-04-23 04:46:12)
2012-05-01 17:34:33.336552|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2012-05-01 17:34:33.336597|INFO |DatabaseQuery | | dbPlugin version: 3.7.3
2012-05-01 17:34:33.336840|INFO |DatabaseQuery | | checking database integrity (may take a while)
2012-05-01 17:34:33.406617|INFO |SQL | | db_CreateTables() tables created
2012-05-01 17:34:33.730873|CRITICAL|PktReader | | Received Error (2)

Then, all subsequent times:

2012-05-01 17:44:19.883873|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.5 (2012-04-23 04:46:12)
2012-05-01 17:44:19.884217|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
2012-05-01 17:44:19.884260|INFO |DatabaseQuery | | dbPlugin version: 3.7.3
2012-05-01 17:44:19.884582|INFO |DatabaseQuery | | checking database integrity (may take a while)
2012-05-01 17:44:19.954711|CRITICAL|DatabaseQuery | | setSQLfromFile( file:sql/update_1.sql) failed

It works fine in my personal computer, which is also a 64-bits Arch.

Kernel: 2.6.32-6-pve x86_64.

Any update on this?

Cheers,

Vlavv.

[SilentStorm]

Had you read this thread prior to posting in it you'd have seen there are replies which fixed the Problem for others, so maybe you should try those and if they don't fix your issue post back with what you tried.