Menu Content

Support

> Forums, FAQs & Paid Support
Welcome, Guest
Username Password: Remember me

bookit upgrade to 2.0.6 problem
(1 viewing) (1) Guest
Universal booking and reservations component for Joomla!.

NOTE: This category has been locked. If you have purchased paid version, please, use our Support Ticket system instead. If you are using free edition, please see the Community Support section.
  • Page:
  • 1

TOPIC: bookit upgrade to 2.0.6 problem

bookit upgrade to 2.0.6 problem 10 years, 9 months ago #39981

Hi,
When I upgrade the Bookit component I get the following error when trying to access the bookit control panel. the only way to solve it so far is to reinstall the older version.

Error message:
-----------------------
Joomla!
1054 - An error has occurred.

Unknown column 'reservation.created_by' in 'on clause' SQL=SELECT `reservation`.*, `editorUser`.`name` as `editor`, `customer`.`checked_out` AS `customerCheckedOut`,SUM(`items`.`fullPriceSupplements`) AS `reservationFullPrice`, SUM(`items`.`fullDeposit`) AS `reservationFullDeposit`, SUM(`items`.`capacity`) AS `fullCapacity`, `creator`.`name` AS `creator`, `modifier`.`name` AS `modifier` FROM `xyz_booking_reservation` AS `reservation` LEFT JOIN `xyz_users` AS `editorUser` ON `editorUser`.`id` = `reservation`.`checked_out` LEFT JOIN `xyz_booking_customer` AS `customer` ON `customer`.`id` = `reservation`.`customer` LEFT JOIN `xyz_booking_reservation_items` AS `items` ON `items`.`reservation_id` = `reservation`.`id` LEFT JOIN `xyz_booking_subject` AS `subjects` ON `items`.`subject` = `subjects`.`id` LEFT JOIN `xyz_users` AS `creator` ON `reservation`.`created_by` = `creator`.`id` LEFT JOIN `xyz_users` AS `modifier` ON `reservation`.`modified_by` = `modifier`.`id` WHERE `from` >= '2013-07-02 23:39:36' AND items.subject IN (0, 2, 3) GROUP BY `reservation`.`id` ORDER BY `from` ASC

---------------------------
Please help.
The topic has been locked.
  • Page:
  • 1
User Login Empty