[Skip to main content](#vessel-content) # Help - 1054 Error Message ## - **[caroltt](/forum/user/20350-caroltt "View caroltt's Profile")** - [![caroltt's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20350-caroltt "View caroltt's Profile") Topic Author - [ Offline](/forum/user/20350-caroltt) Less More - Posts: 7 - Thank you received: 0 - - 13 years 3 months ago [\#114643](#114643) by [caroltt](/forum/user/20350-caroltt "View caroltt's Profile") *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114643 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* was created by *[caroltt](/forum/user/20350-caroltt "View caroltt's Profile")* I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 3 months ago [\#114648](#114648) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114648 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* Hi, In which page do you have this error message ? You can solve the problem by cleaning the cookies. You have in your session a wrong ordering rule which break a SQL query. If we can know which page you are trying to open/see, we could add some improving patch in order to abort such kind of problem. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. The following user(s) said Thank You: [caroltt](/forum/user/20350-caroltt "View caroltt's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[caroltt](/forum/user/20350-caroltt "View caroltt's Profile")** - [![caroltt's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20350-caroltt "View caroltt's Profile") Topic Author - [ Offline](/forum/user/20350-caroltt) Less More - Posts: 7 - Thank you received: 0 - - 13 years 3 months ago [\#114687](#114687) by [caroltt](/forum/user/20350-caroltt "View caroltt's Profile") Replied by *[caroltt](/forum/user/20350-caroltt "View caroltt's Profile")* on topic *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114687 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* [ www.atomicspices.com/component/hikashop/...ato-seeds?Itemid=959](http://www.atomicspices.com/component/hikashop/product/2-annato-seeds?Itemid=959) Thank you! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14278 - - 13 years 3 months ago - 13 years 3 months ago [\#114722](#114722) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114722 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* Could you turn on the debug mode of the joomla configuration and try again ? That should give more information in the error message which should allow us to understand what is going on. I also remember such issue in previous versions of HikaShop. Can you make sure that you have the latest (2.2.0) ? Last edit: 13 years 3 months ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). The following user(s) said Thank You: [caroltt](/forum/user/20350-caroltt "View caroltt's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[caroltt](/forum/user/20350-caroltt "View caroltt's Profile")** - [![caroltt's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20350-caroltt "View caroltt's Profile") Topic Author - [ Offline](/forum/user/20350-caroltt) Less More - Posts: 7 - Thank you received: 0 - - 13 years 3 months ago - 13 years 3 months ago [\#114732](#114732) by [caroltt](/forum/user/20350-caroltt "View caroltt's Profile") Replied by *[caroltt](/forum/user/20350-caroltt "View caroltt's Profile")* on topic *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114732 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* I have version 2.1.3. Is that the problem? It reads that it's the latest stable version. Code: Joomla! Debug Console Session __default hikashop_viewed_products Profile Information Application 0.000 seconds (+0.000); 0.80 MB (+0.799) - afterLoad Application 0.046 seconds (+0.046); 5.85 MB (+5.048) - afterInitialise Application 0.066 seconds (+0.021); 8.56 MB (+2.716) - afterRoute Application 0.127 seconds (+0.061); 14.20 MB (+5.638) - beforeRenderModule mod_hikashop (HikaShop Content Module) Memory Usage 15.32 MB (16,061,304 Bytes) Database Queries 45 Queries Logged SELECT `data` FROM `jos_session` WHERE `session_id` = '77klih4ek8ipuiung6ejj537l7' DELETE FROM `jos_session` WHERE `time` < '1374248587' SELECT folder AS type, element AS name, params FROM jos_extensions WHERE enabled >= 1 AND type ='plugin' AND state >= 0 AND access IN (1,1,2,3) ORDER BY ordering SELECT extension_id AS id, element AS "option", params, enabled FROM jos_extensions WHERE `type` = 'component' AND `element` = 'com_languages' SHOW TABLES SELECT name,value FROM jos_jsn_poweradmin_config WHERE 1 SELECT COUNT(*) FROM jos_extensions WHERE element="jsnadminbar" SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1 SELECT * FROM jos_hikashop_config SELECT extension_id AS id, element AS "option", params, enabled FROM jos_extensions WHERE `type` = 'component' AND `element` = 'com_hikashop' SELECT * FROM jos_languages WHERE published=1 ORDER BY ordering ASC SELECT extension_id AS id, element AS "option", params, enabled FROM jos_extensions WHERE `type` = 'component' AND `element` = 'com_users' SELECT a.id FROM jos_user_usergroup_map AS map LEFT JOIN jos_usergroups AS a ON a.id = map.group_id WHERE map.user_id = 251 SELECT a.*, b.product_category_id, b.category_id, b.ordering FROM jos_hikashop_product AS a LEFT JOIN jos_hikashop_product_category AS b ON a.product_id = b.product_id WHERE a.product_id=1 AND (a.product_access = 'all' OR a.product_access LIKE '%,8,%') LIMIT 1 SELECT * FROM jos_modules WHERE id IN (227,226); UPDATE `jos_hikashop_product` SET `product_hit`='65',`product_last_seen_date`='1374249487' WHERE `product_id`='1' SELECT b.* FROM jos_hikashop_product_related AS a LEFT JOIN jos_hikashop_product AS b ON a.product_related_id = b.product_id WHERE a.product_id =1 AND a.product_related_type='options' AND b.product_published=1 AND (b.product_sale_start='' OR b.product_sale_start<=1374249487) AND (b.product_sale_end='' OR b.product_sale_end>1374249487) AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.product_related_ordering ASC, a.product_related_id ASC SELECT * FROM jos_hikashop_product WHERE product_parent_id IN (1) AND (product_access = 'all' OR product_access LIKE '%,8,%') SELECT a.*,b.* FROM jos_hikashop_variant AS a LEFT JOIN jos_hikashop_characteristic AS b ON a.variant_characteristic_id=b.characteristic_id WHERE a.variant_product_id IN (1) ORDER BY a.ordering ASC,b.characteristic_ordering ASC SELECT * FROM jos_hikashop_file WHERE file_ref_id IN (1) AND file_type IN ('product','file') ORDER BY file_ordering ASC, file_id ASC SELECT currency_id FROM jos_hikashop_currency WHERE currency_published=1 OR currency_id = 1 SELECT * FROM jos_hikashop_price WHERE price_currency_id IN (1,2) AND price_product_id IN (1) AND (price_access = 'all' OR price_access LIKE '%,8,%') ORDER BY price_value DESC SELECT * FROM jos_hikashop_currency WHERE currency_id IN (1) SELECT b.*,c.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN jos_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey WHERE a.category_id = 11 AND b.taxation_published=1 AND taxation_type = '' AND (b.taxation_access = 'all' OR b.taxation_access LIKE '%,8,%') SELECT * FROM jos_hikashop_zone WHERE zone_id = 150 SELECT * FROM jos_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND ( discount_quota>discount_used_times OR discount_quota=0 ) AND discount_start < 1374249487 AND ( discount_end > 1374249487 OR discount_end = 0 ) AND ( discount_product_id IN (1) OR discount_product_id=0 ) AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 ) AND (discount_access = 'all' OR discount_access LIKE '%,8,%') SELECT category_id FROM jos_hikashop_product_category WHERE product_id=1 ORDER BY ordering ASC SELECT b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id IN (13) GROUP BY b.category_id ORDER BY b.category_left SELECT * FROM jos_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_frontcomp` = 1 AND a.field_table='product' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories LIKE '%,13,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,13,%'))) ORDER BY a.`field_ordering` ASC SELECT * FROM jos_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_frontcomp` = 1 AND a.field_table='item' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') AND ((field_with_sub_categories=0 AND (field_categories="all" OR field_categories LIKE '%,13,%'))OR (field_with_sub_categories=1 AND (field_categories="all" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,13,%'))) ORDER BY a.`field_ordering` ASC SELECT b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id IN (13) GROUP BY b.category_id ORDER BY b.category_left SELECT a.* FROM jos_hikashop_badge AS a WHERE a.badge_start <= 1374249487 AND ( a.badge_end >= 1374249487 OR a.badge_end =0 ) AND a.badge_published=1 AND (a.badge_quantity='' OR a.badge_quantity=-1) AND (badge_discount_id=0 OR badge_discount_id=0 ) AND ((badge_category_childs = 0 AND (badge_category_id = 0 OR badge_category_id = 13))OR (badge_category_childs = 1 AND (badge_category_id=0 OR badge_category_id = 1 OR badge_category_id = 2 OR badge_category_id = 13))) ORDER BY a.badge_ordering ASC,a.badge_id ASC SELECT b.* FROM jos_hikashop_product_category AS a LEFT JOIN jos_hikashop_category AS b ON a.category_id = b.category_id WHERE a.product_id = 1 ORDER BY a.ordering ASC SELECT * FROM jos_extensions WHERE folder='content' AND element='hikashopsocial' AND type='plugin' SELECT `name`, `value` FROM `jos_jsn_imageshow_config` WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading') SELECT * FROM jos_extensions WHERE element='com_imageshow' AND type='component' SELECT extension_id AS id, element AS "option", params, enabled FROM jos_extensions WHERE `type` = 'component' AND `element` = 'com_imageshow' SELECT category_id FROM jos_hikashop_category WHERE (category_access = 'all' OR category_access LIKE '%,8,%') AND category_id IN (2) SELECT * FROM jos_hikashop_filter WHERE filter_published = 1 AND (filter_access = 'all' OR filter_access LIKE '%,8,%') ORDER BY filter_ordering SELECT b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_category AS b ON a.category_left >= b.category_left WHERE b.category_right >= a.category_right AND a.category_id=2 GROUP BY b.category_id ORDER BY b.category_left SELECT a.*,b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_file AS b ON a.category_id=b.file_ref_id AND b.file_type='category' WHERE a.category_id = 2 LIMIT 1 SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 SELECT manifest_cache FROM jos_extensions WHERE element LIKE 'jsn_mico_pro' UPDATE `jos_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1374249467;s:18:\"session.timer.last\";i:1374249479;s:17:\"session.timer.now\";i:1374249487;s:22:\"session.client.browser\";s:108:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":2:{s:4:\"data\";a:0:{}s:6:\"return\";s:28:\"http://www.atomicspices.com/\";}}}s:12:\"com_hikashop\";O:8:\"stdClass\":2:{s:7:\"zone_id\";s:3:\"150\";s:12:\"ssl_redirect\";i:0;}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"251\";s:4:\"name\";s:5:\"sa sa\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:19:\"cttsaltas@gmail.com\";s:8:\"password\";s:65:\"589c71725d246a8a3110e8570b5a6ab4:moOPB8Sj4aLMH02xmAAEp1YNj4Nb4cJn\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-03-25 13:37:39\";s:13:\"lastvisitDate\";s:19:\"2013-07-19 15:48:22\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:2:\"{}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"2013-03-25 13:37:39\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"ff566c9bc7e3e389493f6490d5710201\";}hikashop_viewed_products|a:1:{i:1;i:1;}' , `time` = '1374249487' WHERE `session_id` = '77klih4ek8ipuiung6ejj537l7' 38 Query Types Logged, Sorted by Occurrences. SELECT Tables: 4 × SELECT extension_id AS id, element AS "option", params, enabled FROM jos_extensions 3 × SELECT b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_category AS b ON a.category_left >= b.category_left 2 × SELECT * FROM jos_hikashop_field as a 2 × SELECT * FROM jos_extensions 1 × SELECT category_id FROM jos_hikashop_product_category 1 × SELECT manifest_cache FROM jos_extensions 1 × SELECT * FROM jos_hikashop_discount 1 × SELECT * FROM jos_hikashop_zone 1 × SELECT b.*,c.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_taxation AS b ON a.category_namekey=b.category_namekey LEFT JOIN jos_hikashop_tax AS c ON b.tax_namekey=c.tax_namekey 1 × SELECT DISTINCT b.* FROM jos_hikashop_product AS b 1 × SELECT a.* FROM jos_hikashop_badge AS a 1 × SELECT category_id FROM jos_hikashop_category 1 × SELECT * FROM jos_hikashop_filter 1 × SELECT `name`, `value` FROM `jos_jsn_imageshow_config` 1 × SELECT * FROM jos_hikashop_currency 1 × SELECT b.* FROM jos_hikashop_product_category AS a LEFT JOIN jos_hikashop_category AS b ON a.category_id = b.category_id 1 × SELECT a.*,b.* FROM jos_hikashop_category AS a LEFT JOIN jos_hikashop_file AS b ON a.category_id=b.file_ref_id AND b.file_type='category' 1 × SELECT currency_id FROM jos_hikashop_currency 1 × SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id 1 × SELECT * FROM jos_hikashop_confi 1 × SELECT * FROM jos_languages 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id 1 × SELECT COUNT(*) FROM jos_extensions 1 × SELECT folder AS type, element AS name, params FROM jos_extensions 1 × SELECT name,value FROM jos_jsn_poweradmin_config 1 × SELECT a.id FROM jos_user_usergroup_map AS map LEFT JOIN jos_usergroups AS a ON a.id = map.group_id 1 × SELECT a.*, b.product_category_id, b.category_id, b.ordering FROM jos_hikashop_product AS a LEFT JOIN jos_hikashop_product_category AS b ON a.product_id = b.product_id 1 × SELECT * FROM jos_hikashop_file 1 × SELECT `data` FROM `jos_session` 1 × SELECT a.*,b.* FROM jos_hikashop_variant AS a LEFT JOIN jos_hikashop_characteristic AS b ON a.variant_characteristic_id=b.characteristic_id 1 × SELECT * FROM jos_hikashop_product 1 × SELECT * FROM jos_modules 1 × SELECT b.* FROM jos_hikashop_product_related AS a LEFT JOIN jos_hikashop_product AS b ON a.product_related_id = b.product_id 1 × SELECT * FROM jos_hikashop_price OTHER Tables: 1 × UPDATE `jos_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1374249467;s:18:\"session.timer.last\";i:1374249479;s:17:\"session.timer.now\";i:1374249487;s:22:\"session.client.browser\";s:108:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/28.0.1500.72 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:5:\"users\";O:8:\"stdClass\":1:{s:5:\"login\";O:8:\"stdClass\":1:{s:4:\"form\";O:8:\"stdClass\":2:{s:4:\"data\";a:0:{}s:6:\"return\";s:28:\"http://www.atomicspices.com/\";}}}s:12:\"com_hikashop\";O:8:\"stdClass\":2:{s:7:\"zone_id\";s:3:\"150\";s:12:\"ssl_redirect\";i:0;}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"251\";s:4:\"name\";s:5:\"sa sa\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:19:\"cttsaltas@gmail.com\";s:8:\"password\";s:65:\"589c71725d246a8a3110e8570b5a6ab4:moOPB8Sj4aLMH02xmAAEp1YNj4Nb4cJn\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2013-03-25 13:37:39\";s:13:\"lastvisitDate\";s:19:\"2013-07-19 15:48:22\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:2:\"{}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"2013-03-25 13:37:39\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"ff566c9bc7e3e389493f6490d5710201\";}hikashop_viewed_products|a:1:{i:1;i:1;}' , `time` = '1374249487' 1 × UPDATE `jos_hikashop_product` SET `product_hit`='65',`product_last_seen_date`='1374249487' 1 × SHOW TABLE 1 × DELETE FROM `jos_session` Log Messages Last edit: 13 years 3 months ago by [Jerome](/forum/user/80-jerome "View Jerome's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14278 - - 13 years 3 months ago [\#114767](#114767) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114767 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* It's a bug of versions previous 2.2 which happens when a HikaShop content module instance ordering column is not properly set. You can manually update to the 2.2 to fix it (by downloading it on our website and installing it via the joomla installer), or you can try to find which module is causing the problem and disable it. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[caroltt](/forum/user/20350-caroltt "View caroltt's Profile")** - [![caroltt's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20350-caroltt "View caroltt's Profile") Topic Author - [ Offline](/forum/user/20350-caroltt) Less More - Posts: 7 - Thank you received: 0 - - 13 years 3 months ago [\#114822](#114822) by [caroltt](/forum/user/20350-caroltt "View caroltt's Profile") Replied by *[caroltt](/forum/user/20350-caroltt "View caroltt's Profile")* on topic *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114822 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* I updated to 2.2 but the error message is still there. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14278 - - 13 years 3 months ago [\#114828](#114828) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114828 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* We cannot reproduce the problem. Please provide a backend access to your website. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[caroltt](/forum/user/20350-caroltt "View caroltt's Profile")** - [![caroltt's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/20350-caroltt "View caroltt's Profile") Topic Author - [ Offline](/forum/user/20350-caroltt) Less More - Posts: 7 - Thank you received: 0 - - 13 years 3 months ago [\#114829](#114829) by [caroltt](/forum/user/20350-caroltt "View caroltt's Profile") Replied by *[caroltt](/forum/user/20350-caroltt "View caroltt's Profile")* on topic *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114829 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* How can I do this securely? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Jerome](/forum/user/80-jerome "View Jerome's Profile")** - [![Jerome's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar80.png)](/forum/user/80-jerome "View Jerome's Profile") - [ Offline](/forum/user/80-jerome) - HikaShop core developer Less More - Posts: 26394 - Thank you received: 4078 - - [](http://obsi.dev) - 13 years 3 months ago [\#114837](#114837) by [Jerome](/forum/user/80-jerome "View Jerome's Profile") Replied by *[Jerome](/forum/user/80-jerome "View Jerome's Profile")* on topic *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114837 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* Hi, By email, by private message or by using our contact form. Regards, --- Jerome - Obsidev.com HikaMarket & HikaSerial developer / HikaShop core dev team. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86320 - Thank you received: 14278 - - 13 years 3 months ago [\#114870](#114870) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Help - 1054 Error Message](/forum/2-general-talk-about-hikashop/85502-help-1054-error-message#114870 "I get this 1054 error message and I have no idea where to even begin to fix it. :blush: Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM jos_hikashop_product AS b WHERE b.product_published=1 AND b.product_parent_id=1 AND b.product_type = 'variant' AND (b.product_access = 'all' OR b.product_access LIKE '%,8,%') ORDER BY a.ordering ASC LIMIT 0, 20 Could someone help me, please?")* Hi, I'm not sure why but it came from the module: [ atomicspices.com/administrator/index.php...odules&task=edit&cid](http://atomicspices.com/administrator/index.php?option=com_hikashop&ctrl=modules&task=edit&cid)[]=227 I've removed it from the "modules under the product page" since anyway you should not need it there since there is already a related products module enabled there, and it then worked. The following user(s) said Thank You: [caroltt](/forum/user/20350-caroltt "View caroltt's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzg1NTAyLWhlbHAtMTA1NC1lcnJvci1tZXNzYWdlP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.106 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)