database corruption...any tools?

I'm now 100% convinced that we have database corruption.
For a month now we've seen ordinary posts suddenly become calendar events (yes, it just seems to happen at random!)
And now all announcements are GONE.
I'm the one and only person who ever does any announcements, ever. I'm the only one with admin credentials and who knows the id and password and today I noticed that an announcement I'd made - which I created as an announcement all forums was gone, as were all other announcements!
WOW!
They just as of today are GONE.
Actually it might have happened a day or two ago since we lost Internet connection due to ice and snow so for the weekend getting Internet at all was hit and miss. But today I'm thinking, gee, something looks different - and sure enough - no announcements.
And there's another post that has suddenly become a calendar event even though it was NOT an event when it was posted, and it wasn't edited until I edited it today to make it a NON-event post.
Since if anyone edits a post it's put in the post that it was edited, when and by who - I can tell this is happening by magic and it really scares me.
At first I thought that when for the last couple of months when folks asked me "hey, where's my post, why did you delete it" they had simply lost track of it, now I'm believing them - they simply disappear!

Have we been hacked? (we're hosted here..........)

I guess I'm wondering - is there any tool available to check the integrity of the SQL database?????
Backups are fine and dandy, but we get so many posts that by the time we discover thigns are missing, a restore would be worse than the lost posts!

Logging is enabled - so that's a tool that can be used I guess. I enabled it months ago when we had issues with a user removing posts he'd made then claiming he'd never done any such thing.......
It's enabled for all so I'd have to do some real digging.
I can count out bad or rogue moderators being added as i've not even been to that section in the admininstration area in many months. It's a "these are the moderators and that's it" deal. Once it was setup, we agreed that was it.

I've also documented the modifications to the forum - the only 'mods' are in appearance - CSS files, colors, table backgrounds, etc. or the addition of the links near the top of the page and the breadcrumbs near the bottom of the page. I've documented all of this in preparation for an upgrade - as we all like the latest improvements and additions... so I've recently compared our files to the original install files, and very little was actually changed, and those changes are now in writing. Formatting and layout only.
I documented what was changed so when we upgrade (I'll open a ticket on that!) it will be easy for me to put the colors back, to links and donation button near the top, the breadcrumbs and re-add the smilies I put in.
We did use the "mobile "mod"" for a while, but that's exactly when the calendar events went screwy, so I killed that quickly.  I deemed it too risky..........

Of the 5 of us moderators, only 3 of us are even brave enough to do more than "talk about posts" - 2 for sure are so scared of messing up, they won't even move posts..........they tell me to do it!
So that leaves me and 2 others. I trust all of the moderators beyond how most folks trust a brother or wife. If anything ever happened, it would be pure accident. And most don't bother with actual actions, they simply chew on people and tell 'em to shape up or leave. Those that don't are suspended.
I'm the only one with the keys to the admin account. And I login only on rare occasions to resynch the posts, etc. - otherwise I don't even login as admin very often. Just too risky. Never use the admin account for daily use!

I think it's time to prepare for an upgrade......... and to be safe AFTER the upgrade, I'll change the administrator password.

>>change to a calendar event, change announcement status, etc. and because the post itself is not edited it dose not place an 'edited by' within the post.<<

Hmmmmmm, I'd not thought of that.................  LOL - thanks. Will look into that as a possibility.

Ah, forgot about Frank and Scott - they moderate a couple small sections, but have no moderator rights outside of the lost dealership project and perhaps another.
Tom has rights to one section but he can't figure out how to post most of the time, so might as well remove him as a moderator and just make him a "super user" in that section.
But none of them have any rights beyond normal membership for the forum in general - they are moderators to specific sections they are sort of in charge of -

I'll go in an "turn off" logging except moderators since the little problem earlier is since gone..... he forced us to suspend him.

Hi Bill,

I'm with Bruce on this one, I suspect you have some permissions that don't make sense and are there by mistake (yours LOL).

Concerning Calendar events, I have had a look at your forums and can confirm the following.

You have Calendar Permissions for ALL user groups enabled in the following Sections:

Drag Racing
Autocross, Circle Track
Jeeps and 4X4
Charity Projects

And understandably:

Upcoming Shows & Events (and the Sub Forum)
AMO
NAMDRA
AMCRC

^^Those 4^^, obviously they are relevant to Events / Meets etc

But the top 4..?

That's a lot of forum sections to have the calendar enabled for and I was a little surprised to see that a forum n00b with zero posts has been given permissions to create a calendar thread.

I was not able to test your Trade Sections.

Calendar threads do NOT need an end date (just to tie up one of your points).

Moderators - They can edit threads made by the Admin Group. A thread made by Admin in a section a Mod can view, can be edited by a Mod.

I think your forum permissions are a little bit muddled up and need reviewing ASAP.

I've seen all of what you are describing before LOL.. It is user error (and most likely friendly mistakes by yaself and the Staff Team). This is nothing unfriendly or untoward.

I also own and run a Car Forum, we've been going since 2002 now and are pretty big. I've also been administrating WWF forums since the very early days as well, so I'm very well versed etc.

If you need a hand sorting out or reviewing these probs you have at the moment, please feel free to throw me a PM fella.

Many thanks and take care,
Shaun