PDA

View Full Version : Unknown column 'message' in 'field list'


eq4me
09-06-2006, 10:06 AM
Hi,

I can connect via MiniLogin just fine. But when I want to enter the World I get this:


[Status] Booting kaladimb
Map header: 23213 faces, 48 nodes, 25490 facelists
Loaded map: 69639 vertices, 23213 faces
Map BB: (-283.88 -> 445.81, -24.00 -> 1481.41, -95.97 -> 83.97)
Map ./Maps/kaladimb.map loaded.
Path File ./Maps/kaladimb.path not found.
[Status] Weather should change in 5392 seconds
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
[Status] Loading spawn2 points...
[Status] Loading player corpses...
[Status] Loading traps...
[Error] Error in LoadTraps query 'SELECT id,x,y,z,effect,effectvalue,effectvalue2,skill,spa wnchance,maxzdiff,radius,chance,message FROM traps WHERE zone='kaladimb'': #1054: Unknown column 'message' in 'field list'
[Error] Loading traps failed.
Zone->Init failed


I am using EQEmu-0.7.0-845 and peq-luclin-rc1 database. I checked a few other starter zones, got the same error.

I spend quite a bit searching but couldnt find anything on this.

John Adams
09-06-2006, 10:48 AM
Did you search the changelog.txt? Sounds like you missed the 7/16 ADD column sql command.

eq4me
09-06-2006, 10:56 AM
Ouch, silly me.
Thanks alot. :)

arew264
09-12-2006, 01:18 PM
Sorry to rez an old post, but I have this exact error in my fresh install of 0.7.0-845 with PEQ Luclin RC1. I see no changelog file in the tar of 0.7.0. At all.

John Adams
09-12-2006, 01:42 PM
Click the link to eqemulator.net below, back to the portal. Click Downloads. Click changelog for your version. Should be linked there, too.

arew264
09-12-2006, 01:51 PM
DOH!
Now I feel dumb.
Found the log and made the changes I need into an sql file, I'ma source it later tonight and everything should work.

BTW: I'm using MySQL 5, which is supported according to the changelog. Is support complete enough for it to run?

John Adams
09-12-2006, 03:02 PM
I am fairly certain MySQL 5 should not be a problem. I've run on many versions, settiling for 4.1.20 for the most compatibility across all my projects.