Notifications

Clear all

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

Page 2 / 2 Prev

How-to and Troubleshooting

Last Post by Chris 2 years ago

11 Posts

3 Users

1 Reactions

2,419 Views

RSS

Posts: 2611

dimalifragis

Topic starter

Apr 27, 2023 2:56 pm

(@dimalifragis)

Famed Member

Joined: 5 years ago

Hi,

When this will be fixed? Still in 2.0.7.

Thanks

1 Reply

Chris

(@chris)

Joined: 3 years ago

Famed Member

Posts: 3627

Apr 28, 2023 1:26 pm

Reply to

dimalifragis

@dimalifragis,

What type of DB server do you have, MySQL or MariaDB, and what's the version that are you using?

Also, can you update the DB server to the latest version and check if the issue still persists?

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.

Posts: 2611

dimalifragis

Topic starter

Apr 28, 2023 1:39 pm

(@dimalifragis)

Famed Member

Joined: 5 years ago

I have

MySQL Version 10.6.12-MariaDB-log of 6 Feb 2023.

Updates are handled by Cloudlinux and there is no need to update anything.

And you mean you can't replicate it?

Posts: 2611

dimalifragis

Topic starter

Apr 28, 2023 1:45 pm

(@dimalifragis)

Famed Member

Joined: 5 years ago

Does that help:

[27-Apr-2023 14:52:02 UTC] WordPress database error Regex error 'missing closing parenthesis at offset 25' for query SELECT `topicid` FROM wp_wpforo_topics WHERE `title` REGEXP "MyCustomThemes|theme|(207" 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

The topic had a title:

MyCustomThemes theme (207)

Let's if i can replicate it here (if you have debug enabled).

1 Reply

Chris

(@chris)

Joined: 3 years ago

Famed Member

Posts: 3627

Apr 28, 2023 1:58 pm

Reply to

dimalifragis

@dimalifragis,

Thanks for the info, the issue would be fixed in the new version.

In case you want to say thank you !)
We'd really appreciate and be thankful if you leave a good review on plugin page. This is the best way to say thank you to this project and support team.