Shopping Cart Operations > General Support

SQL error when trying to upgrade to 1.4.2.

(1/1)

yonghan79:
Hi core devs,

I get:


--- Code: ---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
--- End code ---

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: ---CREATE INDEX `ac_lang_definition_idx` ON `ac_language_definitions` (`language_value`(500) ASC);
--- End code ---

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: ---CREATE INDEX `ac_settings_idx` ON `ac_settings` (`value`(333) ASC);
--- End code ---

Navigation

[0] Message Index