Duplicate server entries

[Barry-Gigabyte]

Good day everybody,

I've installed the teamspeak server on my windows server and set it up to work with a mysql server via openODBC as described in a topic here on the forums.
Everything worked well, untill i added a second server, (I worked with only 1 till now). When I enter the details and save the server everything is ok. But when I start the server (either via the web-interface, or telnet/TCP client) the servername, and settings and portnumber of my first server with ID = 1 are copied to server 2. This means that I have exactly two identical servers.

Please help! Anyone has some advice?

Thanks in advance,

Barry

[ANR Daemon]

You should have a look on your DB scheme, it need some tweaking to work properly under MySQL. Namely you must check definition of autoincrement columns.

[Draygo]

Open a command line connection to your teamspeak database in mysql.

Run the following

select i_server_id, s_server_name from ts2_servers;

If you see 2 rows outputted with the same server id, your auto_increment is not working correctly. You can manually update the database and force that i_server_id to 2.

update ts2_servers set i_server_id = 2 where s_server_name = '<yourservername here>';

Assuming both servers arnt named exactly the same that will force the second server to use a server id of 2, like it should.

[ANR Daemon]

UPDATE ts2_servers SET i_server_id = 2 WHERE i_server_id = 1 LIMIT 1;
L2read...

But that still not solve the root issue, and you still need updated MySQL files for your server.
If i'm not mistaken, you're going to go to ftp://ftp.freenet.de/pub/4players/teamspeak.org/developer/server/202401/

[Draygo]

UPDATE ts2_servers SET i_server_id = 2 WHERE i_server_id = 1 LIMIT 1;
L2read...

But that still not solve the root issue, and you still need updated MySQL files for your server.
If i'm not mistaken, you're going to go to ftp://ftp.freenet.de/pub/4players/teamspeak.org/developer/server/202401/

Running the above command will set your first servers id to 2. I recommend not running it.

ANR is correct that your .sql files in your mysql folder are probably not correct, and at minimum you will have to redefine your autoincrement columns.

[ANR Daemon]

Running the above command will set your first servers id to 2. I recommend not running it.

ANR is correct that your .sql files in your mysql folder are probably not correct, and at minimum you will have to redefine your autoincrement columns.

It will set one of the server numbers to 2 to allow you to change your table properties and not get "wrong index for key 1" error message back.
And, does it really matters which server will have what number?
All you need is to know what server to delete, and for that you need to have them different numbers, then delete "server 2", because it will not have any users or rights assigned to it. Then export your database WITHOUT TABLE STRUCTURE, destroy database, replace MySQL files, start server, close server, wipe data and fill back your backup.