SQL syntax error when deleting a group join request [#674294]

Problem
When a user creates a group join request and then immediately deletes that join request we see the following error:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE nid = 0' at line 1 query: UPDATE mydb_og_statistics SET WHERE nid = 0 in /public_html/includes/common.inc on line 3467.

Steps to reproduce
1) Site admin creates a new group that requires join approval
2) User2 requests to join the group
3) User2 then selects to delete the join request
4) Join request is deleted, however the above error is thrown.

Comments

Comment #1

dawehner

German

commented 30 January 2010 at 08:35

Could you please try out the latest cvs version? I think i fixed the issue.

1) Site admin creates a new group that requires join approval

Thats not a feature of normal orgranic groups, or?

Comment #2

caschbre commented 30 January 2010 at 12:53

Sure, I can help test the fix. Would it be possible for you to post what changes were made and I'll apply those directly? That way I won't have to worry about other changes that are in the dev version.

1) Site admin creates a new group that requires join approval = Membership requests: Moderated - membership requests must be approved.