Nextcloud Calendar Internals: Difference between revisions

From Mecila
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";