Skip to main content

Help - 1054 Error Message

More
13 years 2 months ago #114643 by caroltt
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 or Create an account to join the conversation.

More
13 years 2 months ago #114648 by Jerome
Replied by Jerome on topic Help - 1054 Error Message
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

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #114687 by caroltt

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago - 13 years 2 months ago #114722 by nicolas
Replied by nicolas on topic Help - 1054 Error Message
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 2 months ago by nicolas.
The following user(s) said Thank You: caroltt

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago - 13 years 2 months ago #114732 by caroltt
Replied by caroltt on topic Help - 1054 Error Message
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 2 months ago by Jerome.

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #114767 by nicolas
Replied by nicolas on topic Help - 1054 Error Message
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 or Create an account to join the conversation.

More
13 years 2 months ago #114822 by caroltt
Replied by caroltt on topic Help - 1054 Error Message
I updated to 2.2 but the error message is still there.

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #114828 by nicolas
Replied by nicolas on topic Help - 1054 Error Message
We cannot reproduce the problem.

Please provide a backend access to your website.

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #114829 by caroltt
Replied by caroltt on topic Help - 1054 Error Message
How can I do this securely?

Please Log in or Create an account to join the conversation.

More
13 years 2 months ago #114837 by Jerome
Replied by Jerome on topic Help - 1054 Error Message
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 or Create an account to join the conversation.

More
13 years 2 months ago #114870 by nicolas
Replied by nicolas on topic Help - 1054 Error Message
Hi,

I'm not sure why but it came from the module:
atomicspices.com/administrator/index.php...odules&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

Please Log in or Create an account to join the conversation.

Time to create page: 0.192 seconds
Powered by Kunena Forum