Sql Database error

[xbp-tpn]

My server went down today and when i brought it back up i got a mysql error. Can someone help me figure out the reason for this? This is the entry in the sql error log

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | | [class_taskmanager].runTask | | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Thu, 17 Oct 2013 16:29:30 +0000 Error: 1032 - Can't find record in 'sessions' IP Address: - /forums/ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT * FROM sessions WHERE id='05ed5972b32262a897f8be0b8dd66625' .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/sources/classes/session/publicSessions.php | [publicSessions].getSession | 361 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [publicSessions].__construct | 3882 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [ips_MemberRegistry].init | 3715 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsRegistry.php | [ips_MemberRegistry].instance | 608 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Thu, 17 Oct 2013 16:29:38 +0000

I managed to fix this by repairing my database but i'm afraid that this might happen again. From what i can understand this was happening because of some problem with user sessions?

[xtech]

I think there it isn't a big deal. I assume you are using MyISAM as MysQL engine. If so, you shall regularly check the database integrity.

[xbp-tpn]

Thanks for the reply. So i should regularly repair my forum's database to avoid this problem?

[Rhett]

Most likely your sessions table is crashed, run a check and repair on the whole DB to be safe.