Update Aimeos Latest Version
Forum rules
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your TYPO3, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
- Posts: 6
- Joined: 08 Dec 2022, 12:19
Update Aimeos Latest Version
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.
can you please help me how i can fix this ?
Thank you
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.
can you please help me how i can fix this ?
Thank you
Re: Update Aimeos Latest Version
You have to run the TYPO3 Upgrade Wizard for the Aimeos extension when upgrading between non-minor versions.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star
Re: Update Aimeos Latest Version
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
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
Re: Update Aimeos Latest Version
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:
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`);
Re: Update Aimeos Latest Version
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.
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.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, give us a star
If you like Aimeos, give us a star