Update Aimeos Latest Version

[pradeepsinh]

Hey,
Greetings

TYPO3 version : 11.5.19
Aimeos Version : 22.10.3

i am using the TYPO3 latest version 11.5.19 with composer based. i have used the aimeos version 22.7.2 in my site.
now i need to update latest aimeos version. but when i update it then shown the database related error in backend and also in frontend.

Screenshot.png (160 KiB) Viewed 3284 times

can you please help me how i can fix this ?

Thank you

[aimeos]

You have to run the TYPO3 Upgrade Wizard for the Aimeos extension when upgrading between non-minor versions.

[gurubroz]

Hi there,

I have also faced this error on upgrading Aimeos core from 22.7.2 to 22.10.3.

I have also tried to run the Upgrade wizard but there are also cause the issue like this https://i.imgur.com/TffHKmG.png

Thanks in advance

[gurubroz]

I have found the solution, I know this is not a standard way but after this my setup have not any issue and working fine.

Run Just this SQL queries to again workout of the new upgraded extension:

Code: Select all

ALTER TABLE `mshop_supplier` ADD `pos` INT NOT NULL DEFAULT '0' AFTER `editor`;
ALTER TABLE `mshop_order` ADD `invoiceno` INT NOT NULL DEFAULT '1';
ALTER TABLE `mshop_order` ADD `rating` decimal(4,2) NOT NULL DEFAULT '0.00';
ALTER TABLE `mshop_order` ADD `ratings` int(11) NOT NULL DEFAULT '0';

CREATE TABLE `mshop_order_basket` ( `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `siteid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `customerid` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `content` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `mtime` datetime NOT NULL, `ctime` datetime NOT NULL, `editor` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


ALTER TABLE `mshop_order_basket` ADD PRIMARY KEY (`id`), ADD KEY `idx_msordca_custid` (`customerid`), ADD KEY `idx_msordca_mtime` (`mtime`); 

[aimeos]

Your shared image doesn't show the error because it's at the end of the output.

The Aimeos setup tasks should automatically update the database structure and migrate the data. If not, sharing the error output as text is required to solve any problems.