Log in

No account? Create an account
June 14th, 2002 - LiveJournal Development — LiveJournal [entries|archive|friends|userinfo]
LiveJournal Development

[ userinfo | livejournal userinfo ]
[ archive | journal archive ]

June 14th, 2002

Communities Posting Comments? [Jun. 14th, 2002|09:09 pm]
LiveJournal Development


There have been two or three support questions over the past few weeks wondering why some communities seem to have comments listed as Posted. lochjournal is listed as having 95 Posted. This has happened to quite a few communities that have always been communities. I checked userinfo.bml, that doesn't seem to be the problem. The problem, instead, seems to stem from back when converted to clusters. In the moveucluster.pl file, the following line is:

# note that poster commented here
if ($item->{'posterid'}) {
  my $pub = $logitem->{'security'} eq "public" ? 1 : 0;
  my ($table, $db) = ("talkleft_xfp", $dbh);
  ($table, $db) = ("talkleft", $dbch) if $userid == $item->{'posterid'};
  $replace_into->($db, $table, "(userid, posttime, journalid, nodetype, ".
                    "nodeid, jtalkid, publicitem)", 50,
                    $userid, $item->{'datepostunix'}, $userid,
                    'L', $jitemid, $jtalkid, $pub);

The second $userid should probably have been $item->{'posterid'}. It looks like items were added to the talkleft and talkleft_xfp tables in error, the posterid was converted to userid by accident.

Correcting this would involve going through talk2 on every cluster, which is not exactly the easiest thing...but it should probably be done sometime. This has affected everyone's "Posted" on the userinfo page.

Am I right? Someone check me and see if the above is the cause or if I'm on crack. I have some support points to get! ;)
link4 comments|post comment

[ viewing | June 14th, 2002 ]
[ go | Previous Day|Next Day ]