We have moved to a new Sailfish OS Forum. Please start new discussions there.

Revision history [back]

click to hide/show revision 1
initial version

posted 2016-10-01 03:05:55 +0200

[BUG?] Manual removing calendar entries, but Event notification still came at a time of Event...

Hi to all...
I noticed about a strange problem. As we know we can import calendar entries from .ics file, this is what I did. But After removing all this entries and also calendar itself, the Event notification still came at a time of Event...
The full process:
1. Create manually a custom calendar, as example (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "insert into Calendars values('11112222-1111-1111-2222-111122223333','Custom calendar','Haifa','#FFFF00',668,0,'mycal','',-1,1475279260,'','',1475279260,'','');"

2. Now import any .ics file to your Calendar. For example you can try this one (Jewish holidays with candle lighting times): https://dl.dropboxusercontent.com/u/17706605/Jolla_C/jewish_cal_with_candle_Haifa_2016-2019.ics
3. Now remove All entries from this calendar (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Components WHERE Notebook='11112222-1111-1111-2222-111122223333';"

4. Now remove this calendar (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Calendars WHERE CalendarId='11112222-1111-1111-2222-111122223333';"

5. When first event will came it will show notification on event screen...

I can't understand why ? It stored also in some other place except "db" file ? Something like timedqt5 ?
Someone know how to fix it ?
Thanks

[BUG?] Manual removing calendar entries, but Event notification still came at a time of Event...

Hi to all...
I noticed about a strange problem. As we know we can import calendar entries from .ics file, this is what I did. But After removing all this entries and also calendar itself, the Event notification still came at a time of Event...
The full process:
1. Create manually a custom calendar, as example (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "insert into Calendars values('11112222-1111-1111-2222-111122223333','Custom calendar','Haifa','#FFFF00',668,0,'mycal','',-1,1475279260,'','',1475279260,'','');"

2. Now import any .ics file to your Calendar. For example you can try this one (Jewish holidays with candle lighting times): https://dl.dropboxusercontent.com/u/17706605/Jolla_C/jewish_cal_with_candle_Haifa_2016-2019.ics
3. Now remove All entries from this calendar (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Components WHERE Notebook='11112222-1111-1111-2222-111122223333';"

4. Now remove this calendar (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Calendars WHERE CalendarId='11112222-1111-1111-2222-111122223333';"

5. When first event will came it will show notification on event screen...

I can't understand why ? It stored also in some other place except "db" file ? Something like timedqt5 ?
Someone know how to fix it ?
Thanks


P.S. I played with this a few times on Jolla C (import, removing entries, removing calendars), maybe here is a problem, but still don't understand why. On Jolla1 and Tablet, for now all looks ok...

[BUG?] Manual removing calendar entries, but Event notification still came at a time of Event...

Hi to all...
I noticed about a strange problem. As we know we can import calendar entries from .ics file, this is what I did. But After removing all this entries and also calendar itself, the Event notification still came at a time of Event...
The full process:
1. Create manually a custom calendar, as example (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "insert into Calendars values('11112222-1111-1111-2222-111122223333','Custom calendar','Haifa','#FFFF00',668,0,'mycal','',-1,1475279260,'','',1475279260,'','');"

2. Now import any .ics file to your Calendar. For example you can try this one (Jewish holidays with candle lighting times): https://dl.dropboxusercontent.com/u/17706605/Jolla_C/jewish_cal_with_candle_Haifa_2016-2019.ics
3. Now remove All entries from this calendar (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Components WHERE Notebook='11112222-1111-1111-2222-111122223333';"

4. Now remove this calendar (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Calendars WHERE CalendarId='11112222-1111-1111-2222-111122223333';"

5. When first event will came it will show notification on event screen...

I can't understand why ? It stored also in some other place except "db" file ? Something like timedqt5 ?
Someone know how to fix it ?
Thanks


P.S. I played with this a few times on Jolla C (import, removing entries, removing calendars), maybe here is a problem, but still don't understand why. On Jolla1 and Tablet, for now all looks ok...


EDIT (04.10.16):
Finally I figured out what was the problem...
Like I suspected, the timed entries also stored inside timedclient-qt5 and if we delete entries from Calendar app by long press on event -> delete, the entries also will be deleted from timedclient-qt5. But if we delete entries from sqlite3 command (see above), they disappear from Calendar app, but timed events still stored inside timedclient-qt5 and we need to remove them manually:

timedclient-qt5 --cancel-event=<cookie number>

I updated my patch and now it remove entries like it should.
But I still don't understand why timed entries not deleted automatically from timedclient-qt5 when entries deleted from Calendar via sqlite3 command...

[BUG?] Manual removing calendar entries, but Event notification still came at a time of Event...Event...[answered]

Hi to all...
I noticed about a strange problem. As we know we can import calendar entries from .ics file, this is what I did. But After removing all this entries and also calendar itself, the Event notification still came at a time of Event...
The full process:
1. Create manually a custom calendar, as example (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "insert into Calendars values('11112222-1111-1111-2222-111122223333','Custom calendar','Haifa','#FFFF00',668,0,'mycal','',-1,1475279260,'','',1475279260,'','');"

2. Now import any .ics file to your Calendar. For example you can try this one (Jewish holidays with candle lighting times): https://dl.dropboxusercontent.com/u/17706605/Jolla_C/jewish_cal_with_candle_Haifa_2016-2019.ics
3. Now remove All entries from this calendar (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Components WHERE Notebook='11112222-1111-1111-2222-111122223333';"

4. Now remove this calendar (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Calendars WHERE CalendarId='11112222-1111-1111-2222-111122223333';"

5. When first event will came it will show notification on event screen...

I can't understand why ? It stored also in some other place except "db" file ? Something like timedqt5 ?
Someone know how to fix it ?
Thanks

P.S. I played with this a few times on Jolla C (import, removing entries, removing calendars), maybe here is a problem, but still don't understand why. On Jolla1 and Tablet, for now all looks ok...


EDIT (04.10.16):
Finally I figured out what was the problem...
Like I suspected, the timed entries also stored inside timedclient-qt5 and if we delete entries from Calendar app by long press on event -> delete, the entries also will be deleted from timedclient-qt5. But if we delete entries from sqlite3 command (see above), they disappear from Calendar app, but timed events still stored inside timedclient-qt5 and we need to remove them manually:

timedclient-qt5 --cancel-event=<cookie number>

I updated my patch and now it remove entries like it should.
But I still don't understand why timed entries not deleted automatically from timedclient-qt5 when entries deleted from Calendar via sqlite3 command...

[BUG?] Manual removing calendar entries, but Event notification still came at a time of Event...[answered]Event...

Hi to all...
I noticed about a strange problem. As we know we can import calendar entries from .ics file, this is what I did. But After removing all this entries and also calendar itself, the Event notification still came at a time of Event...
The full process:
1. Create manually a custom calendar, as example (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "insert into Calendars values('11112222-1111-1111-2222-111122223333','Custom calendar','Haifa','#FFFF00',668,0,'mycal','',-1,1475279260,'','',1475279260,'','');"

2. Now import any .ics file to your Calendar. For example you can try this one (Jewish holidays with candle lighting times): https://dl.dropboxusercontent.com/u/17706605/Jolla_C/jewish_cal_with_candle_Haifa_2016-2019.ics
3. Now remove All entries from this calendar (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Components WHERE Notebook='11112222-1111-1111-2222-111122223333';"

4. Now remove this calendar (as ROOT):

sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db "DELETE FROM Calendars WHERE CalendarId='11112222-1111-1111-2222-111122223333';"

5. When first event will came it will show notification on event screen...

I can't understand why ? It stored also in some other place except "db" file ? Something like timedqt5 ?
Someone know how to fix it ?
Thanks

P.S. I played with this a few times on Jolla C (import, removing entries, removing calendars), maybe here is a problem, but still don't understand why. On Jolla1 and Tablet, for now all looks ok...


EDIT (04.10.16):
Finally I figured out what was the problem...
Like I suspected, the timed entries also stored inside timedclient-qt5 and if we delete entries from Calendar app by long press on event -> delete, the entries also will be deleted from timedclient-qt5. But if we delete entries from sqlite3 command (see above), they disappear from Calendar app, but timed events still stored inside timedclient-qt5 and we need to remove them manually:

timedclient-qt5 --cancel-event=<cookie number>

I updated my patch and now it remove entries like it should.
But I still don't understand why timed entries not deleted automatically from timedclient-qt5 when entries deleted from Calendar via sqlite3 command...