Rhakios
Moderator
Joined: Thu Apr 07, 2005 12:18 am
Posts: 7484
Location: Midlands, UK
|
 Posted: Sat Jul 07, 2012 9:04 pm Post subject: Find all posts |
 |
|
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 |
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
