Calendar cleanup

General
#1

Why can I not run the below any longer?

[root@Xperia10III mkcal]# sqlite3 .local/share/system/privileged/Calendar/mkcal/db
bash: sqlite3: not found

#2

Do you have sqlite3?

sqlite3 --version

If not, have you tried installing sqlite3?

devel-su pkcon install sqlite

1 Like
#3

I did try pkcon install sqlite but it could not find sqlite.
I tried again and then i succeed :slight_smile:

[root@Xperia10III mkcal]# pkcon install sqlite
Løser
Tester ændringer
Afsluttet [ ] (0%)
Følgende pakker er nødt til at blive installeret:
sqlite-3.37.2+git1-1.6.3.jolla.aarch64 Library that implements an embeddable SQL database engine
Fortsæt med ændringer? [N/y] y

Tester ændringer
Installerer
Starter
Henter pakker
Installerer pakker
Afsluttet

#4

Sikkert bedre med en liten oversettelse i et engelsk forum @elkiaer :slight_smile:

[root@Xperia10III mkcal]# pkcon install sqlite
Resolving
Testing changes
Completed [ ] (0%)
The following packages need to be installed:
sqlite-3.37.2+git1-1.6.3.jolla.aarch64 Library that implements an embeddable SQL database engine
Continue with changes? [N/y] y

Testing changes
Installing
Starting
Retrieving packages
Installing packages
Finished
#5

Anyway I can start cleaning my Calendar account. I do not know why but it generate lots of th same account.
Fødselsdage=Birthday
Helligdage=Holidays

29a23868-6013-47c1-9149-8c3daa932c6c|Default||#0000FF|151|0|||-1|1688986920|||1688986920||
b1376da7-5555-1111-2222-227549c4e570|Fødselsdage||#e00080|87|0|Birthday-Nokia||0|1700600166|||1688986920||
323e48e8-758f-4089-8cfb-253dbda749e2|Kalender||#5d00e5|513|1695174788|EasInvitationPlugin|25|-1|1700600165|||1693844706||
287d6695-125a-4cb9-ae71-87bee4d43b70|Helligdage i Danmark||#00aeef|1|1694944385|EasInvitationPlugin|25|-1|1700600164|||1693844706||
b2ad275b-4f6c-4d13-ac3f-d8f5bb52bf5c|Kalender||#99e600|1|1694415603|EasInvitationPlugin|31|-1|1700600166|||1693847857||
92f22058-ab3a-4765-ba71-f52e8aaba743|Fødselsdage||#00aeef|1|0|EasInvitationPlugin|31|-1|1700600165|||1693847857||
5c6e39c8-40d1-4fca-8327-59be65bc7529|Helligdage i Danmark||#00aeef|1|1693847858|EasInvitationPlugin|31|-1|1693848121|||1693847857||
e26eb0bf-471f-4221-9c57-1d3e724fda95|Kalender||red|1|1695020408|EasInvitationPlugin|31|-1|1700600166|||1694456765||
c91f936e-8a95-4b59-b9d7-c4f5dfaa3ec1|Fødselsdage||#00aeef|1|0|EasInvitationPlugin|31|-1|1700600166|||1694456765||
9e6cc487-c761-43a0-9d9d-6321ce351f4b|Helligdage i Danmark||blue|1|0|EasInvitationPlugin|31|-1|1700600165|||1694456765||
eadc8dba-2fb7-46f4-abb0-8107565e98a4|Kalender||red|1|1695367925|EasInvitationPlugin|31|-1|1700600166|||1695277359||
51f066db-8d00-45d1-b183-0ceef0ad0352|Fødselsdage||pink|1|0|EasInvitationPlugin|31|-1|1700600165|||1695277359||
023c7f12-b05e-40bd-9caf-c0c4c99da0e3|Helligdage i Danmark||blue|1|0|EasInvitationPlugin|31|-1|1700600164|||1695277359||
6866ef3f-81d4-4201-bf24-0282b89b00af|Kalender||green|1|1695405080|EasInvitationPlugin|25|-1|1700600165|||1695277359||
05d3ef9f-efb4-46e3-bc6b-15f6158a58fe|Helligdage i Danmark||#00aeef|1|1695964373|EasInvitationPlugin|25|-1|1700600164|||1695277359||
9273fd7b-0073-47df-af8c-11c201876478|Kalender||#00aeef|1|1695908575|EasInvitationPlugin|31|-1|1700600165|||1695476612||
c2008e94-6524-4cf5-a729-f87cb17ecef6|Fødselsdage||blue|1|0|EasInvitationPlugin|31|-1|1700600166|||1695476612||
e866195c-9d8e-4c97-85c6-e6a188acbacb|Helligdage i Danmark||red|1|0|EasInvitationPlugin|31|-1|1700600166|||1695476612||
e46d2114-5bd3-4a79-b0f2-deb73678e101|Kalender||blue|1|1696322883|EasInvitationPlugin|31|-1|1700600166|||1695994350||
4a10a288-d5f8-4f12-aabb-e2d9b446de11|Fødselsdage||#00aeef|1|0|EasInvitationPlugin|31|-1|1700600165|||1695994350||
509868de-3d5d-45d0-9d7c-fe793ee21ab5|Helligdage i Danmark||red|1|0|EasInvitationPlugin|31|-1|1700600165|||1695994350||
97880918-760b-4b12-96b5-d20e52a0ca99|Kalender||green|1|1696506928|EasInvitationPlugin|31|-1|1700600165|||1696334164||
9bf0face-0849-4631-92e9-0326db379b7a|Fødselsdage||pink|1|0|EasInvitationPlugin|31|-1|1700600165|||1696334164||
bfd81b47-1557-4e81-a1b5-20a979d2bfb1|Helligdage i Danmark||blue|1|0|EasInvitationPlugin|31|-1|1700600166|||1696334164||
2faa5ee5-756d-48ba-9410-4408dea819fe|Kalender||#00aeef|1|1697129760|EasInvitationPlugin|25|-1|1700600165|||1696334164||
3bdc447d-c2cf-4b10-9e51-404a8cc8f6bf|Helligdage i Danmark||red|1|0|EasInvitationPlugin|25|-1|1700600165|||1696334164||
f46b4240-158a-4efd-875f-6f1b168a90ef|Kalender||red|1|1697197864|EasInvitationPlugin|31|-1|1700600166|||1696668121||
9418f1bd-dee4-4927-8cbf-aea886f71a8c|Fødselsdage||blue|1|0|EasInvitationPlugin|31|-1|1700600165|||1696668121||
47a04da7-65ba-4f6c-b6fb-52f2ba2c47c1|Helligdage i Danmark||#00aeef|1|0|EasInvitationPlugin|31|-1|1700600165|||1696668121||
ad0f93ca-370d-4558-b962-998b325f3d8a|Kalender||blue|1|1697458056|EasInvitationPlugin|31|-1|1700600166|||1697358066||
74c0b4cf-4c5f-4a94-a312-52853e222a51|Fødselsdage||#00aeef|1|0|EasInvitationPlugin|31|-1|1700600165|||1697358066||
dbd7dd7c-f6c2-47a1-911d-e6f02db898cf|Helligdage i Danmark||red|1|0|EasInvitationPlugin|31|-1|1700600166|||1697358066||
e00bde3b-4b72-4654-875a-1f718aa8ebd8|Kalender||blue|1|1697616875|EasInvitationPlugin|31|-1|1700600166|||1697487305||
d018e11e-2df7-4e00-acc2-61da4c7c45eb|Fødselsdage||red|1|0|EasInvitationPlugin|31|-1|1700600166|||1697487305||
a7d536ec-f94f-4930-8774-c590043987a0|Helligdage i Danmark||#00aeef|1|0|EasInvitationPlugin|31|-1|1700600165|||1697487305||
bc9f73eb-cd90-412f-81dc-1b4d7e71f7da|Kalender||pink|1|1698044458|EasInvitationPlugin|31|-1|1700600166|||1697702537||
9931aa39-4eb5-4607-b77d-650f6034bd96|Fødselsdage||green|1|0|EasInvitationPlugin|31|-1|1700600165|||1697702537||
f390e58e-b4f5-4137-849b-5fb38d6ecc79|Helligdage i Danmark||red|1|0|EasInvitationPlugin|31|-1|1700600166|||1697702537||
cc85f114-03cf-4bdf-bc46-6a2a907c323d|Kalender||#00aeef|1|0|EasInvitationPlugin|25|-1|1700600166|||1697702537||
1e5f93e8-5e20-4f03-b01c-7b7d502b4b09|Helligdage i Danmark||blue|1|0|EasInvitationPlugin|25|-1|1700600164|||1697702537||
e1601b3b-48fb-477f-b3f7-ff628a092d78|Kalender||pink|1|1698760971|EasInvitationPlugin|31|-1|1700600166|||1698073685||
5521b8e5-96ad-4fa9-b3fc-5d090d1603c3|Fødselsdage||#00aeef|1|0|EasInvitationPlugin|31|-1|1700600165|||1698073686||
072be251-7e2e-4267-9300-684a5155291e|Helligdage i Danmark||red|1|0|EasInvitationPlugin|31|-1|1700600164|||1698073686||
b637d696-efd1-4718-b298-7b251b3d3f69|Kalender||green|1|1698360334|EasInvitationPlugin|25|-1|1700600166|||1698073686||
a820a08c-771c-4932-9c62-4921d201c40d|Helligdage i Danmark||blue|1|0|EasInvitationPlugin|25|-1|1700600165|||1698073686||
ee7ceffb-458a-4a48-a1c2-ca95a6052399|Kalender||red|1|1699019760|EasInvitationPlugin|31|-1|1700600166|||1698789388||
bcb6a148-7877-4f76-a370-ab1a3308a8f3|Fødselsdage||#00aeef|1|0|EasInvitationPlugin|31|-1|1700600166|||1698789388||
2d8aa004-8c1b-4b82-b84b-bfb83c83012f|Helligdage i Danmark||blue|1|0|EasInvitationPlugin|31|-1|1700600165|||1698789388||
fddd6590-8b9a-4285-a319-e23f8f0b0535|Kalender||red|1|1699538669|EasInvitationPlugin|31|-1|1700600166|||1699093994||
ec13f825-4b31-4e37-b36e-f162d266ba96|Fødselsdage||blue|1|0|EasInvitationPlugin|31|-1|1700600166|||1699093994||
2a034fc3-f3b6-4c84-8981-323b946fd3f7|Helligdage i Danmark||pink|1|0|EasInvitationPlugin|31|-1|1700600165|||1699093994||
0d46a787-a107-44c5-91b3-5d0fd7f11052|Kalender||green|1|1700084748|EasInvitationPlugin|25|-1|1700600164|||1699093994||
caf56ae2-a79a-4e20-8357-a6f7b6c69011|Helligdage i Danmark||#00aeef|1|0|EasInvitationPlugin|25|-1|1700600166|||1699093994||
2eacfadc-fe59-4d10-99d2-64b21bae47e1|Kalender||blue|1|1699863029|EasInvitationPlugin|31|-1|1700600165|||1699543634||
1dbcb759-c292-4052-b71b-73e7a6e737eb|Fødselsdage||red|1|0|EasInvitationPlugin|31|-1|1700600164|||1699543634||
82e39db6-d0fb-4e2a-976c-4e7d2ce05fc7|Helligdage i Danmark||#00aeef|1|0|EasInvitationPlugin|31|-1|1700600165|||1699543635||
401dd9df-778c-4d82-96a1-1a01e39be73a|Kalender||blue|1|1699972248|EasInvitationPlugin|31|-1|1700600165|||1699885889||
e1a87549-d255-4c47-a7c5-84cef6db9be6|Fødselsdage||red|1|0|EasInvitationPlugin|31|-1|1700600166|||1699885889||
55737156-3134-4f1f-a869-42201921e7b4|Helligdage i Danmark||#00aeef|1|0|EasInvitationPlugin|31|-1|1700600165|||1699885889||
1bba5938-514a-4f1b-9d89-bfbdd4d68eac|Kalender||#00aeef|1|1700566084|EasInvitationPlugin|31|-1|1700600164|||1700345500||
579ad49c-d0e4-48f4-bfed-fa5abf63b12d|Fødselsdage||red|1|0|EasInvitationPlugin|31|-1|1700600165|||1700345501||
09881c59-9261-48d7-bdd6-9ef1dab41c06|Helligdage i Danmark||blue|1|0|EasInvitationPlugin|31|-1|1700600164|||1700345501||

#6

Yes
Now only 2 left:
sqlite> select * from Calendars;
29a23868-6013-47c1-9149-8c3daa932c6c|Default||#0000FF|151|0|||-1|1688986920|||1688986920||
b1376da7-5555-1111-2222-227549c4e570|Fødselsdage||#e00080|87|0|Birthday-Nokia||0|1700600166|||1688986920||
sqlite>