Announcement

Collapse
No announcement yet.

Error 1030 - question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts
    Floris
    Senior Member

  • Floris
    replied
    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.

    Leave a comment:

  • Los
    Senior Member

  • Los
    replied
    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

    Leave a comment:

  • Los
    Senior Member

  • Los
    replied
    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

    Leave a comment:

  • Floris
    Senior Member

  • Floris
    replied
    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.

    Leave a comment:

  • Los
    Senior Member

  • Los
    replied
    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.

    Leave a comment:

  • Los
    Senior Member

  • Los
    replied
    Ummm... that's already set properly.

    Leave a comment:

  • Los
    Senior Member

  • Los
    replied
    Ok, brb with the next set of error messages.

    Leave a comment:

  • Floris
    Senior Member

  • Floris
    replied
    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

    Leave a comment:

  • Floris
    Senior Member

  • Floris
    replied
    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 :

    Leave a comment:

  • Los
    Senior Member

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

    www.texasracingscene.com

    Leave a comment:

  • Floris
    Senior Member

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

    Leave a comment:

  • Los
    Senior Member

  • Los
    replied
    I'm running 3.6.1.

    I do not know what the hook system is.

    Leave a comment:

  • Floris
    Senior Member

  • Floris
    replied
    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.

    Leave a comment:

  • Los
    Senior Member

  • Los
    replied
    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.

    Leave a comment:

  • Los
    Senior Member

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

    Leave a comment:

widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X