Forum

Results 1 to 5 of 5
  1. #1
    Join Date
    December 2006
    Location
    USA
    Posts
    13

    Solved Unable to use mysql data base... unable to create tables

    Hello,
    When I try to make a teamspeak server on windows server 2008 (32 bit) with a mysql server, it is unable to make the tables in the database...

    Code:
    2011-09-29 23:39:13.406343|INFO    |ServerLibPriv |   | Server Version: 3.0.0 [Build: 14957], Windows
    2011-09-29 23:39:13.408296|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
    2011-09-29 23:39:13.408296|INFO    |DatabaseQuery |   | dbPlugin version: 1
    2011-09-29 23:39:13.956112|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
    2011-09-29 23:39:13.957089|CRITICAL|SQL           |   | db_CreateTables() unable to create tables
    looking in my database, it creates "channel_properties" table with "server_id", "id", "ident", "value" as fields before it comes up to that error.

    Is there anything I am able to do to make the database or to fix the issue?

    Thanks
    Joe
    Last edited by 3dhomejoe; October 3rd, 2011 at 04:29 PM.

  2. #2
    Join Date
    June 2008
    Posts
    18,151
    Can you show me the paramter or server.ini and ts3db_mysql.ini?
    Have you made any changes on our create_tables.sql ?
    When sending me private messages: Please make sure to include reference link to your forum thread or post.

    TeamSpeak FAQ || What should i report, when i open a client thread?

  3. #3
    Join Date
    December 2006
    Location
    USA
    Posts
    13
    Hello,

    First I don't have a server.ini file, I was not able to find anything in the doc folder about it when I was setting up the server...

    my ts3db_mysql.ini file is the following...
    Code:
    [config]
    host=localhost
    port=3306
    username=ts3
    password=[HIDDEN]
    database=ts3
    socket=
    and I have not made any changes to the "create_tables.sql" file

  4. #4
    Join Date
    May 2010
    Posts
    6,310
    Hello

    Info about the ts3server.ini in the same documentaiton that you use for the ts3db_mysql.ini
    (also in this forum).

    So please, post the command line that you use to start your server.

  5. #5
    Join Date
    December 2006
    Location
    USA
    Posts
    13
    Alright, thank you I missed the line on how to create the ini file
    Code:
    * createinifile (0)
      If set to "1", the server will create an INI-style config file containing all 
      commandline parameters with the values you have specified.
      Default: The server will not create a config file.
    I only saw the line below it
    Code:
    * inifile (ts3server.ini)
      The physical path where your config file is located. Per default, the config file will
      be called "ts3server.ini".
      Default: The config file is located in your servers installation directory.
    after I can the createinifile I had to change the "dbsqlcreatepath=" line to say "create_mysql/" and not "create_sqlite/" and it was able to work after that.

    Thank You
    3dhomejoe

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. mysql data base
    By tabyret in forum Linux / FreeBSD
    Replies: 1
    Last Post: January 12th, 2012, 08:05 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
  •