Dave wrote:
Trying to open the 'How happy' and 'how pissed off' threads I'm getting this.....Could not obtain post/user information.
DEBUG MODE
SQL Error : 1030 Got error 12 from storage engine
SELECT u.username, u.user_id, u.user_posts, u.user_from, u.user_website, u.user_email, u.user_icq, u.user_aim, u.user_yim, u.user_regdate, u.user_msnm, u.user_viewemail, u.user_rank, u.user_sig, u.user_sig_bbcode_uid, u.user_avatar, u.user_avatar_type, u.user_allowavatar, u.user_allowsmile, p.*, pt.post_text, pt.post_subject, pt.bbcode_uid FROM phpbb_posts p, phpbb_users u, phpbb_posts_text pt WHERE p.topic_id = 5486 AND pt.post_id = p.post_id AND u.user_id = p.poster_id ORDER BY p.post_time ASC LIMIT 2880, 15
Line : 400
File : viewtopic.php
OK, well knowing about this stuff really makes you extra unattractive to girls, but because I'm married now, I don't care anymore....
Basically those threads are so long that while the SQL server was at high load, the server couldn't allocate sufficient memory to sort that many records... while we see nice topics thread posts sorted into nice little sections for us, in the database, each and every post is loaded into the same table and when you click on a thread it had to go and sort all posts pertaining to that topic in ascending order (the ASC bit, hence it places a limit of 2880 records). Long threads will make it time out and throw that error if the server is busy for other reasons.
Luckily my wife loves a nerd