Please help us to make AbanteCart Ideal Open Source Ecommerce Solution for everyone.

Support AbanteCart eCommerce

Author Topic: Updating Abantecart using manual update MySql error  (Read 1064 times)

Offline alevene

  • Full Member
  • ***
  • Posts: 104
  • Karma: +6/-7
    • View Profile
Updating Abantecart using manual update MySql error
« on: April 24, 2017, 02:03:24 PM »
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.


Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1783
  • Karma: +248/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Updating Abantecart using manual update MySql error
« Reply #1 on: April 25, 2017, 03:51:16 AM »
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)
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline alevene

  • Full Member
  • ***
  • Posts: 104
  • Karma: +6/-7
    • View Profile
Re: Updating Abantecart using manual update MySql error
« Reply #2 on: April 25, 2017, 09:25:28 AM »
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.

Offline abolabo

  • core-developer
  • Administrator
  • Hero Member
  • *****
  • Posts: 1783
  • Karma: +248/-11
  • web for all, all for web!
    • View Profile
    • AbanteCart
Re: Updating Abantecart using manual update MySql error
« Reply #3 on: April 25, 2017, 10:27:20 AM »
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)
“No one is useless in this world who lightens the burdens of another.”
― Charles Dickens

Offline alevene

  • Full Member
  • ***
  • Posts: 104
  • Karma: +6/-7
    • View Profile
Re: Updating Abantecart using manual update MySql error
« Reply #4 on: April 25, 2017, 10:49:23 AM »
Thank you. I'll work on it.

 

Powered by SMFPacks Social Login Mod