Announcement

Collapse
No announcement yet.

Serious Database Errors

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

  • Serious Database Errors

    ok, ive been getting errors everytime someone tries to make a new post or reply. and on certain things in the CP like pruning threads. these are the kind of errors im getting:

    --------------------
    Database error in vBulletin 2.2.8:

    Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('test','fdsafdsaf','test')
    mysql error: Can't open file: 'word.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Tuesday 24th of September 2002 01:51:08 PM
    Script: http://www.purekaos.com/board/board/newthread.php
    Referer: http://purekaos.com/board/newthread....amp;forumid=14
    ---------------------

    But after the error message comes up, the post shows up anyways!

    also im getting this error in the CP:
    ---------------------
    Database error in vBulletin Control Panel 2.2.8:

    Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('cool')
    mysql error: Can't open file: 'word.MYD'. (errno: 145)

    mysql error number: 1016

    Date: Tuesday 24th of September 2002 02:37:50 PM
    Script: http://www.purekaos.com/board/board/admin/thread.php
    Referer: http://purekaos.com/board/admin/thread.php
    ----------------------


    so i sent these errors to my host asking for help, and this is what they told me:

    ----------------------
    Hi,

    Inside mysql, run the query :

    show variables;

    look for the line :

    max_user_connections | _ _

    This will show you the max_user_connections allowed on your server. It is generally set somewhere between 45 - 75 connections. The server is generally set to 300 connections total. However, each user/website is also limited to a certain number of connections.

    This number is not a limit to the number of users you can have on your site at a time! This means that you can only have x number of database connections open at once.

    If you are getting the error:

    "mySQL error: User [email protected] has already more than 'max_user_connections' active connections / mySQL error code: 1203"

    This probably means that you are either running too many queries per page, or you are not p
    NickNice: This probably means that you are either running too many queries per page, or you are not properly closing out your database connections.

    Keep in mind, that this limit is the maximum number of persistent links to the database that we give you at a time. This should be plenty to power many, many users at once.

    I would advise that you check your code and make sure you are closing connections and not making un-needed calls to the database.

    Best Regards,
    ----------------------------

    any ideas?

  • #2
    Error code 145: Table was marked as crashed and should be repaired

    Your word table has crashed. Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

    http://www.yourdomain/forum/admin/repair.php?html=1&check=1

    [Of course change the exact URL as appropriate for your forums.]

    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.
    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


    • #3
      thank you so much!!!

      Comment


      • #4
        Originally posted by Steve Machol
        Error code 145: Table was marked as crashed and should be repaired

        Your word table has crashed. Upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Close your forums, then run it from your browser with this syntax:

        http://www.yourdomain/forum/admin/repair.php?html=1&check=1

        [Of course change the exact URL as appropriate for your forums.]

        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.
        I did this and got the following errors:

        Checking table session
        Table Operation Type Text
        vbulletin.session check error The handler for the table doesn't support check
        Repairing table session
        vbulletin.session repair error The handler for the table doesn't support repair
        Checking table session
        Table Operation Type Text
        vbulletin.session check error The handler for the table doesn't support check
        Repairing table session
        vbulletin.session repair error The handler for the table doesn't support repair
        Checking table session
        Table Operation Type Text
        vbulletin.session check error The handler for the table doesn't support check
        Repairing table session
        vbulletin.session repair error The handler for the table doesn't support repair
        Checking table session
        Table Operation Type Text
        vbulletin.session check error The handler for the table doesn't support check
        Repairing table session
        vbulletin.session repair error The handler for the table doesn't support repair


        Now any suggestions? BTW I am running vubulletin, mysqland php on a Windows 2000ADV server, so the UN*X stuff doesn't help much!

        David

        Comment


        • #5
          As the message indicates, the session table does not support repair. Are you getting any database errors from your forums? If so, post the complete error message. Also please start your own thread rather than responding to a thread that is almost a year old.
          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...
          X