JHotelReservation Forum - Error 1064 - SQL Sintax error when going to the payment page.

Hi all forum members,

I notice an error when try to confirm a reservation, error noticed is this:

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 '' at line 7 SQL=select hcr.room_id, c.start_date, c.end_date from grandhotel_hotelreservation_confirmations_rooms hcr left join grandhotel_hotelreservation_confirmations c on c.confirmation_id= hcr.confirmation_id where (c.start_date <'2014-09-17' and c.end_date >='2014-09-15') and c.reservation_status <> 2 and c.confirmation_id <> 0 and c.hotel_id =

anyone can help?

tnks in advance,

cheers from italy :) 

Hi Maurizio, 

This ussually happens when the session expires. We'll handle this in the next release. 

Let us know if this happens on a regular basis. 

Hi Mike tnks for your reply,

No it doesn't happens on a regular basis, it happens only on spare time :)