[SOLVED] SQL Error after composer update
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
-
- Posts: 44
- Joined: 24 Jun 2019, 14:46
[SOLVED] SQL Error after composer update
Hi,
I made composer update today and I got this error:
I tried to migrate but nothing happened. What I have to do?
I have aimeos/aimeos-laravel: 2019.10 and laravel 5.8
--------- SOLVED -------------
https://aimeos.org/docs/Laravel/Upgrade
I had to ran "php artisan aimeos:setup"
I made composer update today and I got this error:
Code: Select all
ErrorSQLSTATE[42S22]: Column not found: 1054 Unknown column 'mpro.dataset' in 'field list': SELECT DISTINCT
mpro."id" AS "product.id", mpro."siteid" AS "product.siteid", mpro."type" AS
"product.type", mpro."code"
AS "product.code", mpro."label" AS "product.label", mpro."config" AS "product.config",
mpro."start" AS "product.datestart", mpro."end" AS "product.dateend", mpro."status" AS "product.status", mpro."ctime" AS "product.ctime", mpro."mtime" AS "product.mtime", mpro."editor" AS "product.editor",
mpro."target" AS "product.target",
mpro."dataset" AS "product.dataset" FROM "mshop_product" AS mpro WHERE ( mpro."siteid" IN (1) AND mpro."id" IN (1,2,3,4,5,6,7,224,226,234,235,238,240,242,243,246) ) LIMIT 25 OFFSET 0 ,
/Users/luca/Desktop/myshop/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/DB/Statement/DBAL/Simple.php:94
I have aimeos/aimeos-laravel: 2019.10 and laravel 5.8
--------- SOLVED -------------
https://aimeos.org/docs/Laravel/Upgrade
I had to ran "php artisan aimeos:setup"