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}