SQL error each time I create a group
By Tim Ryan on Tuesday, 07 April 2015
Posted in Technical Issues
Replies 5
Likes 0
Views 434
Votes 0
This error appears to crop up each time I create a group.

An error has occurred.

 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 ')' at line 1 SQL=UPDATE qqlxb_social_clusters SET `type` = '3' WHERE `id` IN ()

 Return to Control Panel


The group is created, but I can't add avatar images or backgrounds.
Hello Tim,

Actually it is a correct behavior when you upgrading easysocial from old version to the latest. You can just proceed with the installation and the rest should working properly
Ezrul Fazwan
·
Wednesday, 08 April 2015 17:55
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Tim,

I am sorry for the delay of this reply.

It seems like you are using older version of easysocial. This is actually a known issue and already being fixed in our latest version of easysocial. Perhaps you might want to update your easysocial version to the latest version and see if the problem solve.

If you do not want to upgrade your easysocial to the latest version, kindly download the attachment below and place it inside your /media/com_easysocial/apps/fields/group/type
Ezrul Fazwan
·
Wednesday, 08 April 2015 12:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you.

I think I may have made a mistake whilst upgrading. I went and downloaded the latest launcher and uploaded that package and now when I go to EasySocial I am being prompted to "install" it. Is there anything I can do to fix this?
Tim Ryan
·
Wednesday, 08 April 2015 17:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Excellent. I think the language used was slightly misleading.

Thanks for all your help, it's successfully upgraded now and I no longer have the problem with adding groups.
Tim Ryan
·
Wednesday, 08 April 2015 18:07
·
0 Likes
·
0 Votes
·
0 Comments
·
HI Tim,

Thanks for updating us back. I am glad to hear your issue is now resolved.

Have a nice day.
Yasser Ibrahim
·
Wednesday, 08 April 2015 20:33
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post