No convert XP's from 2.3.2 to 3.0RC10

[Schlesie]

I try to update straight my servers of AMXX 1.76d to AMXX 1,8. I wanted to renew also equal WC3FT. The Plugin runs super and so far without problems. But the XP's is not convert by version 2.3.2 into the tables of 3.0.

AMXX-Log:

L 04/13/2008 - 22:31:31: -------- Mapchange to de_desert_city --------
L 04/13/2008 - 22:31:33: [war3ft.amxx] [MYSQLX] Error in querying database, location: 15
L 04/13/2008 - 22:31:33: [war3ft.amxx] [MYSQLX] Message: Unknown column 'playerip' in 'field list' (1054)
L 04/13/2008 - 22:31:33: [war3ft.amxx] [MYSQLX] Query statement: REPLACE INTO `wc3_config` ( `config_id` , `config_value` ) VALUES ( 'sql_conversion', '1' );

sql_conversion already is on "1"

Database:

Tabelle Aktion Einträge Typ Kollation Größe Überhang
war3users 6.063 MyISAM latin1_swedish_ci 388,5 KiB -
wc3_config 13 MyISAM latin1_swedish_ci 2,3 KiB -
wc3_player 0 MyISAM latin1_swedish_ci 1,0 KiB -
wc3_player_extra 0 MyISAM latin1_swedish_ci 1,0 KiB -
wc3_player_race 0 MyISAM latin1_swedish_ci 1,0 KiB -
wc3_player_skill 0 MyISAM latin1_swedish_ci 1,0 KiB -
wc3_web_race 162 MyISAM latin1_swedish_ci 7,7 KiB -
wc3_web_skill 648 MyISAM latin1_swedish_ci 58,8 KiB -
8 Tabellen Gesamt 6.886 MyISAM latin1_swedish_ci 461,2 KiB 0 Bytes

Amxx Plugins

22:48:59 amxx plugins
22:48:59 Currently loaded plugins:
name version author file status
[ 1] Admin Base 1.8.1.3679 AMXX Dev Team admin.amxx running
[ 2] Admin Commands 1.8.1.3679 AMXX Dev Team admincmd.amxx running
[ 3] Admin Help 1.8.1.3679 AMXX Dev Team adminhelp.amxx running
[ 4] Multi-Lingual System 1.8.1.3679 AMXX Dev Team multilingual.am running
[ 5] Menus Front-End 1.8.1.3679 AMXX Dev Team menufront.amxx running
[ 6] Commands Menu 1.8.1.3679 AMXX Dev Team cmdmenu.amxx running
[ 7] Players Menu 1.8.1.3679 AMXX Dev Team plmenu.amxx running
[ 8] Maps Menu 1.8.1.3679 AMXX Dev Team mapsmenu.amxx running
[ 9] Admin Chat 1.8.1.3679 AMXX Dev Team adminchat.amxx running
[ 10] Anti Flood 1.8.1.3679 AMXX Dev Team antiflood.amxx running
[ 11] Info. Messages 1.8.1.3679 AMXX Dev Team imessage.amxx running
[ 12] Admin Votes 1.8.1.3679 AMXX Dev Team adminvote.amxx running
[ 13] NextMap 1.8.1.3679 AMXX Dev Team nextmap.amxx running
[ 14] Nextmap Chooser 1.8.1.3679 AMXX Dev Team mapchooser.amxx running
22:48:59 [ 15] TimeLeft 1.8.1.3679 AMXX Dev Team timeleft.amxx running
[ 16] Pause Plugins 1.8.1.3679 AMXX Dev Team pausecfg.amxx running
[ 17] Stats Configuration 1.8.1.3679 AMXX Dev Team statscfg.amxx running
[ 18] StatsX 1.8.1.3679 AMXX Dev Team statsx.amxx running
[ 19] CS Misc. Stats 1.8.1.3679 AMXX Dev Team miscstats.amxx running
[ 20] CS Stats Logging 1.8.1.3679 AMXX Dev Team stats_logging.a running
[ 21] Warcraft 3 Frozen Thro 3.0 RC10 Geesu & Avanderi war3ft.amxx running
21 plugins, 21 running

Amxx Modules

22:50:18 amxx modules
22:50:18 Currently loaded modules:
name version author status
[ 1] MySQL 1.8.1.3662 AMX Mod X Dev Team running
[ 2] Fun 1.8.1.3660 AMX Mod X Dev Team running
[ 3] Engine 1.8.1.3660 AMX Mod X Dev Team running
[ 4] FakeMeta 1.8.0.3399 AMX Mod X Dev Team running
[ 5] Sockets 1.8.1.3660 HLSW Dev Team running
[ 6] RegEx 1.8.1.3660 AMX Mod X Dev Team running
[ 7] CStrike 1.8.1.3660 AMX Mod X Dev Team running
[ 8] CSX 1.8.1.3666 AMX Mod X Dev Team running
[ 9] SQLite 1.8.0.3399 AMX Mod X Dev Team running
9 modules, 9 correct

Meta List

Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm_i386. v1.8.1.3 ini Start ANY
[ 2] HLGuard RUN - hlguard_mm_night v1.9.n10 ini Chlvl Chlvl
[ 3] SBSRV RUN - sbsrv_mm_i386.so v3.5.2 ini Start Never
[ 4] MySQL RUN - mysql_amxx_i386. v1.8.1.3 pl1 ANY ANY
[ 5] Fun RUN - fun_amxx_i386.so v1.8.1.3 pl1 ANY ANY
[ 6] Engine RUN - engine_amxx_i386 v1.8.1.3 pl1 ANY ANY
[ 7] FakeMeta RUN - fakemeta_amxx_i3 v1.8.0.3 pl1 ANY ANY
[ 8] CStrike RUN - cstrike_amxx_i38 v1.8.1.3 pl1 ANY ANY
[ 9] CSX RUN - csx_amxx_i386.so v1.8.1.3 pl1 ANY ANY
9 plugins, 9 running

WC3-Config

// Warcraft 3 Frozen Throne Configuration File


// Saving Options

wc3_save_xp 1 // Enables saving of experience (default is 0)
wc3_save_xp_db 1 // How should we save XP? (0 = SQLite, 1 = MySQL)

wc3_save_by 0 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)
wc3_save_pruning 1 // Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete 60 // However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round 1 // Save xp at the end of each round (may cause lag, default is 1)


// SQL Database Information

wc3_sql_dbhost "127.0.0.1" // Host Name
wc3_sql_dbuser "*******" // User Name
wc3_sql_dbpass "*******" // Password
wc3_sql_dbname "wc3update" // Database Name

[Geesu]

So the conversion fails? Can you post a .sql file with your 2.3.2 database and a .sql file with what 3.0 tries to create?

[Schlesie]

thx four help

this is my database with all tables, inclusive from 2.3.2 and 3.0RC10

[Geesu]

OK so I'm not sure why your war3users table doesn't have a "playerip" field but it doesn't... So you need to create one and it should function fine. So just add this to it:
`playerip` varchar(35) NOT NULL default ''

Also - please use the latest revision from the SVN - the version you're using was reporting the wrong query as being problematic - I fixed it in SVN (I've also attached a compiled version)

[Schlesie]