Error 1030 - question

[Floris]

Same as before
These are MySQL errors that your host have to look into.

You have had bad corruption and the database has crashed. A root user on the host level has to restore a backup, or fix this problem.

[Los]

Database error in vBulletin 3.6.1:
Invalid SQL:
SELECT thread.pollid, open, threadid, replycount, forumid, question, poll.dateline, options, votes, active, numberoptions, timeout, multiple, voters, public , voteoption
FROM vb3_poll AS poll
INNER JOIN vb3_thread AS thread USING (pollid)
LEFT JOIN vb3_pollvote AS pollvote ON (pollvote.pollid = poll.pollid AND pollvote.userid = 1)
WHERE open <> 10 AND visible = 1 AND active = 1
AND thread.postuserid NOT IN(2508,2503,2507,2504,2526,2527)

AND thread.forumid IN(3)

ORDER BY poll.dateline DESC;
MySQL Error : Got error 28 from table handler
Error Number : 1030
Date : Wednesday, June 6th 2007 @ 04:07:38 PM
Script : http://www.texasracingscene.com/cmps_index.php
Referrer :
IP Address : 68.253.41.18
Username : Los
Classname : vb_database

[Los]

Update:

Database error in vBulletin 3.6.1:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost, thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires

FROM vb3_thread AS thread
LEFT JOIN vb3_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vb3_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

LEFT JOIN vb3_post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN vb3_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

WHERE thread.threadid IN (0,41532,45179,45166,45160,44994,45090,45143,45138,45033,44894,45071,45034,133,44918,44890 ,44771,44066,44942,44695,44895,44930,44346,41629,44620,44802,45106)
ORDER BY sticky DESC, lastpost DESC;
MySQL Error : Can't open file: 'vb3_post.MYI'. (errno: 144)
Error Number : 1016
Date : Wednesday, June 6th 2007 @ 03:12:18 PM
Script : http://www.texasracingscene.com/forumdisplay.php?f=6
Referrer : http://www.texasracingscene.com/
IP Address : 68.253.41.18
Username : Los
Classname : vb_database

[Floris]

The issues vBulletin report back are probably due to this corruption. Contact your hosting provider who gives you this service and have them run optimize and repair from their root account.

[Los]

I do have the error messages when I attempted to repair/optimize tables to fix the error 1016 issue.

vb3_attachment
Check
Warning: Table is marked as crashed and last repair failed
vb3_attachment
Check
Warning: Size of indexfile is: 284672 Should be: 16384
vb3_attachment
Check
Error: Found 124 keys of 123
vb3_attachment
Check
Error: Corrupt
vb3_attachment


vb3_pmtext
Check
Warning: Table is marked as crashed and last repair failed
vb3_pmtext
Check
Warning: Size of indexfile is: 1180672 Should be: 573440
vb3_pmtext
Check
Error: Found 23466 keys of 23465
vb3_pmtext
Check
Error: Corrupt
vb3_pmtext


vb3_post
Check
Warning: Table is marked as crashed and last repair failed
vb3_post
Check
Warning: Size of indexfile is: 22650880 Should be: 2356224
vb3_post
Check
Error: Found 53042 keys of 53041
vb3_post
Check
Error: Corrupt
vb3_post


Then the board just had a catastrophic meltdown heard all over Texas.

[Los]

Ummm... that's already set properly.

[Los]

Ok, brb with the next set of error messages.

[Floris]

MySQL Error: Too Many Connections
The server has maxed out the number of MySQL connections it allows. You can try turning persistent connections off by adding this to your config.php:

$config['MasterServer']['usepconnect'] = 0;

But if you still have problems after that, you will need ask your host to raise the maximum number of connections they allow.

Here is more info on that error: http://dev.mysql.com/doc/refman/5.0/...nnections.html

[Floris]

Database error in vBulletin :

mysql_connect(): Too many connections
E:\wwwroot\texasracingscene.com\TRS\includes\class_core.php on line 271

MySQL Error :
Error Number :

[Los]

I get the error message on the website but right now... its just shut down completely.

www.texasracingscene.com

[Floris]

When you get the error, does it get emailed to you or do you see it in the browser?

[Los]

I'm running 3.6.1.

I do not know what the hook system is.

[Floris]

We will need to know which version you are now running, if you get the same problem with the hook system turned off,, and what the full mysql error is. just the number won't provide enough info.

[Los]

lastly, reading up on some ideas on what to do, I went ahead and did some repair/optimizing and suddenly the entire board shuts down. The main forum is up but no one can post or view threads. Tables in the database are empty with a 1.0 kb for index length and 0 for overhead.

I think I broke my board.

[Los]

Also, people can reply to threads but cannot post. I get a 1016 error as well. What the hell is going on!?