search

magneticstain / CLTools

An application that utilizes and analyzes CraigsList data to help find the perfect apartment.
MIT License
2 stars 2 forks source link

Search String Option in CLData/Calc Failing #26

Closed magneticstain closed 7 years ago

magneticstain commented 7 years ago

Running an API request to CLData/Calc using the s param for a search query results in a blank response.

magneticstain commented 7 years ago 
==> /opt/privypaste/logs/web-errors.log <==
[Sun Jan 08 13:18:58.297081 2017] [:error] [pid 18593] [client 209.6.132.198:56598] CLTools :: CLData - CALC :: [ SEV: CRIT ] :: could not perform calculation :: [ MSG: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%?%)\n\t\t\t\t\t\t\tOR location like (%?%)\n\t\t\t\t\t\t\tor name like (%?%)\n\t\t\t\t\t\t)\n\t\t\t\t\t\tGROUP' at line 9 ]

==> /opt/privypaste/logs/web-access_log <==
209.6.132.198 - - [08/Jan/2017:13:18:58 -0500] "GET /CLTools/CLData/api/v1/calc/?m=count&f=location&o=desc&l=1&s=New HTTP/1.1" 400 3757 "-" "Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/55.0.2883.87 Safari/537.36"