[SOLVED] Error 145 #__comprofiler_views is marked as crashed and should be repaired

This error message appears on every profile. Checking phpmyadmin, the table that the error message is referencing "comprofiler_views" isn't even listed...it's completely missing. The last table listed is "comprofofiler_userreports." Can you please advise me if this table can be recreated/repaired, or if I need to restore from a backup? My other issue is I don't know for how long this table has been missing, or what would have deleted it.

Thank you in advance for any assistance you can offer.

Running CB 1.91.1 on J3.6.5

_comprofiler_views should exist as it's a core table and it's where profile views are stored. It probably has too many rows. Run an empty operation on it in phpmyadmin and see if your issue persists.

Thanks for the reply. Being uncertain how to run an empty operation, I checked phpmyadmin once again, this time using the search box, and indeed the table exists...but twice (see screenshots)?! When I click on the damaged table that is listed in the error message, the same message comes up.

Any advice on how to proceed?

You've 69 thousand rows in that table. That's probably why as you've done no pruning of it. It's advised to setup a CRON task to prune the table every now and again or disable views tracking entirely within CB > Configuration > User Profile.

In phpmyadmin navigate to the table then click the Operations tab and click "Empty the table (TRUNCATE)" to empty it or empty from the table list for your database.

Many thanks for your help!