WordPress database error when searching for product URL
š Holiday Notice - Support Vacation š
ATTENTION: From December 28, 2025 to January 6, 2026 our support team will be on vacation.
Important information:
- ā No ticket responses from December 28 to January 6
- ā Support will resume on January 7, 2026
- š You can still submit tickets during vacation - they will be queued and answered starting January 7
- ā ļø Urgent technical issues: Please check our documentation and codex first
š Season's Greetings! š
We want to thank all our amazing customers for your trust and support throughout 2025!
Merry Christmas and Happy New Year to you and your families! š
We wish you:
- š Successful online stores
- š° Growing sales
- š Happy customers
- šÆ Achieved goals in 2026
Thank you for being with us! We appreciate every one of you and look forward to continuing our work together in the new year.
Rest, recharge, and see you in 2026!
Best regards,
PluginUs.Net Team
If you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
When searching for any keyword in the product URL field, I get the following database error:
WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY wp_posts.post_title DESC
LIMIT 0, 10' at line 5 for query
SELECT SQL_CALC_FOUND_ROWS wp_posts.ID
FROM wp_posts LEFT JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type)
WHERE 1=1 AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private')) AND ( ( ( wpml_translations.language_code = 'nl' OR 0 ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','product','product_variation','ckit_size_guide' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','product','product_variation','ckit_size_guide' ) ) AND ( )
ORDER BY wp_posts.post_title DESC
LIMIT 0, 10
made by do_action('wp_ajax_woobe_get_products'), WP_Hook->do_action, WP_Hook->apply_filters, WOOBE->woobe_get_products, WOOBE_PRODUCTS->gets, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
Hello
what plugin version number are you using?
Hi Pablo,
I'm using V 2.1.1
Hello
Please paste your license key here - https://share.pluginus.net/image/i20210618130558.png -> https://share.pluginus.net/image/i20210618130614.png andĀ wp-admin+FTP access - https://share.pluginus.net/image/i20210618130637.png
UpdateĀ theĀ pluginĀ to latestĀ version - https://bulk-editor.com/how-to-make-auto-update-for-wordpress-plugins-and-themes-bought-on-envato
Hi Pablo,
I updated the plugin and provided the requested details.
Hello
IĀ checked yourĀ site.
you don't have any Extern/AffiliateĀ product, it means that this fieldĀ - https://share.pluginus.net/image/i20221115093427.png - for all products is empty and even in this case filtering does not make errors - https://share.pluginus.net/video/v20221115094014.mp4
Hey Pablo,
I know, I realized later that I should search on slug instad of URL. But still, the error was weird. It's also weird how the error is now gone, because it still happened yesterday after updating the plugin and deleting all cache. Anyway, I suppose this is solved regardless. Thank you!
Hello
OK! If the error occurs again please write to me.
Welcome;)