-- HikaShop version -- : 2.6.0
-- Joomla version -- : 3.4.5
-- PHP version -- : 5.6.6
-- Error-message(debug-mod must be tuned on) -- : An error has occurred.
1054 Unknown column 'b.customtext_280_11_03_22' in 'where clause' SQL=SELECT a.*,b.*,c.*,IFNULL(c.name,CONCAT_WS(' ',d.address_firstname,d.address_middle_name,d.address_lastname)) AS hikashop_name FROM oi6ne_hikashop_order AS b LEFT JOIN oi6ne_hikashop_address AS d ON b.order_billing_address_id=d.address_id LEFT JOIN oi6ne_hikashop_user AS a ON b.order_user_id=a.user_id LEFT JOIN oi6ne_users AS c ON a.user_cms_id=c.id WHERE (b.order_type='sale') AND (c.id LIKE '%gerg%' OR c.username LIKE '%gerg%' OR c.name LIKE '%gerg%' OR a.user_email LIKE '%gerg%' OR b.order_user_id LIKE '%gerg%' OR b.order_number LIKE '%gerg%' OR b.order_id LIKE '%gerg%' OR b.order_invoice_number LIKE '%gerg%' OR b.order_invoice_id LIKE '%gerg%' OR b.order_full_price LIKE '%gerg%' OR d.address_firstname LIKE '%gerg%' OR d.address_lastname LIKE '%gerg%' OR b.pick_up_place_list LIKE '%gerg%' OR b.customtext_280_11_03_22 LIKE '%gerg%' OR b.newpickupplace LIKE '%gerg%' OR b.custom_message_p LIKE '%gerg%') ORDER BY b.order_id desc LIMIT 0, 100
Hello,
When in backend I go to hikashop -> orders and I do a research I get error 1054.
When I then click on "return to control panel" I come to the control panel. When I then go to hikashop -> orders I do not see my orders but again the error page.
When I logout from Joomla and login again and go to hikashop->orders I can see my orders again.
When I do a similar research on hikashop->customers everything works fine.
I already did "check database" but the problem remains.
Do have an idea why the search function on my orders does not work ?
Thank you very much for your answer,
Mireille