Help for Aimeos

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

Please run "php artisan aimeos:setup" to update your database schema

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.

Which Aimeos version are you using?

aimeos wrote:Which Aimeos version are you using?

"aimeos/aimeos-laravel": "~2018.04",

2018.04 isn't supported any more. Please upgrade to 2018.10 LTS

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
':

Your database layout doesn't match those expected by the SQL statements. Please run and watch out for any errors that stop migration to the new DB layout.