Hi, After I accidentally updated my Mariadb to 11 and reverted to 10 I
have a lot of odd duplicated calendars.
MariaDB [sogo]> SELECT c_foldername,count(*) FROM sogo_folder_info WHERE
c_path2='baggypants' GROUP BY c_foldername ORDER BY c_foldername;
+----------------------------+----------+
| c_foldername | count(*) |
+----------------------------+----------+
| Calendar | 162 |
| ChristCentral | 1 |
| Collected Address Book | 1 |
| DEFAULT_TASK_CALENDAR_NAME | 34 |
| Elvanto | 1 |
| england-and-wales | 1 |
| Family | 1 |
| Personal Address Book | 1 |
| Personal Calendar | 1 |
| Reminders | 127 |
| Work | 1 |
+----------------------------+----------+
11 rows in set (0.024 sec)
I'm thinking I should be able to just remove these from the
sogo_folder_info table and then getting sogo-tool cleanup to try and
clean up the orphaned tables. Or should I really be deleting the tables
they point in SQL to as well?
There's only one user that has the duplicated calendars.
Leon
