Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 17 Mar 2005, 09:19
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
pm errors ! no one can read their pms..

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
Reply With Quote
  #2  
Old 17 Mar 2005, 09:20
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Real name: Fillip
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.
Reply With Quote
  #3  
Old 17 Mar 2005, 09:30
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
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.
Reply With Quote
  #4  
Old 17 Mar 2005, 10:16
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
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).
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
  #5  
Old 17 Mar 2005, 10:23
corsacrazy's Avatar
corsacrazy corsacrazy is offline
 
Join Date: May 2002
Real name: wayne
Originally Posted by MarcoH64
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
Reply With Quote
  #6  
Old 17 Mar 2005, 16:41
Revan's Avatar
Revan Revan is offline
 
Join Date: Jan 2004
Real name: Fillip
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?
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Release 0.1 Mark Forum Read/Mark All Read from database hack ethank vBulletin 2.x Full Releases 73 31 Jan 2002 22:42



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 02:14.

Layout Options | Width: Wide Color: