I recently got the error message below on my site and am trying to figure out why
“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 ‘AND product_status=1 AND (1285119555 BETWEEN product_starting_date AND product_c’ at line 1”
Can anyone provide any potential reasons why this is occurring?
The error message tells you quite clearly you have a syntax error in your query.
But if you don’t post the actual query that you are running in its entirety, I would be only guessing as to what you have done wrong.
You didn’t say in your first post that it was working correctly previously.
Regarding sql injection - have you checked if your query is vulnerable to sql injection because I can’t tell if it is or isn’t without seeing the code that creates and runs the query.
I realize it is a syntax problem, im trying to figure out why it has occured… since it was working fine the other day and I didnt make any changes…
Could it be a SQL injection/attack or what are the possible reasons this error just decides to pop up?
any particular reason why you cannot show the entire query?