Find all posts

Comments and suggestions about this site

Moderators: ChrisThornett, LXF moderators

Find all posts

Postby Rhakios » Sat Jul 07, 2012 8:04 pm

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:

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
User avatar
Rhakios
Moderator
 
Posts: 7634
Joined: Wed Apr 06, 2005 11:18 pm
Location: Midlands, UK

Postby Ram » Sun Jul 08, 2012 12:19 am

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.....
User avatar
Ram
LXF regular
 
Posts: 1684
Joined: Thu Apr 07, 2005 9:44 pm
Location: Guisborough

Postby Gonzalez Rivera » Fri Feb 08, 2013 7:33 am

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

SEM Consulting
Gonzalez Rivera
 


Return to This Website

Who is online

Users browsing this forum: No registered users and 0 guests