During Aimeos Setup Got Errors Laravel

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!
awaidqureshi
Posts: 86
Joined: 12 Jan 2019, 15:17

During Aimeos Setup Got Errors Laravel

Post by awaidqureshi » 12 Jan 2019, 15:23

ErrorException thrown with message "An exception occurred while executing '
SELECT mproty."id" AS "product.type.id", mproty."siteid" AS "product.type.siteid",
mproty."code" AS "product.type.code", mproty."domain" AS "product.type.domain",
mproty."label" AS "product.type.label", mproty."status" AS "product.type.status",
mproty."mtime" AS "product.type.mtime", mproty."editor" AS "product.type.editor",
mproty."ctime" AS "product.type.ctime", mproty."pos" AS "product.type.position"
FROM "mshop_product_type" AS mproty

WHERE ( mproty."siteid" IN (1) AND mproty."id" IN (1) )
GROUP BY mproty."id", mproty."siteid", mproty."code", mproty."domain",
mproty."label", mproty."status", mproty."mtime", mproty."editor",
mproty."ctime"

LIMIT 100 OFFSET 0
':

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'mproty.pos' in 'field list' (View: C:\xampp\htdocs\nordicforms\resources\views\home\index.blade.php)"

Stacktrace:
#60 ErrorException in C:\xampp\htdocs\nordicforms\vendor\aimeos\aimeos-core\lib\mwlib\src\MW\DB\Statement\DBAL\Simple.php:97
#59 Aimeos\MW\DB\Exception in C:\xampp\htdocs\nordicforms\vendor\aimeos\aimeos-core\lib\mwlib\src\MW\DB\Statement\DBAL\Simple.php:97
#58 Aimeos\MW\DB\Statement\DBAL\Simple:execute in C:\xampp\htdocs\nordicforms\vendor\aimeos\aimeos-core\lib\mshoplib\src\MShop\Common\Manager\Base.php:882
#57 Aimeos\MShop\Common\Manager\Base:searchItemsBase in C:\xampp\htdocs\nordicforms\vendor\aimeos\aimeos-core\lib\mshoplib\src\MShop\Common\Manager\Type\Base.php:233
#56 Aimeos\MShop\Common\Manager\Type\Base:searchItems in C:\xampp\htdocs\nordicforms\vendor\aimeos\aimeos-core\lib\mshoplib\src\MShop\Product\Manager\Standard.php:659
#55 Aimeos\MShop\Product\Manager\Standard:searchItems in C:\xampp\htdocs\nordicforms\storage\framework\views\e1f6f8fcd69278cad29fba7b482f559e5f08b0b5.php:6
#54 include in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\View\Engines\PhpEngine.php:43
#53 Illuminate\View\Engines\PhpEngine:evaluatePath in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\View\Engines\CompilerEngine.php:59
#52 Illuminate\View\Engines\CompilerEngine:get in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\View\View.php:142
#51 Illuminate\View\View:getContents in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\View\View.php:125
#50 Illuminate\View\View:renderContents in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\View\View.php:90
#49 Illuminate\View\View:render in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Http\Response.php:42
#48 Illuminate\Http\Response:setContent in C:\xampp\htdocs\nordicforms\vendor\symfony\http-foundation\Response.php:202
#47 Symfony\Component\HttpFoundation\Response:__construct in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Router.php:733
#46 Illuminate\Routing\Router:toResponse in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Router.php:705
#45 Illuminate\Routing\Router:prepareResponse in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Router.php:665
#44 Illuminate\Routing\Router:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:30
#43 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Middleware\SubstituteBindings.php:41
#42 Illuminate\Routing\Middleware\SubstituteBindings:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#41 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#40 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\VerifyCsrfToken.php:68
#39 Illuminate\Foundation\Http\Middleware\VerifyCsrfToken:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#38 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#37 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\View\Middleware\ShareErrorsFromSession.php:49
#36 Illuminate\View\Middleware\ShareErrorsFromSession:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#35 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#34 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Session\Middleware\StartSession.php:63
#33 Illuminate\Session\Middleware\StartSession:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#32 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#31 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse.php:37
#30 Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#29 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#28 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Cookie\Middleware\EncryptCookies.php:66
#27 Illuminate\Cookie\Middleware\EncryptCookies:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#26 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#25 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:104
#24 Illuminate\Pipeline\Pipeline:then in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Router.php:667
#23 Illuminate\Routing\Router:runRouteWithinStack in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Router.php:642
#22 Illuminate\Routing\Router:runRoute in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Router.php:608
#21 Illuminate\Routing\Router:dispatchToRoute in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Router.php:597
#20 Illuminate\Routing\Router:dispatch in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:176
#19 Illuminate\Foundation\Http\Kernel:Illuminate\Foundation\Http\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:30
#18 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\fideloper\proxy\src\TrustProxies.php:57
#17 Fideloper\Proxy\TrustProxies:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#16 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#15 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php:31
#14 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#13 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#12 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\TransformsRequest.php:31
#11 Illuminate\Foundation\Http\Middleware\TransformsRequest:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#10 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#9 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\ValidatePostSize.php:27
#8 Illuminate\Foundation\Http\Middleware\ValidatePostSize:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#7 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#6 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode.php:62
#5 Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode:handle in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:151
#4 Illuminate\Pipeline\Pipeline:Illuminate\Pipeline\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Routing\Pipeline.php:53
#3 Illuminate\Routing\Pipeline:Illuminate\Routing\{closure} in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Pipeline\Pipeline.php:104
#2 Illuminate\Pipeline\Pipeline:then in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:151
#1 Illuminate\Foundation\Http\Kernel:sendRequestThroughRouter in C:\xampp\htdocs\nordicforms\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php:116
#0 Illuminate\Foundation\Http\Kernel:handle in C:\xampp\htdocs\nordicforms\public\index.php:55

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

Re: During Aimeos Setup Got Errors Laravel

Post by aimeos » 14 Jan 2019, 13:22

Please run "php artisan aimeos:setup" to update your database schema
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

awaidqureshi
Posts: 86
Joined: 12 Jan 2019, 15:17

Re: During Aimeos Setup Got Errors Laravel

Post by awaidqureshi » 18 Jan 2019, 08:38

aimeos wrote:Please run "php artisan aimeos:setup" to update your database schema
Sir I have done this butt error is still there.so kindly help me about this issue.

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

Re: During Aimeos Setup Got Errors Laravel

Post by aimeos » 18 Jan 2019, 09:30

Which Aimeos version are you using?
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

awaidqureshi
Posts: 86
Joined: 12 Jan 2019, 15:17

Re: During Aimeos Setup Got Errors Laravel

Post by awaidqureshi » 21 Jan 2019, 08:47

aimeos wrote:Which Aimeos version are you using?
"aimeos/aimeos-laravel": "~2018.04",

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

Re: During Aimeos Setup Got Errors Laravel

Post by aimeos » 21 Jan 2019, 09:15

2018.04 isn't supported any more. Please upgrade to 2018.10 LTS
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

awaidqureshi
Posts: 86
Joined: 12 Jan 2019, 15:17

Re: During Aimeos Setup Got Errors Laravel

Post by awaidqureshi » 24 Jan 2019, 09:16

aimeos wrote:2018.04 isn't supported any more. Please upgrade to 2018.10 LTS
I have updated to latest version butt there is an error of database.

ErrorException thrown with message "An exception occurred while executing '
SELECT mproty."id" AS "product.type.id", mproty."siteid" AS "product.type.siteid",
mproty."code" AS "product.type.code", mproty."domain" AS "product.type.domain",
mproty."label" AS "product.type.label", mproty."status" AS "product.type.status",
mproty."mtime" AS "product.type.mtime", mproty."editor" AS "product.type.editor",
mproty."ctime" AS "product.type.ctime", mproty."pos" AS "product.type.position"
FROM "mshop_product_type" AS mproty

WHERE ( mproty."siteid" IN (1) AND mproty."id" IN (1) )
GROUP BY mproty."id", mproty."siteid", mproty."code", mproty."domain",
mproty."label", mproty."status", mproty."mtime", mproty."editor",
mproty."ctime"
LIMIT 100 OFFSET 0
':

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

Re: During Aimeos Setup Got Errors Laravel

Post by aimeos » 25 Jan 2019, 07:49

Your database layout doesn't match those expected by the SQL statements. Please run

Code: Select all

php artisan aimeos:setup
and watch out for any errors that stop migration to the new DB layout.
Professional support and custom implementation are available at Aimeos.com
If you like Aimeos, Image give us a star

Post Reply