Re: Find all posts

Anonymous — Fri Feb 08, 2013 7:33 am

Author: Anonymous

Posted: Fri Feb 08, 2013 7:33 am

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

SEM Consulting

Re: Find all posts

Ram — Sun Jul 08, 2012 1:19 am

Author: Ram

Posted: Sun Jul 08, 2012 1:19 am

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

Find all posts

Rhakios — Sat Jul 07, 2012 9:04 pm

Author: Rhakios

Posted: Sat Jul 07, 2012 9: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:

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)?

Linux Format forums

Re: Find all posts

Re: Find all posts

Find all posts