PDA

View Full Version : Pm Error - Urgent Help Needed!

WFZ
03-23-2008, 04:39 PM
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
03-23-2008, 04:54 PM
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
03-23-2008, 05:01 PM
Ok thanks, I will try this out.

--------------- Added 1206295450 at 1206295450 ---------------

Worked like a charm! Thanks!
Lynne
03-23-2008, 05:17 PM
You may want to go to Maintenance and Repair/Optimize the PM table. That will usually fix things when a table is crashed.
Opserty
03-23-2008, 05:17 PM
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 (http://www.vbulletin.com/docs/html/maintenance_repair_tables)
WFZ
03-23-2008, 05:38 PM
Thanks.
Opserty
03-23-2008, 05:44 PM
Ah dang, thats the second time Lynne has beaten me today! :D
Lynne
03-23-2008, 06:10 PM
Ah dang, thats the second time Lynne has beaten me today! :D
hehe :D