Comprofiler data deleted

I have an interesting issue on a test site. J2.5.16 CB1.9.1 CBS3.0.0

One of my test Admin users (currently with Super User permissions) reported:

"I was testing front and back end access today with the 'Maria' log in and successfully accessing member records, making payments, setting password etc.

However, using the same log in, it is now saying "TEST3 Society of Australian Genealogists has 0 registered users" when I try to search in the front end, even though I can see their records in the back end.

These records in the back end however, have lost the data from the "Private" and "admin" tabs - ie all of the contact and membership details."

My investigation reveals:

1. The comprofiler table is now empty save for the above user's record (see attached screen shot) - other tables that I have checked appear fine
2. The CB User Mgt tab shows all the users but as Unconfirmed and Pending Approval - and when viewing their profiles, all the CB fields are empty, and the user shows as Confirmed and Approved
3. I cannot login to the front end of the site - presumably related to the CB Login process dependence on my having a CB user profile
4. Checking the CBSubs History Logs shows that the test user above expired a large number of users yesterday (she was not aware of doing so) - and the Error Log suggests error notices have been reported yesterday and before yesterday - see three attached screen shots)
5. Running the last three CB Tools (screen shots attached) identifies one or more DB problems, including with the status type of a CBS field being varchar rather than char
6. To build membership mgt reports I had relatively recently being using Fabrik on this test site which does have the capacity to change field data types so this has to be one possible culprit (me that is, rather than Fabrik).

I am thinking I need to restore the site to my last backup, and may well have done that before you reply to this, but I would be interested in any further information/thoughts you can offer. (I will probably use the Fix option on the CB Tools first, but am not expecting any miracle restore of the missing data. Also I suspect that simply trying to restore the comprofiler table would not be wise as the restored table would not be in sync with other site data.)

Have restored the database only and seems to have restored functionality.

Still looking at the CBS history log shows some error notices with this:

"NOTICE: Undefined index: view in /home/sagorg/public_html/test3/components/com_content/router.php on line 48"

Would be particularly interested in what you think this means and what I should do about it.

CB doesn't use view, it uses task. In CB 2.0 CB can use both. Regarding that notice it's coming from Joomlas content router and not CBs. I believe it usually happens when you have a SEF link to a Joomla content article that has no Itemid. Only fix is to ensure every Joomla section/category has a Joomla menu link to ensure they'll all have an Itemid or append live site to the URL directly like CB Blogs and CB Articles does to avoid the issue (note only Content Author plugin will have this issue, use CB Articles).

Thanks, have unpublished CB Author.

I knew I shouldn't have added another comment to my original post. Can you go back to my first post in this thread and give your thoughts on what my test user might have done to delete the comprofiler data and what I can do to prevent it happening in the future?

The only way a user could delete their profile data is if they used the Delete Me field provided by CB Privacy. Aside from that I've no idea how the user deleted themselves.

Just to clarify, this was an admin user with super user privileges, but without access to control panel or database. And the whole comprofiler table (some 14000 records) was deleted except for their record. We do not have CB Privacy installed.