Have nt been here in awhile

Daver · Post by **Daver** » Mon Dec 11, 2006 10:54 pm

I have the latest download and all I need to know is this.

The server crashes and gives thsi error message:

L 12/10/2006 - 15:37:32: [war3ft.amxx] [MYSQLX] Threaded query error, location: 1
L 12/10/2006 - 15:37:32: [war3ft.amxx] [MYSQLX] Message: Unknown column 'playerip' in 'field list' (1054)
L 12/10/2006 - 15:37:32: [war3ft.amxx] [MYSQLX] Query statement:
L 12/10/2006 - 15:37:32: [war3ft.amxx] [MYSQLX] Fail state: Query Failed

I have reg mysql database setup and running with 2 other server so I just want to use the same for the new 3 rd one. In the modules.ini I have mysql uncomented and mysqlite comented.

Thx,

Daver

--- Please enter the following information for support ---
War3ft Version:
Amxmodx Version:
Metamod Version:
amxx list:
amxx modules:
meta list:

Post by **YamiKaitou** » Mon Dec 11, 2006 10:58 pm

Are you tring to use the same database that a 2.3.2 server is using for a 3.0 server? If not, then tell us what the latest download you are running is, 2.3.2 3.0RC1, 3.0RC2, 3.0RC3, 3.0CVS

Post by **Geesu** » Wed Dec 13, 2006 8:29 am

amxx list and meta list pls

Daver · Post by **Daver** » Thu Dec 14, 2006 12:11 am

Yers I am trying to use the same database for both. Is this not possible? I am actually trying to help someone out who set this server up and asked me to fix it so Please cut me a little slack. Should I just use the old setup and scrap the 3.0 server?

Here is the info:
Meta list:
Currently loaded plugins:
description stat pend file vers src load unlod
[ 1] AMX Mod X RUN - amxmodx_mm_i386. v1.76b ini ANY ANY
[ 2] MySQL RUN - mysql_amxx_i386. v1.76b pl1 ANY ANY
[ 3] Fun RUN - fun_amxx_i386.so v1.76 pl1 ANY ANY
[ 4] Engine RUN - engine_amxx_i386 v1.76 pl1 ANY ANY
[ 5] FakeMeta RUN - fakemeta_amxx_i3 v1.76b pl1 ANY ANY
[ 6] CStrike RUN - cstrike_amxx_i38 v1.76 pl1 ANY ANY
[ 7] CSX RUN - csx_amxx_i386.so v1.76a pl1 ANY ANY
7 plugins, 7 running

Plugins:

Currently loaded plugins:
name version author file status
Admin Base 1.76b AMXX Dev Team admin.amxx running
Admin Commands 1.76b AMXX Dev Team admincmd.amxx running
Admin Help 1.76b AMXX Dev Team adminhelp.amxx running
Slots Reservation 1.76b AMXX Dev Team adminslots.amxx running
Multi-Lingual Sys 1.76b AMXX Dev Team multilingual.am running
Menus Front-End 1.76b AMXX Dev Team menufront.amxx running
Commands Menu 1.76b AMXX Dev Team cmdmenu.amxx running
Players Menu 1.76b AMXX Dev Team plmenu.amxx running
Maps Menu 1.76b AMXX Dev Team mapsmenu.amxx running
Admin Chat 1.76b AMXX Dev Team adminchat.amxx running
Anti Flood 1.76b AMXX Dev Team antiflood.amxx running
Scrolling Message 1.76b AMXX Dev Team scrollmsg.amxx running
Info. Messages 1.76b AMXX Dev Team imessage.amxx running
Admin Votes 1.76b AMXX Dev Team adminvote.amxx running
NextMap 1.76b AMXX Dev Team nextmap.amxx running
Nextmap Chooser 1.76b AMXX Dev Team mapchooser.amxx running
TimeLeft 1.76b AMXX Dev Team timeleft.amxx running
Pause Plugins 1.76b AMXX Dev Team pausecfg.amxx running
Stats Configurati 1.76b AMXX Dev Team statscfg.amxx running
StatsX 1.76b AMXX Dev Team statsx.amxx running
Warcraft 3 Frozen 3.0 RC3 Geesu & Avanderi war3ft.amxx debug
21 plugins, 20 running

Thx,
Daver

Post by **Geesu** » Thu Dec 14, 2006 4:14 pm

Add a playerip column - for somereason the autoupdate stuff didn't work