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:

Hi There,

this is valid bug for jomsocial for advance search with checkbox value. please wait out fixes.

Regards,
Albert

12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
OK. Let us know when it will be fixed.
Cheers,
L

12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
any news ?
Cheers,
L

12 years 5 months ago
  • Chris's Avatar
  • Chris
  • Visitor
  • Thank you received: 0
Licenses:

Hi there.

Please extract those files here > \components\com_community\models\search.php(it'll be included into our next installation package)

And then check the issue once again, it should fix the problem. If not, please let us know and we'll look into this once again.

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

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,
we've tested the fix.
First we don't get anymore the MySql error: 1064. That's good.
But we've got the following problem:
1 - login as julien with password as described for JSupport
2 - click on Advance search ("Amis" / "Recherche avancée")
3 - Select first criteria on "Vous êtes ici" (you're here for) check "Trouver des ami(e)s"
4 - Select second criteria on "Sexe" "Egal" "Homme"
5 - click on search: The second criteria disappear. It shouldn't.
6 - If we add a third, a fourth, a fifth, criteria, same behavior they disappear too, so we've got only the first criteria displayed.

Concerning criteria with check values:
Are the results based on "OR" between the different values or are they based on "AND"
Cheers,
L

12 years 5 months ago
Licenses:

Hi,

sorry the issue not well tested yet.
no error any more, but still have bug at form criteria. missing after submit.

please wait our fixes

Regards,
Albert

12 years 5 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
OK, waiting your next fix.
What's about our last question ?:
Concerning criteria with check values:
Are the results based on "OR" between the different values or are they based on "AND"
Cheers,
L

12 years 4 months ago
Licenses:

Hi,

the result based on "AND".
FYI: the issue ticket still in the queue, sorry for the waiting.

Regards,
Albert

12 years 4 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
if result is based on "AND" there is another issue. We've results based on "OR".
1 - login as julien with password as described for JSupport
2 - click on Advance search ("Amis" / "Recherche avancée")
3 - Select first criteria on "Vous êtes ici" (you're here for) check both values "Trouver des ami(e)s", "Trouver l'amour"
Results are users with either first value or the second value.heers,
L
C

12 years 4 months ago
  • Paul's Avatar
  • Paul
  • Visitor
  • Thank you received: 0
Licenses:

Hi SAS Coeurs de Breizh,

The bug report for advanced search has now been fixed, I have attached the files that have been changed . This fix will also be included in the next release.

To apply the fix please extract the zip file and replace the 2 files
components/com_community/templates/default/search.advancesearch.php
components/com_community/views/search/view.html.php

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


Please take a backup of the original files in case they need to be restored. Please let me know if this fixes the issue for you

Have a great day

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

12 years 4 months ago
Licenses:
JomSocial Expired Socialize Expired

Hi,
Great, almost fixed !
- concerning the criteria with checked values:
1 - the values selected are unchecked when search results are displayed. We should keep the values selected
2 - Search results are based on "OR" between the checked values not on "AND"

Cheers,
L

12 years 4 months ago
Licenses:

Hi.

We have not received any response back from you in over 7 days, and would like to know if you consider this issue to be resolved. If you have any further questions, simply reply to this post.


- 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 4 months ago
Licenses:
JomSocial Expired Socialize Expired

Concerning the criteria with checked values:
- Search results are based on "OR" between the checked values not on "AND"

12 years 4 months ago
Licenses:

Hi There,

Our developer confirmed, the search result for checkbox values based on "OR". and non checkbox value based on "AND".
That the right way for the query.

Regards,
Albert

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