AbanteCart Community

Shopping Cart Operations => Support => General Support => Topic started by: yonghan79 on May 12, 2025, 09:30:26 PM

Title: SQL error when trying to upgrade to 1.4.2.
Post by: yonghan79 on May 12, 2025, 09:30:26 PM

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.

Title: Re: SQL error when trying to upgrade to 1.4.2.
Post by: G. O. on May 13, 2025, 12:01:10 AM

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.

Title: Re: SQL error when trying to upgrade to 1.4.2.
Post by: abolabo on May 13, 2025, 04:18:39 AM

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.

Title: Re: SQL error when trying to upgrade to 1.4.2.
Post by: yonghan79 on May 13, 2025, 11:01:26 AM

Thanks abolabo, i will try it

Title: Re: SQL error when trying to upgrade to 1.4.2.
Post by: abolabo on June 05, 2025, 06:03:14 AM

probably same issue can be with table settings

Code: [Select]

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