Announcement

Collapse
No announcement yet.

Mysql error number: 1146 "_forum.user" doesnt exist

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

  • Mysql error number: 1146 "_forum.user" doesnt exist

    I keep on getting this error message, what puzzles me is that the forum was working absolutly perfectly unti a few days ago

    I have tried repairing the tables in Cpanel and using tools.php mysql repair function but still doesnt work.



    Database error in vBulletin 3.0.7:

    Invalid SQL:
    SELECT
    user.username, (user.options & 512) AS invisible, user.usergroupid,
    session.userid, session.inforum, session.lastactivity,
    session.location, IF(displaygroupid=0, user.usergroupid,
    displaygroupid) AS displaygroupid
    FROM session AS session
    LEFT JOIN user AS user ON(user.userid = session.userid)
    WHERE session.lastactivity > 1123751097
    ORDER BY username ASC

    mysql error: Table 'hxforus_forum.user' doesn't exist

    mysql error number: 1146


  • #2
    This means you aare missing your user table. What does the database show?
    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
      These are my all my tables in the database 2 of the tables listed below are from a Hack all in all totalling up to 83 tables of which 81 is the original Vbulletin tables.



      access
      adminhelp
      administrator
      adminlog
      adminutil
      announcement
      attachment
      attachmenttype
      attachmentviews
      avatar
      bbcode
      calendar
      calendarcustomfield
      calendarmoderator
      calendarpermission
      cpsession
      cron
      cronlog
      customavatar
      customprofilepic
      datastore
      deletionlog
      editlog
      event
      faq
      forumpermission
      holiday
      icon
      imagecategory
      imagecategorypermission
      language
      mailqueue
      moderation
      moderator
      moderatorlog
      passwordhistory
      phrase
      phrasetype
      pm
      pmreceipt
      pmtext
      poll
      pollvote
      posthash
      postindex
      post_parsed
      profilefield
      ranks
      regimage
      reminder
      reputation
      reputationlevel
      search
      session
      setting
      settinggroup
      smilie
      stats
      strikes
      style
      subscribeevent
      subscribeforum
      subscribethread
      subscription
      subscriptionlog
      template
      thread
      threadrate
      threadviews
      upgradelog
      useractivation
      userban
      userfield
      usergroup
      usergroupleader
      usergrouprequest
      usernote
      userpromotion
      usertextfield
      usertitle
      vbchat_datastore
      vbchat_store
      word

      Comment


      • #4
        You are missing the user table. Also the default vB3 has 84 tables, not 82 - and a couple of those tables are from hacks you've installed.

        Therefore it looks like you are missing about 5 vB tables. Unfortunately there is no way to fix this with the current database. You will need to restore a backup of your database.
        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