[Skip to main content](#vessel-content)

#   1054 Error

##

- **[dwightlayton](/forum/user/30287-dwightlayton "View dwightlayton's Profile")**
- [![dwightlayton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30287-dwightlayton "View dwightlayton's Profile") Topic Author
- [ Offline](/forum/user/30287-dwightlayton)

Less More

- Posts: 4
- Thank you received: 0
-
-

12 years 5 months ago [\#154128](#154128) by [dwightlayton](/forum/user/30287-dwightlayton "View dwightlayton's Profile")  *[1054 Error](/forum/25-install-update/867818-1054-error#154128 "-- url of the page with the problem -- ;   skillsontherun.com/index.php/hikashop  -- HikaShop version -- : HikaShop Starter: 2.3.0 HikaMarket Multivendor: 1.4.0 -- Joomla version -- : Joomla! 3.2.3 Stable &#91; Ember &#93; 6-March-2014 14:30 GMT -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  I had the basic HikaShop and everything was working fine. I upgraded to the HikaMarket Multivendor and things went south.  If you are not logged into a website you can place an order, but the emailed customer's receipt does not go out after the order is made like is used to with the basic HikaShop. Once you place the order and come back to that same menu (page) (you are now logged in, or if you login first) you will get 1054 error. Here is that error as displayed on the product page:  1054 Error Unknown column 'accepted&#95;zip' in 'where clause' SQL=SELECT DISTINCT b.&#42; FROM joom&#95;hikashop&#95;product&#95;category AS a LEFT JOIN joom&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN joom&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON b.product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE (accepted&#95;zip LIKE '%92629%') OR (accepted&#95;zip LIKE '%9262&#42;%') OR (accepted&#95;zip LIKE '%926&#42;&#42;%') OR (accepted&#95;zip LIKE '%92&#42;&#42;&#42;%') OR (accepted&#95;zip LIKE '%9&#42;&#42;&#42;&#42;%') OR (accepted&#95;zip LIKE '%&#42;&#42;&#42;&#42;&#42;%') AND accepted&#95;cities LIKE '%Dana Point%' ORDER BY a.ordering ASC LIMIT 0, 20  So I know of two issues for sure and maybe a third one that happened, but does not repeat every time like the first two.  1. No auto email receipt for orders placed 2. 1054 error when logged in and trying to open product menu (page) 3. This error has also come up, but not all the time. It happens when I try to update an order status. The error is: Fatal error: Call to a member function get() on a non-object in /home1/dwight/public&#95;html/skillsontherun.com/administrator/components/com&#95;hikamarket/classes/order.php on line 1509  There maybe more issues that I am not aware of.  Please help.")* was created by *[dwightlayton](/forum/user/30287-dwightlayton "View dwightlayton's Profile")*

-- url of the page with the problem -- ; [ skillsontherun.com/index.php/hikashop](http://skillsontherun.com/index.php/hikashop)
-- HikaShop version -- : HikaShop Starter: 2.3.0 HikaMarket Multivendor: 1.4.0
-- Joomla version -- : Joomla! 3.2.3 Stable [ Ember ] 6-March-2014 14:30 GMT
-- PHP version -- : 5.3.28
-- Browser(s) name and version -- : All
-- Error-message(debug-mod must be tuned on) -- : Error_message

I had the basic HikaShop and everything was working fine. I upgraded to the HikaMarket Multivendor and things went south.

If you are not logged into a website you can place an order, but the emailed customer's receipt does not go out after the order is made like is used to with the basic HikaShop. Once you place the order and come back to that same menu (page) (you are now logged in, or if you login first) you will get 1054 error. Here is that error as displayed on the product page:

1054 Error
Unknown column 'accepted_zip' in 'where clause' SQL=SELECT DISTINCT b.* FROM joom_hikashop_product_category AS a LEFT JOIN joom_hikashop_product AS b ON a.product_id=b.product_id LEFT JOIN joom_hikamarket_vendor AS hikam_vendor ON b.product_vendor_id = hikam_vendor.vendor_id WHERE (accepted_zip LIKE '%92629%') OR (accepted_zip LIKE '%9262*%') OR (accepted_zip LIKE '%926**%') OR (accepted_zip LIKE '%92***%') OR (accepted_zip LIKE '%9****%') OR (accepted_zip LIKE '%*****%') AND accepted_cities LIKE '%Dana Point%' ORDER BY a.ordering ASC LIMIT 0, 20

So I know of two issues for sure and maybe a third one that happened, but does not repeat every time like the first two.

1. No auto email receipt for orders placed
2. 1054 error when logged in and trying to open product menu (page)
3. This error has also come up, but not all the time. It happens when I try to update an order status. The error is:
Fatal error: Call to a member function get() on a non-object in /home1/dwight/public_html/skillsontherun.com/administrator/components/com_hikamarket/classes/order.php on line 1509

There maybe more issues that I am not aware of.

Please help.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NzgxOC0xMDU0LWVycm9yP3RtcGw9bWFya2Rvd24=) 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: 86293
- Thank you received: 14271
-
-

12 years 5 months ago [\#154153](#154153) 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](/forum/25-install-update/867818-1054-error#154153 "-- url of the page with the problem -- ;   skillsontherun.com/index.php/hikashop  -- HikaShop version -- : HikaShop Starter: 2.3.0 HikaMarket Multivendor: 1.4.0 -- Joomla version -- : Joomla! 3.2.3 Stable &#91; Ember &#93; 6-March-2014 14:30 GMT -- PHP version -- : 5.3.28 -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : Error&#95;message  I had the basic HikaShop and everything was working fine. I upgraded to the HikaMarket Multivendor and things went south.  If you are not logged into a website you can place an order, but the emailed customer's receipt does not go out after the order is made like is used to with the basic HikaShop. Once you place the order and come back to that same menu (page) (you are now logged in, or if you login first) you will get 1054 error. Here is that error as displayed on the product page:  1054 Error Unknown column 'accepted&#95;zip' in 'where clause' SQL=SELECT DISTINCT b.&#42; FROM joom&#95;hikashop&#95;product&#95;category AS a LEFT JOIN joom&#95;hikashop&#95;product AS b ON a.product&#95;id=b.product&#95;id LEFT JOIN joom&#95;hikamarket&#95;vendor AS hikam&#95;vendor ON b.product&#95;vendor&#95;id = hikam&#95;vendor.vendor&#95;id WHERE (accepted&#95;zip LIKE '%92629%') OR (accepted&#95;zip LIKE '%9262&#42;%') OR (accepted&#95;zip LIKE '%926&#42;&#42;%') OR (accepted&#95;zip LIKE '%92&#42;&#42;&#42;%') OR (accepted&#95;zip LIKE '%9&#42;&#42;&#42;&#42;%') OR (accepted&#95;zip LIKE '%&#42;&#42;&#42;&#42;&#42;%') AND accepted&#95;cities LIKE '%Dana Point%' ORDER BY a.ordering ASC LIMIT 0, 20  So I know of two issues for sure and maybe a third one that happened, but does not repeat every time like the first two.  1. No auto email receipt for orders placed 2. 1054 error when logged in and trying to open product menu (page) 3. This error has also come up, but not all the time. It happens when I try to update an order status. The error is: Fatal error: Call to a member function get() on a non-object in /home1/dwight/public&#95;html/skillsontherun.com/administrator/components/com&#95;hikamarket/classes/order.php on line 1509  There maybe more issues that I am not aware of.  Please help.")*

Hi,

Jerome is the specialist for HikaMarket, not me, but from what I know, this is a new bug since HikaMarket 1.4.0 was released a few days ago. Here is the solution:
[ www.hikashop.com/forum/19-hikamarket/867...-release.html#153947](http://www.hikashop.com/forum/19-hikamarket/867770-hikamarket-1-4-0-release.html#153947)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzI1LWluc3RhbGwtdXBkYXRlLzg2NzgxOC0xMDU0LWVycm9yP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop- Install &amp; Update- Product &amp; Category Display- Content Creation- Sales and Orders- - Orders management- - Reports &amp; Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import &amp; Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel &amp; Slider- - Mass Actions- - Filters &amp; Search- - Discount &amp; 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.146 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
