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,211 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

Hi,

When this will be fixed? Still in 2.0.7.

Thanks


1 Reply
Chris
(@chris)
Joined: 5 years ago

Famed Member
Posts: 3610
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,

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?


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 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?


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

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: 5 years ago

Famed Member
Posts: 3610
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,

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


Page 2 / 2
Share: