I'm in the process of doing a backup so I can update a board (we're still on 2.0.4), but in the meantime, I'd like to debug an issue that's come up on it, as I don't plan on doing the upgrade until tomorrow, after I've had some time to read up on the nuances of php and upgrading it without blowing up half the 'net
Anyhow, I'm getting this error on the site frequently:
phpBB : Critical Error
Error clearing sessions table
SQL Error : 1034 Incorrect key file for table: 'phpbb_sessions'. Try to repair it
DELETE FROM phpbb_sessions WHERE session_time < 1091040409 AND session_id <> 'd55c4e5b62e54f09dc9f49e041f259bd'
Line : 290
Codeslinging is kind of a secondary thing for me, and I know jack about SQL...looking for a step-by-step on how to go about fixing this. I've tried finding the file that holds sessions, but the trail runs cold after home/www ...the third quantifier isn't on the list. Will keep digging for it....but mostly, I'm interested in the items to delete...is it asking me to delete everything from the session time that is LESS than 1091040409, or just that item specifically? And I assume the d55c4e... it's asking me to delete is just that one item, not a range of them, correct?