Updating Abantecart using manual update MySql error

[alevene]

I've tried to do a manual update using the PHPmyAdmin interface and get this message -

#1061 - Duplicate key name 'unique_id in the ac_settings_idx settings. I've looked at the structure keys and compared the settings to another AbanteCart structure. The working system does not have primary keys for either Group or Key. How is the Group key removed as it may be the problem.

I have only found one reference to this phrase - FULLTEXT INDEX `ac_settings_idx` (`value` ASC) apparently to setup the ac_setup.

See photo.

If not how do I fix the problem? I can restore prior versions of the MySql database and the original 1.2.6 files.

[abolabo]

you should just remove all indexes of this table and create primary key for 4 columns: setting_id, store_id, group, key
Look for "indexes" link after table edit section (your screenshot of phpMyAdmin)

[alevene]

I think that by "remove" you mean select the lines with indexs and DROP them and recreate?

I'd add that these may not drop -
The column name 'group' is a MySQL reserved keyword.
The column name 'key' is a MySQL reserved keyword.

When I backed up the database and did a drop on all, I got this message -
#1090 - You can't delete all columns with ALTER TABLE; use DROP TABLE instead
ALTER TABLE `ac_settings` DROP `setting_id` ,
DROP `store_id` ,
DROP `group` ,
DROP `key` ,
DROP `value` ,
DROP `date_modified` ,
DROP `date_added` ;

I deleted group and key individually, and re added. They listed as Primary Keys so nothing changed. The 1.2.7 update.sql file will not import so I'm back to where I began.

[abolabo]

I think that by "remove" you mean select the lines with indexs and DROP them and recreate?

No. i meant indexes for columns. (see screenshot)

[alevene]

Thank you. I'll work on it.