Failure Exception when trying to upgrade from 2020.10 to 2021.07

Help for integrating the Laravel package
Forum rules
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Ahmad
Posts: 72
Joined: 05 Jul 2017, 15:19

Failure Exception when trying to upgrade from 2020.10 to 2021.07

Post by Ahmad » 09 Jul 2021, 13:05

I am trying to upgrade from aimeos/laravel 2020.10 to 2021.07, I use laravel/framework 7.30.4, I do steps like as aimeos docs but process failure because of some exceptions: please take a look.
- first I replace "aimeos/aimeos-laravel": "~2021.07" in composer.json and "post-update-cmd" and after that run composer update --with-all-dependencies
- after update packages run migrate and after that run

Code: Select all

php artisan aimeos:setup
but I get Exception with this message: "ai-admin-jqadm" exists twice in "C:\xampp\htdocs\shop\vendor\aimeos\ai-admin-jqadm" and in "C:\xampp\htdocs\shop\ext\ai-admin-jqadm"

why?I install a fresh 2021.04 version and there are these packages in /ext folder. why i get this and what can i do?

after It, I remove /ext folder and run php artisan aimeos:setup again, and get another exception with this message:
Checking table "users":
Aimeos\MW\DB\Exception
SQLSTATE[HY000]: General error: 1833 Cannot change column 'id': used in a foreign key constraint 'fk_lvuad_pid' of table 'shop.users_address': ALTER TABLE users CHANGE id id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL


why?

I remove the fk_lvuad_pid from my sql and run aimeos:setup again and get another exception with this message:
SQLSTATE[HY000]: General error: 1833 Cannot change column 'id': used in a foreign key constraint 'fk_lvuad_pid' of table 'shop.users_address': ALTER TABLE users CHANGE id id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
I remove these key and get SQLSTATE[HY000]: General error: 1833 Cannot change column 'id': used in a foreign key constraint 'fk_lvuli_pid' of table 'shop.users_list': ALTER TABLE users CHANGE id id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL
remove that and again get SQLSTATE[HY000]: General error: 1833 Cannot change column 'id': used in a foreign key constraint 'fk_lvupr_pid' of table 'shop.users_property': ALTER TABLE users CHANGE id id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL

remove that and aimeos:setup process succeeded.

please help me and say what can i do to upgrade in safe mode and without error from 2020.10 to 2021.07?

User avatar
aimeos
Administrator
Posts: 7879
Joined: 01 Jan 1970, 00:00

Re: Failure Exception when trying to upgrade from 2020.10 to 2021.07

Post by aimeos » 11 Jul 2021, 16:40

First of all, you have to remove the ./ext/ai-* directories because these packages are now located in ./vendor/aimeos/. Our upgrade guide isn't ready yet but will follow in the next 1-2 weeks I think.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply