XP statistics problem after update to 3.00

Psyfire · Post by **Psyfire** » Mon Dec 18, 2006 10:19 am

--- Please enter the following information for support ---
War3ft Version: WC3:FT v2.3.2
Amxmodx Version: AMXX v1.76b
Metamod Version: MM v1.19
amxx list: doesnt matter
amxx modules: doesnt matter
meta list: doesnt matter

Hello,

I got a server running WC3 FT v2.3.2. I got XP statistics 1.1 from the official wc3 ft page. All was running fine until the day I removed the server. Before I removed my server, I did a backup from all server data. The sql database and the xp statistics were not deleted.

After 4 weeks I put another server on, running again wc3 ft with my backuped data and the xp statistics from the old users. Everything was running fine until I saw that wc3 ft got a new version. 3.00 beta or something. I updated all and then I got the problem.

I opened my Xp statistics and I saw that it was terrible wrong. http://www.extreme-assault.de/xp_statistics/

This is the problem. Just look at the tables... Nothing works there, try to search for users, nothing happens. If doesnt show anything right. Then I removed this version 3.00 from the server and reinstalled v2.3.2 but nothng happend. I just want that it works again. Like before the update..

Post by **YamiKaitou** » Mon Dec 18, 2006 10:28 am

viewtopic.php?t=2225&highlight=statistics

Doesn't work with 3.0

Psyfire · Post by **Psyfire** » Mon Dec 18, 2006 11:31 am

I know that it doesnt work, thats why I reinstalled 2.32. But then it wont work again? This is my problem.

Post by **YamiKaitou** » Mon Dec 18, 2006 12:02 pm

Did you wipe the sql database first?

Psyfire · Post by **Psyfire** » Mon Dec 18, 2006 12:16 pm

Sorry my english is not the best. What means "wipe"?

I did not backup the database because I thought nothing would happen. The database is full like in the past. It was not overwritten with a couple of lines from the beta 3.00 update. It has 5000 lines like in the past.

Post by **YamiKaitou** » Mon Dec 18, 2006 12:25 pm

Did you use a clean install of the database for the 3.0 server?

Psyfire · Post by **Psyfire** » Mon Dec 18, 2006 1:09 pm

No I did not use a clean install. But why? I got the installed data from 2.32 and I removed 3.0.0. But I think for a couple of minutes the version 3.0.0 did optimize the database with its tables and destroyed the table form for the version 2.3.2

Is this possible?

Post by **YamiKaitou** » Mon Dec 18, 2006 1:14 pm

3.0 is different from 2.3.2 so it is possible that it corrupted your 2.3.2 data if you already had 2.3.2 data in the database when you installed 3.0 to the database

Psyfire · Post by **Psyfire** » Mon Dec 18, 2006 1:16 pm

Thats hard... So I have to delete now all XP's or can I make something to repair this?

Post by **Geesu** » Mon Dec 18, 2006 1:36 pm

This is b/c 3.0 changes ur database structure...

Delete the playerip column and it will work again

Psyfire · Post by **Psyfire** » Mon Dec 18, 2006 1:45 pm

Just perfect Geesu. It works.

Thread can be closed - Thanks