When I try to access to (admin/reservations/manage/add) I recieve the following Database Error Connexion:

PDOException: 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 'AS field_reservations_date_value, AS field_reservations_date_value2 , md.reserv' at line 1: SELECT ct.entity_id as nid, AS field_reservations_date_value, AS field_reservations_date_value2 , md.reservations_item_nid FROM {} ct INNER JOIN {reservations_reservation_detail} md on ct.revision_id = md.vid INNER JOIN {reservations_resource_node} m on md.reservations_placeholder_nid = m.nid INNER JOIN {node} ctn on ct.revision_id = ctn.vid INNER JOIN {node} mn on m.vid = mn.vid WHERE ( <= :end) AND mn.type = :type AND md.reservations_item_nid !=0 AND md.reservations_item_status = :reservations_item_status ; Array ( [:end] => 2012-03-06 12:49:49 [:type] => aula_presencial [:reservations_item_status] => 2 ) a reservations_overdue_items() (línia 485 de /var/www/academia/sites/all/modules/reservations/includes/database.inc).

Comments

isak_manresa’s picture

isak_manresa commented
Priority: Critical » Major
isak_manresa’s picture

isak_manresa commented

I've disabled and unistalled the module and the problem disapears, but it appears another problem:

In the select items to reserve form only appears the choice option with the first letter of the reservable items embeded. For example If I have the following reservable items:

One
Two
Three

The select items form view is:

OTT

And you can't do the reservation as you have not reservable items in the menu.

stefanwray’s picture

stefanwray commented
Issue summary: View changes
Status: Active » Closed (won't fix)