[Skip to main content](#vessel-content) # Error by creating filer ## - **[designer71](/forum/user/39268-designer71 "View designer71's Profile")** - [![designer71's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/beer.png)](/forum/user/39268-designer71 "View designer71's Profile") Topic Author - [ Offline](/forum/user/39268-designer71) Less More - Posts: 79 - Thank you received: 4 - - 3 months 3 weeks ago - 3 months 3 weeks ago [\#372602](#372602) by [designer71](/forum/user/39268-designer71 "View designer71's Profile") *[Error by creating filer](/forum/45-filters-search/910669-error-by-creating-filer#372602 "-- HikaShop version -- : 6.5.1 -- Joomla version -- : 5.4.1 -- PHP version -- : 8.3 -- Error-message(debug-mod must be tuned on) -- : 42 42S22, 1054, Unknown column 'autocomplete' in 'field list' Hi! I get error then I try to create filter: 42 42S22, 1054, Unknown column 'autocomplete' in 'field list' Any help, please")* was created by *[designer71](/forum/user/39268-designer71 "View designer71's Profile")* -- HikaShop version -- : 6.5.1 -- Joomla version -- : 5.4.1 -- PHP version -- : 8.3 -- Error-message(debug-mod must be tuned on) -- : 42 42S22, 1054, Unknown column 'autocomplete' in 'field list' Hi! I get error then I try to create filter: 42 42S22, 1054, Unknown column 'autocomplete' in 'field list' Any help, please Last edit: 3 months 3 weeks ago by [designer71](/forum/user/39268-designer71 "View designer71's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkxMDY2OS1lcnJvci1ieS1jcmVhdGluZy1maWxlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 3 months 3 weeks ago [\#372605](#372605) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Error by creating filer](/forum/45-filters-search/910669-error-by-creating-filer#372605 "-- HikaShop version -- : 6.5.1 -- Joomla version -- : 5.4.1 -- PHP version -- : 8.3 -- Error-message(debug-mod must be tuned on) -- : 42 42S22, 1054, Unknown column 'autocomplete' in 'field list' Hi! I get error then I try to create filter: 42 42S22, 1054, Unknown column 'autocomplete' in 'field list' Any help, please")* Hello, Thank you for the report, this is a genuine bug on our side. The autocomplete options that were added to the text filters were mistakenly written as columns of the filter table when saving, and since no such column exists the database rejected the query, hence the "1054 Unknown column 'autocomplete'" error. It happens for everyone creating or saving a filter, so it is not something specific to your setup. This is now fixed. A patched 6.5.1 build with the correction is available, so please update HikaShop (download the install package in My account>My subscriptions and install it on your website via the Joomla extensions installer) to get it. Filters then save normally, and your autocomplete settings are kept. The following user(s) said Thank You: [designer71](/forum/user/39268-designer71 "View designer71's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkxMDY2OS1lcnJvci1ieS1jcmVhdGluZy1maWxlcj90bXBsPW1hcmtkb3du) or [Create an account](/register) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & 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.049 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)