[Skip to main content](#vessel-content) # 1054 error ## - **[murdock89](/forum/user/31952-murdock89 "View murdock89's Profile")** - [![murdock89's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/31952-murdock89 "View murdock89's Profile") Topic Author - [ Offline](/forum/user/31952-murdock89) Less More - Posts: 3 - Thank you received: 0 - - 12 years 4 months ago [\#158893](#158893) by [murdock89](/forum/user/31952-murdock89 "View murdock89's Profile") *[1054 error](/forum/25-install-update/868768-1054-error#158893 "-- 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.")* was created by *[murdock89](/forum/user/31952-murdock89 "View murdock89's Profile")* -- url of the page with the problem -- : [ wpsoutdoors.com](http://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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2ODc2OC0xMDU0LWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")** - [![Mohamed Thelji's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6861.png)](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") - [ Offline](/forum/user/6861-mohamed-thelji) Less More - Posts: 12953 - Thank you received: 1778 - - - 12 years 4 months ago [\#158907](#158907) by [Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile") Replied by *[Mohamed Thelji](/forum/user/6861-mohamed-thelji "View Mohamed Thelji's Profile")* on topic *[1054 error](/forum/25-install-update/868768-1054-error#158907 "-- 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](https://www.hikashop.com/support/documentation/integrated-documentation/10-hikashop/61-hikashop-compatibility-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. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2ODc2OC0xMDU0LWVycm9yP3RtcGw9bWFya2Rvd24=) 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.153 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)