Nextcloud Calendar Internals

From Mecila
Jump to navigation Jump to search

Find and delete duplicate calendar entries

Create script select_oc_calendarobjects.sql:

use nextcloud;
SELECT * FROM oc_calendarobjects;
mysql -u root -p < select_oc_calendarobjects.sql > oc_calendarobjects.csv

Search in oc_calendarobjects.csv the entries and note the first number (id).

Delete:

Delete FROM oc_calendarobjects where ID="206088";
Delete FROM oc_calendarobjects_props where ID="206088";