Calendar Shows Birthday of a Deleted Contact

miqrogroove commented 6 years ago

Steps to reproduce

Installed ownCloud on a new Ubuntu server a few days ago.
Imported contacts.
Deleted a few contacts (via CardDav)
Noticed the birthday calendar for next month shows a contact who no longer exists.
Confirmed contact does not appear in OC website.
Confirmed both CalDav and website calendars are showing a birthday that should not exist anymore.

Expected behaviour

Deleted contacts should never appear in the birthday calendar.

Actual behaviour

Deleting contacts appears to have no effect.

Server configuration

Operating system: Ubuntu

Web server: Apache

Database: MySQL

PHP version: 7.2

ownCloud version: (see your admin page) 10.0.9

Calendar version: (see the apps page)

Updated from an older installed version or fresh install: Fresh with imported contacts and calendar files.

Signing status (ownCloud 9.0 and above): What?

Login as admin user into your cloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results here.

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your instance's installation folder

ownCloud configuration:

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your instance's installation folder

or 

Insert your config.php content here
Make sure to remove all sensitive content such as passwords. (e.g. database password, passwordsalt, secret, smtp password, …)

Are you using external storage, if yes which one: local/smb/sftp/...

Are you using encryption: yes/no TLS only

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/... No

LDAP configuration (delete this part if not used)

With access to your command line run e.g.:
sudo -u www-data php occ ldap:show-config
from within your instance's installation folder

Without access to your command line download the data/owncloud.db to your local
computer or access your SQL server remotely and run the select query:
SELECT * FROM `oc_appconfig` WHERE `appid` = 'user_ldap';

Be sure to replace sensitive data as the name/IP-address of your LDAP server or groups.

Client configuration

Browser:

Operating system:

CalDAV-clients: Using CalDAV-Sync for Android, iOS calendar, both in addition to website calendar.

Logs

Web server error log

Insert your webserver log here

Log file (data/owncloud.log)

Insert your ownCloud.log file here

Browser log

Insert your browser log here, this could for example include:

a) The javascript console log
b) The network log 
c) ...

DeepDiver1975 commented 6 years ago

Mind having a look into the server log under data/owncloud.log at the time of deletion? THX

miqrogroove commented 6 years ago

Nothing at time of deletion. Log level is errors only, because https://github.com/owncloud/core/issues/31524

miqrogroove commented 6 years ago

Possibly relevant: I had some difficulty with the contacts import and ultimately deleted my contacts list and repeated the process once or twice to resolve date syntax errors. Now in the web calendar some of the birthdays show up in duplicate or triplicate.

miqrogroove commented 6 years ago

Symptoms resolved by deleting the birthday calendar and manually updating it from the shell command suggested by https://central.owncloud.org/t/multiple-entries-in-contacts-birthday-calendar-per-person/5973

That just leaves the matter of why the birthdays are not deleted when the contacts are deleted?

DeepDiver1975 commented 6 years ago

That just leaves the matter of why the birthdays are not deleted when the contacts are deleted?

Some date format issues during import could be the reason ... logs should show ....

There is an occ command to sync the birthday calendar: ./occ dav:sync-birthday-calendar - this should help as well ...

owncloud / calendar