I'm using WAMP2.0i and tried this module.. everthing seems correct until one time, I tried to create a base rate 1000 and assign it to certain hotel room type. when I hit save a message prompts telling :

PDOException: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'from_rate' at row 1: UPDATE {hotel_booking_room_types} SET from_rate=:db_update_placeholder_0 WHERE (nid = :db_condition_placeholder_0) ; Array ( [:db_update_placeholder_0] => 1000.000 [:db_condition_placeholder_0] => 11 ) in hotel_booking_set_room_from_rate() (line 545 of C:\wamp\www\Balai Gloria\sites\all\modules\uc_hotel\hotel_booking\hotel_booking.util.inc).

Im kind of worried because I can't set base rates 1000 and above.. does anybody know how to solve this problem??? I attach the sample prompt I got.. help me please.. thank you very much Drupal.org..

CommentFileSizeAuthor
#3 Untitled4.png247.11 KBrequiem08
Untitled3.png180.22 KBrequiem08
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

larowlan’s picture

larowlan
Location 🇦🇺🏝.au GMT+10
CreditAttribution: larowlan commented

Just alter the precision/scale of the from_rate field in the hotel_booking_room_types table.
It only supports 999.99 per night. Which is probably short sighted given Yen or other currencies.

requiem08’s picture

requiem08 CreditAttribution: requiem08 commented

I appreciate the help..and yes, we use peso here, so thats why 999. is somehow short.. ok I'll try it.. thanks

requiem08’s picture

requiem08 CreditAttribution: requiem08 commented
FileSize
Untitled4.png247.11 KB
requiem08’s picture

requiem08 CreditAttribution: requiem08 commented
Status: Active » Closed (fixed)
bailey86’s picture

bailey86 CreditAttribution: bailey86 commented

I see you are using Windows - but thought this bug report may shed some light on your issue.

This looks like it could be related to a bug in the Debian package libapache2-mod-php5filter. I've reported it here:

http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=709023

My fix was to install the package libapache2-mod-php5 which then replaced libapache2-mod-php5filter.

In fact the package libapache2-mod-php5 should be used in preference to libapache2-mod-php5filter as on the package page for libapache2-mod-php5filter it even says 'Unless you specifically need filter-module support, you most likely should instead install libapache2-mod-php5.'

This has also been reported as a bug - http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=709027

It could also be related to https://bugs.php.net/bug.php?id=62507