SQL error when trying to upgrade to 1.4.2.

Started by yonghan79, May 12, 2025, 09:30:26 PM

Previous topic - Next topic

yonghan79

Hi core devs,

I get:

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.

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


abolabo

probably same issue can be with table settings

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

Forum Rules Code of conduct
AbanteCart.com 2010 -