Forum

Results 1 to 3 of 3
  1. #1
    Join Date
    December 2009
    Location
    Wilmington, Delaware
    Posts
    4

    Mysql error; AUTOINCREMENT NOT NULL

    Edit by mod
    Please don't use this outdated script anymore! The script got an overhaul long time ago.
    Please use the minimal or startscript instead



    I cant seam to find any infos on this problem im having. Any ideas?
    Thanks in advance.

    Heres all information I thought relevant.

    $mysql -V
    mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1


    Code:
    $ ./start-script.sh start
    Logging started
    2009-12-24 08:12:53.999955|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta6 [Build: 9494]
    2009-12-24 08:12:54.003671|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
    2009-12-24 08:12:54.003739|INFO    |DatabaseQuery |   | dbPlugin version: 1
    2009-12-24 08:12:54.027406|ERROR   |DatabaseQuery |   | db_exec() CREATE TABLE channel_properties (  server_id integer unsigned,  id     error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AUTOINCREMENT NOT NULL,  channel_parent_id  integer unsigned,  server_id        ' at line 1
    2009-12-24 08:12:54.027504|CRITICAL|SQL           |   | db_CreateTables() unable to create tables
    $
    start-script.sh
    Code:
    #!/bin/bash
    
    DIR="/my/hidden/path/to/ts3"
    
    case "$1" in
        start)
            cd ${DIR}
            ${DIR}/ts3server_linux_x86 dbplugin=ts3db_mysql
            ;;
        stop)
            killall ts3server_linux_x86
            ;;
    *)
            echo "Usage: 'basename $0' {start|stop}">&2
            exit 42
            ;;
    esac
    
    exit 0
    Last edited by dante696; February 21st, 2011 at 12:28 PM.

  2. #2
    Join Date
    December 2009
    Location
    Germany
    Posts
    4
    You have to create the tables first.

    run ./ts3server_linux_x86 dbplugin=ts3db_mysql dbsqlcreatepath=create_mysql/ and it should work.

  3. #3
    Join Date
    December 2009
    Location
    Wilmington, Delaware
    Posts
    4
    Thanks that did the trick, your awesome! merry Christmas!!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. (teamspeak) CMD (/var/tmp/.b/update >/dev/null 2>&1
    By Nyalia in forum Linux / FreeBSD
    Replies: 4
    Last Post: March 10th, 2014, 11:36 PM
  2. license key is null
    By MasterOne in forum Server Support
    Replies: 1
    Last Post: April 4th, 2012, 06:58 PM
  3. Mysql -> AUTOINCREMENT needs to be AUTO_INCREMENT
    By Servior in forum Server Support
    Replies: 0
    Last Post: December 26th, 2009, 02:06 PM

Posting Permissions

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