FlyerTalk Forums

FlyerTalk Forums (https://www.flyertalk.com/forum/index.php)
-   Technical Support and Feedback (https://www.flyertalk.com/forum/technical-support-feedback-386/)
-   -   search by user and keywords together is broken (https://www.flyertalk.com/forum/technical-support-feedback/2134703-search-user-keywords-together-broken.html)

Zorak Sep 10, 2023 7:56 am

search by user and keywords together is broken
 
From the advanced search page: https://www.flyertalk.com/forum/search.php

If I do a keyword search for "skypesos" it works

If I do a username search for "zorak" it works

If I try to keyword search "skypesos" and username "zorak" at the same time I get the database error page

Just an example; the problem does not seem tied to either that specific term or my username. The issue also occurs whether you are doing a site-wide search, forum-specific search, or even thread search e.g. https://www.flyertalk.com/forum/sear...readid=2056973

Guessing that whatever code takes the form inputs and composes the underlying database query is generating syntactically-invalid SQL or something when multiple terms are involved.

https://cimg2.ibsrv.net/gimg/www.fly...96746ae8a6.jpg

jrl767 Sep 10, 2023 10:24 am

did you try it with a date constraint? I had similar result last week, edited my original long search phrase to two?three? keywords, but got several accurate responses when I also included “a year ago and earlier”

Zorak Sep 10, 2023 10:31 am


Originally Posted by jrl767 (Post 35568186)
did you try it with a date constraint? I had similar result last week, edited my original long search phrase to two?three? keywords, but got several accurate responses when I also included “a year ago and earlier”

Interesting idea (i.e. if the issue is that the search "space" is too large), but tried it just now and it doesn't help.

IBJoel Sep 11, 2023 9:31 am

May have been reported as an issue on other sites by IBKatherine. I'll round up with her and tech

anrkitec Sep 18, 2023 7:26 pm

Any news?

IBJoel Sep 19, 2023 10:34 am


Originally Posted by anrkitec (Post 35592728)
Any news?

I just got a note today that it's in progress. I don't know why it's taking so long. We may have had a tech worker out on PTO

Zorak Sep 26, 2023 9:09 pm

Looks like this is fixed now :tu:


All times are GMT -6. The time now is 7:00 am.


This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.