Need some help!

[t()mbst()ne]

I just noticed i lost another 500 posts from my forums! this happend once before about 2 days ago, thought maybe a mod deleted a few threads etc but its happend just now again :( I only got 1 error before this happend and it was something about Style ID not found or something... i lost the email :o I have no idea what is making this happen but is there anything i should be looking at for posts and threads to just go missing?

[Steve Machol]

How do you know for sure they are missing?

[t()mbst()ne]

How do you know for sure they are missing?
Well two ways i noticed to start with, the counter on the main forum home was around 7000 posts, its now 5282. Then one main forum was at 3000 posts in it, its now 2598 posts? others have told me every now an again its seems to go down and i know no mods have deleted the posts them selves... i am checking that are web host hasent limited us on the SQL database size, witch its around 20MB for the forum right now, though we do have 3 other SQL databases...

[Steve Machol]

Something strange is happening then. There is no mechanism in vB that would automatically prune posts like this. How do you know one of your Mods isn't doing this? Can you recall anything about the error messqge you received?

[t()mbst()ne]

Something strange is happening then. There is no mechanism in vB that would automatically prune posts like this. How do you know one of your Mods isn't doing this? Can you recall anything about the error messqge you received?

I just got this error:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: USE gamers
mysql error: Access denied for user: 'gamers@localhost' to database 'gamers'

mysql error number: 1044

Date: Tuesday 06th of May 2003 06:04:15 PM
Script: http://www.gamersonline.net.nz/forum/forum/admin/repair.php?check=1&iterations=4&forum=gamers
Referer:

How can i fix this ?

[Steve Machol]

This error means either:

1. One or more of the following is wrong in your config.php file:

$dbusername
$dbpassword
$dbname

If you are unsure of what the appropriate values are then you will need to ask your web host.

2. Or that this db user is not assigned to that database or does not have permission to access MySQL. Since each web host is different, if you do not know how to do this then contact your web host for help.

[t()mbst()ne]

This error means either:

1. One or more of the following is wrong in your config.php file:

$dbusername
$dbpassword
$dbname

If you are unsure of what the appropriate values are then you will need to ask your web host.

2. Or that this db user is not assigned to that database or does not have permission to access MySQL. Since each web host is different, if you do not know how to do this then contact your web host for help.
Hmm i got it working but it brings this error up on the tables after runing the repair.php:

Checking table session
Table Operation Type Text
gamers_gamers.session check error The handler for the table doesn't support check
Repairing table session
gamers_gamers.session repair error The handler for the table doesn't support repair
Checking table session
Table Operation Type Text
gamers_gamers.session check error The handler for the table doesn't support check
Repairing table session
gamers_gamers.session repair error The handler for the table doesn't support repair
Checking table session
Table Operation Type Text
gamers_gamers.session check error The handler for the table doesn't support check
Repairing table session
gamers_gamers.session repair error The handler for the table doesn't support repair
Checking table session
Table Operation Type Text
gamers_gamers.session check error The handler for the table doesn't support check
Repairing table session
gamers_gamers.session repair error The handler for the table doesn't support repair


Any ideas?

[Steve Machol]

The session table is HEAP and doesn't support repair. That's nothing to be concerned about.

[t()mbst()ne]

I think its fixed now after runing that repair file.. as i havent got anymore database error emails, thanks for j00r help. :)