Upgrade Exceptions Table

[cactusrunning]

I keep getting these error messages when trying to upgrade: NOTE: Skipped upgrade statements: 3.

I went into my phpAdmin to view the Upgrade Exceptions Table and am seeing this:

("PRIMARY" must be the name of and only of a primary key!)

I selected to ignore this and then receive this error message in the table:

MySQL said: Documentation
No index parts defined!

I assume I need to manually alter a field in this table so it will be ignored when running my upgrade. Any ideas on what to alter it to say? My options are to change the Index Type or Field. Within each of these are different options.

[cactusrunning]

I also see this:

sqlstatement
ALTER TABLE orders ADD INDEX idx_cust_id_orders_id...
ALTER TABLE orders_products ADD INDEX idx_prod_id_...
INSERT INTO configuration (configuration_title, co...

but can't figure out to the read the rest of the statements. I thought maybe if I could read the statements I would know what to insert into the configure file and what to alter in the tables.......

[cactusrunning]

Ok I got the statements opened. Here is what the configuration one says to do:

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Show Split Tax Lines', 'SHOW_SPLIT_TAX_CHECKOUT', 'false', 'If multiple tax rates apply, show each rate as a separate line at checkout', '1', '22', 'zen_cfg_select_option(array(\'true\', \'false\'), ', now());

Am I supposed to insert this entire paragraph or just the part that starts with VALUES to the end?

[DrByte]

NO NO NO!

It says they were Skipped ... for a reason: ie: they're already done.

And that's because you're re-running the database upgrade over and over and over and over again.