• Hey Guest, we're evolving the future of TeaSpeak.
    You're invited to join the discussion here!

Migrate Tea*Speak mysql to teaspeak mysql

Status
Not open for further replies.
O

omar

New member
I just put my mysql connection info to config.yml , and run teastart_minimal.sh i got this error

"[2018-08-14 12:46:26] [CRITICAL] GEN | Could not setup SQL table indexes! Command 'CREATE INDEX `idx_servers_serverId` ON `servers` (`serverId`);' returns sql: CREATE INDEX `idx_servers_serverId` ON `servers` (`serverId`); returned -> -1/Key column 'serverId' doesn't exist in table"

Tea*Speak use server_id key on servers and clients table but teaspeak use serverId key.
How can i migrate my database from Tea*Speak to teaspeak ?
I have too much foreign and primary key on my database what should i do ?
 
WolverinDEV

WolverinDEV

TeaSpeak Team
Staff member
Administrator
Hey,
its not possible to use your Tea*Speak database with TeaSpeak.
You have to create snapshots and import them.
 
O

omar

New member
Nevermind the migrade, i have another problem :\

Code: 
[2018-08-14 13:43:28] [DEBUG]    19 | Updating server property: virtualserver_last_client_disconnect. New value: 1534247008. Query: UPDATE `properties` SET `value` = :value WHERE `serverId` = :sid AND `type` = :type AND `id` = :id AND `key` = :key
[2018-08-14 13:43:28] [DEBUG]    45 | Updating server property: virtualserver_last_client_disconnect. New value: 1534247008. Query: UPDATE `properties` SET `value` = :value WHERE `serverId` = :sid AND `type` = :type AND `id` = :id AND `key` = :key
[2018-08-14 13:43:28] [ERROR]   GEN | SQL Error: Can't create more than max_prepared_stmt_count statements (current value: 16382)
[2018-08-14 13:43:28] [CRITICAL]   GEN | Failed to execute sql command: -1/Can't create more than max_prepared_stmt_count statements (current value: 16382)
[2018-08-14 13:43:28] [ERROR]   GEN | SQL Error: Can't create more than max_prepared_stmt_count statements (current value: 16382)
[2018-08-14 13:43:28] [CRITICAL]   GEN | Failed to execute sql command: -1/Can't create more than max_prepared_stmt_count statements (current value: 16382)
[2018-08-14 13:43:28] [DEBUG]   244 | [95.10.188.168:52277/undefined] Cant flush io!
[2018-08-14 13:43:28] [DEBUG]   244 | [95.10.188.168:52277/undefined]   Acknowledge queue not empty!
[2018-08-14 13:43:28] [INFO]    244 | Voice client 0/s9+shZrjkvYeb3T/xmX36v5jmUM= (undefined) from xx.xx.xx.xx:52277 left.
[2018-08-14 13:43:28] [DEBUG]   244 | Updating server property: virtualserver_last_client_disconnect. New value: 1534247008. Query: UPDATE `properties` SET `value` = :value WHERE `serverId` = :sid AND `type` = :type AND `id` = :id AND `key` = :key
[2018-08-14 13:43:28] [ERROR]   GEN | SQL Error: Can't create more than max_prepared_stmt_count statements (current value: 16382)
[2018-08-14 13:43:28] [CRITICAL]   GEN | Failed to execute sql command: -1/Can't create more than max_prepared_stmt_count statements (current value: 16382)
[2018-08-14 13:43:28] [DEBUG]    88 | Cant decrypt packet of type Command. Dropping packet. Error: memory verify failed!
[2018-08-14 13:43:28] [DEBUG]    88 | Cant decrypt packet even with default key!
[2018-08-14 13:43:28] [DEBUG]    97 | Cant decrypt packet of type Command. Dropping packet. Error: memory verify failed!
[2018-08-14 13:43:28] [DEBUG]    97 | Cant decrypt packet even with default key!
[2018-08-14 13:43:28] [DEBUG]   112 | [xx.xx.xxx.xx:64634/undefined] Got initivexpand acknowlage!
[2018-08-14 13:43:28] [DEBUG]    17 | Cant decrypt packet of type Command. Dropping packet. Error: memory verify failed!
[2018-08-14 13:43:28] [DEBUG]    17 | Cant decrypt packet even with default key!
[2018-08-14 13:43:28] [CRITICAL]   GEN | Could not shutdown server within 30 seconds! (Hangup!)
[2018-08-14 13:43:28] [CRITICAL]   GEN | Killing server!
 
Status
Not open for further replies.