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

djk · #1 05-21-2003, 11:19 AM

Getting this at the
source reloaddb.sql; step

any ideas?

Morbid · #2 05-22-2003, 07:28 AM

yeah i got that one too.. i am completely lost

Zasheet · #3 05-23-2003, 05:05 PM

Add me to the list of morons that cant figure this out... then answer it. :p~

jarett82 · #4 05-24-2003, 01:08 PM

Yep, same here...can't get past this point.

IASilvor · #5 05-24-2003, 06:28 PM

Yeah I've got the same problem, hope someone can help with this.
EDIT------
After grabbing worlddata1.1.zip it got a little further but then i got another very similar error (something about column not matching value I think), and it just stopped and kept beeping forever. I really hope someone knows how to get by this..

Lurker_005 · #6 05-25-2003, 03:31 AM

This problem is caused by mismatched versions of data (drawde's, telmet, or DB Addon), and db.ini

They both need to match the version of the EQEmu executables.

The Omega Soldier · #7 05-28-2003, 05:27 AM

I had this problem as well, it seems that the database can't read the world data that's inside the mysql/bin directory. Try downloading the latest world data and the eqnpc program from

www.edwardpinniger.bctalk.net

and extracting the world data to the mysql/bin folder. if you still get the error, try converting the files using the above program. write back if it still don't work.