A PHP Error was encountered

Severity: Notice

Message: Undefined variable: sortOrder

Filename: models/booking_m.php

Line Number: 462

Database Error

A Database Error Occurred

Error Number: 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 43

SELECT hotel_allotment.ha_id, hotel_allotment.event_id, hotel_info.hotel_id, hotel_info.hotel_img, hotel_allotment.display_website, hotel_allotment.display_group_booking_website, hotel_allotment.order_number, hotel_allotment.display_fb, hotel_allotment.display_content, hotel_allotment.external_link, hotel_info.hotel_name_en, hotel_info.hotel_name_ch, hotel_info.address, hotel_info.star_rating, hotel_allotment.currency , hotel_allotment.official_hotel, hotel_info.ty_id, hotel_allotment.cancel_by, hotel_allotment.charge_id, hotel_allotment.transport_access_to_venue, hotel_allotment.link_for_transport_access, hotel_allotment.transport_access_to_venue_ch, hotel_allotment.default_free_text_area, hotel_allotment.free_text_border_0_enable, hotel_allotment.free_text_border_0_color, hotel_allotment.free_text_border_1_enable, hotel_allotment.free_text_border_1_color, hotel_allotment.rate_check, hotel_allotment.check1_ota_name, hotel_allotment.check1_rate, hotel_allotment.check2_ota_name, hotel_allotment.check2_rate, hotel_allotment.free_text_area, hotel_allotment.free_text_area_ch FROM hotel_info INNER JOIN hotel_allotment ON hotel_allotment.hotel_id = hotel_info.hotel_id INNER JOIN room_allotment ON hotel_allotment.ha_id = room_allotment.ha_id WHERE hotel_allotment.active = '1' AND room_allotment.booking_id = '0' GROUP BY room_allotment.ha_id ORDER BY hotel_allotment.order_number ASC,

Filename: /home/burnaby/public_html/register/v2/models/booking_m.php

Line Number: 464