phpBB down again

Yep, and just in time for one of my bug fixes for fisher. I had several message with another user on the board yesterday, and after I finally released a test to him and thinking that could be the fix, I can't get any reply back any more.

After release it to the user and go to bed, I was anxious to see if the user had any feed back to me this morning. But, my forum is totally down!! So I opened a ticket to my ISP immediately, and the reply was to contact the phpBB dev team.

So I started to do debugging myself. turned out in session.php, a query was causing the problem: SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = 'fcc36259f92c0f8e29a87f7e4e4d55d1' AND u.user_id = s.session_user_id
The select statement is blocking the entire site!! And I can't do much else either, because the phpMyAdmin tool provided by my ISP is down as well.

Anyway, I have sent those to my ISP, and let's hope the forums will get back up soon.

(EDIT: the final solution? Restore the old phpBB2 database. The lessons learned? Take care of your databases from time to time, and back them up!)