Zend_Db_Statement_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column '7Cdesc' in 'order clause' SQL: SELECT P.page_id, V1.property_value as meno, V2.property_value as urad, V3.property_value as pracovisko FROM tblPages as P LEFT JOIN tblPagePropertyValues as V1 ON (P.page_id = V1.page_id AND V1.property_id = 216) LEFT JOIN tblPagePropertyValues as V2 ON (P.page_id = V2.page_id AND V2.property_id = 217) LEFT JOIN tblPagePropertyValues as V3 ON (P.page_id = V3.page_id AND V3.property_id = 218) WHERE P.parent_page_id = 342174 AND P.page_state_id = 1 ORDER BY meno%7Cdesc,pracovisko,meno PARAMS: array ( ) in file /home/upsvar/live/vendor/buxus/legacy-base/buxus/includes/classes/db/buxus_db_statement_pdo.php on line 26 #0 /home/upsvar/live/vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): BuxusDB_Statement_PDO->_execute() #1 /home/upsvar/live/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute() #2 /home/upsvar/live/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query() #3 /home/upsvar/live/vendor/buxus/legacy-base/buxus/includes/classes/db/buxus_db_adapter_mysql.php(82): Zend_Db_Adapter_Pdo_Abstract->query() #4 /home/upsvar/live/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(737): BuxusDB_Adapter_Mysql->query() #5 /home/upsvar/live/vendor/buxus/legacy-base/buxus/includes/database.php(150): Zend_Db_Adapter_Abstract->fetchAll() #6 /home/upsvar/live/buxus/application/models/VpmAgentsList.class.php(28): SQL_GetQueryResults() #7 /home/upsvar/live/buxus/application/controllers/VpmAgentsController.php(32): VpmAgentsList->__construct() #8 /home/upsvar/live/vendor/zendframework/zendframework1/library/Zend/Controller/Action.php(516): VpmAgentsController->listAction() #9 /home/upsvar/live/vendor/buxus/legacy/src/LegacyDispatcher.php(98): Zend_Controller_Action->dispatch() #10 /home/upsvar/live/vendor/buxus/legacy/src/BuxusControllerFront.php(159): Buxus\Legacy\LegacyDispatcher->dispatch() #11 /home/upsvar/live/vendor/buxus/legacy/src/LegacyBuxusTemplateRenderer.php(152): Buxus\Legacy\BuxusControllerFront->dispatch() #12 /home/upsvar/live/vendor/buxus/core/src/Core/Routing/SeoUrlRoute.php(119): Buxus\Legacy\LegacyBuxusTemplateRenderer->renderZFAction() #13 /home/upsvar/live/vendor/buxus/core/src/Core/Routing/SeoUrlRoute.php(168): Buxus\Core\Routing\SeoUrlRoute->runPage() #14 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Routing/Router.php(681): Buxus\Core\Routing\SeoUrlRoute->run() #15 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Routing\Router->Illuminate\Routing\{closure}() #16 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #17 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle() #18 /home/upsvar/live/vendor/buxus/core/src/Core/Session/StartSessionMiddleware.php(25): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #19 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Buxus\Core\Session\StartSessionMiddleware->handle() #20 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #21 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle() #22 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #23 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Cookie\Middleware\EncryptCookies->handle() #24 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #25 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Routing/Router.php(683): Illuminate\Pipeline\Pipeline->then() #26 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Routing/Router.php(658): Illuminate\Routing\Router->runRouteWithinStack() #27 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Routing/Router.php(624): Illuminate\Routing\Router->runRoute() #28 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Routing/Router.php(613): Illuminate\Routing\Router->dispatchToRoute() #29 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(170): Illuminate\Routing\Router->dispatch() #30 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(130): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}() #31 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #32 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #33 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #34 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle() #35 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #36 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle() #37 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(63): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #38 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Illuminate\Foundation\Http\Middleware\CheckForMaintenanceMode->handle() #39 /home/upsvar/live/vendor/fideloper/proxy/src/TrustProxies.php(57): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #40 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Fideloper\Proxy\TrustProxies->handle() #41 /home/upsvar/live/vendor/dingo/api/src/Http/Middleware/Request.php(111): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #42 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(171): Dingo\Api\Http\Middleware\Request->handle() #43 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(105): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}() #44 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(145): Illuminate\Pipeline\Pipeline->then() #45 /home/upsvar/live/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(110): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter() #46 /home/upsvar/live/public/index.php(55): Illuminate\Foundation\Http\Kernel->handle() #47 {main}