[Skip to main content](#vessel-content) # 1054 error after update! ## - **[mare88](/forum/user/34697-mare88 "View mare88's Profile")** - [![mare88's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34697-mare88 "View mare88's Profile") Topic Author - [ Offline](/forum/user/34697-mare88) Less More - Posts: 11 - Thank you received: 0 - - 11 years 9 months ago [\#185566](#185566) by [mare88](/forum/user/34697-mare88 "View mare88's Profile") *[1054 error after update!](/forum/25-install-update/874068-1054-error-after-update#185566 "-- HikaShop version -- : HikaShop starter 2.3.5. -- Joomla version -- : 3.3.6. -- PHP version -- : 5.3.29. -- Browser(s) name and version -- : Firefox 34.0.5. Good evening to all! I just updated my HikaShop to the latest version (2.3.5.) and immediately I started having problems. My products are divided by 'Product categories' & by 'Brand'. When I click any of my Brands (from my 'Brands' module) in order to view the respective products, I get a '1054 Error'. More specifically: Error: 1054 - Unknown column 'b.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM v0c6e_hikashop_product AS b WHERE b.product_published=1 AND b.product_type = 'main' AND b.product_manufacturer_id IN (12) AND b.product_quantity!=0 ORDER BY b.ordering ASC LIMIT 0, 16 I turned on the Joomla debug mode, and set the 'Error reporting' to maximum (as advised in other topics), but I can't see any other relative information. I've attached a photo, so that you can have a look too. Could you please, please help me? It's urgent. Thank you very very much in advance!")* was created by *[mare88](/forum/user/34697-mare88 "View mare88's Profile")* -- HikaShop version -- : HikaShop starter 2.3.5. -- Joomla version -- : 3.3.6. -- PHP version -- : 5.3.29. -- Browser(s) name and version -- : Firefox 34.0.5. Good evening to all! I just updated my HikaShop to the latest version (2.3.5.) and immediately I started having problems. My products are divided by 'Product categories' & by 'Brand'. When I click any of my Brands (from my 'Brands' module) in order to view the respective products, I get a '1054 Error'. More specifically: *Error: 1054 - Unknown column 'b.ordering' in 'order clause' SQL=SELECT DISTINCT b.\* FROM v0c6e\_hikashop\_product AS b WHERE b.product\_published=1 AND b.product\_type = 'main' AND b.product\_manufacturer\_id IN (12) AND b.product\_quantity!=0 ORDER BY b.ordering ASC LIMIT 0, 16* I turned on the Joomla debug mode, and set the 'Error reporting' to maximum (as advised in other topics), but I can't see any other relative information. I've attached a photo, so that you can have a look too. Could you please, please help me? It's urgent. Thank you very very much in advance! - [ ![Error.jpg](/forum/attachment/21502) ](/forum/attachment/21502 "Error.jpg") [ ](/forum/attachment/21502?download=1 "Error.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDA2OC0xMDU0LWVycm9yLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 9 months ago [\#185667](#185667) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 error after update!](/forum/25-install-update/874068-1054-error-after-update#185667 "-- HikaShop version -- : HikaShop starter 2.3.5. -- Joomla version -- : 3.3.6. -- PHP version -- : 5.3.29. -- Browser(s) name and version -- : Firefox 34.0.5. Good evening to all! I just updated my HikaShop to the latest version (2.3.5.) and immediately I started having problems. My products are divided by 'Product categories' & by 'Brand'. When I click any of my Brands (from my 'Brands' module) in order to view the respective products, I get a '1054 Error'. More specifically: Error: 1054 - Unknown column 'b.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM v0c6e_hikashop_product AS b WHERE b.product_published=1 AND b.product_type = 'main' AND b.product_manufacturer_id IN (12) AND b.product_quantity!=0 ORDER BY b.ordering ASC LIMIT 0, 16 I turned on the Joomla debug mode, and set the 'Error reporting' to maximum (as advised in other topics), but I can't see any other relative information. I've attached a photo, so that you can have a look too. Could you please, please help me? It's urgent. Thank you very very much in advance!")* Hi, Please change the line: if($pageInfo->filter->order->value=='a.ordering'){ to: if($pageInfo->filter->order->value=='a.ordering' || $pageInfo->filter->order->value=='b.ordering'){ in the file components/com_hikashop/views/product/view.html.php and that should fix the problem. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDA2OC0xMDU0LWVycm9yLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[mare88](/forum/user/34697-mare88 "View mare88's Profile")** - [![mare88's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/34697-mare88 "View mare88's Profile") Topic Author - [ Offline](/forum/user/34697-mare88) Less More - Posts: 11 - Thank you received: 0 - - 11 years 9 months ago [\#185696](#185696) by [mare88](/forum/user/34697-mare88 "View mare88's Profile") Replied by *[mare88](/forum/user/34697-mare88 "View mare88's Profile")* on topic *[1054 error after update!](/forum/25-install-update/874068-1054-error-after-update#185696 "-- HikaShop version -- : HikaShop starter 2.3.5. -- Joomla version -- : 3.3.6. -- PHP version -- : 5.3.29. -- Browser(s) name and version -- : Firefox 34.0.5. Good evening to all! I just updated my HikaShop to the latest version (2.3.5.) and immediately I started having problems. My products are divided by 'Product categories' & by 'Brand'. When I click any of my Brands (from my 'Brands' module) in order to view the respective products, I get a '1054 Error'. More specifically: Error: 1054 - Unknown column 'b.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM v0c6e_hikashop_product AS b WHERE b.product_published=1 AND b.product_type = 'main' AND b.product_manufacturer_id IN (12) AND b.product_quantity!=0 ORDER BY b.ordering ASC LIMIT 0, 16 I turned on the Joomla debug mode, and set the 'Error reporting' to maximum (as advised in other topics), but I can't see any other relative information. I've attached a photo, so that you can have a look too. Could you please, please help me? It's urgent. Thank you very very much in advance!")* Indeed, it fixed it! Thanks a lot, Nicolas! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDA2OC0xMDU0LWVycm9yLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[infonat](/forum/user/16252-infonat "View infonat's Profile")** - [![infonat's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/16252-infonat "View infonat's Profile") - [ Offline](/forum/user/16252-infonat) Less More - Posts: 3 - Thank you received: 0 - - 11 years 9 months ago [\#185980](#185980) by [infonat](/forum/user/16252-infonat "View infonat's Profile") Replied by *[infonat](/forum/user/16252-infonat "View infonat's Profile")* on topic *[1054 error after update!](/forum/25-install-update/874068-1054-error-after-update#185980 "-- HikaShop version -- : HikaShop starter 2.3.5. -- Joomla version -- : 3.3.6. -- PHP version -- : 5.3.29. -- Browser(s) name and version -- : Firefox 34.0.5. Good evening to all! I just updated my HikaShop to the latest version (2.3.5.) and immediately I started having problems. My products are divided by 'Product categories' & by 'Brand'. When I click any of my Brands (from my 'Brands' module) in order to view the respective products, I get a '1054 Error'. More specifically: Error: 1054 - Unknown column 'b.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM v0c6e_hikashop_product AS b WHERE b.product_published=1 AND b.product_type = 'main' AND b.product_manufacturer_id IN (12) AND b.product_quantity!=0 ORDER BY b.ordering ASC LIMIT 0, 16 I turned on the Joomla debug mode, and set the 'Error reporting' to maximum (as advised in other topics), but I can't see any other relative information. I've attached a photo, so that you can have a look too. Could you please, please help me? It's urgent. Thank you very very much in advance!")* - HikaShop version : HikaShop business 2.3.5 - Joomla version : 3.3.6 - PHP version : 5.5.40 - Navigateur et version : Firefox 34.0 - Language : Français/French Bonjour, J'ai effectué la mise à jour d'Hikashop Business vers la dernière version 2.3.5. Quand je copie une commande dans l'administration, ça ne fonctionne plus et voici le message qui s'affiche : *1054 Unknown column 'shipping\_address' in 'field list' SQL=INSERT IGNORE INTO `a2jwc\_hikashop\_order` ( `order\_billing\_address\_id`,`order\_shipping\_address\_id`,`order\_user\_id`,`order\_status`,`order\_discount\_code`,`order\_created`,`order\_ip`,`order\_currency\_id`,`order\_shipping\_price`,`order\_discount\_price`,`order\_shipping\_id`,`order\_shipping\_method`,`order\_payment\_id`,`order\_payment\_method`,`order\_full\_price`,`order\_modified`,`order\_partner\_id`,`order\_partner\_price`,`order\_partner\_paid`,`order\_type`,`order\_partner\_currency\_id`,`order\_shipping\_tax`,`order\_discount\_tax`,`order\_tax\_info`,`order\_payment\_price`,`order\_invoice\_created`,`order\_shipping\_params`,`order\_payment\_params`,`order\_paiement`,`order\_bi`,`order\_note`,`order\_abonnement`,`order\_detail`,`order\_condreg`,`order\_site\_id`,`shipping\_address`,`order\_invoice\_id`,`order\_invoice\_number` ) VALUES ...* Je dois relancer le composant Hikashop pour poursuivre. Merci pour vos conseils par avance. _______________________________________________________ Goodmorning! I just updated my HikaShop Business to the latest version (2.3.5). When I copy an order in backend, I get a '1054 Error'. More specifically: *1054 Unknown column 'shipping\_address' in 'field list' SQL=INSERT IGNORE INTO `a2jwc\_hikashop\_order` ( `order\_billing\_address\_id`, ...* (see above) Thank you in advance! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDA2OC0xMDU0LWVycm9yLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) 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)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86290 - Thank you received: 14268 - - 11 years 9 months ago [\#185992](#185992) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[1054 error after update!](/forum/25-install-update/874068-1054-error-after-update#185992 "-- HikaShop version -- : HikaShop starter 2.3.5. -- Joomla version -- : 3.3.6. -- PHP version -- : 5.3.29. -- Browser(s) name and version -- : Firefox 34.0.5. Good evening to all! I just updated my HikaShop to the latest version (2.3.5.) and immediately I started having problems. My products are divided by 'Product categories' & by 'Brand'. When I click any of my Brands (from my 'Brands' module) in order to view the respective products, I get a '1054 Error'. More specifically: Error: 1054 - Unknown column 'b.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM v0c6e_hikashop_product AS b WHERE b.product_published=1 AND b.product_type = 'main' AND b.product_manufacturer_id IN (12) AND b.product_quantity!=0 ORDER BY b.ordering ASC LIMIT 0, 16 I turned on the Joomla debug mode, and set the 'Error reporting' to maximum (as advised in other topics), but I can't see any other relative information. I've attached a photo, so that you can have a look too. Could you please, please help me? It's urgent. Thank you very very much in advance!")* Hi, Try to add the code: Code: unset($order->shipping_address); unset($order->billing_address); after the code: Code: unset($order->order_id); unset($order->order_number); unset($order->order_invoice_id); unset($order->order_invoice_number); unset($order->order_subtotal); unset($order->override_shipping_address); unset($order->order_subtotal_no_vat); unset($order->history); in the file administrator/components/com_hikashop/classes/order.php That should help avoid the error but it's not guaranteed as we couldn't reproduce the error on our end and thus couldn't test the fix. The following user(s) said Thank You: [infonat](/forum/user/16252-infonat "View infonat's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDA2OC0xMDU0LWVycm9yLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[infonat](/forum/user/16252-infonat "View infonat's Profile")** - [![infonat's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/16252-infonat "View infonat's Profile") - [ Offline](/forum/user/16252-infonat) Less More - Posts: 3 - Thank you received: 0 - - 11 years 9 months ago [\#186013](#186013) by [infonat](/forum/user/16252-infonat "View infonat's Profile") Replied by *[infonat](/forum/user/16252-infonat "View infonat's Profile")* on topic *[1054 error after update!](/forum/25-install-update/874068-1054-error-after-update#186013 "-- HikaShop version -- : HikaShop starter 2.3.5. -- Joomla version -- : 3.3.6. -- PHP version -- : 5.3.29. -- Browser(s) name and version -- : Firefox 34.0.5. Good evening to all! I just updated my HikaShop to the latest version (2.3.5.) and immediately I started having problems. My products are divided by 'Product categories' & by 'Brand'. When I click any of my Brands (from my 'Brands' module) in order to view the respective products, I get a '1054 Error'. More specifically: Error: 1054 - Unknown column 'b.ordering' in 'order clause' SQL=SELECT DISTINCT b.* FROM v0c6e_hikashop_product AS b WHERE b.product_published=1 AND b.product_type = 'main' AND b.product_manufacturer_id IN (12) AND b.product_quantity!=0 ORDER BY b.ordering ASC LIMIT 0, 16 I turned on the Joomla debug mode, and set the 'Error reporting' to maximum (as advised in other topics), but I can't see any other relative information. I've attached a photo, so that you can have a look too. Could you please, please help me? It's urgent. Thank you very very much in advance!")* C'est résolu, Merci beaucoup Nicolas ! Indeed, it fixed it! Thanks a lot, Nicolas! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg3NDA2OC0xMDU0LWVycm9yLWFmdGVyLXVwZGF0ZT90bXBsPW1hcmtkb3du) 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.277 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)