1054 Error

  • Posts: 4
  • Thank you received: 0
11 years 3 months ago #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 [ 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 or Create an account to join the conversation.

  • Posts: 84146
  • Thank you received: 13651
  • MODERATOR
11 years 3 months ago #154153

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

Please Log in or Create an account to join the conversation.

Time to create page: 0.053 seconds
Powered by Kunena Forum