SQL error when trying to upgrade to 1.4.2.

[yonghan79]

Hi core devs,

I get:

Code: [Select]

SQL-ERROR: "array (
'error_text' => 'Can\'t DROP INDEX `abqm_lang_definition_idx`; check that it exists',
'errno' => 1091,
)"  in /home/xxxxx/xxxx/core/lib/package_manager.php on line 832
when try to upgrade to 1.4.2.

[G. O.]

I got same error. to fix it you need to go to your hosting account and login to phpMyAdmin site and locate this (abqm_lang_definition_idx) and rename it correctly as should be then upgrade your cart again.

[abolabo]

if index does not exists just run this sql and start upgrade process again.

Code: [Select]

CREATE INDEX `ac_lang_definition_idx` ON `ac_language_definitions` (`language_value`(500) ASC);
Do not forget replace ac_ prefix in the names with yours before.

[yonghan79]

Thanks abolabo, i will try it

[abolabo]

probably same issue can be with table settings

Code: [Select]

CREATE INDEX `ac_settings_idx` ON `ac_settings` (`value`(333) ASC);