J-BusinessDirectory - Errors after updating to 5.50 Beta

Hi,


Firstly, I was getting an error when I was clicking 'book a room' on the website. I looked on this forum to look for a solution (http://www.cmsjunkie.com/forum/error-when-click--book-room/?p=1), and it was suggested to update to the latest J-Reservation. I updated to 5.50 BETA, thinking that would sort that problem out.


However, after doing this update, I got the following seperate error when searching for hotels on the website and also got errors in the J-Reservation Admin when trying to add a room:


The error i'm getting on the website from searching a hotel:
Unknown column 'r.room_order' in 'order clause' SQL=select *,hlt.content as room_main_description, rr.id as rate_id ,h.reservation_cost_val AS reservation_cost_val, h.reservation_cost_proc AS reservation_cost_proc from ws_hotelreservation_rooms r inner join ws_hotelreservation_rooms_rates rr on r.room_id = rr.room_id inner join ws_hotelreservation_hotels h ON h.hotel_id = r.hotel_id left join (select * from ws_hotelreservation_language_translations where type = 2 and language_tag = 'en-GB' ) as hlt on hlt.object_id = r.room_id where 1 and r.is_available = 1 and #r.front_display=1 and r.hotel_id= 11 order by r.room_order


The error i'm getting on the admin when trying to manage a room:
Unknown column 'r.room_order' in 'order clause' SQL=SELECT r.*,hrr.id as rate_id FROM `ws_hotelreservation_rooms` AS r LEFT JOIN `ws_hotelreservation_rooms_rates` AS hrr ON hrr.room_id=r.room_id WHERE (r.is_available IN (0, 1)) GROUP BY r.room_id ORDER BY r.room_order asc Unknown column 'r.room_order' in 'order clause' SQL=SELECT r.*,hrr.id as rate_id FROM `ws_hotelreservation_rooms` AS r LEFT JOIN `ws_hotelreservation_rooms_rates` AS hrr ON hrr.room_id=r.room_id WHERE (r.is_available IN (0, 1)) GROUP BY r.room_id ORDER BY r.room_order asc Unknown column 'r.room_order' in 'order clause' SQL=SELECT r.*,hrr.id as rate_id FROM `ws_hotelreservation_rooms` AS r LEFT JOIN `ws_hotelreservation_rooms_rates` AS hrr ON hrr.room_id=r.room_id WHERE (r.is_available IN (0, 1)) GROUP BY r.room_id ORDER BY r.room_order asc


Bare in mind, everything was working fine before I updated to 5.5.0, except the 'book a room' function.

Could someone please advise


Thanks

Hi Christian, 

It seems that the update didn't perform well. Pleae create a ticket with in your cmsjunkie account and send us the Joomla login as well. We'll look into this asap.