Ack.. DBloaditems error

**Derision** · #9 10-19-2004, 11:46 PM

Quote:

Originally Posted by jenniferrose

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.

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;