-- 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.