By Peter McLeland on Wednesday, 21 August 2019
Posted in Technical Issues
Replies 3
Likes 0
Views 1.7K
Votes 0
Have just updated to ED 4.1.11 and get the following error when posting a new topic

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 ') AND `sendEmail` = '1'' at line 1

Can you help please?
Hm, it seems like this will be the similar issue from what you facing on Easysocial. https://stackideas.com/forums/previous-fix-not-working-on-update-to-es-3-1-4#reply-467410

I did added this code from this file on your site JoomlaFolder/administrator/components/com_easydiscuss/includes/easydiscuss.php :


if (!$saGroup) {
$obj = new stdClass();
$obj->id = 8;

$saGroup[] = $obj;
}


It should work fine now.

By the way, if you do not want to notify those email notification to your site admin then you can disable these setting https://take.ms/Xd1mp so it will not trying to find your site admin account.
·
Wednesday, 21 August 2019 17:41
·
0 Likes
·
0 Votes
·
0 Comments
·
I thought I had added that modified code after updating... but maybe not.

Thank you very much
·
Wednesday, 21 August 2019 18:25
·
0 Likes
·
0 Votes
·
0 Comments
·
Oh actually that thread what I mentioned to is under Easysocial.

What I modify that file is under Easydiscuss component, is it you needed to send notification to your site admin when someone publish a new discussion or reply on your site?
·
Wednesday, 21 August 2019 18:43
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post