A PHP Error was encountered

Severity: Warning

Message: Creating default object from empty value

Filename: libraries/REST_Controller.php

Line Number: 37

A PHP Error was encountered

Severity: Warning

Message: Cannot modify header information - headers already sent by (output started at /home/infohost/rest/system/libraries/Exceptions.php:166)

Filename: codeigniter/Common.php

Line Number: 356

Database Error

A Database Error Occurred

Error Number: 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 'and OCCURRED<= and BEAT='' GROUP BY CrimePoints.BEAT' at line 3

SELECT CrimePoints.BEAT, Sum(CrimePoints.Violence) AS Violence, Sum(CrimePoints.Property) AS Property, Sum(CrimePoints.Homicide) AS Homicide, Sum(CrimePoints.Assaults) AS Assaults, Sum(CrimePoints.Robbery) AS Robbery, Sum(CrimePoints.Burglary) AS Burglary, Sum(CrimePoints.Rape) AS Rape, Sum(CrimePoints.Weapons) AS Weapons, Sum(CrimePoints.Drugs) AS Drugs, Sum(CrimePoints.Sex) AS Sex FROM CrimePoints WHERE OCCURRED>= and OCCURRED<= and BEAT='' GROUP BY CrimePoints.BEAT;