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

XF 1.2 xf_session table crashing... truncate to fix

Discussion in 'Troubleshooting and Problems' started by alex.tsakiris, Feb 22, 2014.

  1. alex.tsakiris

    alex.tsakiris Member

    I originally posted this in another thread, but thought it might help to start it in a new thread so I can at least help others see how to fix... or kinda fix.

    my forum went down and generated a "unavailable message". my host InMotion did a SQL repair, but was unable to get me back up.

    I went into my cpanel and truncated the xf_session table and the forum came back up.

    I'm still trying to figure out what caused this problem... any suggestions appreciated.
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    xf_session is one of the few MyISAM tables. Is that table corrupt? Try running a repair in phpmyadmin. Most of XF's tables are InnoDB and don't support repair, but xf_session is MyISAM and can be repaired.

    Without a specific error message I can't be sure about the problem though.
     
  3. Dinh Thanh

    Dinh Thanh Well-Known Member

    Your forum is going to be busy. You may need memcached and turn session into cache.
     
  4. Mike

    Mike XenForo Developer Staff Member

Share This Page