The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
||||
|
||||
HELP my PM's Quit Working
Database error in vBulletin 3.6.7:
Invalid SQL: SELECT pm.*, pmtext.* , icon.title AS icontitle, icon.iconpath FROM vbpm AS pm LEFT JOIN vbpmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid) LEFT JOIN vbicon 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 : Can't create/write to file '/tmp/#sql_dff_0.MYI' (Errcode: 30) Error Number : 1 Date : Tuesday, June 19th 2007 @ 12:22:08 AM Script : http://www.dieselbombers.com/private.php Referrer : http://www.dieselbombers.com/index.php IP Address : Username : DieselMinded Classname : vb_database Now My Sites Down Database error in vBulletin 3.6.7: Invalid SQL: SELECT post.postid, post.pagetext, post.userid, post.username, post.visible, thread.forumid, thread.title as thread_title, thread.threadid, forum.forumid, forum.title as forum_title FROM vbpost as post LEFT JOIN vbthread as thread on (post.threadid = thread.threadid) LEFT JOIN vbforum as forum on (thread.forumid = forum.forumid) WHERE forum.forumid not in (23,116,118,99,98,6,37,97,117,132,171) AND post.visible = 1 ORDER BY postid DESC LIMIT 7; MySQL Error : Got error 127 from storage engine Error Number : 1030 Date : Tuesday, June 19th 2007 @ 12:27:26 AM Script : http://www.dieselbombers.com/ Referrer : IP Address : Username : DieselMinded Classname : vb_database What Do I DO???? |
#2
|
||||
|
||||
Sounds like you have some corrupted database tables. Try repairing them or ask your host to. You do have a backup right?
|
#3
|
||||
|
||||
yes i have a back up ITs backed up everynight by the host and i have a hard copy from about a week ago
This is on the Server End? The Pms quit working , so i went in and repaired and optimized tables and fixed unique indexs then Bam the whole board went down . Am I Hosed Here?? DM |
#4
|
||||
|
||||
I would contact your host.
|
#5
|
||||
|
||||
I did and they fixed it I had to repair and optimize 3 times before all the baddies went away
vbpost Check Warning: Table is marked as crashed and last repair failed vbpost Check Warning: Size of datafile is: 8711068 Should be: 8710664 vbpost Check Error: Keypointers and record positions doesn't match vbpost Check Warning: Found 31653 parts Should be: 31628 parts vbpost Check Error: Corrupt Now there all OK WHEW man i hate it when my sites down How can i prevent it ? |
#6
|
|||
|
|||
Were you modifying something or developing an add-on at the time when your database corrupted - if so, what was this program attempting to do?
You've posted your question in the programming discussions area, so I was wondering what the programming angle was? |
#7
|
||||
|
||||
I was flipping out I think i posted a thread on a McDonalds Forum too
lol No I wasnt doing anything , First the Pms quit working then all hell broke loose DM |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|