Error Message on New Addon/Upgrade page [#851192]

I have been using uc_hotel to develop a rental property site and it is an amazing module. I upgraded to version 2 to take advantage of the 'Book Now' feature on the node page and it works great. I am getting the following error when going to configure a new addon/upgrade:

* user warning: Table 'username_rentals.hotel_room_types' doesn't exist query: SELECT hrt.nid, n.title FROM hotel_room_types AS hrt, node AS n WHERE n.nid = hrt.nid in /home/username/public_html/rentalhomes/sites/all/modules/uc_hotel/hotel_addons_upgrades/hotel_addons_upgrades_admin.inc on line 195.
* warning: Invalid argument supplied for foreach() in /home/username/public_html/rentalhomes/includes/form.inc on line 1207.

This error causes the 'Limit by room type' block to not be populated with any of the room types I have created. It selects them all by default which is not a big deal for me but just something I wanted to bring up.

Currently running:
Drupal 6.17
PHP 5.2.11

Thanks again for the great module and all the work that has been done.

Comments

Comment #1

larowlan

🇦🇺🏝.au GMT+10

CreditAttribution: larowlan commented 12 July 2010 at 01:37

Thanks, the table name has changed to hotel_booking_room_types.
Lee

Comment #2

cmoss CreditAttribution: cmoss commented 12 July 2010 at 02:59

Thanks for the quick reply that solved the problem with invalid tables and my room type field is now getting populated. I'm still getting the warning for:

* warning: Invalid argument supplied for foreach() in /home/username/public_html/rentalhomes/includes/form.inc on line 1207

Comment #3

larowlan

🇦🇺🏝.au GMT+10

CreditAttribution: larowlan commented 12 July 2010 at 03:39

Hi
Can you post a link to your finished site when done, I'm always keen to see the module in use.
I think this error is most likely due to a checkbox field having a null for the options instead of an array.
What page are you viewing when you get the error.
If it is the node edit page, do you have any fields that don't appear to render correctly eg 'Rate modifiers' or 'Occupancy modifiers'.
Lee

Comment #4

larowlan

🇦🇺🏝.au GMT+10

CreditAttribution: larowlan commented 14 July 2010 at 03:06

Fixed issue with table name in dev version

Comment #5

cmoss CreditAttribution: cmoss commented 14 July 2010 at 22:21

The site is a development site to show a client what is possible with a new website. It's probably as far as it's going to go right now without further input from the client as far as a go/no-go on their end. Right now it's set up so you can search for homes for a set date or browse the open rental homes and book from the nodes. You can also purchase ski lift tickets with your rental home. This will be expanded to include waterpark tickets during the summer months. I am still using a standard theme and have not done much customizing just working on function over form right now.

http://rentalhomes.1860webdesigns.com

The error code I am getting is on the admin/store/hotel_booking/upgrades_addons/add page and everything seems to be showing fine. The only thing I can't get to show up is pricing in the availability calendars even though I have the option checked. This module is a great addition to the Drupal community thanks for the hard work.