Failure Exception when trying to upgrade from 2020.10 to 2021.07
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!
Always add your Laravel, Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Failure Exception when trying to upgrade from 2020.10 to 2021.07
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
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?
- 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
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?
Re: Failure Exception when trying to upgrade from 2020.10 to 2021.07
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, give us a star
If you like Aimeos, give us a star