FlyerTalk Forums - View Single Post - search by user and keywords together is broken
Old Sep 10, 2023 | 7:56 am
  #1  
Zorak
Moderator: Hyatt, American Express; FlyerTalk Evangelist
Community Builder
Active Streak: 30 Days
All eyes on you!
10 Years on Site
 
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,648
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.

Zorak is offline