Bugfix: JomSocial – Group Invitations don’t send

Jomsocial 2.2 for Joomla!

Symptom:

When clicking Send Invitations, nothing happens

Cause:

AJAX request returns a Joomla! 500 Internal Server Error:

DB function failed with error number 1064
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 ‘creator=’67’ WHERE groupid=’97’ AND userid=’5417” at line 1
SQL=UPDATE jos_community_groups_invite SET groupid=’97’, userid=’5417′ creator=’67’ WHERE groupid=’97’ AND userid=’5417′

This is an obvious and very basic SQL syntax error – there is no comma after userid=’5417′

JomSocial’s AJAX error handling is… somewhat lacking – it simply fails to respond to most errors, including the dreaded ‘Invalid Token’ Joomla! error, meaning the user has no idea that an error has even occurred, and leaving them ill equipped to report problems.

Solution:

componentscom_communitytablesgroupinvite.php

89c89< . $db->nameQuote( 'userid' ) . '=' . $db->Quote( $this->userid ) . ' '---> . $db->nameQuote( 'userid' ) . '=' . $db->Quote( $this->userid ) . ','

(Unix diff formatting)

Leave a Reply

Your email address will not be published. Required fields are marked *