Forum: Community Center


Subject: FreeStuff search apparently is not working

ronknights opened this issue on Jun 21, 2002 ยท 3 posts


ronknights posted Fri, 21 June 2002 at 7:50 AM

Yesterday I did a search for "eyelash eyebrow" transmaps, and found Newt's stuff. I posted the info for someone who needed it. Now the search won't work at all. We get this error message which I like to translate as "programming or web master error:" (The clue to me is when it mentions SQL....etc) We'd appreciate your assistance here. "SQL Query Error: You have an error in your SQL syntax near '??? AND bIsStandAlone = ??? ORDER BY uplo' at line 19 Query was: SELECT freestuff.*, freestufftopsection.name AS topname FROM freestuff LEFT JOIN freestufftopsection ON freestuff.topsectionid = freestufftopsection.sectionid WHERE (freestuff.name LIKE '%newt%' OR UCASE(author) LIKE UCASE('%newt%') OR notes LIKE '%newt%') AND bIsCommercial = ??? AND bIsStandAlone = ??? ORDER BY uploadedon DESC Sorry, but no files match your search"


audre posted Wed, 26 June 2002 at 6:56 PM

pretty sure this has been fixed.


ronknights posted Wed, 26 June 2002 at 10:10 PM

It most certainly has. But I posted that message 5 days ago. Message671414.jpg