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;