search by user and keywords together is broken
Sep 10, 2023 | 7:56 am
#1
Original Poster
Moderator: Hyatt, American Express; FlyerTalk Evangelist
Join Date: Jun 2015
Location: WAS
Programs: :rolleyes:, DL DM, AA EXP, UA Silver, Hyatt Glob, Mlife Noir (=> Marriott Amb), invol FT beta tester
Posts: 21,643
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.
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.
Sep 10, 2023 | 10:24 am
#2
FlyerTalk Evangelist
Join Date: Nov 2009
Location: SEA the REAL Washington; occasionally in the other Washington (DCA area)
Programs: AS MVPG 100K (Atmos Titanium) / 0.5MM; DL fallen PM (1.58MM = Complimentary Annual GM); AA Gold
Posts: 24,441
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”
Sep 10, 2023 | 10:31 am
#3
Original Poster
Moderator: Hyatt, American Express; FlyerTalk Evangelist
Join Date: Jun 2015
Location: WAS
Programs: :rolleyes:, DL DM, AA EXP, UA Silver, Hyatt Glob, Mlife Noir (=> Marriott Amb), invol FT beta tester
Posts: 21,643
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.
