
# 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! ;)