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 after upgrade: 1064 - You have an error in your SQL syntax

9 years 7 months ago
Licenses:
JomSocial Active

Dear support team,

I upgraded JomSocial from version 3.1.0.4 to 3.2.1.4 but now get an error message:

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

Could you please send me a step by step guide how to solve the issue?

Your quick response will be appreciated!

Many thanks,
Alex

9 years 7 months ago
Licenses:

Hi, Alexander.

Please, read this topic: www.jomsocial.com/forum/installation/18192-error-1064#92633

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
9 years 7 months ago
Licenses:
JomSocial Active

Hi Michael,

Thanks a lot for your quick response.

I run the query after replacing the database suffix (2 places), and got en empty result.

Is that good or bad?
Many thanks,
Alex

9 years 7 months ago
Licenses:

Hi, Alexander.

It's good. Try now if issue persist.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
9 years 7 months ago
Licenses:
JomSocial Active

Sorry I should have added that I tested the community link immediately, but it gives exactly the same error.

What else can we do to solve the issue?
Many thanks,
Alex

9 years 7 months ago
Licenses:

Hi, Alexander.

I assign developer to this thread.

- Instead of saying: 'it's not working', explain the problem in detail.
- Screenshots with the URL visible in them and the problem marked are more than welcome.
- Tell us how to replicate the problem, we can't fix it if we can't find it.
- Make sure that your site/server meets JomSocial System Requirements
- Make sure to setup JomSocial Cron Job
- Always provide us with access details to the backend and ftp. We need it to debug problems.
- If you have a similar problem, but a solution you found isn't working, open a new thread instead of 'merging' with an existing one.

- Use the "Thank You" feature on any post that helped you
The following user(s) said Thank You: Alexander
9 years 7 months ago
Licenses:
JomSocial Active

Super, thank you Michael!
I am standby to discus or provide access when needed.
Alex

9 years 7 months ago
Licenses:

Hi ALexander,

I think this issue related with:
www.jomsocial.com/forum/installation/18192-error-1064#92633

here the steps:
1. open phpmyadmin
2. backup xxxx_community_groups
3. execute this query

SELECT `member`.groupid, `group`.id 
FROM `wottide_community_groups_members` AS `member` LEFT JOIN `xxxx_community_groups` AS `group` ON (`member`.groupid = `group`.id ) WHERE `group`.id IS NULL
4. if the result not empty. delete it.


Regards,
Albert

The following user(s) said Thank You: Alexander
9 years 7 months ago
Licenses:
JomSocial Active

Fantastic, that worked!!

The result was empty and the community pages loaded again without errors.

Thanks very much for your help, Albertus and Michal!
Alex

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