The table already exists in the database. I'm attaching a screenshot of the customer_session fields. Is the table structure okay?

Hi Community,

I’m experiencing a persistent issue with AbanteCart v1.4.1 on a live deployment. After submitting the login form, the user is redirected to the expected account/account URL, but then immediately redirected back to the login page without any error message.

Observed Behavior:
Login form submits via POST to account/login with valid credentials.

The response returns 302 Found to account/account (as expected).

Then the browser is redirected again with 302 back to login page.

Final status is 200 OK on the login page – but the user is never authenticated.

No errors appear in AbanteCart logs or server logs.

The customer cookie is issued after login, but gets immediately deleted in the next request.

This separate theme stylesheet is not used in Bootstrap 4 or 5, as theming is now handled via Sass variables and CSS custom properties.

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

--
-- 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';


I have made a clean install and tried to rename SALE in the english language and it doesnt work, still continues with word SALE