Notifications
Clear all

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

11 Posts
3 Users
1 Likes
1,798 Views
dimalifragis
Posts: 2577
Topic starter
(@dimalifragis)
Famed Member
Joined: 4 years ago

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: 2577
Topic starter
(@dimalifragis)
Famed Member
Joined: 4 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: 2577
Topic starter
(@dimalifragis)
Famed Member
Joined: 4 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: 2577
Topic starter
(@dimalifragis)
Famed Member
Joined: 4 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: 2577
Topic starter
(@dimalifragis)
Famed Member
Joined: 4 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: 8 years ago

Support Team
Posts: 10503

Hi @dimalifragis,

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

Page 1 / 2