[Fusionforge-general] 5.0.3: Post to forums fails
Marc Fournier
scrappy at hub.org
Mon Jan 21 07:44:56 CET 2013
Found it … no foreign key from forum_monitored_forums -> users:
gforge=# alter table forum_monitored_forums add constraint forum_monitored_forums_user_id_fkey foreign key ( user_id ) references users ( user_id ) ;
ALTER TABLE
So when I cleaned out a whack of spammers, this table didn't get cleaned out too :(
Cleaned out that table, added the foreign key to prevent it from happening again, posting works again …
On 2013-01-20, at 10:28 PM, Marc Fournier <scrappy at hub.org> wrote:
>
> 'k, just upgraded to 5.0.3, still getting "Open transaction detected!!!" when I try and post a message to a forum, and in the error log file:
>
> cal/sbin/php-fpm" stderr: PHP message: PHP Fatal error: Call to a member function isActive() on a non-object in /usr/local/www/pgfoundry.org/fusionforge-5.0.3/common/forum/ForumMessage.class.php on line 642, referer: http://pgfoundry.org/forum/new.php?forum_id=44&group_id=1000013
>
> the code being pointed to is:
>
> function sendNotice($has_attach=false) {
> $ids =& $this->Forum->getMonitoringIDs();
>
> $recipients = array ();
> foreach ($ids as $id) {
> $recipient = user_get_object ($id) ;
> if ($recipient->isActive()) {
> $recipients[] = $recipient ;
> }
> }
>
> Is there a 'corrupt' user in the system, maybe? or … ? something i need to check on the database side?
>
> Help?
>
>
> _______________________________________________
> Fusionforge-general mailing list
> Fusionforge-general at lists.fusionforge.org
> http://lists.fusionforge.org/cgi-bin/mailman/listinfo/fusionforge-general
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.fusionforge.org/pipermail/fusionforge-general/attachments/20130120/80111df5/attachment.html>
More information about the Fusionforge-general
mailing list