cokotech
17-04-2007, 11:16
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!
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!