Log in

View Full Version : pm errors ! no one can read their pms..


corsacrazy
03-17-2005, 08:19 AM
on private .php


Database error in vBulletin 3.0.0:
Invalid SQL:
SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=1 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50

mysql error: Got error 28 from table handler
mysql error number: 1030
Date: Thursday 17th of March 2005 05:17:55 AM
Script: forums/private.php?
Referer: forums/private.php?do=editfolders
Username: corsacrazy

Revan
03-17-2005, 08:20 AM
I would suggest running the Repair in ACP.
If that doesn't solve it, then UR SCR00-D ;) Nah seriously now, then I have no idea.

corsacrazy
03-17-2005, 08:30 AM
my repair script seems to just do all kinds of things which results in errors elsewhere its seriously messed up since i moved server etc.

Marco van Herwaarden
03-17-2005, 09:16 AM
Looks like you have serious database problems. I hope you still have good backup.

I suggest asking this question at vbulletin.com (maybe even support ticket).

corsacrazy
03-17-2005, 09:23 AM
Looks like you have serious database problems. I hope you still have good backup.

I suggest asking this question at vbulletin.com (maybe even support ticket).
yes i will do. and i dont have a recent back up !!! last decent one was beggining of feb server move was mid feb then all backups from then till now are probally corrupt

Revan
03-17-2005, 03:41 PM
Well if it turns out to be SQL problems too advanced to fix, would you rather restart your forum, or revert it to beginning of February? ;)