- Posts: 25
- Thank you received: 0
error 1054 after searching in orders
- mireille76
-
Topic Author
- Offline
Less
More
11 years 2 weeks ago #219724
by mireille76
error 1054 after searching in orders was created by mireille76
-- 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
-- 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.
11 years 1 week ago #219865
by nicolas
Replied by nicolas on topic error 1054 after searching in orders
Hi,
Add the line:
before the line:
in the file administrator/components/com_hikashop/views/order/view.html.php and that will fix the problem.
Add the line:
Code:
if($field->field_type == "customtext") continue;
Code:
$searchMap[]='b.'.$field->field_namekey;
The following user(s) said Thank You: mireille76
Please Log in or Create an account to join the conversation.
- mireille76
-
Topic Author
- Offline
Less
More
- Posts: 25
- Thank you received: 0
11 years 1 week ago #219960
by mireille76
Replied by mireille76 on topic error 1054 after searching in orders
Thank you,
This solved the issue.
Thanks,
Mireille
This solved the issue.
Thanks,
Mireille
Please Log in or Create an account to join the conversation.
Time to create page: 0.044 seconds