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.

MySql error: 1064

12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
Joomla : v3.3.0
JomSocial:v3.2.0.3
Socialize:v1.2.7
Got this error, see attached file, on advance search module. Steps to reproduce it:
1 - login as julien with password as described for JSupport
2 - click on Advance search ("Amis" / "Recherche avancée")
3 - Select first criteria on sexe "Homme"
4 - Select second criteria on "Vous êtes ici" (you're here for) check "Trouver des ami(e)s"
5 - click on search: It works.
6 - Change sex criteria from "Homme" to "Femme"
7 - Click on search: Got the MySql error


Cheers,
L

Attachments:
12 years 5 months ago
Licenses:

Hi.

We have search options on forum... try to use and you'll find solutions for most of your issues.
I posted fix already ;)
I post it again for you.

- 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

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

12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
is your fix add, also, the one in relation with:
www.jomsocial.com/forum/installation/160...with-id-errors/81270
Because I got this one too, and I've set this fix.
Cheers,
L

12 years 5 months ago
Licenses:

Hi.

Yes, it should fix it also.

- 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
12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
we've applied the fix, but we still have the same issue regarding the MySql error: 1064
Cheers,
L

12 years 5 months ago
Licenses:

Hi.

Please, upgrade to current JomSocial version -> 3.2.0.4 and check if issue still 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
12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
we've just upgraded to v3.2.0.4, unfortunately problem still there.
It seems related to a specific criteria: "Vous êtes ici pour". So in order to reproduce the issue:
Login as julien then click on "Amis/Recherche avancée".
First criteria "Vous êtes ici pour" equal check "Trouver des ami(e)s" click "Rechercher", it works.
Add another criteria sex equal "Homme" click "Rechercher", got the MySql error 1064, if not just change criteria sex to "Femme" and you will get the error.
Cheers,
L

12 years 5 months ago
Licenses:

Hi.

It could be connected with gender issue fix.
So please try this:

1. Edit user in JomSocial backend
2. Change gender to opposite (if was Male change to Female)
3. Save
4. Change it back
5. Save
6. Check 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
12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
done your recommendations, unfortunately MySql error still there.
To reproduce it just follow my steps in my previous post.
Cheers,
L

12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

hi,
have a look on the following link:
www.screencast.com/t/OmrpXQC0SFm
Cheers,
L

12 years 5 months ago
Licenses:

Hi.

I was able to reproduce it on your site.
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
12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
OK; Waiting your feedback.
Cheers,
L

12 years 5 months ago
Licenses:

Hi,

please provide me your cpanel/phpmyadmin access detail. I must debugging your DB related with this issue.

Regards,
Albert

12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
cpane access details have been set in my previous post.
cheers,
L

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