[SOLVED] SQL Error after composer update
Posted: 09 Oct 2019, 13:27
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"