Select "print" from your browser's "File" menu.

Back to Post


Username Post: users posts not appearing in recent posts
sb1963
FusionBB Fanatic
Posts 1636
 08-18-10 08:47 PM - Post#84455    

The user is actually me with one of my alternative admin logins. Any post - reply or new topic shows in the forum but in omitted from recent topics.

I can't think of or find a setting that would cause that.

sb1963
FusionBB Fanatic
Posts 1636
 09-25-10 11:17 AM - Post#84621    

Not a one off - still happening

Couchtomatoe
Code Monkey
Posts 3049
Couchtomatoe 		09-25-10 01:09 PM - Post#84622    

well try this.. go to the recent_activity script and go to about line 481 after the closing of the $sql put this

print_r($sql);

then run the script and see what the sql query is actually saying.. then remove that line and run that query in phpMyAdmin or any other form of it..

see if there are any posts showing up.. look at the query and try to figure out why..
The artist formerly known as scroungr
Couch-Tomatoe
sb1963
FusionBB Fanatic
Posts 1636
 09-25-10 01:40 PM - Post#84624    

  • Couchtomatoe Said:
look at the query and try to figure out why..




I will - once I figure out what you mean!

Couchtomatoe
Code Monkey
Posts 3049
Couchtomatoe 		09-25-10 02:04 PM - Post#84626    

your talking about recent posts not showing up for someone in the recent_activity.php script right? well look about line 480 in that script and you will see the SQL query... put the print_r($sql) after the closing "; and run the script you will see at the top the query it is trying to use.. then look at said query and see if that user is excluded.. then remove that print_r($sql) so no one else sees it..
The artist formerly known as scroungr
Couch-Tomatoe
sb1963
FusionBB Fanatic
Posts 1636
 09-25-10 03:57 PM - Post#84628    

This is what I got. The user ID of the poster (1) isn't on the list. However there are loads of member ID's missing from that list - including 15, my main account & I can see posts from user 15

Code:



 SELECT p.forum_id,p.post_id,p.post_body,p.post_subject,p.post_posted,p.post_is_topic,u.info_display_name,u.info_reg_date,u.info_total_posts,u.info_title,u.info_title_custom,u.info_location,u.info_sharebirthday,u.info_birthday,p.user_id,u.info_signature,info_name_color,info_group_flag,p.post_include_sig,p.post_icon,p.post_has_files,p.post_has_polls,p.post_edited,p.post_edited_by,p.post_edited_reason,p.post_parent,p.post_reply_name,p.post_ip,u.info_group_flag,u.info_no_ignore,u.info_name_color,t.topic_subject,t.topic_is_closed,t.topic_id,t.topic_preview,t.topic_replies,t.topic_views,f.forum_title,f.forum_gallery,f.forum_thumbnail,f.forum_med_image,u.info_attitude,t.topic_prefix,f.forum_ad FROM fbb_forums AS f, fbb_topics AS t, fbb_posts AS p, fbb_user_info AS u WHERE p.user_id = u.user_id AND p.topic_id = t.topic_id AND p.forum_id = f.forum_id AND p.is_moderated != 1 AND t.topic_moved = 0 AND p.post_posted BETWEEN '1285369200' AND '1285455599' AND f.forum_id IN (14,17,18,19,20,22,23,24,25,27,28,29,31,32,34,35,37,44,61,66,67,68,69,70,71,72,73,74,75,76,78,79,94,96,98,99,100,105,107,109,113,114,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,144,145,146,147,148,149,150,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,168,171,172,174,175,177,179,180,181,183,184,186,188,189,190,191,193,194,195,196,198,199,202,204,205,206,207,208,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,231,232,233,234,235,236,237,238,239,240,241,242,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,290,291,292,293,294,295,296,297,298,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,317,318,319,320,321,322,323,324,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,393,394,395,396,397,399,400,401,402,403,406,408,413,414,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,451,452,453,454,455,456,457,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,510,511,512,513,514,515,516,517,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,544,545,546,547,548,549,550,551,552,553,554,555,557,558,559,560,561,562,563,564,565,566,567,568,569,570,572,573,574,575,576,577,578,579,580,582,583,584,586,587,588,589) AND p.user_id != '1' ORDER BY p.post_posted DESC LIMIT 20  


Couchtomatoe
Code Monkey
Posts 3049
Couchtomatoe 		09-25-10 06:16 PM - Post#84629    

ok next take that query and run it in phpMyAdmin and see if the posts show there

but lets pull it apart to explain it

its telling you to get this stuff

[code]SELECT p.forum_id,p.post_id,p.post_body,p.post_subject,p.post_posted,p.post_is_topic,u.info_display_name,u.info_reg_date,u.info_total_posts,u.info_title,u.info_title_custom,u.info_location,u.info_sharebirthday,u.info_birthday,p.user_id,u.info_signature,info_name_color,info_group_flag,p.post_include_sig,p.post_icon,p.post_has_files,p.post_has_polls,p.post_edited,p.post_edited_by,p.post_edited_reason,p.post_parent,p.post_reply_name,p.post_ip,u.info_group_flag,u.info_no_ignore,u.info_name_color,t.topic_subject,t.topic_is_closed,t.topic_id,t.topic_preview,t.topic_replies,t.topic_views,f.forum_title,f.forum_gallery,f.forum_thumbnail,f.forum_med_image,u.info_attitude,t.topic_prefix,f.forum_ad
[/code]


from these tables

[code]FROM fbb_forums AS f, fbb_topics AS t,
fbb_posts AS p,
fbb_user_info AS u
[/code]

link these tables by

[code]WHERE p.user_id = u.user_id
AND p.topic_id = t.topic_id
AND p.forum_id = f.forum_id
[/code]

then its telling you not to grab moderated posts

[code]AND p.is_moderated != 1
[/code]

so first I would check one of his posts and see what the is_moderated is set to.. a one means his posts are being moderated and you wont see them til you approve them

then its also telling you not to grab moved topics

[code]AND t.topic_moved = 0[/code]

and to grab it all between

[code]AND p.post_posted BETWEEN '1285369200' AND '1285455599'[/code]

which is between Fri, 24 Sep 2010 23:00:00 GMT and Sat, 25 Sep 2010 22:59:59 GMT

from all these forums

[code]AND f.forum_id IN (14,17,18,19,20,22,23,24,25,27,28,29,31,32,34,35,37,44,61,66,67,68,69,70,71 ,72,73,74,75,76,78,79,94,96,98,99,100,105,107,109,113,114,120,121,122,123,1 24,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142, 144,145,146,147,148,149,150,152,153,154,155,156,157,158,159,160,161,162,163 ,164,165,166,168,171,172,174,175,177,179,180,181,183,184,186,188,189,190,19 1,193,194,195,196,198,199,202,204,205,206,207,208,212,213,214,215,216,217,2 18,219,220,221,222,223,224,225,226,231,232,233,234,235,236,237,238,239,240, 241,242,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260 ,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,27 9,280,281,282,283,284,285,286,287,288,290,291,292,293,294,295,296,297,298,3 00,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,317,318,319, 320,321,322,323,324,326,327,328,329,330,331,332,333,334,335,336,337,338,339 ,340,341,342,343,344,345,346,347,348,349,350,353,354,355,356,357,358,359,36 0,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,3 79,380,381,382,383,384,385,386,387,388,389,390,391,393,394,395,396,397,399, 400,401,402,403,406,408,413,414,415,416,417,418,419,420,421,422,423,424,425 ,426,427,428,429,431,432,433,434,435,436,437,438,439,440,441,442,443,444,44 5,446,447,448,449,451,452,453,454,455,456,457,459,460,461,462,463,464,465,4 66,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484, 485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503 ,504,505,506,507,508,510,511,512,513,514,515,516,517,520,521,522,523,524,52 5,526,527,528,529,530,531,532,533,534,535,536,537,538,539,540,541,542,543,5 44,545,546,547,548,549,550,551,552,553,554,555,557,558,559,560,561,562,563, 564,565,566,567,568,569,570,572,573,574,575,576,577,578,579,580,582,583,584 ,586,587,588,589)
[/code]

but not for user_id

[code]AND p.user_id != '1'
[/code]

finaly only return 20 at a time and order them on post time

[code]ORDER BY p.post_posted DESC LIMIT 20[/code]

The artist formerly known as scroungr
Couch-Tomatoe
sb1963
FusionBB Fanatic
Posts 1636
 09-25-10 06:23 PM - Post#84630    

Ah - forums, not users.

Thing is they are posted by me using another ID which I use when posting items on behalf of outside contributors. That account is not set for moderated posting.

Interesting contradiction though as it looks like that user is moderated from your breakdown.

Interesting, because when I HAVE put a user on moderated posting their posts appear in 'recent posts' even before they are approved which is not good.

Couchtomatoe
Code Monkey
Posts 3049
Couchtomatoe 		09-25-10 08:40 PM - Post#84633    

yeah but this there

AND p.is_moderated != 1

should not allow moderated posts through
The artist formerly known as scroungr
Couch-Tomatoe



FusionBB™ Version 3.2 | ©2003-2013 InteractivePHP, Inc.
Execution time: 0.044 seconds.   Total Queries: 50   Zlib Compression is on.
All times are (GMT-4). Current time is 02:32 PM
Top