Tygh\Exceptions\AException

Message

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc' at line 1 (1064)

SELECT cscart_ab__mb_motivation_items.*, cscart_ab__mb_motivation_item_descriptions.name, cscart_ab__mb_motivation_item_descriptions.description, cscart_ab__mb_motivation_item_descriptions.lang_code FROM cscart_ab__mb_motivation_items LEFT JOIN cscart_ab__mb_motivation_item_objects as destination_objects_not_exclude ON cscart_ab__mb_motivation_items.motivation_item_id = destination_objects_not_exclude.motivation_item_id AND destination_objects_not_exclude.object_type = 'D' AND cscart_ab__mb_motivation_items.exclude_destinations = "N"LEFT JOIN cscart_ab__mb_motivation_item_objects as destination_objects_exclude ON cscart_ab__mb_motivation_items.motivation_item_id = destination_objects_exclude.motivation_item_id AND destination_objects_exclude.object_type = 'D' AND destination_objects_exclude.object_id IN (9) AND cscart_ab__mb_motivation_items.exclude_destinations = "Y"LEFT JOIN cscart_ab__mb_motivation_item_objects as category_objects_not_exclude ON cscart_ab__mb_motivation_items.motivation_item_id = category_objects_not_exclude.motivation_item_id AND category_objects_not_exclude.object_type = 'C' AND cscart_ab__mb_motivation_items.exclude_categories = "N"LEFT JOIN cscart_ab__mb_motivation_item_objects as category_objects_exclude ON cscart_ab__mb_motivation_items.motivation_item_id = category_objects_exclude.motivation_item_id AND category_objects_exclude.object_type = 'C' AND category_objects_exclude.object_id IN (1752) AND cscart_ab__mb_motivation_items.exclude_categories = "Y" INNER JOIN cscart_ab__mb_motivation_item_descriptions ON cscart_ab__mb_motivation_item_descriptions.motivation_item_id = cscart_ab__mb_motivation_items.motivation_item_id AND cscart_ab__mb_motivation_item_descriptions.lang_code = 'hu' WHERE 1 AND cscart_ab__mb_motivation_items.status = 'A' AND ((destination_objects_not_exclude.object_id IN (0, 9) OR destination_objects_not_exclude.object_id IS NULL) AND (destination_objects_exclude.motivation_item_id IS NULL)) AND ((category_objects_not_exclude.object_id IN (0, 1752) OR category_objects_not_exclude.object_id IS NULL) AND (category_objects_exclude.motivation_item_id IS NULL)) AND cscart_ab__mb_motivation_items.company_id = 1 GROUP BY cscart_ab__mb_motivation_items.motivation_item_id ORDER BY desc

Error at

app/Tygh/Database/Connection.php, line: 1127

Backtrace

File:app/Tygh/Database/Connection.php
Line:491
Function:throwError
File:app/Tygh/Database/Connection.php
Line:249
Function:query
File:app/functions/fn.database.php
Line:44
Function:getHash
File:app/addons/ab__motivation_block/func.php
Line:212
Function:db_get_hash_array
File:var/cache/templates/abt__unitheme2/4ebae12f91a352aa5fb5038686b4bf8b0622285c.tygh.ab__motivation_block.tpl.php
Line:120
Function:fn_ab__mb_get_motivation_items
File:app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line:188
Function:content_61651f4345e3e5_16864446
File:app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
Line:304
Function:fetch
File:var/cache/templates/abt__unitheme2/feed5b542b349df8e97ee0b6ade61f734226defb.tygh.ab__motivation_block.post.tpl.php
Line:45
Function:getSubTemplate
File:app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line:188
Function:content_61651f43423041_90889830
File:app/functions/smarty_plugins/block.hook.php
Line:112
Function:fetch
File:var/cache/templates/abt__unitheme2/b24af5936c88a60572ad912f06489408aaf09499.tygh.default_template.tpl.php
Line:722
Function:smarty_block_hook
File:app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line:188
Function:content_61651f3d19fb39_75494323
File:app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php
Line:304
Function:fetch
File:var/cache/templates/abt__unitheme2/8554ca58b97ba6f77adc4c7fc37c38c91fcfb150.tygh.view.tpl.php
Line:119
Function:getSubTemplate
File:app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line:188
Function:content_61651f3c630717_98630640
File:app/Tygh/SmartyEngine/Core.php
Line:76
Function:fetch
File:app/Tygh/BlockManager/RenderManager.php
Line:767
Function:fetch
File:app/Tygh/BlockManager/RenderManager.php
Line:626
Function:_renderMainContent
File:app/Tygh/BlockManager/RenderManager.php
Line:484
Function:renderBlockContent
File:app/Tygh/BlockManager/RenderManager.php
Line:406
Function:renderBlock
File:app/Tygh/BlockManager/RenderManager.php
Line:364
Function:renderBlocks
File:app/Tygh/BlockManager/RenderManager.php
Line:229
Function:renderGrid
File:app/Tygh/BlockManager/RenderManager.php
Line:199
Function:renderGrids
File:app/Tygh/BlockManager/RenderManager.php
Line:163
Function:_renderContainer
File:app/functions/smarty_plugins/function.render_location.php
Line:52
Function:render
File:var/cache/templates/abt__unitheme2/df940310be4eb863bc2e3470d21a5330da16f2dc.tygh.index.tpl.php
Line:183
Function:smarty_function_render_location
File:app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php
Line:188
Function:content_61651f2ecd6a01_50886171
File:app/Tygh/SmartyEngine/Core.php
Line:76
Function:fetch
File:app/functions/fn.control.php
Line:595
Function:fetch
File:index.php
Line:25
Function:fn_dispatch