¡¡¡PRECAUTION!!!, When update to new versión of artio bookink 2.1.0, the filter to search or view of subjects crash and gives this error:


1054 - Unknown column 'sbj.featured' in 'field list' SQL=SELECT `sbj`.`id`, `sbj`.`title`, `sbj`.`alias`, `sbj`.`featured`, `sbj`.`template`, `sbj`.`introtext`, `sbj`.`params`, ROUND(RAND() * `sbj`.`id`) AS `rand_id`,COUNT(`kid`.`id`) AS `children` , count(`rsum`.`capacity`) AS `num_orders` FROM `jo_booking_subject` AS `sbj` LEFT JOIN `jo_booking_subject` AS `kid` ON `kid`.`parent` = `sbj`.`id` LEFT JOIN `jo_booking_reservation_items` AS `rsum` ON `rsum`.`subject` = `sbj`.`id` WHERE `sbj`.`state` = 1 AND `sbj`.`access` IN (1,1) AND `kid`.`id` IS NULL AND (`sbj`.`publish_up` <= '2013-07-19 09:19:21' OR `sbj`.`publish_up` = '0000-00-00 00:00:00') AND (`sbj`.`publish_down` >= '2013-07-19 09:19:21' OR `sbj`.`publish_down` = '0000-00-00 00:00:00') AND `sbj`.`total_capacity` >= 4 GROUP BY `sbj`.`id` ORDER BY `sbj`.`featured` DESC, `sbj`.`ordering` ASC


This is a very big fudge

Hello,
you must always do update from Book it back-end (Check Updates)
Try to repair it by SQL query (replace #_ with your joomla db prefix):
ALTER TABLE `#__booking_subject` ADD `featured` TINYINT NOT NULL AFTER `state`

if it will throw similar error after sql update, continue with:

ALTER TABLE `#__booking_price` ADD `adult_occupancy_price` text NOT NULL
ALTER TABLE `#__booking_price` ADD `child_occupancy_price` text NOT NULL
ALTER TABLE `#__booking_reservation_items` ADD `adult_occupancy` int(11) NOT NULL DEFAULT \'0\'
ALTER TABLE `#__booking_reservation_items` ADD `child_occupancy` int(11) NOT NULL DEFAULT \'0\'
ALTER TABLE `#__booking_subject` ADD `max_adult_occupancy` int(11) NOT NULL DEFAULT \'0\'
ALTER TABLE `#__booking_subject` ADD `max_child_occupancy` int(11) NOT NULL DEFAULT \'0\'
ALTER TABLE `#__booking_reservation_type` ADD `dynamic_gap_time` tinyint(1) NOT NULL DEFAULT 0
ALTER TABLE `#__booking_price` ADD `deposit_type` TINYINT NOT NULL DEFAULT \'1\'
ALTER TABLE `#__booking_price` ADD `deposit_include_supplements` TINYINT NOT NULL DEFAULT \'0\'
ALTER TABLE `#__booking_price` ADD `time_range` TINYINT NOT NULL DEFAULT \'0\'
ALTER TABLE `#__booking_price` ADD `head_piece` INT NOT NULL, ADD `tail_piece` INT NOT NULL

INSERT INTO `#__booking_payment` (`id`, `title`, `alias`, `checked_out`, `checked_out_time`) VALUES
(10, 'Cash', 'cash', 0, '0000-00-00 00:00:00') ON DUPLICATE KEY UPDATE `id` = 10;

INSERT INTO `#__booking_payment` (`id`, `title`, `alias`, `checked_out`, `checked_out_time`) VALUES
(11, 'Cheque', 'cheque', 0, '0000-00-00 00:00:00') ON DUPLICATE KEY UPDATE `id` = 11;

I always upgrade from Book it back-end (Check Updates), and this error occurred updating from the Book it back-end (Check Updates)