upgraded aimeos 2019.10 to 2020.07

Help for integrating the Laravel package
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!
User avatar
bilginkilic
Posts: 34
Joined: 05 Jul 2020, 07:08

upgraded aimeos 2019.10 to 2020.07

Post by bilginkilic » 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
"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)

User avatar
aimeos
Administrator
Posts: 7836
Joined: 01 Jan 1970, 00:00

Re: upgraded aimeos 2019.10 to 2020.07

Post by aimeos » 02 Aug 2020, 07:11

Can you post the output of

Code: Select all

php artisan aimeos:setup
Maybe there's a dependency issue so the order of the setup tasks is wrong in your case
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

User avatar
bilginkilic
Posts: 34
Joined: 05 Jul 2020, 07:08

Re: upgraded aimeos 2019.10 to 2020.07

Post by bilginkilic » 02 Aug 2020, 15:58

I tried again and the error disappeared thank you
@bilginkilic_ (twitter)

Post Reply