Error message generated by searches

[groznak]

We have been getting that same error since December 18, 2018.

It is the only error we have in our error log since that time.

[thecoalman]

Open phpmyadmin in your hosting control panel. Open the database where phpBB is if it isn't already open, all the tables should be listed in the right pane. Click the search tab and search for %wmv%, down the bottom make sure that all tables are selected.

You should get a results page listing all the tables and how many matches in each one. The bbcode table should 0 have results. The posts table may have some. Whatever the case you can copy the positive results here.

[groznak]

You should get a results page listing all the tables and how many matches in each one. The bbcode table should 0 have results. The posts table may have some. Whatever the case you can copy the positive results here.

Thanks.

The bbcodes table had zero results.

1. 2 matches in phpbb3_attachments
2. 120 matches in phpbb3_log (these are the error messages since 2018)
3. 203 matches in phpbb3_posts
4. 16 matches in phpbb3_search_wordlist

[thecoalman]

The usual advice applies, make a backup of your database first.

Go into the ACP main page and under search settings link on left disable search.

Go to the maintenance tab and under the search index page delete the search index.

Reparse the posts using CLI. https://www.phpbb.com/support/docs/en/3 ... -reparser/

Enable search and then go to search index page and reindex the posts.

That's the sledgehammer approach and the route I would take.

................................

You can also try opening the posts table and search for [/wmv]. Presumably there won't be many results. Using the post ID from the results you can find the post on the forum. Either remove it or edit it, just to be clear you are removing or editing on live forum. Don't delete directly from database.

If issue persists delete the search index and rebuild it.

[groznak]

Thanks.

I'll discus it with the rest of the admins and see how it works.