upgraded aimeos 2019.10 to 2020.07
Posted: 31 Jul 2020, 19:45
I got this error: how to fix?
Aimeos\MW\DB\Exception
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mlocsi.siteid' in 'field list': SELECT mlocsi."id" AS "locale.site.id", mlocsi."siteid" AS "locale.site.siteid", mlocsi."code" AS "locale.site.code", mlocsi."label" AS "locale.site.label", mlocsi."config" AS "locale.site.config", mlocsi."status" AS "locale.site.status", mlocsi."editor" AS "locale.site.editor", mlocsi."mtime" AS "locale.site.mtime", mlocsi."ctime" AS "locale.site.ctime" FROM "mshop_locale_site" AS mlocsi WHERE mlocsi."level" = 0 AND ( mlocsi."code" = 'default' ) ORDER BY mlocsi."id" ASC LIMIT 1 OFFSET 0
myshopx\vendor\aimeos\aimeos-core\lib\mwlib\src\MW\DB\Statement\DBAL\Simple.php:75
PHP artisan aimeos:setup did not work..
Update attribute "key" columns
Checking table mshop_attribute
Aimeos\MW\DB\Exception : SQLSTATE[42S02]: Base table or view not found: 1932 Table 'paltoru.mshop_attribute' doesn't exist in engine: SELECT "id", "domain", "type", "code" FROM "mshop_attribute" WHERE "key" = ''
at C:\xampp\htdocs\paltoruappx\vendor\aimeos\aimeos-core\lib\mwlib\src\MW\DB\Statement\DBAL\Simple.php:75
Aimeos\MW\DB\Exception
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mlocsi.siteid' in 'field list': SELECT mlocsi."id" AS "locale.site.id", mlocsi."siteid" AS "locale.site.siteid", mlocsi."code" AS "locale.site.code", mlocsi."label" AS "locale.site.label", mlocsi."config" AS "locale.site.config", mlocsi."status" AS "locale.site.status", mlocsi."editor" AS "locale.site.editor", mlocsi."mtime" AS "locale.site.mtime", mlocsi."ctime" AS "locale.site.ctime" FROM "mshop_locale_site" AS mlocsi WHERE mlocsi."level" = 0 AND ( mlocsi."code" = 'default' ) ORDER BY mlocsi."id" ASC LIMIT 1 OFFSET 0
myshopx\vendor\aimeos\aimeos-core\lib\mwlib\src\MW\DB\Statement\DBAL\Simple.php:75
PHP artisan aimeos:setup did not work..
Update attribute "key" columns
Checking table mshop_attribute
Aimeos\MW\DB\Exception : SQLSTATE[42S02]: Base table or view not found: 1932 Table 'paltoru.mshop_attribute' doesn't exist in engine: SELECT "id", "domain", "type", "code" FROM "mshop_attribute" WHERE "key" = ''
at C:\xampp\htdocs\paltoruappx\vendor\aimeos\aimeos-core\lib\mwlib\src\MW\DB\Statement\DBAL\Simple.php:75
"php": "^7.2",
"aimeos/ai-payments": "^2020.07",
"aimeos/aimeos-laravel": "~2020.07",
"composer/installers": "^1.9",
"fideloper/proxy": "^4.0",
"laravel/framework": "^6.0",
"laravel/tinker": "^1.0",
"laravel/ui": "^1.0",
"omnipay/common": "^3.0",
"php-http/guzzle6-adapter": "^1.0",
"php-http/httplug": "^1.0"