Database Error

Error: 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 ') AND Period.id=19 AND Unit.start<=Period.end AND Unit.end>=Period.start ORDER B' at line 1

SQL Query: SELECT DISTINCT Unit.*, UnitType.unit_type FROM periods AS Period, unit_types AS UnitType INNER JOIN (cities_units INNER JOIN units AS Unit ON cities_units.unit_id = Unit.id) ON UnitType.id = Unit.unit_type_id WHERE cities_units.city_id IN () AND Period.id=19 AND Unit.start<=Period.end AND Unit.end>=Period.start ORDER BY Unit.start, Unit.end;

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

Notice (8): Undefined property: View::$Js [CORE/Cake/View/View.php, line 804]

Fatal error: Call to a member function writeBuffer() on null in /home/clients/74c43d8ac986b47945c887bbbf8914c8/web/app/View/Layouts/default.ctp on line 104