Invalid name "index.catalog:position()"
Forum rules
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Always add your Aimeos and PHP version as well as your environment (Linux/Mac/Win)
Spam and unrelated posts will be removed immediately!
Invalid name "index.catalog:position()"
Laravel: 5.6
PHP: 7.1.3
Aimeos: ~2018.07
On my dev PC, /list and /detail load up fine for all my products. When I pushed the code to my server if I go to /list or a detail page, I get a "non-recoverable error occurred" message. The list shows no products at all. The detail page shows the error banner, but otherwise work fine. The same errors occurred on my laptop, which has the same code and the same database entries as the working PC.
Two separate entries in the log:
and
PHP: 7.1.3
Aimeos: ~2018.07
On my dev PC, /list and /detail load up fine for all my products. When I pushed the code to my server if I go to /list or a detail page, I get a "non-recoverable error occurred" message. The list shows no products at all. The detail page shows the error banner, but otherwise work fine. The same errors occurred on my laptop, which has the same code and the same database entries as the working PC.
Two separate entries in the log:
Code: Select all
Invalid name "index.catalog:position()"
Code: Select all
#0 /home/vagrant/code/arcandoak/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Criteria/Expression/Combine/SQL.php(102): Aimeos\MW\Criteria\Expression\Compare\Base->toString(Array, Array, Array)
#1 /home/vagrant/code/arcandoak/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Criteria/Expression/Combine/SQL.php(102): Aimeos\MW\Criteria\Expression\Combine\SQL->toString(Array, Array, Array)
#2 /home/vagrant/code/arcandoak/vendor/aimeos/aimeos-core/lib/mwlib/src/MW/Criteria/SQL.php(128): Aimeos\MW\Criteria\Expression\Combine\SQL->toString(Array, Array, Array)
#3 /home/vagrant/code/arcandoak/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Index/Manager/DBBase.php(205): Aimeos\MW\Criteria\SQL->getConditionString(Array, Array, Array)
#4 /home/vagrant/code/arcandoak/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Common/Manager/Base.php(869): Aimeos\MShop\Index\Manager\DBBase->getSQLReplacements(Object(Aimeos\MW\Criteria\MySQL), Array, Array, Array)
#5 /home/vagrant/code/arcandoak/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Index/Manager/DBBase.php(324): Aimeos\MShop\Common\Manager\Base->searchItemsBase(Object(Aimeos\MW\DB\Connection\DBAL), Object(Aimeos\MW\Criteria\MySQL), 'mshop/index/man...', 'mshop/index/man...', Array, 0, 3)
#6 /home/vagrant/code/arcandoak/vendor/aimeos/aimeos-core/lib/mshoplib/src/MShop/Index/Manager/Standard.php(499): Aimeos\MShop\Index\Manager\DBBase->searchItemsIndexBase(Object(Aimeos\MW\Criteria\MySQL), Array, 0, 'mshop/index/man...', 'mshop/index/man...')
#7 /home/vagrant/code/arcandoak/ext/ai-controller-frontend/controller/frontend/src/Controller/Frontend/Product/Standard.php(340): Aimeos\MShop\Index\Manager\Standard->searchItems(Object(Aimeos\MW\Criteria\MySQL), Array, 0)
#8 /home/vagrant/code/arcandoak/ext/ai-client-html/client/html/src/Client/Html/Catalog/Base.php(618): Aimeos\Controller\Frontend\Product\Standard->searchItems(Object(Aimeos\MW\Criteria\MySQL), Array, 0)
#9 /home/vagrant/code/arcandoak/ext/ai-client-html/client/html/src/Client/Html/Catalog/Base.php(206): Aimeos\Client\Html\Catalog\Base->searchProducts(Object(Aimeos\MW\View\Standard))
#10 /home/vagrant/code/arcandoak/ext/ai-client-html/client/html/src/Client/Html/Catalog/Lists/Standard.php(461): Aimeos\Client\Html\Catalog\Base->getProductList(Object(Aimeos\MW\View\Standard))
#11 /home/vagrant/code/arcandoak/ext/ai-client-html/client/html/src/Client/Html/Catalog/Lists/Standard.php(133): Aimeos\Client\Html\Catalog\Lists\Standard->addData(Object(Aimeos\MW\View\Standard), Array, NULL)
#12 /home/vagrant/code/arcandoak/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Base/Page.php(91): Aimeos\Client\Html\Catalog\Lists\Standard->getBody()
#13 /home/vagrant/code/arcandoak/vendor/aimeos/aimeos-laravel/src/Aimeos/Shop/Controller/CatalogController.php(58): Aimeos\Shop\Base\Page->getSections('catalog-list')
#14 [internal function]: Aimeos\Shop\Controller\CatalogController->listAction()
#15 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(54): call_user_func_array(Array, Array)
#16 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(45): Illuminate\Routing\Controller->callAction('listAction', Array)
#17 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Route.php(212): Illuminate\Routing\ControllerDispatcher->dispatch(Object(Illuminate\Routing\Route), Object(Aimeos\Shop\Controller\CatalogController), 'listAction')
#18 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Route.php(169): Illuminate\Routing\Route->runController()
#19 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Router.php(665): Illuminate\Routing\Route->run()
#20 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Routing\Router->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#21 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(41): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#22 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#23 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#24 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(68): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#25 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#26 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#27 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#28 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#29 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#30 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(63): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#31 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#32 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#33 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#34 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#35 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#36 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(66): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#37 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#39 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#40 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Router.php(667): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#41 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Router.php(642): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#42 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Router.php(608): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#43 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Router.php(597): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#44 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(176): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#45 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(30): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#46 /home/vagrant/code/arcandoak/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#47 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Fideloper\Proxy\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#48 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#49 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#50 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#51 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#52 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(31): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#53 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#55 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#56 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#58 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(62): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#59 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(151): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle(Object(Illuminate\Http\Request), Object(Closure))
#60 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(53): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#61 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(104): Illuminate\Routing\Pipeline->Illuminate\Routing\{closure}(Object(Illuminate\Http\Request))
#62 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(151): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#63 /home/vagrant/code/arcandoak/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#64 /home/vagrant/code/arcandoak/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#65 {main}
Aimeos version: ~2018.10, PHP version: 7.2, Laravel version: 5.8
Re: Invalid name "index.catalog:position()"
Seems you have a mix of package versions. You can check with "composer show" and you should either have all "2018.07.*" or all "2018.10.*" packages. As 2018.07 isn't supported any more, you should upgrade to 2018.10 nevertheless.
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
Re: Invalid name "index.catalog:position()"
"composer show" came back with all 2018.07.* packages, but running composer update and getting everything up to 2018.10 seems to have resolved the issue.aimeos wrote:Seems you have a mix of package versions. You can check with "composer show" and you should either have all "2018.07.*" or all "2018.10.*" packages. As 2018.07 isn't supported any more, you should upgrade to 2018.10 nevertheless.
Thanks!
Aimeos version: ~2018.10, PHP version: 7.2, Laravel version: 5.8