Deleting members SQL error and wrong replies/views count

[Mr.Frank]

Good day guys, how are you today ?

I'm contacting you today because I have two problems with my platform. I would really be grateful if you could assist and make me learn, as I'm a true computer dummy.

• First, I have two errors in My SQL database and I have a hard time knowing what to do to replace the tables :

XYZ_forum.profile_portal_views
Error : Can't find file: 'profile_portal_views' (errno: 2)
status : Operation failed

XYZ_forum.topic_views
Error : Can't find file: 'topic_views' (errno: 2)
status : Operation failedI get this error when I try to delete a member :

When I click on delete in member management nothing happens. When I click on the member and then click on delete member, I get this error :

An error occured with the SQL server:
mySQL query error: DELETE FROM profile_portal_views WHERE views_member_id IN (2809)

This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above.

I contacted my host but I don't know how to replace these tables. Can you help and show me how please ?

• Second, new posts and views counts are wrong since maybe a week now. You'll imagine it's hard to find new content for my members. I tried to resync and recount but it didn't solve the problem.

Should I re-install everything ? Have you encountered similar problems before?

Thank you very much for your time and assistance guys, it's awesome to know you're there.

Enjoy your day!

Cordially,

Frank

[Mr.Frank]

Ok I got a nice reply from IP board . Now my issue is solved and I learnt a bit more on MySQL during the process.

Alan Wagstaff

01 May 2013 - 03:29 AM

Hello,

The second problem is caused by the first so once we have that fixed, the counts will correct themselves.

For the first problem, this is caused by 2 corrupt database tables, the "profile_portal_views" table and the "topic_views" table which can be fixed in a few ways.

The first is to ask your web host to run the MySQL repair tools on the tables. If that fails, then the second way is to ask your web host to drop / delete those 2 tables (ask them to take a full database backup first) and then you can re-create them in your Admin CP under Support -> Diagnostics -> Database Checker. You will only be able to recreate them after your web host has deleted them though.

These 2 tables contain some of the view counts for topics and profiles so they will be lost unfortunately (not all view counts, just some recent ones).

If you run in to any problems please let me know.

Many thanks,
Alan.

--
Alan Wagstaff
Invision Power Services, Inc

Thank you !