Richard Hawley
http://richardhawleyforum.co.uk/

What the feck is this???
http://richardhawleyforum.co.uk/viewtopic.php?f=12&t=10819
Page 2 of 2

Author:  sunflower [ Thu Jul 17, 2008 6:52 pm ]
Post subject: 

mph wrote:
no, it's your fault sunflower. dun again.


:cry: :cry: :cry:

Author:  catsandbooks [ Thu Jul 17, 2008 6:59 pm ]
Post subject: 

sunflower wrote:
mph wrote:
no, it's your fault sunflower. dun again.


:cry: :cry: :cry:



:*: We love you really sunflower Image

Author:  Big Louise [ Fri Jul 18, 2008 6:49 pm ]
Post subject: 

That lady in the thong is just classy.

Author:  Rita [ Fri Jul 18, 2008 7:34 pm ]
Post subject: 

Big Louise wrote:
That lady in the thong is just classy.


Isn't she? Lovely. :?

Author:  Happy Clapper [ Wed Jul 30, 2008 11:20 pm ]
Post subject:  Re: What the feck is this???

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


It's an SQL database error maybe too much content or the database index refrerencing the post is corrupt.

Author:  sunflower [ Wed Jul 30, 2008 11:24 pm ]
Post subject:  Re: What the feck is this???

Happy Clapper wrote:
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


It's an SQL database error maybe too much content or the database index refrerencing the post is corrupt.



weve missed you so much :D

:*:

Author:  Dawoodcock [ Wed Jul 30, 2008 11:25 pm ]
Post subject: 

One of the other forums I'm on has just upgraded and it is so much better. Let's hope Mute do the decent thing and upgrade us asap.

Author:  Happy Clapper [ Wed Jul 30, 2008 11:30 pm ]
Post subject: 

phpbb is very advanced now, I think the version used on here is about 3 years out of date.....

Author:  Happy Clapper [ Wed Jul 30, 2008 11:32 pm ]
Post subject:  Re: What the feck is this???

sunflower wrote:
weve missed you so much :D

:*:


ahhh shucks, I only come on when very bored or pissed... x

Author:  sunflower [ Wed Jul 30, 2008 11:32 pm ]
Post subject: 

who's elano? :?

Author:  Happy Clapper [ Wed Jul 30, 2008 11:43 pm ]
Post subject: 

He plays midfield for City and Brazil, and he's well cute x

Author:  speedyvespa [ Thu Jul 31, 2008 5:59 am ]
Post subject:  Re: What the feck is this???

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 :D

Page 2 of 2 All times are UTC [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/