database crash

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dodgez
    Senior Member
    • Apr 2005
    • 103
    • 3.0.7

    database crash

    It gives:
    Database error in vBulletin 3.5.0:

    Invalid SQL:

    SELECT
    user.username, (user.options & 512) AS invisible, user.usergroupid,
    session.userid, session.inforum, session.lastactivity,
    IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
    FROM vb3_session AS session
    LEFT JOIN vb3_user AS user ON(user.userid = session.userid)
    WHERE session.lastactivity > 1128103806
    ORDER BY username ASC;

    MySQL Error : Got error 12 from table handler
    Error Number : 1030
    Date : Friday, September 30th 2005 @ 01:25:06 PM
    Script : http://boostedmopar.com/forums/
    Referrer :
    IP Address : 12.19.56.132
    Username : DodgeZ
    Classname : vb_database






    When I try using my host's repair tool I get:
    Repairing Database

    jeepfra3_bmforum is now being repaired.
    jeepfra3_bmforum.vb3_access OK
    jeepfra3_bmforum.vb3_adminhelp OK
    jeepfra3_bmforum.vb3_administrator OK
    jeepfra3_bmforum.vb3_adminlog OK
    jeepfra3_bmforum.vb3_adminutil OK
    jeepfra3_bmforum.vb3_adv_modules OK
    jeepfra3_bmforum.vb3_adv_pages OK
    jeepfra3_bmforum.vb3_adv_setting OK
    jeepfra3_bmforum.vb3_adv_settinggroup OK
    jeepfra3_bmforum.vb3_announcement OK
    jeepfra3_bmforum.vb3_attachment OK
    jeepfra3_bmforum.vb3_attachmenttype OK
    jeepfra3_bmforum.vb3_attachmentviews OK
    jeepfra3_bmforum.vb3_avatar OK
    jeepfra3_bmforum.vb3_bbcode OK
    jeepfra3_bmforum.vb3_calendar OK
    jeepfra3_bmforum.vb3_calendarcustomfield OK
    jeepfra3_bmforum.vb3_calendarmoderator OK
    jeepfra3_bmforum.vb3_calendarpermission OK
    jeepfra3_bmforum.vb3_cpsession
    error : The handler for the table doesn't support repair
    jeepfra3_bmforum.vb3_cron OK
    jeepfra3_bmforum.vb3_cronlog OK
    jeepfra3_bmforum.vb3_customavatar
    error : Not enough memory for blob at 2960 (need 200402)
    status : Operation failed
    jeepfra3_bmforum.vb3_customprofilepic OK
    jeepfra3_bmforum.vb3_datastore OK
    jeepfra3_bmforum.vb3_deletionlog OK
    jeepfra3_bmforum.vb3_editlog OK
    jeepfra3_bmforum.vb3_event OK
    jeepfra3_bmforum.vb3_faq OK
    jeepfra3_bmforum.vb3_forum OK
    jeepfra3_bmforum.vb3_forumpermission OK
    jeepfra3_bmforum.vb3_forumread OK
    jeepfra3_bmforum.vb3_holiday OK
    jeepfra3_bmforum.vb3_icon OK
    jeepfra3_bmforum.vb3_imagecategory OK
    jeepfra3_bmforum.vb3_imagecategorypermission OK
    jeepfra3_bmforum.vb3_language
    error : Not enough memory for blob at 0 (need 298761)
    error : Not enough memory for blob at 0 (need 298761)
    status : Operation failed
    jeepfra3_bmforum.vb3_mailqueue OK
    jeepfra3_bmforum.vb3_moderation OK
    jeepfra3_bmforum.vb3_moderator OK
    jeepfra3_bmforum.vb3_moderatorlog OK
    jeepfra3_bmforum.vb3_passwordhistory OK
    jeepfra3_bmforum.vb3_paymentapi OK
    jeepfra3_bmforum.vb3_paymentinfo OK
    jeepfra3_bmforum.vb3_paymenttransaction OK
    jeepfra3_bmforum.vb3_phrase OK
    jeepfra3_bmforum.vb3_phrasetype OK
    jeepfra3_bmforum.vb3_plugin OK
    jeepfra3_bmforum.vb3_pm OK
    jeepfra3_bmforum.vb3_pmreceipt OK
    jeepfra3_bmforum.vb3_pmtext OK
    jeepfra3_bmforum.vb3_poll OK
    jeepfra3_bmforum.vb3_pollvote OK
    jeepfra3_bmforum.vb3_post OK
    jeepfra3_bmforum.vb3_post_parsed OK
    jeepfra3_bmforum.vb3_posthash OK
    jeepfra3_bmforum.vb3_postindex OK
    jeepfra3_bmforum.vb3_product OK
    jeepfra3_bmforum.vb3_productcode OK
    jeepfra3_bmforum.vb3_profilefield OK
    jeepfra3_bmforum.vb3_ranks OK
    jeepfra3_bmforum.vb3_regimage OK
    jeepfra3_bmforum.vb3_reminder OK
    jeepfra3_bmforum.vb3_reputation OK
    jeepfra3_bmforum.vb3_reputationlevel OK
    jeepfra3_bmforum.vb3_search OK
    jeepfra3_bmforum.vb3_session
    error : The handler for the table doesn't support repair
    jeepfra3_bmforum.vb3_setting OK
    jeepfra3_bmforum.vb3_settinggroup OK
    jeepfra3_bmforum.vb3_smilie OK
    jeepfra3_bmforum.vb3_stats OK
    jeepfra3_bmforum.vb3_strikes OK
    jeepfra3_bmforum.vb3_style OK
    jeepfra3_bmforum.vb3_subscribeevent OK
    jeepfra3_bmforum.vb3_subscribeforum OK
    jeepfra3_bmforum.vb3_subscribethread OK
    jeepfra3_bmforum.vb3_subscription OK
    jeepfra3_bmforum.vb3_subscriptionlog OK
    jeepfra3_bmforum.vb3_tachyforumpost OK
    jeepfra3_bmforum.vb3_tachythreadpost OK
    jeepfra3_bmforum.vb3_template OK
    jeepfra3_bmforum.vb3_templatehistory OK
    jeepfra3_bmforum.vb3_thread OK
    jeepfra3_bmforum.vb3_threadrate OK
    jeepfra3_bmforum.vb3_threadread OK
    jeepfra3_bmforum.vb3_threadviews OK
    jeepfra3_bmforum.vb3_upgradelog OK
    jeepfra3_bmforum.vb3_user OK
    jeepfra3_bmforum.vb3_useractivation OK
    jeepfra3_bmforum.vb3_userban OK
    jeepfra3_bmforum.vb3_userfield OK
    jeepfra3_bmforum.vb3_usergroup OK
    jeepfra3_bmforum.vb3_usergroupleader OK
    jeepfra3_bmforum.vb3_usergrouprequest OK
    jeepfra3_bmforum.vb3_usernote OK
    jeepfra3_bmforum.vb3_userpromotion OK
    jeepfra3_bmforum.vb3_usertextfield OK
    jeepfra3_bmforum.vb3_usertitle OK
    jeepfra3_bmforum.vb3_vbfields OK
    jeepfra3_bmforum.vb3_word OK

    Repair Complete





    I am running the miserable user plug in and CMPS 2.0.0


    The site is www.boostedmopar.com

  • Mike Sullivan
    Former vBulletin Developer
    • Apr 2000
    • 13327
    • 3.6.x

    #2
    # perror 12
    Error code 12: Cannot allocate memory
    Your machine has run out of memory/swap (as the repair errors indicate as well). If it's your machine, you'll have to add more memory/swap; otherwise, you'll have to contact your host.

    Comment

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