Problem with MySQL 5.0

[cokotech]

Hello!

We changed our Database from sqlite to mysql 5.0. The Server is running, and wie can change the text form the channels, but wie can't creat new users and rooms. When we try to do this the server shows a message like ... already in Use....
The Log File shows the following information:


16-04-07 18:31:04,ERROR,All,SQL, ExecSQL Error: EDatabaseError.Duplicate entry '0' for key 1 in query: insert into ts2_channels
(i_channel_server_id,
i_channel_parent_id,
b_channel_flag_moderated,
b_channel_flag_hierarchical,
b_channel_flag_default,
i_channel_codec,
i_channel_order,
i_channel_maxusers,
s_channel_name,
s_channel_topic,
s_channel_description,
s_channel_password,
dt_channel_created)
values
(16,
751,
0,
0,
0,
12,
3200,
50,
'[FPA]',
'Freie Piraten Allianz',
'Oberhaupt : Hispaniola - ICQ 233-209-830^M',
'',
'16042007183016314');

16-04-07 23:39:10,ERROR,All,CLIENT, DBAddUser Exception: EInvalidField.DatabaseError: Duplicate entry '0' for key 1
16-04-07 23:39:28,ERROR,All,SQL, ExecSQL Error: EDatabaseError.Duplicate entry '0' for key 1 in query: insert into ts2_clients
(i_client_server_id,
b_client_privilege_serveradmin,
s_client_name,
s_client_password,
dt_client_created)
values
(16,
0,
'sponsor',
'test',
'16042007233928437');

Is somebody able to help us?

Bye Sven!

[cokotech]

Okay, i found it by mysqlf, the autoincrement feature in the tables was disabled for the Primary Key!


Bye SVen!

[Reedy Boy]

http://forum.goteamspeak.com/attachm...0&d=1164623354 is the updated SQL Files for MySQL