Server DB/application corrupted.

[Zarkow]

Have been running the RC2 successfully for 1 month, but today it started acting up.

When conencting no-one can see the derfault-channel, their own nick ("Connected as " in statusbar - notice absence of nickname) or successfully join any of the channels.

I'm the admin and when I connect I can create channels, but not join them (can't see my connected nick either) or edit the newly created channel or any of the others either...

The log-file, when I edited server-data via www-admin interface, states:

---------------------------------------------------------------
-------------- log started at 01-04-03 21:04 -------------
---------------------------------------------------------------
01-04-03 21:04:25,ALL,Info,server, Server init initialized
01-04-03 21:04:25,ALL,Info,server, Server version: 2.0.19.16 Win32
01-04-03 21:04:25,ALL,Info,server, Starting server with port: 8767
01-04-03 21:04:25,ALL,Info,server, Server init finished
01-04-03 21:09:17,ERROR,All,UDP Listener, SP: 8767 CMD_cs_PlayerChannelSwitch Exception: Access violation at address 004A5EA0 in module 'SERVER_WINDOWS.EXE'. Read of address FFFFFFFF
01-04-03 21:12:10,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: update ts2_servers set
s_server_name = 'Z's Server',
s_server_welcomemessage = 'ABFs TS Server',
i_server_maxusers = 20,
i_server_udpport = 8767,
s_server_password = '[XXXXXXXX]',
b_server_clan_server = -1,
b_server_allow_codec_celp51 = -1,
b_server_allow_codec_celp63 = -1,
b_server_allow_codec_gsm148 = -1,
b_server_allow_codec_gsm164 = -1,
b_server_allow_codec_celp52 = -1,
s_server_webposturl = '',
s_server_weblinkurl = '',
b_server_active = -1
where i_server_id = 1;

01-04-03 21:21:06,ALL,Info,server, Server shutdown initialized
01-04-03 21:21:09,ALL,Info,server, Server shutdown finished
---------------------------------------------------------------
--------------- log ended at 01-04-03 21:21 --------------
---------------------------------------------------------------

Any ideas or help would be nice. If I have to reinstall the software on the server, I would in that case need pointers as to how I save the user-DB...

[Armstrong]

s_server_name = 'Z's Server',

Take out the ' in Z's Server. See if that helps.

[Zarkow]

I just testet to add that, and got the logg-msg. The error's apeard before that.

[Dark Star]

01-04-03 21:09:17,ERROR,All,UDP Listener, SP: 8767 CMD_cs_PlayerChannelSwitch Exception: Access violation at address 004A5EA0 in module 'SERVER_WINDOWS.EXE'. Read of address FFFFFFFF
01-04-03 21:12:10,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: update ts2_servers


Seems there is an access violation to the ts database. Before I would say to replace the database which in your case means a reinstall. I would just make sure that you have not changed any rights to the applications folder so that the ts app can write to it's own database.

There are issues in ts2 where user flagging rights for channels will become wrong in non moderated channels when you move a user that has certain flags attached to them, but this should not cause the problem you are having.

Worse case you can reinstall making sure there is nothing left in the ts2 folder before reinstalling and you will get a clean database.

[Dark Star]

When conencting no-one can see the derfault-channel, their own nick ("Connected as " in statusbar - notice absence of nickname) or successfully join any of the channels.


What about yourself as admin?


Did you delete your default channel? Or maybe someone did?

[Zarkow]

No..and when I login I cannot se defualt-channel, try to switch to another of the channels but nothing happends..can create new chanels but make no options related to them (as if I had no rights, since the DB is corrupt).

[Dark Star]

Make sure your rights are correct for your SA accounts.


If you don't know how to script out the user database and append it back your going to have to reinstall to get a clean database and manually add users. Strange you can still connect without being able to see any default channel.

[Zarkow]

Well, the thing is just that in the userDB I'm still noted as Admin, got all rights, but when I (or any user) login, they don't even get the 'Connected as [their nick]' in the statusbar...

[bierdopje]

I had the same problem.
After deleting all Channels and creating a few afterwards, it worked fine again.

Although, when I check the log-file, it says:
"21-04-03 16:31:28,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: update ts2_channels set".

Earlier in the log this error is reported: "20-04-03 09:11:04,ERROR,All,SQL, ExcecSQL Error: SQL logic error or missing database in query: update ts2_channels".

Not sure what this means, but not having any problems right now (that I know of).


Greet'Z
Rik, bierdopje

[bierdopje]

Problem solved for me with latest client and server.


Greet'Z
Rik, bierdopje