Error (2.1.0)

Welcome, Guest

TOPIC: Error (2.1.0)

Error (2.1.0) 10 years, 9 months ago #40208

babylon5 OFFLINE Posts: 4	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) 10 years, 9 months ago #40209

kriza3 OFFLINE Posts: 2	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) 10 years, 9 months ago #40210

babylon5 OFFLINE Posts: 4	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) 10 years, 9 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) 10 years, 9 months ago #40213

kriza3 OFFLINE Posts: 2	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) 10 years, 8 months ago #40326

mengana OFFLINE Posts: 101	My tables look like ok... that's not the solution to my problem.. please help! Attachments: tables.JPG (31KB)
	The topic has been locked.

Page:
1
2
3
4
5

ARTIO Forums

Support