Announcement

Collapse
No announcement yet.

Error 1030 - question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Error 1030 - question

    To anyone who reads this, I've been getting this several times in the last couple of months. Last time, the board seemingly resolved itself but started with the error again. This disabled PM functions, CMPS (from vbulletin.org or something), and the ability to shut off the board. If I update tonight (as I've downloaded the 3.6.7L1 software), will this alleviate the issue? My tech guys say that the original problem, which Steve linked me to, wasn't the issue. Would I even be able to upgrade the board at all? Help!

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

    Comment


    • #3
      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.

      Comment


      • #4
        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.

        Comment


        • #5
          I'm running 3.6.1.

          I do not know what the hook system is.

          Comment


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

            Comment


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

              www.texasracingscene.com

              Comment


              • #8
                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 :

                Comment


                • #9
                  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

                  Comment


                  • #10
                    Ok, brb with the next set of error messages.

                    Comment


                    • #11
                      Ummm... that's already set properly.

                      Comment


                      • #12
                        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.

                        Comment


                        • #13
                          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.

                          Comment


                          • #14
                            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

                            Comment


                            • #15
                              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

                              Comment

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