Winter's Roar sql statements

[zephyr325]

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...

[sotonin]

http://www.eqemulator.net/forums/vie...8&start=15

[zephyr325]

Originally Posted by sotonin

http://www.eqemulator.net/forums/viewtopic.php?t=17818&start=15

Thanks - Still trying to learn here, passed over that post too quickly. That fixed the load!