Forum


Notice to all users

We are migrating towards a new forum system located at community.teamspeak.com, as such this forum will become read-only on January 29, 2020

Results 1 to 4 of 4
  1. #1
    Join Date
    April 2013
    Posts
    2

    database error when trying to ban

    Hello guys,

    im running my ts3 server for a couple of months now and today i noticed that i cant ban people anymore.
    I get the message "database error".

    Updated my server and tryied to restart, i got a "permission denied" message on
    ./ts3server_startscript.sh restart

    I donīt know if that is a problem with the file permissions but i changed a couple of them to 755 and i was able to restart again. But that didn't fixed the "database error" problem.

    I didn't changed anything on the server files lately... where is the error coming from?

    chmodīs:


    Code:
    drwxr-xr-x 8 root root    4096 Apr 13 21:09 .
    drwxr-xr-x 4 root root    4096 Mar  9 12:43 ..
    drwxr-xr-x 2 root root    4096 Apr 13 20:57 doc
    drwxr-xr-x 4 root root    4096 Dec 17 00:37 files
    -rwxr-xr-x 1 root root  217640 Apr 13 20:56 libts3db_mysql.so
    -rwxr-xr-x 1 root root 1056840 Apr 13 20:56 libts3db_sqlite3.so
    drwxr-xr-x 2 root root   12288 Apr 13 21:04 logs
    -rwxr-xr-x 1 root root       1 Dec 17 00:36 query_ip_blacklist.txt
    -rwxr-xr-x 1 root root      10 Dec 17 00:36 query_ip_whitelist.txt
    drwxr-xr-x 2 root root    4096 Mar 12 21:36 serverquerydocs
    drwxr-xr-x 4 root root    4096 Mar  5 21:01 sql
    -rwxr-xr-x 1 root root 5557096 Dec 17 00:37 ts3server_linux_amd64
    -rwxr-xr-x 1 root root    1192 Apr 13 20:57 ts3server_minimal_runscript.sh
    -rw-r--r-- 1 root root       6 Apr 13 21:04 ts3server.pid
    -rwxr-xr-x 1 root root  561152 Apr 13 21:09 ts3server.sqlitedb
    -rwxr-xr-x 1 root root    3727 Apr 13 20:57 ts3server_startscript.sh
    drwxr-xr-x 2 root root    4096 Dec 17 00:37 tsdns
    just checked the log files:

    Code:
    2013-04-13 19:04:56.365325|ERROR   |DatabaseQuery |   | db_exec failed unrecognized token: ":"
    2013-04-13 19:04:56.365352|ERROR   |DatabaseQuery |   | db_exec() INSERT INTO bans (server_id, ban_ip, ban_name, ban_uid, ban_timestamp, error: unrecognized token: ":"
    2013-04-13 19:05:49.430905|ERROR   |DatabaseQuery |   | invalid parameter found :ban_hash:
    2013-04-13 19:05:49.431021|ERROR   |DatabaseQuery |   | db_exec failed unrecognized token: ":"
    2013-04-13 19:05:49.431048|ERROR   |DatabaseQuery |   | db_exec() INSERT INTO bans (server_id, ban_ip, ban_name, ban_uid, ban_timestamp, error: unrecognized token: ":"
    2013-04-13 19:09:06.723530|ERROR   |DatabaseQuery |   | invalid parameter found :ban_hash:
    2013-04-13 19:09:06.723644|ERROR   |DatabaseQuery |   | db_exec failed unrecognized token: ":"
    2013-04-13 19:09:06.723670|ERROR   |DatabaseQuery |   | db_exec() INSERT INTO bans (server_id, ban_ip, ban_name, ban_uid, ban_timestamp, error: unrecognized token: ":"
    2013-04-13 19:13:59.159618|ERROR   |DatabaseQuery |   | invalid parameter found :ban_hash:
    2013-04-13 19:13:59.159728|ERROR   |DatabaseQuery |   | db_exec failed unrecognized token: ":"
    2013-04-13 19:13:59.159755|ERROR   |DatabaseQuery |   | db_exec() INSERT INTO bans (server_id, ban_ip, ban_name, ban_uid, ban_timestamp, error: unrecognized token: ":"
    Last edited by Chris; April 15th, 2013 at 10:15 AM.

  2. #2
    Join Date
    July 2006
    Posts
    1,600
    You did not update your database properly when updating the binary.

  3. #3
    Join Date
    April 2013
    Posts
    2
    After a second update of the files it worked. Thanks

  4. #4
    Join Date
    September 2006
    Location
    Germany / Hannover
    Posts
    137
    ... and please, dont run the ts as root!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Database Error
    By Speshals in forum Server Support
    Replies: 2
    Last Post: July 24th, 2015, 10:11 AM
  2. Database Error
    By alexandrep in forum Windows
    Replies: 5
    Last Post: May 22nd, 2012, 08:29 PM
  3. database error
    By shayran in forum Windows
    Replies: 6
    Last Post: March 29th, 2012, 07:08 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
  •