Community Forums Today's Posts     Member List     Archive    
Page 1 of 2 12 LastLast
Results 1 to 15 of 18
  1. #1
    Join Date
    Aug 2005
    Location
    Cali, USA
    Posts
    65

    Solved Teamspeak3 update_1.sql error

    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.

  2. #2
    Join Date
    May 2010
    Posts
    6,369
    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.
    Last edited by florian_fr40; 04-01-2012 at 08:12.

  3. #3
    Join Date
    Aug 2005
    Location
    Cali, USA
    Posts
    65
    Quote Originally Posted by florian_fr40 View Post
    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!

  4. #4
    Join Date
    May 2010
    Posts
    6,369
    you're welcome
    Last edited by florian_fr40; 21-11-2011 at 08:25.

  5. #5
    Join Date
    Dec 2011
    Location
    on your six
    Posts
    13

    Exclamation [CRITICAL] Server suddenly not reachable, sqlite problem

    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

    Code:
    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

    Code:
    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 ***
    Last edited by florian_fr40; 04-01-2012 at 08:13.

  6. #6
    Join Date
    May 2010
    Posts
    6,369
    Hello

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

  7. #7
    Join Date
    Dec 2011
    Location
    on your six
    Posts
    13
    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?

  8. #8
    Join Date
    May 2010
    Posts
    6,369
    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.

  9. #9
    Join Date
    Dec 2011
    Location
    on your six
    Posts
    13
    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.

  10. #10
    Join Date
    May 2010
    Posts
    6,369
    New database sent in pm.

    About the database type switch, you could find several tutos/infos on this forum
    Last edited by florian_fr40; 04-01-2012 at 21:54.

  11. #11
    Join Date
    Dec 2011
    Location
    on your six
    Posts
    13
    Works fine, many thanks!

  12. #12
    Join Date
    May 2010
    Posts
    6,369
    Quote Originally Posted by Massivve View Post
    Works fine, many thanks!
    You're welcome

  13. #13
    Join Date
    Jan 2012
    Posts
    1

    setSQLfromFile( file:sql/update_1.sql) failed

    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:
    Code:
    ./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:
    Code:
    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 ***

  14. #14
    Join Date
    May 2012
    Posts
    3
    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.
    Last edited by Vlavv; 01-05-2012 at 22:57.

  15. #15
    Join Date
    Jan 2010
    Location
    Germany
    Posts
    2,046
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MySQL: setSQLfromFile( file:sql/update_1.sql) failed
    By tgp1994 in forum Server Support
    Replies: 6
    Last Post: 29-11-2012, 01:57
  2. Replies: 0
    Last Post: 04-08-2010, 16:12
  3. [solved] Failed sql/update_1.sql
    By WolwX in forum Server Support
    Replies: 2
    Last Post: 04-02-2010, 13:05
  4. Error to install Teamspeak3 Server
    By JohnnyKing94 in forum Linux / FreeBSD
    Replies: 24
    Last Post: 07-01-2010, 21:22

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •