craigk5n / webcalendar

WebCalendar is a PHP application used to maintain a calendar for a single user or an intranet group of users. It can also be configured as an event calendar.
http://www.k5n.us/webcalendar.php
GNU General Public License v2.0
149 stars 71 forks source link

Imported Events can't edited after the Import (outlookcsv) #332

Open GemeinsamGemeinde opened 1 year ago

GemeinsamGemeinde commented 1 year ago

I have the problem that imported dates can no longer be edited by the GUI. When trying to edit an imported appointment, I get the error message

"Fatal error: Uncaught TypeError: gmmktime(): Argument #4 ($month) must be of type ?int, string given in .../includes/functions.php:824 Stack trace: #0 .../includes/functions.php(824): gmmktime(0, 0, 0, '', '', '') #1 .../edit_entry.php(194): date_to_epoch('') #2 {main} thrown in ..... /includes/functions.php on line 824"

Webcalendar V1.9.1 , PHP version 8.0 , MSSQL 5.7

Appointments are imported via outlookcsv and are displayed correctly.

In the database in the Table webcal_entry the two values `cal_due_date,cal_due_time` are respectively NULL, all other values are imported correctly. The entries are correct shown in the kalender and also in the iframe at the combined homepage... but can't edited anymore. The deletion of the entry by the GUI is possible

table webcal_entry (cal_id, cal_group_id, cal_ext_for_id, cal_create_by, cal_date, cal_time, cal_mod_date, cal_mod_time, cal_duration, cal_due_date, cal_due_time, cal_priority, cal_type, cal_access, cal_name, cal_location, cal_url, cal_completed, cal_description) 2085, NULL, NULL, 'stephan', 20221202, 130000, 20221225, 150059, 120, NULL, NULL, 5, 'E', 'P', 'EVENT', 'EVENTLOCATION', NULL, NULL, 'EVENT');

Any idea to fill the fields in the database correct at the import?

Greetings Stephan