[Skip to main content](#vessel-content)

#   error 1054 after searching in orders

##

- **[mireille76](/forum/user/39053-mireille76 "View mireille76's Profile")**
- [![mireille76's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39053-mireille76 "View mireille76's Profile") Topic Author
- [ Offline](/forum/user/39053-mireille76)

Less More

- Posts: 25
- Thank you received: 0
-
-

11 years 2 weeks ago [\#219724](#219724) by [mireille76](/forum/user/39053-mireille76 "View mireille76's Profile")  *[error 1054 after searching in orders](/forum/45-filters-search/880305-error-1054-after-searching-in-orders#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&#95;280&#95;11&#95;03&#95;22' in 'where clause' SQL=SELECT a.&#42;,b.&#42;,c.&#42;,IFNULL(c.name,CONCAT&#95;WS(' ',d.address&#95;firstname,d.address&#95;middle&#95;name,d.address&#95;lastname)) AS hikashop&#95;name FROM oi6ne&#95;hikashop&#95;order AS b LEFT JOIN oi6ne&#95;hikashop&#95;address AS d ON b.order&#95;billing&#95;address&#95;id=d.address&#95;id LEFT JOIN oi6ne&#95;hikashop&#95;user AS a ON b.order&#95;user&#95;id=a.user&#95;id LEFT JOIN oi6ne&#95;users AS c ON a.user&#95;cms&#95;id=c.id WHERE (b.order&#95;type='sale') AND (c.id LIKE '%gerg%' OR c.username LIKE '%gerg%' OR c.name LIKE '%gerg%' OR a.user&#95;email LIKE '%gerg%' OR b.order&#95;user&#95;id LIKE '%gerg%' OR b.order&#95;number LIKE '%gerg%' OR b.order&#95;id LIKE '%gerg%' OR b.order&#95;invoice&#95;number LIKE '%gerg%' OR b.order&#95;invoice&#95;id LIKE '%gerg%' OR b.order&#95;full&#95;price LIKE '%gerg%' OR d.address&#95;firstname LIKE '%gerg%' OR d.address&#95;lastname LIKE '%gerg%' OR b.pick&#95;up&#95;place&#95;list LIKE '%gerg%' OR b.customtext&#95;280&#95;11&#95;03&#95;22 LIKE '%gerg%' OR b.newpickupplace LIKE '%gerg%' OR b.custom&#95;message&#95;p LIKE '%gerg%') ORDER BY b.order&#95;id desc LIMIT 0, 100  Hello,  When in backend I go to hikashop -&gt; orders and I do a research I get error 1054. When I then click on &quot;return to control panel&quot; I come to the control panel. When I then go to hikashop -&gt; orders I do not see my orders but again the error page. When I logout from Joomla and login again and go to hikashop-&gt;orders I can see my orders again.  When I do a similar research on hikashop-&gt;customers everything works fine.  I already did &quot;check database&quot; 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")* was created by *[mireille76](/forum/user/39053-mireille76 "View mireille76's Profile")*

-- 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 -&gt; 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 -&gt; orders I do not see my orders but again the error page.
When I logout from Joomla and login again and go to hikashop-&gt;orders I can see my orders again.

When I do a similar research on hikashop-&gt;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](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4MDMwNS1lcnJvci0xMDU0LWFmdGVyLXNlYXJjaGluZy1pbi1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

11 years 1 week ago [\#219865](#219865) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[error 1054 after searching in orders](/forum/45-filters-search/880305-error-1054-after-searching-in-orders#219865 "-- 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&#95;280&#95;11&#95;03&#95;22' in 'where clause' SQL=SELECT a.&#42;,b.&#42;,c.&#42;,IFNULL(c.name,CONCAT&#95;WS(' ',d.address&#95;firstname,d.address&#95;middle&#95;name,d.address&#95;lastname)) AS hikashop&#95;name FROM oi6ne&#95;hikashop&#95;order AS b LEFT JOIN oi6ne&#95;hikashop&#95;address AS d ON b.order&#95;billing&#95;address&#95;id=d.address&#95;id LEFT JOIN oi6ne&#95;hikashop&#95;user AS a ON b.order&#95;user&#95;id=a.user&#95;id LEFT JOIN oi6ne&#95;users AS c ON a.user&#95;cms&#95;id=c.id WHERE (b.order&#95;type='sale') AND (c.id LIKE '%gerg%' OR c.username LIKE '%gerg%' OR c.name LIKE '%gerg%' OR a.user&#95;email LIKE '%gerg%' OR b.order&#95;user&#95;id LIKE '%gerg%' OR b.order&#95;number LIKE '%gerg%' OR b.order&#95;id LIKE '%gerg%' OR b.order&#95;invoice&#95;number LIKE '%gerg%' OR b.order&#95;invoice&#95;id LIKE '%gerg%' OR b.order&#95;full&#95;price LIKE '%gerg%' OR d.address&#95;firstname LIKE '%gerg%' OR d.address&#95;lastname LIKE '%gerg%' OR b.pick&#95;up&#95;place&#95;list LIKE '%gerg%' OR b.customtext&#95;280&#95;11&#95;03&#95;22 LIKE '%gerg%' OR b.newpickupplace LIKE '%gerg%' OR b.custom&#95;message&#95;p LIKE '%gerg%') ORDER BY b.order&#95;id desc LIMIT 0, 100  Hello,  When in backend I go to hikashop -&gt; orders and I do a research I get error 1054. When I then click on &quot;return to control panel&quot; I come to the control panel. When I then go to hikashop -&gt; orders I do not see my orders but again the error page. When I logout from Joomla and login again and go to hikashop-&gt;orders I can see my orders again.  When I do a similar research on hikashop-&gt;customers everything works fine.  I already did &quot;check database&quot; 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")*

Hi,

Add the line: Code:

if($field-&gt;field_type == "customtext") continue;

before the line: Code:

$searchMap[]='b.'.$field-&gt;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](/forum/user/39053-mireille76 "View mireille76's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4MDMwNS1lcnJvci0xMDU0LWFmdGVyLXNlYXJjaGluZy1pbi1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[mireille76](/forum/user/39053-mireille76 "View mireille76's Profile")**
- [![mireille76's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/39053-mireille76 "View mireille76's Profile") Topic Author
- [ Offline](/forum/user/39053-mireille76)

Less More

- Posts: 25
- Thank you received: 0
-
-

11 years 1 week ago [\#219960](#219960) by [mireille76](/forum/user/39053-mireille76 "View mireille76's Profile")  Replied by *[mireille76](/forum/user/39053-mireille76 "View mireille76's Profile")* on topic *[error 1054 after searching in orders](/forum/45-filters-search/880305-error-1054-after-searching-in-orders#219960 "-- 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&#95;280&#95;11&#95;03&#95;22' in 'where clause' SQL=SELECT a.&#42;,b.&#42;,c.&#42;,IFNULL(c.name,CONCAT&#95;WS(' ',d.address&#95;firstname,d.address&#95;middle&#95;name,d.address&#95;lastname)) AS hikashop&#95;name FROM oi6ne&#95;hikashop&#95;order AS b LEFT JOIN oi6ne&#95;hikashop&#95;address AS d ON b.order&#95;billing&#95;address&#95;id=d.address&#95;id LEFT JOIN oi6ne&#95;hikashop&#95;user AS a ON b.order&#95;user&#95;id=a.user&#95;id LEFT JOIN oi6ne&#95;users AS c ON a.user&#95;cms&#95;id=c.id WHERE (b.order&#95;type='sale') AND (c.id LIKE '%gerg%' OR c.username LIKE '%gerg%' OR c.name LIKE '%gerg%' OR a.user&#95;email LIKE '%gerg%' OR b.order&#95;user&#95;id LIKE '%gerg%' OR b.order&#95;number LIKE '%gerg%' OR b.order&#95;id LIKE '%gerg%' OR b.order&#95;invoice&#95;number LIKE '%gerg%' OR b.order&#95;invoice&#95;id LIKE '%gerg%' OR b.order&#95;full&#95;price LIKE '%gerg%' OR d.address&#95;firstname LIKE '%gerg%' OR d.address&#95;lastname LIKE '%gerg%' OR b.pick&#95;up&#95;place&#95;list LIKE '%gerg%' OR b.customtext&#95;280&#95;11&#95;03&#95;22 LIKE '%gerg%' OR b.newpickupplace LIKE '%gerg%' OR b.custom&#95;message&#95;p LIKE '%gerg%') ORDER BY b.order&#95;id desc LIMIT 0, 100  Hello,  When in backend I go to hikashop -&gt; orders and I do a research I get error 1054. When I then click on &quot;return to control panel&quot; I come to the control panel. When I then go to hikashop -&gt; orders I do not see my orders but again the error page. When I logout from Joomla and login again and go to hikashop-&gt;orders I can see my orders again.  When I do a similar research on hikashop-&gt;customers everything works fine.  I already did &quot;check database&quot; 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")*

Thank you,
This solved the issue.
Thanks,
Mireille

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzg4MDMwNS1lcnJvci0xMDU0LWFmdGVyLXNlYXJjaGluZy1pbi1vcmRlcnM/dG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.056 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
