Pm Error - Urgent Help Needed!

[WFZ]

Hello,

When I try and access my PM's area, or try to send a PM, I keep recieving this Database error:

Please help!

Database error in vBulletin 3.7.0 Release Candidate 1:

Invalid SQL:

SELECT COUNT(*) AS total, folderid
FROM pm AS pm
WHERE userid = 1
GROUP BY folderid;

MySQL Error : Table './wfzdatabase/pm' is marked as crashed and should be repaired
Error Number : 145
Date : Sunday, March 23rd 2008 @ 05:37:50 PM
Script : http://www.wrestling-forums.net/private.php
Referrer : http://www.wrestling-forums.net/index.php
IP Address : 86.149.81.175
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.15

[mystic10]

IT MOST PROBABLY A HACK U HAVE RECENTLY INSTALLED....I HAD THIS ERROR A WHILE BACK...MY HACK WAS CYB PM...I UNINSTALLED IT AND REINSTALLED IT AND IT WORKED...

IF U 100% BELIEVE ITS NOT BC OF A HACK THAN THE BEST U DO TO DOUBLE CHECK UR THEORY IS..
disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

This will disable all hooks and allow you to log in properly with no hooks running.

THAN GO BACK AND SEE IF U STILL HAVE PM PROBLEM IF U STILL HAVE IT THAN OPEN A TICKET WITH VB AND IF U DONT HAVE IT THAN GO BACK AND ONE BYE ONE DISABLE UR HACK AND SEE WHICH ONE IS GIVING PROBLEM

HOPE THIS HELPS WISH U BEST OF LUCK

[WFZ]

Ok thanks, I will try this out.

--------------- Added [DATE]1206295450[/DATE] at [TIME]1206295450[/TIME] ---------------

Worked like a charm! Thanks!

[Lynne]

You may want to go to Maintenance and Repair/Optimize the PM table. That will usually fix things when a table is crashed.

[Opserty]

MySQL Error : Table './wfzdatabase/pm' is marked as crashed and should be repaired

Reading the error message is also helpful. Even though your problem seems to no longer persist I recommend you repair the pm table anyway, as you may have problems later on down the line.

AdminCP > Maintenance > Repair / Optimize Tables

Also documented in the vBulletin Manual: Repair / Optimize Tables

[WFZ]

Thanks.

[Opserty]

Ah dang, thats the second time Lynne has beaten me today!

[Lynne]

Originally Posted by Opserty

Ah dang, thats the second time Lynne has beaten me today!

hehe