Mention if you're using this component with CB, EasySocial or Jomsocial

sql error

More
5 years 7 months ago - 5 years 7 months ago #42105 by michaelg252
Replied by michaelg252 on topic sql error
hey adrian im sorry but im having another sql error...it happens when i click the clear button at the top of the page in the search area...and also when i click the hides link and the date link when there are no hides or dates available....and i did not get this error when i clicked the down link because i had 1 down available for viewing...

0 - 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 'AND age<= AND distance<=0 AND ishide IS NULL ORDER BY distance ASC, age ASC ' at line 12 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 'AND age<= AND distance<=0 AND ishide IS NULL ORDER BY distance ASC, age ASC' at line 12

This message contains confidential information

thanks adrian...
Last edit: 5 years 7 months ago by michaelg252.

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #42111 by nordmograph
Replied by nordmograph on topic sql error
Have you set the Do your profiles have a DOB field?
This is required.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #42116 by michaelg252
Replied by michaelg252 on topic sql error
yes i have it and its set up in dd

Attachments:

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #42133 by michaelg252
Replied by michaelg252 on topic sql error
Hey didnt want you to overlook thus one as it says solved..please see my previous post. My clear search button returns a sql error posted in the previous post and i have the dob field set...any idea how to resolve this. Thanks again adrian

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #42138 by nordmograph
Replied by nordmograph on topic sql error
Hey,
Not sure why this is tagged as solved. I'm looking into this right now. Definitely not solved yet.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

Please Log in or Create an account to join the conversation.

More
5 years 7 months ago #42139 by nordmograph
Replied by nordmograph on topic sql error
Can you download 1.1.13, it should fix the error.
Let me know.

- Need help? Post the URL of the related page (eventualy as confidential info), it will help solve your issue faster.
- An error, notice or warning? report the exact message including the line number
- If you get a white page , enable error reporting and / or check your server error logs.

Please Log in or Create an account to join the conversation.

Time to create page: 0.370 seconds
Powered by Kunena Forum
Disclaimer: Nordmograph is not affiliated with or endorsed by The Joomla! Project™. Any products and services provided through this site are not supported or warrantied by The Joomla! Project or Open Source Matters, Inc. Use of the Joomla!® name, symbol, logo and related trademarks is permitted under a limited license granted by Open Source Matters, Inc.