Table size article_search_object_keywords

Software Support
1

We have an old portal (version 2.2.2), which was a long time without updating and without configuration of captcha, allowing user registrations by spammers.
Analyzing the tables, I noticed that a particular table has several records (3327083 table rows) and consumes about 197MB.
Is there any way to make sure all the records in this table are real and not created by spammers?

Regards,

Renato L. Sousa

2

Hi @rensousa,

The article_search_object_keywords table contains your built-in full-text search index. It’s not a useful target for spammers. If you like, you can re-generate it by running php tools/rebuildSearchIndex.php.

Regards,
Alec Smecher
Public Knowledge Project Team