There is a bug in the occupancy modifier form submit function causing an SQL error:

user warning: Unknown column 'hrmid' in 'where clause' query: UPDATE hotel_occupancy_modifiers SET adult_child = 'child', threshold = 1, value = 25 WHERE hrmid = 0 in C:\wamp\www\sites\all\modules\custom\uc_hotel\hotel_booking\hotel_booking_admin.inc on line 553.
CommentFileSizeAuthor
#1 618248.patch1.26 KBwillvincent

Comments

willvincent’s picture

willvincent commented
Status: Active » Needs review
StatusFileSize
new 618248.patch1.26 KB

For clarification:

This bug occurs when after an occupancy modifier has been created an attempt is made to update its settings. Initial creation and deletion of occupancy modifiers is unaffected.

WHERE hrmid should actually be WHERE hoid

This patch should correct the problem. Please review and post results.

willvincent’s picture

willvincent commented
Status: Needs review » Fixed

Hammered on this for a while. Patch solves this issue, doesn't affect anything else. Committed to cvs.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.