error 1054 after searching in orders

  • Posts: 25
  • Thank you received: 0
9 years 2 weeks ago #219724

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

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

  • Posts: 82867
  • Thank you received: 13373
  • MODERATOR
9 years 2 weeks ago #219865

Hi,

Add the line:

if($field->field_type == "customtext") continue;
before the line:
$searchMap[]='b.'.$field->field_namekey;
in the file administrator/components/com_hikashop/views/order/view.html.php and that will fix the problem.

The following user(s) said Thank You: mireille76

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

  • Posts: 25
  • Thank you received: 0
9 years 2 weeks ago #219960

Thank you,
This solved the issue.
Thanks,
Mireille

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

Time to create page: 0.059 seconds
Powered by Kunena Forum