1146 Error Upgrading 1.4.1 > 1.4.2

[MGBReg]

Hi Trying to upgrade to the latest version but fails and error logs show

Unknown Error: AbanteCart core v.1.4.1 SQL-ERROR: "array (
'error_text' => 'Table \'db769632144.abc_customer_sessions\' doesn\'t exist',
'errno' => 1146,
)" in /homepages/10/d4527924**/htdocs/mgbregalia/core/lib/package_manager.php on line 832

Any Ideas?

Thanks

[abolabo]

Run this sql-query before upgrade via phpMyAdmin.
Do not forget do full backup of your cart (see database export tab in phpMyAdmin)

Code Select Expand


--
-- DDL for table `user_sessions`
--
DROP TABLE IF EXISTS `abc_user_sessions`;
CREATE TABLE `abc_user_sessions` (
    `user_id` int(11) NOT NULL,
    `token` varchar(128) NOT NULL DEFAULT '',
    `ip` varchar(50) NOT NULL DEFAULT '',
    `last_active` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`user_id`, `token`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- DDL for table `customer_sessions`
--
DROP TABLE IF EXISTS `abc_customer_sessions`;
CREATE TABLE `abc_customer_sessions` (
    `customer_id` int(11) NOT NULL AUTO_INCREMENT,
    `session_id` varchar(128) NULL DEFAULT '',
    `ip` varchar(50) NOT NULL DEFAULT '',
    `last_active` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `date_added` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`customer_id`, `session_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

#update menu design item
UPDATE `abc_dataset_values`
SET value_varchar = 'design/template'
WHERE row_id=3 AND value_varchar='extension/extensions/template';

#fix or prior upgrade 1.3.4->1.4.0
UPDATE `abc_blocks`
SET controller='blocks/viewed_products'
WHERE controller='viewed_products/viewed_products' AND block_txt_id = 'viewed_products';


[MGBReg]

Thank you for the reply abolabo.
I've only just seen it and I tried to update again today with the same issue.

I ran the SQL-query and got the following message.

#1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

So I tried changing the NULL to UNIQUE on all lines but it did not like that either :0(

Then tried it all individually and it now gets past those and comes up with

2025-08-05 20:04:43 - Unknown Error: AbanteCart core v.1.4.1 SQL-ERROR: "array (
'error_text' => 'Duplicate column name \'supplier_code\'',
'errno' => 1060,
)" in /homepages

Any further ideas?

Regards
Paul