Nextcloud Calendar Internals: Difference between revisions
Jump to navigation
Jump to search
(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...") |
(No difference)
|
Latest revision as of 12:14, 15 February 2022
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";