Calendars - unknown column 'event_limit'

Post Reply
ipropoland
Posts: 20
Joined: 13 Dec 2021, 17:13
Name: Waldemar Rychert
Location: Poland - Gniezno

Calendars - unknown column 'event_limit'

Post by ipropoland »

Hi Sergei,

I wanted to start using calendars but the below error occurred:

Code: Select all

Database Error: 1054 - Unknown column 'event_limit' in 'field list'
Query: insert into app_ext_calendar (name, enable_ical, default_view, view_modes, event_limit, highlighting_weekends, min_time, max_time, time_slot_duration, entities_id, in_menu, heading_template, start_date, end_date, use_background, fields_in_popup, filters_panel) values ('TEST', '0', 'month', '', '6', '', '', '', '00:30:00', '54', '0', '', '612', '612', '', '', 'default')
Page: /index.php?module=ext/calendar/configuration&action=save_report&token=

Code: Select all

Database Error: 1054 - Unknown column 'event_limit' in 'field list'
Query: insert into app_ext_pivot_calendars (name, default_view, enable_ical, view_modes, event_limit, highlighting_weekends, min_time, max_time, time_slot_duration, display_legend, in_menu, users_groups, sort_order) values ('dd', 'month', '0', '', '6', '', '', '', '00:30:00', '0', '0', '{\"6\":\"\",\"5\":\"\",\"4\":\"\"}', '')
Page: /index.php?module=ext/pivot_calendars/reports&action=save&token=
Rukovoditel 3.2.1
Extentions 3.2.1
ipropoland
Posts: 20
Joined: 13 Dec 2021, 17:13
Name: Waldemar Rychert
Location: Poland - Gniezno

Re: Calendars - unknown column 'event_limit'

Post by ipropoland »

What is the type of this field? I will add it.
User avatar
support
Site Admin
Posts: 6215
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Calendars - unknown column 'event_limit'

Post by support »

Strange. Open phpmyamdin and run next query

Code: Select all

ALTER TABLE `app_ext_calendar` ADD `event_limit` SMALLINT NOT NULL AFTER `view_modes`;
Hope this is help.
ipropoland
Posts: 20
Joined: 13 Dec 2021, 17:13
Name: Waldemar Rychert
Location: Poland - Gniezno

Re: Calendars - unknown column 'event_limit'

Post by ipropoland »

support wrote: 03 Jan 2023, 17:24 Strange. Open phpmyamdin and run next query

Code: Select all

ALTER TABLE `app_ext_calendar` ADD `event_limit` SMALLINT NOT NULL AFTER `view_modes`;
Hope this is help.
Almost... :) Another column missing.
Database Error: 1054 - Unknown column 'filters_panel' in 'field list'
Query: insert into app_ext_calendar (name, enable_ical, default_view, view_modes, event_limit, highlighting_weekends, min_time, max_time, time_slot_duration, entities_id, in_menu, heading_template, start_date, end_date, use_background, fields_in_popup, filters_panel) values ('TEST CAL', '0', 'agendaWeek', 'listMonth', '20', '.fc-sun,.fc-sat', '', '', '00:30:00', '54', '1', '', '612', '612', '', '', 'default')
Page: /index.php?module=ext/calendar/configuration&action=save_report
User avatar
support
Site Admin
Posts: 6215
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Calendars - unknown column 'event_limit'

Post by support »

Code: Select all

ALTER TABLE `app_ext_calendar` ADD `filters_panel` VARCHAR(16) NOT NULL DEFAULT 'default' AFTER `fields_in_popup`;
ipropoland
Posts: 20
Joined: 13 Dec 2021, 17:13
Name: Waldemar Rychert
Location: Poland - Gniezno

Re: Calendars - unknown column 'event_limit'

Post by ipropoland »

Thank you! Now it works :)
Post Reply