EQEmulator Forums - Ack.. DBloaditems error

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::General Support (https://www.eqemulator.org/forums/forumdisplay.php?f=598)

- - Ack.. DBloaditems error (https://www.eqemulator.org/forums/showthread.php?t=16474)

dzags

10-19-2004 01:12 AM

Ack.. DBloaditems error

Just had to restart my server on a new computer, set everything up how I had before (it worked perfect before) but now when I start my world.exe I get this error

Code:

DBLoaditems query 'SELECT charges,unknown002,unknown003,merchantprice,unknown005,unknown006,unknown007,spellcharges,itemclass,name,lore,idfile.... lots of other things, ends with FROM items ORDER BY id', #1054: Unknown column 'spellcharges' in 'field list'

Then my zones won't load anything... they get stuck on [status ] loading items and [status] EMuShareMem loaded

Did I miss something in my installation?

dzags

10-19-2004 01:14 AM

Update: my zones loaded, but they say [Error] Loading items FAILED!

eq_addict_08

10-19-2004 02:29 AM

Did you use a backup of your old DB or source a new one? I would guess you sourced a new one. Looks like you have columns in items table that your source doesn't know about. I had that issue putting new items dumps into my older server. Just have to mod the DB to fit what your server expects.

dzags

10-19-2004 02:31 AM

How would I go about doing that?

Chrysm

10-19-2004 04:32 AM

Re: Ack.. DBloaditems error

Quote:

Originally Posted by dzags

Just had to restart my server on a new computer, set everything up how I had before (it worked perfect before) but now when I start my world.exe I get this error

Code:

DBLoaditems query 'SELECT charges,unknown002,unknown003,merchantprice,unknown005,unknown006,unknown007,spellcharges,itemclass,name,lore,idfile.... lots of other things, ends with FROM items ORDER BY id', #1054: Unknown column 'spellcharges' in 'field list'

Then my zones won't load anything... they get stuck on [status ] loading items and [status] EMuShareMem loaded

Did I miss something in my installation?

ALTER TABLE items CHANGE 'unknown008' 'SpellCharges' INT(11) DEFAULT '0' NOT NULL;

jenniferrose

10-19-2004 01:50 PM

Quote:

ALTER TABLE items CHANGE 'unknown008' 'SpellCharges' INT(11) DEFAULT '0' NOT NULL;

has this actually worked for anyone? ive tried this on several occassions trying to get a working 6.0 database, but always get

you have an error in syntax at 'unknown008' 'SpellCharges' INT(11) DEFAULT '0' NOT NULL at line 1

Trasher

10-19-2004 02:51 PM

Quote:

Originally Posted by jenniferrose

Quote:

ALTER TABLE items CHANGE 'unknown008' 'SpellCharges' INT(11) DEFAULT '0' NOT NULL;

I have done this and together with the update for the 5.8 DB the 6.0-dr1 works fine.

You only have to do it one time. :D

Sakrateri

10-19-2004 11:23 PM

Im gettting the same exact error in syntax as you Trasher . Anyone know a fix?

Derision

10-19-2004 11:46 PM

Quote:

Originally Posted by jenniferrose

Drop the single quotes around unknown008 and SpellCharges, e.g.

Quote:

ALTER TABLE items CHANGE unknown008 SpellCharges INT(11) DEFAULT '0' NOT NULL;

or change the single quotes to 'backticks', e.g.

Code:

ALTER TABLE items CHANGE `unknown008` `SpellCharges` INT(11) DEFAULT '0' NOT NULL;

Xothin

10-20-2004 06:16 AM

Actually, the syntax that finally worked for me was...

Code:

ALTER TABLE items CHANGE `unknown008` `SpellCharges` INT(11) DEFAULT "0" NOT NULL;

zephyr325

10-20-2004 06:30 AM

Quote:

Originally Posted by Xothin

Actually, the syntax that finally worked for me was...

Code:

ALTER TABLE items CHANGE `unknown008` `SpellCharges` INT(11) DEFAULT "0" NOT NULL;

Agreed - this was the format I had to use (changing both types of tics) before it would work.

All times are GMT -4. The time now is 12:24 AM.