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 'groups ON pf.parent_id = groups.feature_id LEFT JOIN cscart_product_features_des' at line 1 (1064)
SELECT pf.feature_id, pf.company_id, pf.feature_type, pf.parent_id, pf.display_on_product, pf.display_on_catalog, pf.display_on_header, cscart_product_features_descriptions.description, cscart_product_features_descriptions.lang_code, cscart_product_features_descriptions.prefix, cscart_product_features_descriptions.suffix, pf.categories_path, cscart_product_features_descriptions.full_description, pf.status, pf.comparison, pf.position, groups.position AS group_position FROM cscart_product_features AS pf LEFT JOIN cscart_product_features AS groups ON pf.parent_id = groups.feature_id LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'ro' INNER JOIN cscart_ult_objects_sharing ON (cscart_ult_objects_sharing.share_object_id = pf.feature_id AND cscart_ult_objects_sharing.share_company_id = 1 AND cscart_ult_objects_sharing.share_object_type = 'product_features') WHERE 1 AND pf.feature_type != 'G' AND pf.status IN ('A') AND pf.feature_type IN ('E') ORDER BY group_position, pf.position, cscart_product_features_descriptions.description
app/Tygh/Database.php, line: 714
| File: | app/Tygh/Database.php |
| Line: | 359 |
| Function: | error |
| File: | app/Tygh/Database.php |
| Line: | 166 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 42 |
| Function: | getHash |
| File: | app/functions/fn.catalog.php |
| Line: | 4134 |
| Function: | db_get_hash_array |
| File: | app/functions/fn.catalog.php |
| Line: | 9442 |
| Function: | fn_get_product_features |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 661 |
| Function: | fn_get_all_brands |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 537 |
| Function: | getValue |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 400 |
| Function: | renderBlockContent |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 335 |
| Function: | renderBlock |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 293 |
| Function: | renderBlocks |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 230 |
| Function: | _renderGrid |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 289 |
| Function: | _renderGrids |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 230 |
| Function: | _renderGrid |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 181 |
| Function: | _renderGrids |
| File: | app/Tygh/BlockManager/RenderManager.php |
| Line: | 146 |
| Function: | _renderContainer |
| File: | app/functions/smarty_plugins/function.render_location.php |
| Line: | 48 |
| Function: | render |
| File: | var/cache/templates/vivashop/05c1fbe3cd762e02da5b5f8bd78e564149a057f2.tygh.et_content.override.tpl.php |
| Line: | 50 |
| Function: | smarty_function_render_location |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 188 |
| Function: | content_6a5531c38ec9d9_30554345 |
| File: | app/functions/smarty_plugins/block.hook.php |
| Line: | 81 |
| Function: | fetch |
| File: | var/cache/templates/vivashop/dc2efe1739fa91c7977ed99b51eb9f0051336eeb.tygh.index.tpl.php |
| Line: | 169 |
| Function: | smarty_block_hook |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 188 |
| Function: | content_6a5531c3271e20_39724456 |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 68 |
| Function: | fetch |
| File: | app/lib/vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php |
| Line: | 394 |
| Function: | fetch |
| File: | app/Tygh/SmartyEngine/Core.php |
| Line: | 52 |
| Function: | display |
| File: | app/functions/fn.control.php |
| Line: | 611 |
| Function: | display |
| File: | index.php |
| Line: | 25 |
| Function: | fn_dispatch |