Entirely solved all problems re 'No Checkout button on my Booking cart' [#2006032]

1. At http://www.slapeninyerseke.nl/node/12 I have a Unit Description Page. On the left is the Booking button. On this test site I have so far only one unit type and only one unit. When I book this room I apparently must choose between the only availabe unit type and no type, which seems confusing and though I have only one unit, I must choose from 6. Can I get rid of this?

2. The next page offers 'Book this' and that one works allright, But the next page displays the Booking Cart which has no checkout button. It seems the end of the ride. Possibly a connection needs to be made here with the Commerce module, but I can read nowhere how.

Am I doing something wrong? Please help.
Many thanks
Theo Richel

Comments

Comment #1

theorichel commented 28 May 2013 at 15:14

With regard to my point 1: When I set the the Quantity to 1 ( In 'Bookable units' - 'Options' ) to 1 I get this error:
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'rooms_booking_unit_options_value' at row 1: INSERT INTO {field_data_rooms_booking_unit_options} (entity_type, entity_id, revision_id, bundle, delta, language, rooms_booking_unit_options_name, rooms_booking_unit_options_quantity, rooms_booking_unit_options_operation, rooms_booking_unit_options_value) 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, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9); Array ( [:db_insert_placeholder_0] => rooms_unit [:db_insert_placeholder_1] => 20 [:db_insert_placeholder_2] => 20 [:db_insert_placeholder_3] => tweepers_kamer_voc [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => VOC-kamer [:db_insert_placeholder_7] => 1 [:db_insert_placeholder_8] => add [:db_insert_placeholder_9] => ) in field_sql_storage_field_storage_write() (regel 451 van /storage/web/public/sites/www.slapeninyerseke.nl/modules/field/modules/field_sql_storage/field_sql_storage.module).

Comment #2

theorichel commented 29 May 2013 at 11:14

Title:

No checkout button on my Booking cart

» Partly solved

Well the checkout button problem appeared to be a simple permission issue, sorry for that, it is solved now.

As to the imho superfluous selection from 6 units however, I still very much want to get rid of that, that is also where the error message above is about.

Comment #3

theorichel commented 29 May 2013 at 19:23

Title:

Partly solved

» Entirely solved all problems re 'No Checkout button on my Booking cart'

The problem with regard to the necessity to choose from unit types where there is only one has been solved: it is a setting.

The problem with regard to the number of units remains: I am still offered 6 but have only 1 room of each type is still there, but since it offers default a 1 I can live with it. Noone will probably click it to see how many options there are.

The error message was a configuration issue, but I have forgotten how I solved it.It is anyway quite important to check after each change if the different pages still link correctly to each other.

It is a powerful module, sure, but it is a pity that the whole thing is so miserably documented. I am now struggling with an option to have my customers actually pay for the rooms they rent.