Community Forums Today's Posts     Member List     Archive    
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Location
    Berlin
    Posts
    25

    Problem with MySQL 5.0

    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!

  2. #2
    Join Date
    Jan 2007
    Location
    Berlin
    Posts
    25
    Okay, i found it by mysqlf, the autoincrement feature in the tables was disabled for the Primary Key!


    Bye SVen!

  3. #3
    Join Date
    Oct 2006
    Location
    UK
    Posts
    1,027
    http://forum.goteamspeak.com/attachm...0&d=1164623354 is the updated SQL Files for MySQL

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problem TS2 mit mySQL 4.1.13 zum Laufen zu bringen
    By Tekkla in forum [TeamSpeak 2] Server Support
    Replies: 13
    Last Post: 14-07-2006, 18:51
  2. [Howto] TS2 Server + MySQL 5.0
    By ConiKost in forum [TeamSpeak 2] Server Support
    Replies: 0
    Last Post: 08-06-2006, 19:08
  3. MYSQL -Problem
    By Komandar in forum [TeamSpeak 2] Server Support
    Replies: 20
    Last Post: 18-08-2005, 20:44
  4. mysql password problem
    By nathangoing in forum [TeamSpeak 2] Server Support
    Replies: 6
    Last Post: 23-06-2004, 14:21

Posting Permissions

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