Linux Format forums Forum Index Linux Format forums
Help, discussion, magazine feedback and more
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Find all posts

 
Post new topic   Reply to topic    Linux Format forums Forum Index -> This Website
View previous topic :: View next topic  
Author Message
Rhakios
Moderator


Joined: Thu Apr 07, 2005 12:18 am
Posts: 7634
Location: Midlands, UK

PostPosted: Sat Jul 07, 2012 9:04 pm    Post subject: Find all posts Reply with quote

Just messing around, I clicked on towy's name as he was on-line and, just out of sheer idle curiosity, clicked on "Find all posts by...". This generates a nice error message:

Quote:

General Error

Could not obtain search results

DEBUG MODE

SQL Error : 126 Incorrect key file for table '/tmp/#sql_4908_0.MYI'; try to repair it

SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid FROM phpbb_forums f, phpbb_topics t, phpbb_users u, phpbb_posts p, phpbb_posts_text pt WHERE p.post_id IN (42, 43, 84, 87, 130, 221, 224, 230, 231, 233, 258, 298, 300, 320, 343, 348, 349, 355, 357, 359, 360, 396, 400, 424, 447, 449, 450, 453, 455, 457, 458, 464, 470, 471, 477, 481, 492, 493, 500, 504, 508, 513, 532, 533, 535, 548, 551, 554, 564, 575, 583, 590, 594, 598, 600, 601, 635, 640, 643, 652, 697, 714, 727, 729, 743, 753, 756, 757, 771, 799, 800, 812, 822, 850, 1026, 1028, 1036, 1037, 1100, 1107, 1115, 1116, 1120, 1121, 1147, 1149, 1166, 1177, 1201, 1212, 1213, 1237, 1240, 1265, 1266, 1267, 1286, 1325, 1328, 1340, 1348, 1349, 1357, 1358, 1359, 1360, 1362, 1372, 1383, 1389, 1401,
<snip>
106612, 106625, 106626, 106627, 106628, 106639, 106672, 106699, 106708, 106714, 106747, 106759, 106801, 106813, 106824, 106829) AND pt.post_id = p.post_id AND f.forum_id = p.forum_id AND p.topic_id = t.topic_id AND p.poster_id = u.user_id ORDER BY p.post_time DESC LIMIT 0, 15

Line : 788
File : search.php


In fact it does this for my posts too, and, for example, for Hudzilla. It doesn't do it for people with only a few posts to their name. A little testing shows the limit is somewhere between 258 (Flea) and 265 (Hudzilla).
Am I, are we, to be denied the collected wisdom of this forum's most prolific posters (points finger in nelz's general direction)?
_________________
Bye, Rhakios
Back to top
View user's profile Send private message
Ram
LXF regular


Joined: Thu Apr 07, 2005 10:44 pm
Posts: 1674
Location: Guisborough

PostPosted: Sun Jul 08, 2012 1:19 am    Post subject: Reply with quote

Been doing it for a while - I should have said earlier.
_________________

lubuntu LXDE 13.10 running on AMD Phenom II*4; ASUS Crosshair III Formula MB; 4 GB Ram.....
Back to top
View user's profile Send private message MSN Messenger
Gonzalez Rivera
Guest





PostPosted: Fri Feb 08, 2013 7:33 am    Post subject: Reply with quote

This point looks good to highlight. I observed it now!

SEM Consulting
Back to top
View previous topic :: View next topic  
Display posts from previous:   
Post new topic   Reply to topic    Linux Format forums Forum Index -> This Website All times are GMT
Page 1 of 1

 
Jump to:  
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
You cannot vote in polls in this forum
Linux Format forums topic RSS feed 


Powered by phpBB © 2001, 2005 phpBB Group


Copyright 2011 Future Publishing, all rights reserved.


Web hosting by UKFast