Mattias: 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..."

2022-02-15T12:14:21Z

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..."

New page

=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";

Nextcloud Calendar Internals - Revision history

Mattias: 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..."