Elxis CMS Forum

Extensions => Components => Topic started by: shoaibi on January 28, 2011, 14:18:31

Title: IOSR and offlineCC
Post by: shoaibi on January 28, 2011, 14:18:31
Hi,

I have enabled OfflineCC for all hotels with some of 0.00 fee and some with 10.00 fee.
I am facing strange issues in either case:

Case #1:
The administration panel on the hotel edit page's payment tab says that:
Code: [Select]
If Credit Card Offline (offlinecc) payment method is enabled then guests will be asked for credit card info even if the surety fee amount is zero!

But if I try a reservation on a hotel with fee set as zero, i don't see anything about offlineCC anywhere, further more the confirm page looks really ugly, no images, no CSS. This behavior may be due to because i am trying it as a logged in user, not as a user due to offline mode.  Image is attacked to this topic.

Case #2:
While if If i try to a reservation on a hotel with fee set to 10.00 i do see:

Code: [Select]
Reservation surety fee

The hotel requires you to pay in advance 10.00 SGD as a surety fee for your reservation.

and the confirm pages show offlinecc payment mode, when i click confirm takes about 30 seconds and then shows:

Code: [Select]
mysql Error [1054] : EXECUTE

clicking on it shows:

Code: [Select]
mysql Error [1054] : EXECUTE
URI: index.php?option=com_reservations&task=prepay&Itemid=51&rescode=CTON-1027-3556
Message: Unknown column 'h.dialect1' in 'field list'
SELECT r.ofirstname, r.olastname, r.checkin, r.checkout, r.feeamount, r.totalprice, h.hid, h.title, h.dialect1, h.dialect2, h.dialect3, h.lid, h.seotitle AS seohot, h.clickatell, l.title AS loctitle, l.dialect1 AS locdialect1, l.dialect2 AS locdialect2, l.dialect3 AS locdialect3, l.seotitle AS seoloc FROM elx_res_reservations r LEFT JOIN elx_res_hotels h ON h.hid=r.hid LEFT JOIN elx_res_locations l ON l.lid=h.lid WHERE r.userid='72' AND r.rescode='CTON-1027-3556' AND h.published='1' LIMIT 0,1

and

Code: [Select]
DESCRIBE `elx_res_hotels`;

shows:

Code: [Select]
+---------------+--------------+------+-----+---------------------+----------------+
| Field         | Type         | Null | Key | Default             | Extra          |
+---------------+--------------+------+-----+---------------------+----------------+
| hid           | int(11)      | NO   | PRI | NULL                | auto_increment |
| title         | varchar(255) | YES  |     | NULL                |                |
| description   | text         | YES  |     | NULL                |                |
| lid           | int(11)      | NO   |     | 0                   |                |
| published     | smallint(6)  | NO   |     | 0                   |                |
| comments      | smallint(6)  | NO   |     | 0                   |                |
| stars         | int(11)      | NO   |     | 0                   |                |
| ownerid       | int(11)      | NO   |     | 0                   |                |
| ownername     | varchar(255) | YES  |     | NULL                |                |
| owneremail    | varchar(255) | YES  |     | NULL                |                |
| address       | varchar(255) | YES  |     | NULL                |                |
| phone         | varchar(40)  | YES  |     | NULL                |                |
| fax           | varchar(40)  | YES  |     | NULL                |                |
| googlemap     | varchar(120) | YES  |     | NULL                |                |
| imagemap      | varchar(120) | YES  |     | NULL                |                |
| checkintime   | varchar(10)  | NO   |     | 14:00               |                |
| checkouttime  | varchar(10)  | NO   |     | 12:00               |                |
| pets          | smallint(6)  | NO   |     | 0                   |                |
| terms         | text         | YES  |     | NULL                |                |
| season        | varchar(255) | NO   |     | ALL                 |                |
| seotitle      | varchar(255) | YES  |     | NULL                |                |
| hits          | int(11)      | NO   |     | 0                   |                |
| dateadded     | datetime     | NO   |     | 1979-12-19 00:00:00 |                |
| fee           | varchar(10)  | YES  |     | NULL                |                |
| interfax      | smallint(6)  | NO   |     | 0                   |                |
| ifaxuser      | varchar(60)  | YES  |     | NULL                |                |
| ifaxpass      | varchar(60)  | YES  |     | NULL                |                |
| ifaxnumber    | varchar(50)  | YES  |     | NULL                |                |
| clickatell    | smallint(6)  | NO   |     | 0                   |                |
| clickuser     | varchar(50)  | YES  |     | NULL                |                |
| clickpass     | varchar(50)  | YES  |     | NULL                |                |
| clickapi      | varchar(50)  | YES  |     | NULL                |                |
| clickmobile   | varchar(50)  | YES  |     | NULL                |                |
| clicksender   | varchar(20)  | YES  |     | NULL                |                |
| tripadvisor   | varchar(180) | YES  |     | NULL                |                |
| accid         | int(11)      | YES  |     | 0                   |                |
| childdiscount | int(11)      | YES  |     | 0                   |                |
| operdiscount  | int(11)      | YES  |     | 0                   |                |
| earlydays     | int(11)      | YES  |     | 30                  |                |
| earlydiscount | int(11)      | YES  |     | 0                   |                |
| longdays      | int(11)      | YES  |     | 5                   |                |
| longdiscount  | int(11)      | YES  |     | 0                   |                |
| weekday1      | int(2)       | YES  |     | 0                   |                |
| weekdaypc1    | int(11)      | YES  |     | 0                   |                |
| weekday2      | int(2)       | YES  |     | 0                   |                |
| weekdaypc2    | int(11)      | YES  |     | 0                   |                |
| weekday3      | int(2)       | YES  |     | 0                   |                |
| weekdaypc3    | int(11)      | YES  |     | 0                   |                |
+---------------+--------------+------+-----+---------------------+----------------+
48 rows in set (0.00 sec)

Though reservation is made because i get the email.

Errors in apache's errorlog:

Code: [Select]
mod_fcgid: stderr: PHP Fatal error: Call to undefined method iosres_offlinecc::zeroprocessor() in /var/www/components/com_reservations/fviews/booking.html.php on line 1158
mod_fcgid: stderr: PHP Fatal error: Call to undefined method iosres_offlinecc::zeroprocessor() in /var/www/components/com_reservations/fviews/booking.html.php on line 1158
mod_fcgid: stderr: PHP Fatal error: Class 'reservHtml' not found in /var/www/components/com_reservations/pm/offlinecc.php on line 299
mod_fcgid: stderr: PHP Fatal error: Call to undefined method iosres_offlinecc::zeroprocessor() in /var/www/components/com_reservations/fviews/booking.html.php on line 1158
mod_fcgid: stderr: PHP Fatal error: Class 'reservHtml' not found in /var/www/components/com_reservations/pm/offlinecc.php on line 299


Will appreciate any help.


[EDIT]:
Also tried with guess user after disabling offline mode, identical results.

[attachment deleted by admin]
Title: Re: IOSR and offlineCC
Post by: datahell on February 07, 2011, 19:11:49
The reason is simple. You have updated IOSR from 3.3 to 3.5 but not fully. At least you haven't updated some files and IOSR modules/bots. Did you read the reamed.txt file, included in the update patch, before you proceed to the update?

For example "dialect1" column does not exist in v3.5, so your database is updated but the file system is outdated.

Please do the update again and be careful this time. Make sure all files are updated and the overwrite action does not fails. Also update all the IOSR modules/bots you use to their last version.