For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Please see our announcement here.
SELECT b.*, r.standnoof_rooms FROM `main_booking` AS b LEFT JOIN room_type AS r ON r.id = b.roomtype_id WHERE b.roomtype_id = '3' AND (b.booking_date2 > '2013--08-26' AND b.booking_date1 < '2013-08-29')
return $matched - $actroom;
$actroom = '{room_type___standnoof_rooms}';
$rom = '{room_type___room_type}';
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$query->select("COUNT(*)")->from('main_booking');
$query->where{'main_booking___check_in'='main_booking___date_time'} and {'main_booking___roomtype_id'= $rom);
$db->setQuery($query);
$matched = $db->loadResult();
return $matched - $actroom;
$v1=(int)'{room_type___noof_rooms}';
$v2=(int)'{room_type___noof_nights}'*(int)'{room_type___standroom_price}';
$total = $v1 + $v2;
return $total;