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 When Profile Clicked on Toolbar

11 years 5 days ago
  • Jim's Avatar
    Topic Author
  • Jim
  • Offline
  • Fresh Boarder
  • Posts: 40
  • Thank you received: 1
Licenses:
JomSocial Active Socialize Expired

When I click Profile I get the following 1064 message and the login dialog pops up:

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 `x9fa2_community_groups_members` WHERE `approved` = 1 AND `memberid` = GROUP BY `groupid`

Using JomSocial 3.2.0.2 on Joomla 3.3.0

11 years 5 days ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hello Jim

we are looking into this.
please be advised that Joomla 3.3 has only been released few hours ago.
You should never install extension that has been released before without proper testing.

- Don't say feature not working. Instead, explain what you tried and what was the outcome.
- When you think you found the bug, try to replicate it on a fresh Joomla.
- When looking for support always provide temporary Super Administrative access to your site. We will ask for it anyway.
- Help yourself and read documentation which can give you answers to almost all questions you may have
The following user(s) said Thank You: Eva
11 years 5 days ago
  • Jim's Avatar
    Topic Author
  • Jim
  • Offline
  • Fresh Boarder
  • Posts: 40
  • Thank you received: 1
Licenses:
JomSocial Active Socialize Expired

For your information, before installing JomSocial 3.2.0.2 on my live site, I installed JomSocial 3.2.0.2 on my local server (xampp) running Joomla 3.3 and it is currently running with NO ERRORS. When I login, NO ERRORS. When I click anything on the toolbar, Profile, etc., NO ERRORS.

I always test before upgrading.

11 years 5 days ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Jim

Joomla changed something with sessions.
try to post a status on your localhost and then click on any toolbar item.

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 `x9fa2_community_groups_members` WHERE `approved` = 1 AND `memberid` = GROUP BY `groupid`
This error clearly says that "memberid" is missing and we confirmed this as a bug.
The patch will be provided later today and your patience with this issue is appreaciated.

- Don't say feature not working. Instead, explain what you tried and what was the outcome.
- When you think you found the bug, try to replicate it on a fresh Joomla.
- When looking for support always provide temporary Super Administrative access to your site. We will ask for it anyway.
- Help yourself and read documentation which can give you answers to almost all questions you may have
The following user(s) said Thank You: Pete Ward
11 years 5 days ago
Licenses:
JomSocial Active GURU Active Publisher Active AdAgency Active iSEO Active Socialize Active

Hello

Can you try to apply this patch and see if it works?

This attachment is hidden for guests.
Please log in or register to see it.

- Don't say feature not working. Instead, explain what you tried and what was the outcome.
- When you think you found the bug, try to replicate it on a fresh Joomla.
- When looking for support always provide temporary Super Administrative access to your site. We will ask for it anyway.
- Help yourself and read documentation which can give you answers to almost all questions you may have

This message has an attachment file.
Please log in or register to see it.

11 years 5 days ago
  • Jim's Avatar
    Topic Author
  • Jim
  • Offline
  • Fresh Boarder
  • Posts: 40
  • Thank you received: 1
Licenses:
JomSocial Active Socialize Expired

I applied the patch. Now when I log in I get these two messages:

Message
Login Successful.

Error
Sorry, User ID not found.

The only thing that displays is the Toolbar.

11 years 5 days ago
  • Jim's Avatar
    Topic Author
  • Jim
  • Offline
  • Fresh Boarder
  • Posts: 40
  • Thank you received: 1
Licenses:
JomSocial Active Socialize Expired

Success with JomSocial 3.2.0.3

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

About Us

Our product

Support

Contact Us

Site Policies

Elsewhere

© JomSocial.com All Rights Reserved