SQL Syntax Error

[kkotowick]

So I have a hosted web server running Debian Linux. When I run the following command, I get the output:

$ LD_LIBRARY_PATH=/home/*****/teamspeak.******.com ./ts3server_minimal_runscript.sh dbplugin=ts3db_mysql

TeamSpeak Server 3.0.0-beta28 [Build: 12264]
(c)TeamSpeak Systems GmbH

Logging started
2010-09-19 22:27:29.978011|INFO    |ServerLibPriv |   | Server Version: 3.0.0-beta28 [Build: 12264], Linux
2010-09-19 22:27:29.979286|INFO    |DatabaseQuery |   | dbPlugin name:    MySQL plugin, (c)TeamSpeak Systems GmbH
2010-09-19 22:27:29.979317|INFO    |DatabaseQuery |   | dbPlugin version: 1
2010-09-19 22:27:31.369071|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,  ch                                                     annel_parent_id  integer unsigned,  server_id        ' at line 1
2010-09-19 22:27:31.369153|CRITICAL|SQL           |   | db_CreateTables() unable to create tables

This user specified in "ts3db_mysql.ini" has full permissions/privilages on the database, and I know it can access it because it manages to create one table before crashing. Any reason it would be doing this?

[florian_fr40]

Hello

If the mysql server is not on the same computer, be sure that the user is able to remote connection "%".

Have you test if you can connect or/and create table with an database editor (like heidisql or phpmyadmin) ?

[kkotowick]

Like I said in the first post:

... and I know it can access it because it manages to create one table before crashing. Any reason it would be doing this?

[florian_fr40]

You can't use just the start parameter dbplugin.

You must use dbplugin to specifiy the access database AND the sql command file with : dbsqlcreatepath and dbsqlpath

In your case try with this :

./ts3server_minimal_runscript.sh dbplugin=ts3db_mysql dbsqlpath=sql/ dbsqlcreatepath=create_mysql/ dbsqlpath=sql/

to specifiy the mysql command (by default the server use the sqlite commands).

The clean solution will be to use the ts3server.ini and with your ts3db_mysql.ini