upgraded aimeos 2019.10 to 2020.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!
- bilginkilic
- Posts: 34
- Joined: 05 Jul 2020, 07:08
upgraded aimeos 2019.10 to 2020.07
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"
@bilginkilic_ (twitter)
Re: upgraded aimeos 2019.10 to 2020.07
Can you post the output of
Maybe there's a dependency issue so the order of the setup tasks is wrong in your case
Code: Select all
php artisan aimeos:setup
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
- bilginkilic
- Posts: 34
- Joined: 05 Jul 2020, 07:08
Re: upgraded aimeos 2019.10 to 2020.07
I tried again and the error disappeared thank you
@bilginkilic_ (twitter)