Vbulletin Error for Table is marked as crashed and should repaired


Vbulletin which is a great forum software but if you are getting any email like

Message: SQLSTATE[HY000]: General error: 1194 Table ‘session’ is marked as crashed and should be repaired; Code: HY000

To handle such kind of error you simply need to login to vbulletin section go to Maintenance >> Repair / Optimize tables

vbulletin maintanence

Check on the table which needs to be repaired and click on below button ‘Repair table’

For the sake of knowledge i can define both keyword:
Optimize Table: This means defragmentation on mysql data and reclaim the lost space.

Repair Table: With this button mysql want to repair the table which got crashed by any reason. After repair all the data of your table got restored

Related posts:

The following two tabs change content below.

Chandra Shekhar

Consultant at Infogain
Chandra Shekhar is a LAMP Developer,Thinker,Blogger and currently working as Magento(Ecommerce) specialist.. I am always open to learn new things in LAMP as well as other newer technology. In the journey of my last 9 years of web and product development, I have decided to share my knowledge and experience to Open Source Community in 2011. In this regard I have started CuteHits.com. Since then I am actively sharing my knowledge on various LAMP technology through CuteHits.com’s technical ... Read More about Chandra Shekhar

Latest posts by Chandra Shekhar (see all)