Notice

The forum is in read only mode.

Support Forum

Welcome! Support Forums have been reactivated
Welcome the Technical Support section. Help us in assisting you by providing us with a concise and descriptive elaboration of your issues. Be specific and if possible, provide us with a step-by-step instruction in replicating your problem.

Error: 1064 after upgrade

10 years 11 months ago
  • Kane's Avatar
    Topic Author
  • Kane
  • Offline
  • Fresh Boarder
  • Posts: 21
  • Thank you received: 0
Licenses:
JomSocial Expired

Joomla 3.3.0
JS 3.2.0.5


Had login/out issue after joomla upgrade. Found that JS upgrade fixed issue so upgraded, now jomsocial home has following error:

Error: 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 'GROUP BY `groupid`' at line 1 SQL=SELECT `groupid` FROM `iamme_community_groups_members` WHERE `approved` = 1 AND `memberid` = GROUP BY `groupid`

*PLEASE HELP ASAP SITE IS DOWN.*
I currently have groups disabled.

Attachment ScreenShot2014-05-22at9.52.34PM.png not found

Attachments:
10 years 11 months ago
  • Dimas Tekad Santosa's Avatar
  • Dimas Tekad Santosa
  • Visitor
  • Thank you received: 0
Licenses:

Hi,

I just replicated login to your site and seems everything is working fine, this issue caused by old jomsocial version and Joomla 3.3, but it already fixed in newest version 3.2.0.5

10 years 11 months ago
  • Kane's Avatar
    Topic Author
  • Kane
  • Offline
  • Fresh Boarder
  • Posts: 21
  • Thank you received: 0
Licenses:
JomSocial Expired

I appreciate the fix. I am now finding 4 other issues.

1. when avatar is uploaded on profile, the crop frame is off the popup.
2. Even though upload avatar user point is disabled, it is still showing in activity stream.
3. The activity stream shows a broken link to uploaded avatar image.
4. Super Users are unable to delete activity from the stream on the front end and must use monitor on backend to remove.

All of these issues occurred since last upgrade. I have included images.
********************

Attachment ScreenShot2014-05-23at12.25.52AM.png not found


********************

Attachment ScreenShot2014-05-23at9.51.28AM.png not found


********************

Attachment ScreenShot2014-05-23at9.52.07AM.png not found

Attachments:
10 years 11 months ago
  • Dimas Tekad Santosa's Avatar
  • Dimas Tekad Santosa
  • Visitor
  • Thank you received: 0
Licenses:

Hi Kane,

Most of your isssue caused by 3rd party joomla template.. anyway can you try to create new topic for each issue, please? so we can focus to each issue as well.

thank you

Moderators: Piotr Garasiński
Powered by Kunena Forum

Join 180,000 websites creating Amazing communities

JomSocial is the most complete, easy-to-use addon that turns Joomla CMS into a
full -fledged, social networking site

TRY NOW BUY NOW