Is it a PHP scripts' problem or it comes from RoR:
New contract
Create a new contract. Please fill in all required data.
Mysql::Error: 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 ? < departure) || (arrival < ? AND ? < departure) || (? < arrival && ? > ' at line 1: SELECT count(room_id = '?' && ((arrival < ? AND ? < departure) || (arrival < ? AND ? < departure) || (? < arrival && ? > departure))32008-04-292008-04-292009-04-292009-04-292008-04-292009-04-29) AS count_room_id_arrival_and_departure_arrival_and_departure_arrival_departure_3_2008_04_29_2008_04_29_2009_04_29_2009_04_29_2008_04_29_2009_04_29 FROM `contracts`
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I don't remember if I tried that using the PHP client or through RoR.
It wasn't through the "Create a new contract" button in the back end, that's what I am quite sure about.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Is it a PHP scripts' problem or it comes from RoR:
New contract
Create a new contract. Please fill in all required data.
Mysql::Error: 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 ? < departure) || (arrival < ? AND ? < departure) || (? < arrival && ? > ' at line 1: SELECT count(room_id = '?' && ((arrival < ? AND ? < departure) || (arrival < ? AND ? < departure) || (? < arrival && ? > departure))32008-04-292008-04-292009-04-292009-04-292008-04-292009-04-29) AS count_room_id_arrival_and_departure_arrival_and_departure_arrival_departure_3_2008_04_29_2008_04_29_2009_04_29_2009_04_29_2008_04_29_2009_04_29 FROM `contracts`
I don't remember if I tried that using the PHP client or through RoR.
It wasn't through the "Create a new contract" button in the back end, that's what I am quite sure about.