Unkown column 'usedspells'....

[bnut]

I was following the set up for EQemu server and everything was going smoothly untill I got to the following step:

-----------------------------------------------
3.4) This part might be a little tricky for some, so read word-by-word.

- Go to your MySQL bin directory ( C:\mysql\bin ) and open " mysql.exe "

- Now type the following in this order ( Type one line, hit enter, move on to next)

create database eq;

use eq

source db.sql;

A bunch of lines should pass by ( this is normal ).

< If your computer 'beeps' , just ignore it >

Once it finishs(stop scrolling lines) Type the following

source reloaddb.sql;
------------------------------------------------

After typing reloaddb.sql;

I got the following:

ERROR 1054: Unknown column 'usedspells' in 'field list'



Any clues?

[tcsmyworld]

you need to update the DB to include npc_spells updates.

[Bordael]

My understanding is that the npc_spells table needs a new columb to allow the data population to work.

what I don't understand is which columb needs adding, what the attrubutes should be and also do I need to change the sql ?

If someone could explain in simple terms or produce a step by step guide to fix this it would be much appriciated

Thx