•Notice: Undefined index: value2 in merci_load_reservations_for_node_in_timespan() (line 766 of /[path]/modules/merci/includes/database.inc).
•Notice: Undefined index: value2 in merci_reserved_bucket_items() (line 523 of /[path]/modules/merci/includes/database.inc).
•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_merci_date_value2 ,md.merci_item_nid FROM field_data_field_merci_date c' at line 1: SELECT ct.entity_id as nid,field_merci_date_value AS field_merci_date_value, AS field_merci_date_value2 ,md.merci_item_nid FROM {field_data_field_merci_date} ct INNER JOIN {merci_reservation_detail} md on ct.revision_id = md.vid INNER JOIN {merci_bucket_node} m on md.merci_placeholder_nid = m.nid INNER JOIN {node} ctn on ct.revision_id = ctn.vid INNER JOIN {node} mn on m.vid = mn.vid WHERE ( (field_merci_date_value >= :start1 and field_merci_date_value <= :start2) OR ( >= :start3 and <= :start4) OR (field_merci_date_value <= :start5 and >= :start6) ) AND mn.type = :type AND md.merci_item_nid !=0 AND NOT md.merci_item_status <= :merci_item_status ; Array ( [:start1] => 2013-12-30 00:00:00 [:start2] => 2013-12-30 00:00:00 [:start3] => 2013-12-30 00:00:00 [:start4] => 2013-12-30 00:00:00 [:start5] => 2013-12-30 00:00:00 [:start6] => 2013-12-30 00:00:00 [:type] => item_1 [:merci_item_status] => 0 ) in merci_reserved_bucket_items() (line 578 of /[path]/modules/merci/includes/database.inc).
..

Comments

darrick’s picture

Category: Bug report » Support request

MERCI requires a start and end date.

News4u’s picture

yes i fixed it thank you.
But is it possible to use other attribute with calendar instead of using time
Maybe using DAY /Night or both
How can i achieve this..?