Unknown column 'groups_alias.position' in 'field list' (1054)
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_alias.position AS group_position, cscart_product_features_values.value, cscart_product_features_values.variant_id, cscart_product_features_values.value_int FROM cscart_product_features AS pf LEFT JOIN cscart_product_features AS groups_alias_alias ON pf.parent_id = groups_alias.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_product_features_values ON cscart_product_features_values.feature_id = pf.feature_id AND cscart_product_features_values.product_id = 1067240 AND cscart_product_features_values.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.display_on_product = 'Y' AND ( pf.categories_path = '' OR ISNULL(pf.categories_path)OR FIND_IN_SET(290, pf.categories_path) OR FIND_IN_SET(19342, pf.categories_path) OR FIND_IN_SET(19389, pf.categories_path) OR FIND_IN_SET(19460, pf.categories_path) ) GROUP BY pf.feature_id ORDER BY group_position, pf.position, cscart_product_features_descriptions.description
app/Tygh/Database/Connection.php, line: 1133
| File: | app/Tygh/Database/Connection.php |
| Line: | 503 |
| Function: | throwError |
| File: | app/Tygh/Database/Connection.php |
| Line: | 229 |
| Function: | query |
| File: | app/functions/fn.database.php |
| Line: | 28 |
| Function: | getArray |
| File: | app/controllers/common/debugger.php |
| Line: | 60 |
| Function: | db_get_array |
| File: | app/functions/fn.control.php |
| Line: | 700 |
| Function: | include |
| File: | app/functions/fn.control.php |
| Line: | 456 |
| Function: | fn_run_controller |
| File: | index.php |
| Line: | 25 |
| Function: | fn_dispatch |