After enabling module:

Hotel Booking 7.x-1.0-alpha1
Requires: Cart (enabled), Order (enabled), Product (enabled), Image (enabled), File (enabled), Field (enabled), Field SQL storage (enabled), Store (enabled), Date API (enabled), Payment (enabled), Rules (enabled), Entity tokens (enabled), Entity API (enabled), Date Popup (enabled)

Installation fails with this error:

<PDOException: SQLSTATE[42P07]: Duplicate table: 7 ERROR: relation "hotel_booking_availability_calendars_hotel_booking_avail_cal_no" already exists: CREATE INDEX "hotel_booking_availability_calendars_hotel_booking_avail_cal_no_check_out_ix_idx" ON {hotel_booking_availability_calendars} ("no_check_out"); Array ( ) in db_create_table() (line 2588 of /data/web/html/test.com/includes/database/database.inc). 

then 5 empty tables are created in the database:

hotel_booking_availability_calendars
hotel_booking_occupancy_modifiers
hotel_booking_rate_calendars
hotel_booking_rate_modifiers
hotel_booking_rates

Comments

larowlan’s picture

Thanks, will investigate.
There are automated tests for the module and this doesn't show up so that's weird!

larowlan’s picture

Status: Active » Fixed

This down to database engine.
The index hotel_booking_availability_calendars_hotel_booking_avail_cal_no_check_out_ix_idx was truncated to
hotel_booking_availability_calendars_hotel_booking_avail_cal_no but so was a similar index named hotel_booking_availability_calendars_hotel_booking_avail_cal_no_check_in_ix_idx - hence the conflict.
Have renamed the indexes to smaller names.

Status: Fixed » Closed (fixed)
Issue tags: -database error

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