|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself. |
10-19-2004, 01:12 AM
|
Sarnak
|
|
Join Date: Oct 2004
Posts: 34
|
|
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?
__________________
err.
|
10-19-2004, 01:14 AM
|
Sarnak
|
|
Join Date: Oct 2004
Posts: 34
|
|
Update: my zones loaded, but they say [Error] Loading items FAILED!
__________________
err.
|
10-19-2004, 02:29 AM
|
Hill Giant
|
|
Join Date: Nov 2003
Location: Drunk tank
Posts: 199
|
|
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.
|
10-19-2004, 02:31 AM
|
Sarnak
|
|
Join Date: Oct 2004
Posts: 34
|
|
How would I go about doing that?
__________________
err.
|
10-19-2004, 04:32 AM
|
Sarnak
|
|
Join Date: Oct 2002
Location: New Orleans, LA
Posts: 71
|
|
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;
__________________
Tuesdays in the 80's I was in bed by 8... and home by 11... OH!
~Quagmire, The Family-Guy
|
10-19-2004, 01:50 PM
|
Sarnak
|
|
Join Date: Jun 2003
Posts: 40
|
|
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
|
10-19-2004, 02:51 PM
|
Fire Beetle
|
|
Join Date: Nov 2003
Posts: 3
|
|
Quote:
Originally Posted by jenniferrose
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
|
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.
|
10-19-2004, 11:23 PM
|
|
Dragon
|
|
Join Date: Mar 2004
Location: England
Posts: 776
|
|
Im gettting the same exact error in syntax as you Trasher . Anyone know a fix?
|
10-19-2004, 11:46 PM
|
Developer
|
|
Join Date: Feb 2004
Location: UK
Posts: 1,540
|
|
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;
|
10-20-2004, 06:16 AM
|
Sarnak
|
|
Join Date: Oct 2004
Posts: 68
|
|
Actually, the syntax that finally worked for me was...
Code:
ALTER TABLE items CHANGE `unknown008` `SpellCharges` INT(11) DEFAULT "0" NOT NULL;
|
10-20-2004, 06:30 AM
|
Hill Giant
|
|
Join Date: Sep 2004
Posts: 117
|
|
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.
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT -4. The time now is 07:28 AM.
|
|
|
|
|
|
|
|
|
|
|
|
|