Advertisement:

Author Topic: Search error, minus sign + 'by user'  (Read 155 times)

Offline a10

  • Charter Member
  • Sr. Member
  • *
  • Posts: 927
Search error, minus sign + 'by user'
« on: January 14, 2020, 08:36:40 AM »
Using the minus sign (-wordxyz) together with a 'by user' produces this error. OK with no 'by user'.
I think I've seen this long time ago, so probably not related to recent updates etc. No index.

Not unique table/alias: 'm'
File: /customers/1/xyz/httpd.www/forum/Sources/Search.php
Line: 1352

Note: It appears that your database may require an upgrade. Your forum's files are currently at version SMF 2.0.17, while your database is at version 2.0.7. The above error might possibly go away if you execute the latest version of upgrade.php.
2.0.17, ssl, php 7.3.13, 10.3.21-MariaDB
Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown, Add Join Date to Post.

Offline Looking

  • SMF Hero
  • ******
  • Posts: 2,417
  • SMF Customization
    • jeanborde on Facebook
    • SMF Custom Themes & Custom Coding
Re: Search error, minus sign + 'by user'
« Reply #1 on: January 14, 2020, 10:33:06 AM »
I tested that on this site and another SMF site and only got:

"Did you forget to put something to search for?"

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,838
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Search error, minus sign + 'by user'
« Reply #2 on: January 14, 2020, 10:56:18 AM »
I have this tracked internally as an issue already. Internal bug track id #71
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline a10

  • Charter Member
  • Sr. Member
  • *
  • Posts: 927
Re: Search error, minus sign + 'by user'
« Reply #3 on: January 14, 2020, 11:02:08 AM »
1st enter what one searches for. Then add -whatever to be omitted from results.
Example: forum -search

ok, so it's already 'bugged' :O)
Thanks
2.0.17, ssl, php 7.3.13, 10.3.21-MariaDB
Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown, Add Join Date to Post.