Nextcloud Calendar Internals

From Mecila
Revision as of 12:14, 15 February 2022 by Mattias (talk | contribs) (Created page with "=Find and delete duplicate calendar entries= Create script select_oc_calendarobjects.sql: use nextcloud; SELECT * FROM oc_calendarobjects; mysql -u root -p < select_oc_ca...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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";