Solunas Hotel Booking Engine

Tracker: Bugs

4 Reservations in the past - ID: 2750806

Last Update: Comment added ( tschlabach )

Details:

Trying to make a reservation for the past (arrival date prior to today's
date) leads to an unpleasant error message.

Submitted:

Torsten Schlabach ( tschlabach ) - 2009-04-10 18:52

Priority:

Status:

Open

Resolution:

None

Assigned:

Nobody/Anonymous

Category:

PHP client

Group:

None

Visibility:

Public

Comments ( 2 )

Date: 2009-04-29 13:10 Sender: tschlabach 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.
Date: 2009-04-29 12:43 Sender: nobody 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`

Date: 2009-04-29 13:10
Sender: tschlabach

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.

Date: 2009-04-29 12:43
Sender: nobody

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`

Solunas Hotel Booking Engine

Tracker: Bugs

Comments ( 2 )

Log in to comment.

Attached File

No Files Currently Attached

Change

No changes have been made to this artifact.

About SourceForge

Find Software

Develop Software

Community

Help