1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

cpanel mysql question.

Discussion in 'Off Topic' started by jonsidneyb, Dec 7, 2011.

  1. jonsidneyb

    jonsidneyb Well-Known Member

    This is not about xenforo sorry. I asked this question in the cpanel and mysql forums but have not got an answer yet.

    I was getting data base errors and did a repair mysql inside of cpanel. I did a check db and it ended quickly. I would have thought the site would be back up but it isn't.

    Is it kind of odd that the site would not be back up after the repair of the db?
     
  2. Digital Doctor

    Digital Doctor Well-Known Member

    What were the database errors ?
     
  3. ENF

    ENF Well-Known Member

    It seems that one of your tables has crashed.

    Code:
    Invalid SQL:
     
    SELECT
    userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight, usercsscache.cachedcss, IF(usercsscache.cachedcss IS NULL, 0, 1) AS hascachedcss, usercsscache.buildpermissions AS cssbuildpermissions
     
    FROM vb4_user AS user
    LEFT JOIN vb4_userfield AS userfield ON (user.userid = userfield.userid)
    LEFT JOIN vb4_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN vb4_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb4_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb4_customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN vb4_sigpic AS sigpic ON (user.userid = sigpic.userid) LEFT JOIN vb4_usercsscache AS usercsscache ON (user.userid = usercsscache.userid)
     
    WHERE user.userid = 3;
     
    MySQL Error : Table './jsbur2_vb4edc/vb4_user' is marked as crashed and should be repaired
    Error Number : 145
    Request Date : Wednesday, December 7th 2011 @ 12:47:55 AM
    Error Date : Wednesday, December 7th 2011 @ 12:47:55 AM
    Script : http://edcforums.com/
    Referrer : http://edcforums.com/
    IP Address : 114.48.XXX.XXX
    Username : Unregistered
    Classname : vB_Database
    MySQL Version :
    -->
    
    You'll need to run a repair through phpMyadmin or whatever database tool you have to use. Run a repair on that table and see if things come back to normal.
     
  4. jonsidneyb

    jonsidneyb Well-Known Member

    I didn't read all or your post. Editing my response.
     
  5. jonsidneyb

    jonsidneyb Well-Known Member


    MySQL Error : Got error 134 from storage engine
    Error Number : 1030
     
  6. ENF

    ENF Well-Known Member

    It seems you fixed it... I can see your site again without errors.

    PS: The store link at the bottom of your forum page (footer) goes to a broken link. :)
     
  7. jonsidneyb

    jonsidneyb Well-Known Member

    Got it fixed. That was the first time I have ever been in phpmyadmin before.
     
  8. jonsidneyb

    jonsidneyb Well-Known Member

    hmmm, now to figure out how to fix that. I am such a novice.
     
  9. jonsidneyb

    jonsidneyb Well-Known Member

    Thanks.
     

Share This Page