1054 error

-- url of the page with the problem -- : wpsoutdoors.com
-- HikaShop version -- : 2.31
-- Joomla version -- : 3.3
-- PHP version -- : 5.3.28
-- Browser(s) name and version -- : opera, chrome, firefox, safari, and IE all current and occurs on all
-- Error-message(debug-mod must be tuned on) -- : Error_message 1054 - Unknown column 'a.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM nhy_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

I've searched the forum with none of the previous solutions helping including updating to current version, cleaning browser, etc.

Any help is appreciated.

Hello,
Reading the documentation will probably help you : www.hikashop.com/support/documentation/i...lity-issues.html#SQL

500 - JDatabaseMySQL::query: 1054 - Unknown column 'XXXXXX' in 'where clause' SQL=SELECT * FROM.....
How to fix (for update issues)?
You should open the file administrator/components/com_hikashop/install.hikashop.php and search for that column name. You should see something like that:

$this->db->setQuery("ALTER TABLE `#__hikashop_YYYY` ADD `XXXXXXXX` .....................................................");
$this->db->query();

You need to open your phpmyadmin and run the query which is in the double quotes in your database. Don't forget to replace #__ by the prefix of your tables (it's usually jos_ for Joomla 1.5 but it is random for Joomla > 1.6 ).

For custom fields, you can just delete them and the error should disappear.
How to avoid problems later on ?
You should make sure that your MySQL user has the ALTER privilege. If you don't know how to do that, you should ask your hosting company.