[Skip to main content](#vessel-content) # Mass action timing out ## - **[smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile")** - [![smithshop123's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/17903-smithshop123 "View smithshop123's Profile") Topic Author - [ Offline](/forum/user/17903-smithshop123) Less More - Posts: 212 - Thank you received: 17 - - 7 months 3 weeks ago - 7 months 3 weeks ago [\#370750](#370750) by [smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile") *[Mass action timing out](/forum/44-mass-actions/910172-mass-action-timing-out#370750 "-- HikaShop version -- : 6.3.0 -- Joomla version -- : 6.0.3 -- PHP version -- : 8.3.30 -- Browser(s) name and version -- : Opera One(version: 112.0.5197.30) -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 3699 Timeout exceeded in regular expression match. Hi, we're running a simple regex to find a short string in our product description and add 'True'/'False' to a custom field (see attached). We need this to filter out certain products before submitting our product list to google. This has always worked in the past and no major changes have been made to the site (php version was updated recently). It has an 8000 upper limit but we have tested '1000' as an upper limit with the same result (below). Further, the timeout happens very quickly. Any suggestion on how to investigate or fix this. An error has occurred. 3699 Timeout exceeded in regular expression match. Thanks, Ian and Stu")* was created by *[smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile")* -- HikaShop version -- : 6.3.0 -- Joomla version -- : 6.0.3 -- PHP version -- : 8.3.30 -- Browser(s) name and version -- : Opera One(version: 112.0.5197.30) -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 3699 Timeout exceeded in regular expression match. Hi, we're running a simple regex to find a short string in our product description and add 'True'/'False' to a custom field (see attached). We need this to filter out certain products before submitting our product list to google. This has always worked in the past and no major changes have been made to the site (php version was updated recently). It has an 8000 upper limit but we have tested '1000' as an upper limit with the same result (below). Further, the timeout happens very quickly. Any suggestion on how to investigate or fix this. An error has occurred. 3699 Timeout exceeded in regular expression match. Thanks, Ian and Stu - [ ![mass-action-timeout.jpg](/forum/attachment/61261) ](/forum/attachment/61261 "...on-timeout.jpg") [ ](/forum/attachment/61261?download=1 "...on-timeout.jpg") Last edit: 7 months 3 weeks ago by [smithshop123](/forum/user/17903-smithshop123 "View smithshop123's Profile"). Reason: The service provide did something to trigger a timeout. So we used a search command that didn't require regex and it worked. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MTAxNzItbWFzcy1hY3Rpb24tdGltaW5nLW91dD90bXBsPW1hcmtkb3du) 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: 86324 - Thank you received: 14286 - - 7 months 3 weeks ago - 7 months 3 weeks ago [\#370751](#370751) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Mass action timing out](/forum/44-mass-actions/910172-mass-action-timing-out#370751 "-- HikaShop version -- : 6.3.0 -- Joomla version -- : 6.0.3 -- PHP version -- : 8.3.30 -- Browser(s) name and version -- : Opera One(version: 112.0.5197.30) -- Error-message(debug-mod must be tuned on) -- : An error has occurred. 3699 Timeout exceeded in regular expression match. Hi, we're running a simple regex to find a short string in our product description and add 'True'/'False' to a custom field (see attached). We need this to filter out certain products before submitting our product list to google. This has always worked in the past and no major changes have been made to the site (php version was updated recently). It has an 8000 upper limit but we have tested '1000' as an upper limit with the same result (below). Further, the timeout happens very quickly. Any suggestion on how to investigate or fix this. An error has occurred. 3699 Timeout exceeded in regular expression match. Thanks, Ian and Stu")* Hi, The issue comes from your regex pattern .*s3.*. In MySQL, REGEXP already matches anywhere in the string, so the .* on both sides is redundant. It forces the regex engine to consume the entire description text and then backtrack through it, which on long HTML descriptions triggers MySQL's regex timeout. That's why changing the limitation from 8000 to 1000 didn't help because the timeout happens on individual product descriptions, not on the total number of products processed. Your workaround of switching to a non-regex search method was the right call. The CONTAINS operator translates to a SQL LIKE query which is much more efficient for simple text searches like this. If you ever need REGEXP specifically, just use s3 as the pattern instead of .*s3.* It does the same thing without the backtracking issue. Last edit: 7 months 3 weeks ago by [nicolas](/forum/user/63-nicolas "View nicolas's Profile"). Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ0LW1hc3MtYWN0aW9ucy85MTAxNzItbWFzcy1hY3Rpb24tdGltaW5nLW91dD90bXBsPW1hcmtkb3du) 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.070 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)