Skip to Content Skip to Menu

[SOLVED] Bug in search plugin

  • fribse2011
  • fribse2011
  • OFFLINE
  • Posts: 921
  • Thanks: 79
  • Karma: 8
9 years 11 months ago - 9 years 11 months ago #252480 by fribse2011
[SOLVED] Bug in search plugin was created by fribse2011
Using the exclude function in search plugin works if I only enter one UserID.
If I enter two, I see this message:
Code:
1241 - Operand should contain 1 column(s) SQL=SELECT u.* FROM kef_users AS u LEFT JOIN kef_comprofiler AS ue ON u.id = ue.id WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND (((u.`name` LIKE '%dkdb%')) OR ((u.`username` LIKE '%dkdb%'))) AND u.block = 0 AND ue.banned = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND u.id NOT IN ( (17, 60) ) ORDER BY u.registerDate DESC LIMIT 0, 50
Best regards
Fribse

Frømandsklubben Nikon, www.nikondyk.dk
We're a volunteer driven diving club in Ishøj, Denmark.
Har du brug for en dykkerklub der rummer alle, så kom ned til os.
Last edit: 9 years 11 months ago by fribse2011.

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

  • krileon
  • krileon
  • ONLINE
  • Posts: 48482
  • Thanks: 8283
  • Karma: 1443
9 years 11 months ago #252508 by krileon
Replied by krileon on topic Bug in search plugin
Looks like double brackets. Fixing for CB Search Bot 2.0.2 release today.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

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

  • fribse2011
  • fribse2011
  • OFFLINE
  • Posts: 921
  • Thanks: 79
  • Karma: 8
9 years 11 months ago #252535 by fribse2011
Replied by fribse2011 on topic Bug in search plugin
And that made it work, could you maybe correct the typo on the website, it's sort of annoying when searching :-)

Best regards
Fribse

Frømandsklubben Nikon, www.nikondyk.dk
We're a volunteer driven diving club in Ishøj, Denmark.
Har du brug for en dykkerklub der rummer alle, så kom ned til os.
Attachments:
The following user(s) said Thank You: krileon

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

  • nant
  • nant
  • OFFLINE
  • Posts: 12339
  • Thanks: 1467
  • Karma: 877
9 years 11 months ago #252538 by nant
Replied by nant on topic Bug in search plugin

fribse2011 wrote: And that made it work, could you maybe correct the typo on the website, it's sort of annoying when searching :-)


Fixed - tanks for reporting!
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting

Visit my CB Profile - Send me a Private Message (PM)

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

Moderators: beat, nant, krileon
Powered by Kunena Forum