Announcement

Collapse
No announcement yet.

Big Database Error!!!

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

  • Big Database Error!!!

    Hi,
    in every page in my forum is this text:
    ------------------------------------------------------
    There seems to have been a slight problem with the GamersHood Forums database.
    Please try again by pressing the refresh button in your browser.
    An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
    We apologise for any inconvenience
    -------------------------------------------------------

    I even can't get into admincp, i can't do nothing?



    All the errors in email is like that:

    -------------------------------------------------------
    Database error in vBulletin 3.0.7:

    Invalid SQL:
    SELECT
    post.*, post.username AS postusername, post.ipaddress AS ip,
    user.*, userfield.*, usertextfield.*,
    icon.title as icontitle, icon.iconpath,
    avatar.avatarpath, NOT ISNULL(customavatar.avatardata) AS hascustomavatar, customavatar.dateline AS avatardateline,


    editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
    editlog.reason AS edit_reason,
    post_parsed.pagetext_html, post_parsed.hasimages,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

    FROM post AS post
    LEFT JOIN user AS user ON(user.userid = post.userid)
    LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
    LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
    LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
    LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)

    LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
    LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid)
    WHERE post.postid IN (0,27,663,814,822,852,859,868,869,870,875)
    ORDER BY dateline

    mysql error: Can't open file: 'user.MYD'. (errno: 145)

    mysql error number: 1016

    -----------------------------------------------

    Is there any suggestions what to do?

    Thanks

  • #2
    Can't open file: 'file.MYI'. (errno: 145)
    Error 145 = Table was marked as crashed and should be repaired
    You should run optimize & repair on your database tables.

    Comment


    • #3
      Originally posted by Floris
      Can't open file: 'file.MYI'. (errno: 145)
      Error 145 = Table was marked as crashed and should be repaired
      You should run optimize & repair on your database tables.
      Can you say how, becouse i only know one way to do that and that's with adminCP, but i can't use even adminCP

      Comment


      • #4
        Do you have phpmyadmin?

        if not, contact your hosting provider and ask them to run optimize and repair on your database for you.

        Comment


        • #5
          Originally posted by Floris
          Do you have phpmyadmin?

          if not, contact your hosting provider and ask them to run optimize and repair on your database for you.
          Thanks!
          I'll contact them, becouse i have phpMyAdmin 2.2.6 and there's no repair, only optimize.


          edit:
          ok found something. but can't do anything? I attached a picture below...
          Do i must left that for my host providers?
          Attached Files
          Last edited by Krika; Sat 25 Jun '05, 12:58pm.

          Comment


          • #6
            Serious crash .. yep: Contact the host. This has nothing to do with vBulletin software and is a hosting related issue.

            Comment


            • #7
              ok, thanks again (:

              Comment


              • #8
                if you have ssh telnet access you can run mysqlcheck to repair database, if you don't then ask web host to run mysqlcheck for you which doesn't need taking down mysql server

                To repair such corruption try using mysqlcheck http://dev.mysql.com/doc/mysql/en/using-mysqlcheck.html


                if you have ssh telnet access better way is to run these commands

                1. check database tables

                mysqlcheck -s -u mysqlusername -p vbforumdbname

                ignore session and cp session table messages

                2. repair table

                mysqlcheck -r -q -u mysqlusername -p vbforumdbname


                3. recheck database tables

                mysqlcheck -s -u mysqlusername -p vbforumdbname

                if you want to do one table at a time then add tablename(s) to end of commandline

                i.e.

                mysqlcheck -s -u mysqlusername -p vbforumdbname tablename1 tablename2 tablename3
                :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                :: Nginx SPDY SSL - World Flags Demo [video results]
                :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                Comment


                • #9
                  I've had this to happen every so often. Will upgrading fix this?

                  Comment


                  • #10
                    Frequent database crashes are an indication of a poorly maintained server. Upgrading will not overcome this.
                    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


                    • #11
                      unless you're running mysql 4.0.22 or a buggy mysql release, than upgrading mysql won't fix this, if you're referring to upgrading vB then no it won't fix this as it's more of server/server hardware issue or server admin issue i.e. host restarting mysql abruptly
                      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                      :: Nginx SPDY SSL - World Flags Demo [video results]
                      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                      Comment

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