Ack.. DBloaditems error

[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

DBLoaditems query 'SELECT charges,unknown002,unknown003,merchantprice,unknow n005,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]

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

[eq_addict_08]

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]

How would I go about doing that?

[Chrysm]

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

DBLoaditems query 'SELECT charges,unknown002,unknown003,merchantprice,unknow n005,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]

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]

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

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]

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

[Derision]

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

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


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

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

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

[Xothin]

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




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

[zephyr325]

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




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.