AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Closed] WordPress database error Regex error 'missing closing parenthesis

11 Posts
3 Users
1 Reactions
4,212 Views
dimalifragis
Posts: 2600
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@dimalifragis)
Famed Member
Joined: 6 years ago
[#34004]

Any ideas what than can be?

WP 6.11, PHP 8.0x & wpForo latest

 

[06-Feb-2023 18:14:44 UTC] WordPress database error Regex error 'missing closing parenthesis at offset 67' for query SELECT `topicid` FROM wp_wpforo_topics WHERE `title` REGEXP "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" made by do_action('wp_ajax_wpforo_search_existed_topics'), WP_Hook->do_action, WP_Hook->apply_filters, wpforo\classes\Actions->search_existed_topics, wpforo\classes\Topics->search


10 Replies
dimalifragis
Posts: 2600
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@dimalifragis)
Famed Member
Joined: 6 years ago

Did my test (i deleted the topic) triggered any error?

It seems it happens when a new topic title is searched for suggestions.

For example:

AAAAAAA BBBBB KK English CCCCC ZZZ DDDDDDD 1.1.1 (NNNNNNNNNNNNN release)


dimalifragis
Posts: 2600
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@dimalifragis)
Famed Member
Joined: 6 years ago

Here is a full debug log, again today

[08-Feb-2023 14:36:04 UTC] WordPress database error Regex error 'missing closing parenthesis at offset 11' for query SELECT `topicid` FROM wp_wpforo_topics WHERE `title` REGEXP "Nice|(live>" made by do_action('wp_ajax_wpforo_search_existed_topics'), WP_Hook->do_action, WP_Hook->apply_filters, wpforo\classes\Actions->search_existed_topics, wpforo\classes\Topics->search

[08-Feb-2023 14:36:03 UTC] WordPress database error Regex error 'missing closing parenthesis at offset 10' for query SELECT `topicid` FROM wp_wpforo_topics WHERE `title` REGEXP "Nice|(live" made by do_action('wp_ajax_wpforo_search_existed_topics'), WP_Hook->do_action, WP_Hook->apply_filters, wpforo\classes\Actions->search_existed_topics, wpforo\classes\Topics->search

[08-Feb-2023 14:36:03 UTC] WordPress database error Regex error 'missing closing parenthesis at offset 8' for query SELECT `topicid` FROM wp_wpforo_topics WHERE `title` REGEXP "Nice|(li" made by do_action('wp_ajax_wpforo_search_existed_topics'), WP_Hook->do_action, WP_Hook->apply_filters, wpforo\classes\Actions->search_existed_topics, wpforo\classes\Topics->search


dimalifragis
Posts: 2600
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@dimalifragis)
Famed Member
Joined: 6 years ago

Example of topic title triggering the above starts with:

Nice (live?) xxxxxxxxxxxxxxxxxxxxxx

I would guess something is wrong with parenthesis, since both topics contained some "(xxxxx)"

 

 


dimalifragis
Posts: 2600
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@dimalifragis)
Famed Member
Joined: 6 years ago

I can replicate this. Just start a Topic and write the title with

"Nice (live?) something something"

Paste the title doesn't trigger this, TYPING it letter by letter does that.

I hope i helped.


1 Reply
Robert
Admin
(@robert)
Joined: 3 months ago

Support Team
Posts: 10747
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian

Hi @dimalifragis,

Thank you for the details. I added this in the issue list.


Page 1 / 2
Share: