Problems with admin interface when using MySQL Database...

[kevinmd88]

I searched all over the place for anyone having a similar problem. I even found some relevant discussions, but none of them seemed to produce a resolution (or were in German :) ).

I configured TeamSpeak server (2.0.r24.b1) to use MySQL 5 using the ODBC driver that was described somewhere in this forum. It seemed to work fine, the server started without errors and I could connect to the server just fine.

I openedhe web administration page and logged in as one of my super administrator accounts, and when I selected my server, the interface went completely berzerck. There were %%VARIABLE%% things everywhere, in the main layout and the Server Settings page (%%LOGGEDINUSERNAME%% I think was one of them) and these %%VARIABLE%% things seemed to be in place of the values that would otherwise be there for me to edit, like in textboxes. I could not save any data. I remember at some point I received an error message along the lines of "the specified server is invalid".

Has anyone else had this problem? Is there a way to fix this?

Thanks in advance :)

[ANR Daemon]

Haven't had this problem in a while. Looks strange.
Did You add "SET NAMES YourEncoding" in ODBC connection settings in control panel? (Guess MySQL5 operate in UTF8 by default)

Is it newly created database or port from SQLite?

[kevinmd88]

MySQL 5 said it defaulted to the "latin1" encoding when I configured it... but I tried adding the "SET NAMES latin1;" to the initial statement. Didn't help.

And it happens regardless, both when I setup MySQL and use the database it creates by default, or if I import mine.

[EDIT]
Also, I just looked in my server error log. It has some suspicious entries:

25-11-07 12:08:32,ALL,Info,server, Server init initialized
25-11-07 12:08:32,ALL,Info,server, Server version: 2.0.24.1 Win32
25-11-07 12:08:32,WARNING,Info,SQL, created table ts2_servers
25-11-07 12:08:32,WARNING,Info,SQL, created table ts2_server_privileges
25-11-07 12:08:32,WARNING,Info,SQL, created table ts2_channels
25-11-07 12:08:32,WARNING,Info,SQL, created table ts2_channel_privileges
25-11-07 12:08:32,WARNING,Info,SQL, created table ts2_clients
25-11-07 12:08:32,WARNING,Info,SQL, created table ts2_bans
25-11-07 12:08:32,ERROR,All,SERVER, VirtualServer Startup(1) Exception: EInvalidField.field b_sp_AdminEditServerWelcomeMessage not found
25-11-07 12:08:33,ALL,Info,server, Server init finished
25-11-07 12:08:48,ERROR,All,WEBINTERFACE, SetVariables Exception: EAccessViolation.Access violation at address 0048A416 in module 'server_windows.exe'. Read of address 00000024
25-11-07 12:11:22,ALL,Info,server, Server shutdown initialized
25-11-07 12:11:22,ALL,Info,server, Stopping VirtualServer id:1 with port:8767
25-11-07 12:11:22,ERROR,All,SERVER, TServerObject.Stop(1) Exception: EAccessViolation.Access violation at address 0048A468 in module 'server_windows.exe'. Read of adderss 0000000C
25-11-07 12:11:22,ALL,Info,server, Stopped VirtualServer id:1 with port:8767
25-11-07 12:11:24,ALL,Info,server, Server shutdown finished

[ANR Daemon]

Looks like You have bugged SQL files.
Take care and download fresh set of SQL files for Your server then recreate database.

[kevinmd88]

Well, I think I've found 99% of the problem. I deleted the MySQL database so that teamspeak would recreate it, and before that I got rid of the "Engine=MyISAM" at the end of the create statements in the mysql_sql folder's create table scripts.

Now I no longer get any problems EXCEPT for the server permissions pages. They all still show a variable in place of the permissions checkboxes.

Such as:

%!SERVERCFG_GROUP_PERMISSIONS_SA!%

the SA at the end seems to point to server admin, and it applies to all the other groups as well.

I look and the Engine=MyISAM is not on the create query for the server permissions table...

Any help? :)

[ANR Daemon]

Sure. I'll upload my database structure as my time permits.
I have many issues sorted and it working for me so far.

Here is it.

Take Your time to adjust tables encoding and storage type.
Backup all Your table data, trash all tables and run this script.
Import tables data backs. Then start server.

If it is fresh installation, You may skip backup/restore steps and go directly to trashing and importing structure, then try to start server.