Errors 1203, 1030, and 1016

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Don Maddox
    Senior Member
    • Aug 2002
    • 152
    • 3.6.x

    Errors 1203, 1030, and 1016

    I've never had any errors with my forum until today when all of the sudden I received about 20 error e-mails from the forum. Here is a bit of information:

    1. http://www.warfarehq.com/forums/index.php
    2. PHP version: 4.1.2
    3. MySQL Client API version: 3.23.39
    4. Apache/1.3.26 (Unix) FrontPage/5.0.2.25102001 i686 unknown
    5. Hacks?: NO

    Here are the errors I received:

    Database error in vBulletin :

    Link-ID == false, connect failed
    mysql error: User warfarehq@localhost has already more than 'max_user_connections' active connections

    mysql error number: 1203

    Date: Wednesday 04th of September 2002 12:52:47 PM
    Script: /forums/index.php
    Referer:
    Also this one.

    Database error in vBulletin 2.2.6:

    Invalid SQL: INSERT IGNORE INTO word (wordid,title) VALUES (NULL,'sequences'),(NULL,'elem'),(NULL,'klimov'),(NULL,'fled'),(NULL,'remembers'),(NULL,'v olga'),(NULL,'hooks'),(NULL,'einsatzgruppen'),(NULL,'unwatchable'),(NULL,'punches'),(NULL, 'subjective'),(NULL,'muffled'),(NULL,'audible'),(NULL,'ringing'),(NULL,'deafened'),(NULL,' imperceptibly'),(NULL,'kino'),(NULL,'revamped'),(NULL,'2disc'),(NULL,'recommened'),(NULL,' unjustly'),(NULL,'bible'),(NULL,'revelation'),(NULL,'divine'),(NULL,'chap'),(NULL,'verse') ,(NULL,'thunder'),(NULL,'see.')
    mysql error: Got error 28 from table handler

    mysql error number: 1030

    Date: Wednesday 04th of September 2002 12:52:48 PM
    Script: http://www.warfarehq.com/forums/forums/newreply.php
    Referer: http://www.warfarehq.com/forums/newr...ly&postid=1713
    And...

    Database error in vBulletin 2.2.6:

    Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('hey','','this','has','been','here','for','a','bit','but','i','was','wondering','if','you ','found','an','opponent','','','i','have','yet','to','play','my','first','email','game',' so','i','think','i','qualify','as','a','newbie','','','im','up','for','a','game','of','ea' ,'if','you','are','still','looking','','','cheers','','brig')
    mysql error: Can't open file: 'word.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Wednesday 04th of September 2002 01:09:46 PM
    Script: http://www.warfarehq.com/forums/forums/newreply.php
    Referer: http://www.warfarehq.com/forums/newr...y&threadid=172
    And...

    Database error in vBulletin 2.2.6:

    Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('steel','beasts','is','a','superb','sim','ive','designed','many','scenarios','for','sb',' andd','am','proud','to','be','on','the','sb2','scenario','design','team','','heres','by',' far','the','best','way','to','hook','up','with','opponents/teammates','for','multiplayer','the','site','is','being','reconstructed','but','use','the' ,'links','to','both','the','forums','and','the','chatroom','','','','url','http//www.steelbeasts.com/','/url','','','','this','is','the','official','fansite','its','very','popular','and','you','w ill','need','to','look','no','further','','ice')
    mysql error: Can't open file: 'word.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Wednesday 04th of September 2002 01:15:45 PM
    Script: http://www.warfarehq.com/forums/forums/newreply.php
    Referer: http://www.warfarehq.com/forums/newr...y&threadid=257
    There are several more error messages with the same MySQL error numbers. Any help would be appreciated.
    http://www.gamesquad.com
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    All different errors. The biggest problem is error 28. This means that the partition with the MySQL databases has run out of space. You should close your forums immediately and contact your host before any more corruption occurs. They need o free up some space.

    After they've done that, upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Then run it from your browser with this syntax:

    repair.php?html=1&check=1

    If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok. See if this fixes the problem.

    Note that you are also using more MySQL connections than your host allows. You can try turning persistent connections off in your config.php:

    PHP Code:
    // use persistant connections to the database
    // 0 = don't use
    // 1 = use
    $usepconnect 0
    But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • hornstar6969
      Senior Member
      • Aug 2005
      • 1818
      • 3.8.x

      #3
      Problem with this is tht you cant close the forums because i get the database error message when I go to options in the admincp

      MySQL Error : Got error 28 from table handler
      Error Number : 1030
      Selling my BigBoard GamerzNeeds.net/forums Threads: 193 502, Posts: 1 540 045, Members: 718 566 It is listed here http://forums.digitalpoint.com/showt...3#post18297060

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        Error code 28: No space left on device

        One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums (if you can) and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

        Here is an explanation of the error on the MySQL site:

        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

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