JHotelReservation Forum - Upgrading To Joomla 4

Support Forum

 
 

 

Hi I have just updated  a Staging site  from Joomla3  To Joomla 4   Everything worked perfectly  but Joomla  Has Show one Database  Problem listed below  is this OK or IS Action required 

 

  • Table 'o7db8_hotelreservation_emails' has the wrong type or attributes for column 'email_type' with type `email_type`. (From file 5.1.0.sql.)
  • Table 'o7db8_hotelreservation_offers_rooms_price' does not have index 'PRICE_IDX'. (From file 5.4.0.sql.)
  • Table 'o7db8_hotelreservation_language_translations' does not have index 'IDX_TRS'. (From file 5.4.0.sql.)
  • Table 'o7db8_hotelreservation_confirmations' does not have index 'IDX_CNF'. (From file 5.4.0.sql.)
  • Table 'o7db8_hotelreservation_offers_rates' does not have index 'IDX_ROOMS'. (From file 5.4.0.sql.)
  • Table 'o7db8_hotelreservation_rooms_rate_prices' does not have index 'IDX_RRP'. (From file 5.4.0.sql.)
  • Table 'o7db8_hotelreservation_confirmations_rooms' does not have index 'IDX_CNF'. (From file 5.4.0.sql.)
  • Table 'o7db8_hotelreservation_offers' has the wrong type or attributes for column 'offer_order' with type int(10). (From file 5.4.0.sql.)
  • Table 'o7db8_hotelreservation_permissions' has the wrong type or attributes for column 'id' with type `id`. (From file 5.4.3.sql.)
  • Table 'o7db8_hotelreservation_emails' has the wrong type or attributes for column 'email_type' with type `email_type`. (From file 5.4.3.sql.)
  • Table 'o7db8_hotelreservation_rooms' has the wrong type or attributes for column 'room_order' with type `ordering`. (From file 5.5.0.sql.)
  • Table 'o7db8_hotelreservation_offers' has the wrong type or attributes for column 'offer_order' with type `ordering`. (From file 5.5.0.sql.)
  • Table 'o7db8_hotelreservation_excursions' has the wrong type or attributes for column 'excursion_order' with type `ordering`. (From file 5.5.0.sql.)
  • Table 'o7db8_hotelreservation_extra_options' should not have index 'NewIndex'. (From file 5.6.0.sql.)
  • Table 'o7db8_hotelreservation_confirmations_rooms_airport_transfer' should not have index 'NewIndex'. (From file 5.6.0.sql.)
  • Table 'o7db8_hotelreservation_hotels' has the wrong type or attributes for column 'hotel_short_description' with type `hotel_short_description`. (From file 5.6.0.sql.)
  • Table 'o7db8_hotelreservation_excursions' should not have index 'NewIndex'. (From file 6.0.0.sql.)
  • Table 'o7db8_hotelreservation_emails_default' has the wrong type or attributes for column 'email_default_type' with type `email_default_type`. (From file 6.0.1.sql.)
  • Table 'o7db8_hotelreservation_offers_rates' does not have index 'IDX_OFR'. (From file 6.0.2.sql.)
  • Table 'o7db8_hotelreservation_offers_rate_prices' does not have index 'offrateprice_rateid_idx'. (From file 6.0.2.sql.)
  • Table 'o7db8_hotelreservation_confirmations' does not have index 'confirmations_1_IDX'. (From file 6.0.2.sql.)
  • Table 'o7db8_hotelreservation_hotel_pictures' does not have index 'pictures_1_IDX'. (From file 6.0.2.sql.)
  • Table 'o7db8_hotelreservation_language_translations' does not have index 'translation_composite_idx'. (From file 6.0.2.sql.)
  • Table 'o7db8_hotelreservation_offers_rate_prices' does not have index 'rateid_date'. (From file 6.0.3.sql.)
  • Table 'o7db8_hotelreservation_beds24_rates_mapping' does not exist. (From file 6.0.5.sql.)
  • Table 'o7db8_hotelreservation_emails_default' has the wrong type or attributes for column 'email_default_type' with type `email_default_type`. (From file 6.0.5.sql.)
  • Table 'o7db8_hotelreservation_emails' has the wrong type or attributes for column 'email_type' with type `email_type`. (From file 6.0.5.sql.)
  • Table 'o7db8_hotelreservation_hotel_board_types' does not exist. (From file 6.1.0.sql.)
  • Table 'o7db8_hotelreservation_hotel_board_type_relation' does not exist. (From file 6.1.0.sql.)
  • Table 'o7db8_hotelreservation_applicationsettings' does not have column 'different_confirmation_admin_email'. (From file 6.1.0.sql.)
  • Table 'o7db8_hotelreservation_emails_default' has the wrong type or attributes for column 'email_default_type' with type `email_default_type`. (From file 6.1.0.sql.)
  • Table 'o7db8_hotelreservation_confirmations' has the wrong type or attributes for column 'remarks' with type `remarks`. (From file 7.0.0.sql.)
  • Table 'o7db8_hotelreservation_confirmations' has the wrong type or attributes for column 'remarks_admin' with type `remarks_admin`. (From file 7.0.0.sql.)
  • Table 'o7db8_hotelreservation_emails_default' has the wrong type or attributes for column 'email_default_type' with type ENUM('Reservation Email','Cancelation Email','Review Email','Invoice Email','Bookings List','Client Invoice Email','Availability Request Email'). (From file 7.0.4.sql.)
  • 110 database changes were checked.
  • 125 database changes did not alter table structure and were skipped.
2 replies

I have just tried booking a room and it has shown an error page and prevented the reservation. 

Hi,

 

Please use the Fix Database functionality, https://cmsjunkie.com/docs/jhotelreservation/hotelreservationadministration.html#application-settings

 

Marius B.
Helpdesk Specialist
 
 
 

3 Item(s)

Show per page