• Welcome to Simple Machines Community Forum. Please login or sign up.
December 03, 2021, 05:06:13 PM

News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord


Search error, minus sign + 'by user'

Started by a10, January 14, 2020, 08:36:40 AM

Previous topic - Next topic

a10

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.18, php 7.4.25, MariaDB 10.3.30. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown, Add Join Date to Post.

Looking

I tested that on this site and another SMF site and only got:

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

vbgamer45

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

a10

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.18, php 7.4.25, MariaDB 10.3.30. Mods: Contact Page, Like Posts, Responsive Curve, Search Focus Dropdown, Add Join Date to Post.

Advertisement: