Menu Content

Podpora

> Diskusní fóra, FAQs & placená podpora
Welcome, Guest
Username Password: Remember me

Error (2.1.0)
(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.

TOPIC: Error (2.1.0)

Error (2.1.0) 7 years, 3 months ago #40208

Hello,

since update following error message is shown when trying to edit and save bookable items.

Unknown column 'max_adult_occupancy' in 'field list' SQL=UPDATE `yjxby_booking_subject` SET `parent`='0',`template`='1',`title`='Ferienwohnung 1',`alias`='fewo-1',`introtext`='

I urgent need your help.......please

Kind Regards
Sabine
The topic has been locked.

Re: Error (2.1.0) 7 years, 3 months ago #40209

I have the same problem.
I updated to version 2.1.0 on two sites, and both have this error and stopped working reservations.
The topic has been locked.

Re: Error (2.1.0) 7 years, 3 months ago #40210

I will have a look at "vik booking" which seems a promising extension as the support from artio does not seem to solve those problems immediately ;-(
The topic has been locked.

Re: Error (2.1.0) 7 years, 3 months ago #40212

  • jitr
  • OFFLINE
  • ARTIO Support
  • Posts: 1432
Hello, this is very strange. New columns in the the table #___booking_subject should be created during upgrade process. Did you update with standard upgrader? You can create missing columns with folllowing commands:
 
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_subject` ADD `featured` TINYINT( 1 ) NOT NULL AFTER `state`
 

You have to replace #_ with prefix of your database.
ARTIO Support Team
The topic has been locked.

Re: Error (2.1.0) 7 years, 3 months ago #40213

I've uninstalled and installed the component again, but still does not work in version 2.1.0 reservation. It is possible to download version 2.0.7 somewhere free?
The topic has been locked.

Re: Error (2.1.0) 7 years, 2 months ago #40326

My tables look like ok... that's not the solution to my problem.. please help!
Attachments:
The topic has been locked.
Přihlášení uživatele Prázdný