Richard Hawley

Richard Hawley Forum
It is currently Thu Mar 28, 2024 8:22 pm

All times are UTC [ DST ]




Post new topic Reply to topic  [ 27 posts ]  Go to page Previous  1, 2
Author Message
 Post subject:
PostPosted: Thu Jul 17, 2008 6:52 pm 
Offline
Scone hoarding gobshite
User avatar

Joined: Tue Nov 22, 2005 10:10 pm
Posts: 6601
Location: still annoying craig
mph wrote:
no, it's your fault sunflower. dun again.


:cry: :cry: :cry:


Top
 Profile  
 
 Post subject:
PostPosted: Thu Jul 17, 2008 6:59 pm 
Offline
Hawleytastic!
User avatar

Joined: Mon Aug 20, 2007 5:23 pm
Posts: 3585
Location: Perfect weather to fly ...
sunflower wrote:
mph wrote:
no, it's your fault sunflower. dun again.


:cry: :cry: :cry:



:*: We love you really sunflower Image

_________________
The way your face could light the bitter dark of every street
In every town I'll ever go


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jul 18, 2008 6:49 pm 
Offline
I need a life
User avatar

Joined: Fri Aug 10, 2007 9:54 am
Posts: 857
Location: Birmingham
That lady in the thong is just classy.


Top
 Profile  
 
 Post subject:
PostPosted: Fri Jul 18, 2008 7:34 pm 
Offline
Hawleytastic!

Joined: Sun Oct 07, 2007 6:25 pm
Posts: 1114
Big Louise wrote:
That lady in the thong is just classy.


Isn't she? Lovely. :?


Top
 Profile  
 
PostPosted: Wed Jul 30, 2008 11:20 pm 
Offline
Biggest Hawley Fan on Canal Street
User avatar

Joined: Wed Sep 10, 2003 1:53 pm
Posts: 4069
Location: Back for a fleeting moment
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.


Top
 Profile  
 
PostPosted: Wed Jul 30, 2008 11:24 pm 
Offline
Scone hoarding gobshite
User avatar

Joined: Tue Nov 22, 2005 10:10 pm
Posts: 6601
Location: still annoying craig
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

:*:


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 30, 2008 11:25 pm 
Offline
Site Admin
User avatar

Joined: Tue Sep 06, 2005 6:10 pm
Posts: 12339
Location: Usually to be found at a computer
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.

_________________
There's a raven in the distance, his inscription's all around you, you can't hide

https://www.facebook.com/LiamMcKaheyandtheBodies
https://cousteaux.com/music


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 30, 2008 11:30 pm 
Offline
Biggest Hawley Fan on Canal Street
User avatar

Joined: Wed Sep 10, 2003 1:53 pm
Posts: 4069
Location: Back for a fleeting moment
phpbb is very advanced now, I think the version used on here is about 3 years out of date.....


Top
 Profile  
 
PostPosted: Wed Jul 30, 2008 11:32 pm 
Offline
Biggest Hawley Fan on Canal Street
User avatar

Joined: Wed Sep 10, 2003 1:53 pm
Posts: 4069
Location: Back for a fleeting moment
sunflower wrote:
weve missed you so much :D

:*:


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


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 30, 2008 11:32 pm 
Offline
Scone hoarding gobshite
User avatar

Joined: Tue Nov 22, 2005 10:10 pm
Posts: 6601
Location: still annoying craig
who's elano? :?


Top
 Profile  
 
 Post subject:
PostPosted: Wed Jul 30, 2008 11:43 pm 
Offline
Biggest Hawley Fan on Canal Street
User avatar

Joined: Wed Sep 10, 2003 1:53 pm
Posts: 4069
Location: Back for a fleeting moment
He plays midfield for City and Brazil, and he's well cute x


Top
 Profile  
 
PostPosted: Thu Jul 31, 2008 5:59 am 
Offline
Hawley Groupie
User avatar

Joined: Sun Dec 09, 2007 12:22 am
Posts: 125
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

_________________
There was a young man from Sri Lanka
Who refused to take part in limericks

the end.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 27 posts ]  Go to page Previous  1, 2

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 34 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group