View Single Post
  #1  
Old 10-15-2004, 02:10 PM
zephyr325
Hill Giant
 
Join Date: Sep 2004
Posts: 117
Default Winter's Roar sql statements

I've got two questions/errors I'm running into in the Winter's Roar sql update.

First, in the defintion of the aa_actions table, it looks like there are 10 columns:

CREATE TABLE aa_actions (
aaid mediumint unsigned not null,
rank tinyint unsigned not null,
reuse_time mediumint unsigned not null,
spell_id mediumint unsigned not null,
target tinyint unsigned not null,
nonspell_action tinyint unsigned not null,
nonspell_mana mediumint unsigned not null,
nonspell_duration mediumint unsigned not null,
redux_aa mediumint unsigned not null,
redux_rate tinyint not null,

PRIMARY KEY(aaid, rank)
);

Yet there are 11 columns in the Insert commands:

INSERT INTO `aa_actions` VALUES (35,0,4320,0,0,1,1,0,0,264,10);


Problem #2:

When I try to import these lines for the forage table:
INSERT INTO forage (zoneid,Itemid,level,chance) VALUES(291, 63833, 0, 100);

I get the following error:

ERROR 1054: Unknown column 'chance' in 'field list'

Any thoughts here?

Thanks...
Reply With Quote