HIKASHOP ESSENTIAL 60€The basic version. With the main features for a little shop.
HIKAMARKETAdd-on Create a multivendor platform. Enable many vendors on your website.
HIKASERIALAdd-on Sale e-tickets, vouchers, gift certificates, serial numbers and more!
MARKETPLACEPlugins, modules and other kinds of integrations for HikaShop
I get this 1054 error message and I have no idea where to even begin to fix it. 
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.
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,
Please Log in or Create an account to join the conversation.
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) ?
Please Log in or Create an account to join the conversation.
I have version 2.1.3. Is that the problem? It reads that it's the latest stable version.
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 MessagesPlease Log in or Create an account to join the conversation.
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.
I updated to 2.2 but the error message is still there.
Please Log in or Create an account to join the conversation.
We cannot reproduce the problem.
Please provide a backend access to your website.
Please Log in or Create an account to join the conversation.
How can I do this securely?
Please Log in or Create an account to join the conversation.
Hi,
By email, by private message or by using our contact form.
Regards,
Please Log in or Create an account to join the conversation.
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.
Please Log in or Create an account to join the conversation.
