#378 table structure error?

[Francesco]

Hi,
it seems that during install table structure is not correct.
Just downloaded package, buy many tables are wrong (p.e. this is query to edit area):

UPDATE mrbs_area SET area_name='Sale',disabled=0,timezone='Europe/Rome',area_admin_email='',custom_html='',resolution=3600,default_duration=3600,default_duration_all_day=0,morningstarts=0,morningstarts_minutes=0,eveningends=23,eveningends_minutes=0,min_book_ahead_enabled=0,max_book_ahead_enabled=0,max_per_day_enabled=0,max_per_week_enabled=0,max_per_month_enabled=0,max_per_year_enabled=0,max_per_future_enabled=0,private_enabled=0,private_default=0,private_mandatory=0,private_override='none',approval_enabled=1,reminders_enabled=1,enable_periods=0,confirmation_enabled=0,confirmed_default=1 WHERE id=1

Aggiornamento area fallito:

Warning: Unknown column 'min_book_ahead_enabled' in 'field list' in /var/www/clients/client503/web1675/web/booking/edit_area_room.php on line 560 Errore: 1

this when adding a booking:

Warning: Cannot add or update a child row: a foreign key constraint fails (c503criferrara2.mrbs_entry, CONSTRAINT mrbs_entry_ibfk_2 FOREIGN KEY (repeat_id) REFERENCES mrbs_repeat (id) ON DELETE CASCADE ON UPDATE CASCADE) in /var/www/clients/client503/web1675/web/booking/mrbs_sql.inc on line 598 INSERT INTO mrbs_entry (start_time, end_time, entry_type, repeat_id, room_id, create_by, modified_by, name, type, description, status, ical_uid, ical_sequence, ical_recur_id) VALUES (1488434400, 1488438000, 0, 0, 1, 'fviali', '', 'atest', 'I', '', 0, 'MRBS-58b47547394f8-f21d57d0@criferrara.it', 0, '')

[Campbell Morrison]

Can you describe exactly what you did please? Are you sure you are using the 1.6.1 release? I don't think line 560 of edit_area_room.php in 1.6.1 could produce that error.

[Francesco]

Wow, you're right.. it was a "bad mix" of versions