Forum

Results 1 to 5 of 5
  1. #1
    Join Date
    March 2013
    Posts
    3

    Update from Server Version 3.0.6 to 3.0.7 failed

    Hey mates,

    I just tried to update my TS 3 Server to the new version.
    It gives me following error log:

    2013-03-14 09:36:38.468953|INFO |ServerLibPriv | | TeamSpeak 3 Server 3.0.7 (2013-03-02 06:03:25)
    2013-03-14 09:36:38.468953|INFO |DatabaseQuery | | dbPlugin name: SQLite3 plugin, Version 2, (c)TeamSpeak Systems GmbH
    2013-03-14 09:36:38.468953|INFO |DatabaseQuery | | dbPlugin version: 3.7.3
    2013-03-14 09:36:38.468953|INFO |DatabaseQuery | | checking database integrity (may take a while)
    2013-03-14 09:36:38.809987|INFO |FileManager | | listening on 0.0.0.0:30033
    2013-03-14 09:36:38.887995|CRITICAL|DatabaseQuery | | unknown table field requested: ban_hash

    It works if I use it clean and let it create a new sqlitedb but the old DB works fine in my Server 3.0.6.1

    Did I miss something ?

    Rgds,
    Loop

  2. #2
    Join Date
    September 2012
    Posts
    6,080
    Looks like you modified the database manually before or had file permissions preventing the server from reading / writing certain files.

    You can run the following statement on the database which should fix it, however we can't support manual modifications of the database:
    Code:
    ALTER TABLE bans ADD COLUMN ban_hash varchar(255);

  3. #3
    Join Date
    March 2013
    Posts
    3
    No modification of the database was done at all.

  4. #4
    Join Date
    September 2012
    Posts
    6,080
    Then maybe it was write protected, used by something else or the sql files were not readable.

  5. #5
    Join Date
    March 2013
    Posts
    3
    Cant find anything. What tool can I use to apply the alter command ?

    So this is the query that SQLite Manager shows me the table was created with:
    CREATE TABLE bans ( ban_id integer PRIMARY KEY AUTOINCREMENT NOT NULL, server_id integer unsigned, ban_ip varchar(255), ban_name varchar(2048), ban_uid varchar(255), ban_timestamp integer unsigned, ban_length integer unsigned, ban_invoker_client_id integer unsigned, ban_invoker_uid varchar(40), ban_invoker_name varchar(255), ban_reason varchar(255), ban_enforcements integer unsigned default 0)

    As far as I can see the ban_hash was never in.


    Altered it now with the Mozilla Plugin and it all works fine.
    Just I really don't know why this field was not in.

    Thanx for your help

    Can be closed
    Last edited by Chris; March 14th, 2013 at 12:35 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. "Failed to query latest client version from update server"
    By PotaBlava in forum General Questions
    Replies: 2
    Last Post: August 26th, 2014, 05:22 PM
  2. [Resolved] NPL no longer woking after update to newest version (Server version)
    By Sriggin in forum Linux / FreeBSD
    Replies: 3
    Last Post: August 6th, 2013, 05:36 PM
  3. Replies: 3
    Last Post: November 8th, 2012, 01:22 PM
  4. Update to version 27 and my server not start =/
    By igorsantos11 in forum Linux / FreeBSD
    Replies: 1
    Last Post: August 8th, 2010, 08:47 PM
  5. Update Server Version
    By Bgdu67 in forum Server Support
    Replies: 6
    Last Post: January 31st, 2010, 04:46 AM

Posting Permissions

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