Hi
I installed the module and first it would not show up in the Shop Admin page but some other pointed me to the direrct URL for the module. Made the setting.
Added a room and made 500 rooms available.
Wanted to order - see the 2 mouth where all is red and click the " " and selected a month and saved it and got the following error:

Error messagePDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'available' at row 1: INSERT INTO {hotel_booking_availability_calendars} (nid, calendar_dt, available, minimum_occupancy, minimum_stay, no_check_in, no_check_out) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => 2011-04-01T00:00:00 [:db_insert_placeholder_2] => 500 [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 0 ) in drupal_write_record() (line 6776 of /var/www/www.smsworking.dk/www/booking/includes/common.inc).

Please can anyone help me here?
I have tried to change the date format, changed the availability settings from 0 to 12 back to 0.
Nothing seems to help.

Comments

Jens Peter’s picture

I change the number of rooms to 99 and not the 500 I made in the first place and now it is working.
So I guess there is a maximum amount for one specific room type how ever I have not found that maximum yet.

Can anyone tell me where I can change this? And what the maximum is?

Thanks.

larowlan’s picture

Issue tags: +Release blocker

Hi
500 rooms is beyond the system limit.
Happy to take a patch in the form of a hook_update_N function that goes in the install file to alter the db schema so that the available column in hotel_booking_available_calendars can accept numbers as large as 500.
Will be spending some time on the module over next two weeks, if you don't beat me to it!
LR

larowlan’s picture

Status: Active » Closed (won't fix)

No reply, leaving maximum quantity of a given room type at 99 limit.