1473880 - Version 52.9.0 installed, Calendar gone. Did I lose all calendar entries???? Invalidprefs.js in profile folder

Status: RESOLVED WORKSFORME

(Calendar :: General, defect)

Description

[Pastor Larry]

Attachment: Application Basics (from T'Bird).txt

User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36

Steps to reproduce:

I followed the pop-up to upgrade to Version 52.9.0 and so I did. I closed T'bird and pushed the update button. Once I saw the complete message, I restarted T'bird.


Actual results:

T'Bird restarted OK. The calendar tab was gone. The entries in the menu bar are gone. There is nothing in the Add-On section.


Expected results:

I've upgraded many times before with no problems. The calendar tab should have been there and the calendar menu bar should still be there.
Have I lost all my 100's of calendar entries?

Comment 1

[Pastor Larry]

Attachment: T'Bird Update History

Comment 2

[Jorg K (CEST = GMT+2)]

You didn't lose anything if the calendar has a hiccup ;-)

Do this:
- Tools > Add-ons. Remove Lightning. No kidding.
- Restart TB.
- Tools > Options, Advanced, General, Config Editor.
  Paste the line below into the search box.
  extensions.installedDistroAddon.{e2fda1a4-762b-4020-b5ad-a41df1933103}
- Right-click onto the search result and select "Reset".
- Restart TB.

Working now?

Comment 3

[Pastor Larry]

Attachment: 2018-07-07 19_50_54-Add-ons Manager - Mozilla Thunderbird.png

Comment 4

[Pastor Larry]

(In reply to Jorg K (GMT+2) from comment #2)
> You didn't lose anything if the calendar has a hiccup ;-)
> 
> Do this:
> - Tools > Add-ons. Remove Lightning. No kidding.
> - Restart TB.
> - Tools > Options, Advanced, General, Config Editor.
>   Paste the line below into the search box.
>   extensions.installedDistroAddon.{e2fda1a4-762b-4020-b5ad-a41df1933103}
> - Right-click onto the search result and select "Reset".
> - Restart TB.
> 
> Working now?

Lightning isn't in the list (see attachment)...

Comment 5

[Jorg K (CEST = GMT+2)]

Did you do the following?

- Tools > Options, Advanced, General, Config Editor.
  Paste the line below into the search box.
  extensions.installedDistroAddon.{e2fda1a4-762b-4020-b5ad-a41df1933103}
- Right-click onto the search result and select "Reset".
- Restart TB.

Comment 6

[Pastor Larry]

(In reply to Jorg K (GMT+2) from comment #5)
> Did you do the following?
> 
> - Tools > Options, Advanced, General, Config Editor.
>   Paste the line below into the search box.
>   extensions.installedDistroAddon.{e2fda1a4-762b-4020-b5ad-a41df1933103}
> - Right-click onto the search result and select "Reset".
> - Restart TB.

Yes! It worked, I now have a calendar and a reminder box.
Thank-you so much, I appreciate it.

Is there anything I can do to prevent this issue in the future? Shall I keep this procedure for the future?

Comment 7

[Jorg K (CEST = GMT+2)]

Sadly there are some occasions where the Calendar gets a hiccup. Since it's bundled with TB, this is the way to activate the bundled version no matter what happened before.

Comment 8

[Pastor Larry]

(In reply to Jorg K (GMT+2) from comment #7)
> Sadly there are some occasions where the Calendar gets a hiccup. Since it's
> bundled with TB, this is the way to activate the bundled version no matter
> what happened before.

Thanks for the heads-up and thanks again...

Comment 10

[allen.biggins]

I have tried entering this line in config editor but the line doesn't exist:-

extensions.installedDistroAddon.{e2fda1a4-762b-4020-b5ad-a41df1933103}

I'm using Linux Mint 17.1 (64 bit) and TB 52.9.1 (64-bit) and I had a crash a couple of days ago and now I have no calendar data at all. Here's the story so far:-



When I started TB a few days ago, there were no emails and TB asked if I wanted to use an existing email and I did so I entered my email address and then it worked. I knew that the email data was there because I was able to look at my email using Firefox web browser.
The problem I then found was that there were no message filters and the calendar was completely empty. I wasn't too concerned about the filters but I was concerned about the calendar data.
I then went to View settings for this account, then server settings and examined the data in the box Local directory under the Message storage heading and changed that as I previously advised. Still no data in the calendar.
I've had a look at the files in the calendar-data directory and there's data in the file named local.sqlite.
I've also had a look at the file storage.sdb and it looks very much to me as having no data in it at all.
From what I understand, the calendar data should be in storage.sdb, therefore i need to know what I have to do to get that data (plus any control files if any) back into the place where it should be.
Is it just a matter of copying that file (local.sqlite) and overwriting the storage.sdb file?
I have not reloaded TB or changed any files or settings other than what I have mentioned earlier.
As I have stated in earlier posts that I am using Linux Mint 17.1 64 bit and TB 52.9.1 (64-bit).
Is there any further information that you need to know? If so I would be happy to provide same.
Thank you
Allen
Oz

I'm desperate to recover my calendar data as it has some mighty important info in there. Any help would be tremendously appreciated.
Thank you
Allen

Comment 11

[Jorg K (CEST = GMT+2)]

This is really a support question. Somehow your profile got messed up.

> When I started TB a few days ago, there were no emails and TB asked if
> I wanted to use an existing email and I did so I entered my email
> address and then it worked.
Yes, at that point you set up a new profile. What's the content of your profiles.ini file in your .thunderbird directory?

Please don't touch/copy/more/remove any files before we clarified what happened. Yes, the calendar data is in calendar-data/local.sqlite, but when you run the new profile, it doesn't access the data from the old profile.

Comment 12

[allen.biggins]

details of profiles.ini as requested:-

[General]
StartWithLastProfile=1

[Profile0]
Name=default
IsRelative=1
Path=w388arwk.default

profiles.ini (END)


listing of .thunderbird directory

allenb@arb-P7812 ~/.thunderbird $ ll
total 64
drwx------   7 allenb allenb  4096 Aug 20 13:19 .
drwxr-xr-x 106 allenb allenb 32768 Aug 20 14:04 ..
drwx------   5 allenb allenb  4096 Aug 10 07:37 Crash Reports
drwx------   2 allenb allenb  4096 Oct 25  2014 hkpfqkuc.default
-rw-r--r--   1 allenb allenb    94 Oct 25  2014 profiles.ini
drwx------  11 allenb allenb  4096 Aug 20 14:02 w388arwk.default
drwx------  11 allenb allenb  4096 Aug 20 13:19 w388arwk.default.backup
drwx------   3 allenb allenb  4096 Oct 25  2014 z60d8erq.default

Cheers
Allen

Comment 13

[Jorg K (CEST = GMT+2)]

OK, so only one profile at work, w388arwk.default.

You made that backup? So where is calendar-data/local.sqlite?

I never understood what you meant by:
> I then went to View settings for this account, then server settings and
> examined the data in the box Local directory under the Message storage
> heading and changed that as I previously advised.

Anyway, if the current profile is w388arwk.default, the calendar data is in there it should work if you reinstall Lighting from here:
https://addons.thunderbird.net/en-GB/thunderbird/addon/lightning/
That should be compatible with TB 52.9.1. Or does Lightning already show up as installed and enabled add-on?

What's the exact content of ~/.thunderbird/w388arwk.default/calendar-data/ ?

Comment 14

[allen.biggins]

Attachment: screenshot showing lightning is installed

Comment 15

[allen.biggins]

Contents of directory calendar-data:-

allenb@arb-P7812 ~/.thunderbird/w388arwk.default/calendar-data $ ll
total 1424
drwx------  3 allenb allenb    4096 Aug 18 17:56 .
drwx------ 11 allenb allenb    4096 Aug 20 21:19 ..
drwx------  2 allenb allenb    4096 Oct 25  2014 backup
-rw-r--r--  1 allenb allenb   98304 Jul 19 15:51 deleted.sqlite
-rw-r--r--  1 allenb allenb 1343488 Aug 18 17:56 local.sqlite
allenb@arb-P7812 ~/.thunderbird/w388arwk.default/calendar-data $ cd backup/
allenb@arb-P7812 ~/.thunderbird/w388arwk.default/calendar-data/backup $ ll
total 744
drwx------ 2 allenb allenb   4096 Oct 25  2014 .
drwx------ 3 allenb allenb   4096 Aug 18 17:56 ..
-rw-r--r-- 1 allenb allenb 753664 Oct 25  2014 local.v20.sqlite
allenb@arb-P7812 ~/.thunderbird/w388arwk.default/calendar-data/backup $ 

File local.sqlite is in calendar-data

Lightning is shown as installed (see attachment)

Cheers
Allen

Comment 16

[allen.biggins]

Further info:-

When I start TB it does show the calendar but there is no data in it and there is heaps in there as I've had a look at the contents of the local.sqlite file located in the calendar-data directory.

Allen

Comment 17

[Jorg K (CEST = GMT+2)]

Attachment: calendar-selection.png

You said you had a crash, perhaps the local.sqlite was corrupted. You could download SQLite tools (https://www.sqlite.org/download.html) and check the file. On Windows, I have sqlite3.exe for that job.

Make 500% sure you have a backup copy of local.sqlite.

Or another experiment: Close TB, rename local.sqlite, start TB and create an event. Do you get a new local.sqlite file in the same location?

I vaguely remember a case of not seeing my Calendar data while everything else was OK. Are you sure you have the relevant Calendars selected, see screenshot.

Comment 18

[allen.biggins]

Here's my screenshot of my calendar. AFAIK I've only got one.

I have also previously mentioned that the file where the calendar data is held is empty! That is if I'm correct that it is the file named storage.sdb located in my .thunderbird directory. I recall reading somewhere that is where the calendar data is stored. I have also read that calendar data is stored in the file local.sqlite and that file is in the calendar-data directory. Which one is correct?

There is data in the directory named calendar-data which is shown in an earlier post. That file local.sqlite looks very much to me like it is my calendar data.

FYI here is the contents of my .thunderbird directory:-

allenb@arb-P7812 ~/.thunderbird/w388arwk.default $ ll
total 43504
drwx------ 11 allenb allenb     4096 Aug 21 07:38 .
drwx------  7 allenb allenb     4096 Aug 20 13:19 ..
-rw-r--r--  1 allenb allenb    11999 Aug 20 11:21 abook.mab
-rw-------  1 allenb allenb     6076 Aug 20 08:18 addons.json
-rw-r--r--  1 allenb allenb   524288 Oct 25  2014 addons.sqlite
-rw-r--r--  1 allenb allenb        0 Aug 20 23:07 AlternateServices.txt
-rw-r--r--  1 allenb allenb   524288 Oct 25  2014 blist.sqlite
-rw-------  1 allenb allenb   548885 Aug 17 07:24 blocklist-addons.json
-rw-------  1 allenb allenb    27953 May 19  2017 blocklist-gfx.json
-rw-------  1 allenb allenb   139100 May  4 07:17 blocklist-plugins.json
-rw-------  1 allenb allenb   345209 Aug 20 08:20 blocklist.xml
-rw-r--r--  1 allenb allenb        1 Oct 25  2014 _CACHE_CLEAN_
drwx------  3 allenb allenb     4096 Aug 18 17:56 calendar-data
-rw-r--r--  1 allenb allenb   360448 Aug 20 23:07 cert8.db
-rw-r--r--  1 allenb allenb     1870 Oct 25  2014 cert_override.txt
-rw-r--r--  1 allenb allenb    98304 Oct 25  2014 chromeappsstore.sqlite
-rw-r--r--  1 allenb allenb      162 Aug 20 11:30 compatibility.ini
-rw-r--r--  1 allenb allenb   229376 Jul 19 16:11 content-prefs.sqlite
-rw-r--r--  1 allenb allenb   524288 Aug 20 23:07 cookies.sqlite
-rw-r--r--  1 allenb allenb    32768 Aug 21 07:33 cookies.sqlite-shm
-rw-r--r--  1 allenb allenb    65616 Aug 21 07:33 cookies.sqlite-wal
drwx------  3 allenb allenb     4096 Aug 21 07:34 crashes
drwx------  2 allenb allenb     4096 Aug 21 07:49 datareporting
-rw-r--r--  1 allenb allenb      123 Aug 19 19:53 directoryTree.json
-rw-------  1 allenb allenb      500 Aug 19 10:23 downloads.json
drwx------  4 allenb allenb     4096 Jul 15 21:54 extensions
-rw-r--r--  1 allenb allenb      427 Aug 20 11:30 extensions.ini
-rw-------  1 allenb allenb     6502 Aug 20 11:30 extensions.json
-rw-r--r--  1 allenb allenb   458752 Oct 25  2014 extensions.sqlite
-rw-r--r--  1 allenb allenb      611 Jul 12  2015 folderTree-1.json
-rw-r--r--  1 allenb allenb      805 Jan 17  2016 folderTree-2.json
-rw-r--r--  1 allenb allenb      840 Mar 31  2016 folderTree-3.json
-rw-r--r--  1 allenb allenb      840 Apr  4  2016 folderTree-4.json
-rw-r--r--  1 allenb allenb     1185 Dec  6  2016 folderTree-5.json
-rw-r--r--  1 allenb allenb     1112 Dec 30  2016 folderTree-6.json
-rw-r--r--  1 allenb allenb     1226 Aug 20 23:07 folderTree.json
-rw-r--r--  1 allenb allenb   196608 Oct 25  2014 formhistory.sqlite
-rw-r--r--  1 allenb allenb 35160064 Aug 21 07:34 global-messages-db.sqlite
drwx------  3 allenb allenb     4096 Aug 18 19:15 gmp
-rw-r--r--  1 allenb allenb    88591 Aug 20 12:38 history.mab
drwx------  9 allenb allenb     4096 Aug 19 07:07 ImapMail
-rw-r--r--  1 allenb allenb    67172 Aug 18 18:59 impab.mab
-rw-r--r--  1 allenb allenb    46718 Aug 18 19:15 Invalidprefs.js
-rw-------  1 allenb allenb    18654 Aug  2 10:20 junklog.html
-rw-r--r--  1 allenb allenb    16384 Aug 20 23:07 key3.db
-rw-r--r--  1 allenb allenb  1310720 Aug 17 07:24 kinto.sqlite
-rw-r--r--  1 allenb allenb    42329 Aug 25  2015 localstore.rdf
lrwxrwxrwx  1 allenb allenb       15 Aug 21 07:33 lock -> 127.0.1.1:+2963
-rw-------  1 allenb allenb     7149 Aug 19 06:59 logins.json
drwx------  7 allenb allenb     4096 Aug 19 06:59 Mail
-rw-r--r--  1 allenb allenb      482 Oct 25  2014 mailViews.dat
-rw-r--r--  1 allenb allenb     8317 Jul 21 18:41 mimeTypes.rdf
drwx------  2 allenb allenb     4096 Aug 10 07:48 minidumps
-rw-r--r--  1 allenb allenb    70820 Aug 21 07:43 panacea.dat
-rw-r--r--  1 allenb allenb        0 Aug 21 07:33 .parentlock
-rw-r--r--  1 allenb allenb   131072 Aug 19 07:11 permissions.sqlite
-rw-r--r--  1 allenb allenb     1535 Jul 14 12:15 persdict.dat
-rw-r--r--  1 allenb allenb  2228224 Aug 21 07:42 places.sqlite
-rw-r--r--  1 allenb allenb    32768 Aug 21 07:51 places.sqlite-shm
-rw-r--r--  1 allenb allenb    32824 Aug 21 07:51 places.sqlite-wal
-rw-------  1 allenb allenb      846 May  3 06:24 pluginreg.dat
-rw-r--r--  1 allenb allenb    32335 Oct 25  2014 prefs-1.js
-rw-r--r--  1 allenb allenb    32334 Oct 25  2014 prefs-2.js
-rw-r--r--  1 allenb allenb    19398 Aug 20 23:07 prefs.js
-rw-r--r--  1 allenb allenb    41132 Jun  8 08:04 revocations.txt
drwx------  2 allenb allenb    40960 Aug 10 07:49 saved-telemetry-pings
-rw-------  1 allenb allenb    17134 May 19  2016 search.json
-rw-------  1 allenb allenb     4238 Jul 13 09:24 search.json.mozlz4
-rw-r--r--  1 allenb allenb    16384 Oct 25  2014 secmod.db
-rw-r--r--  1 allenb allenb        0 Aug 20 23:07 SecurityPreloadState.txt
-rw-------  1 allenb allenb       53 Aug 21 07:33 sessionCheckpoints.json
-rw-------  1 allenb allenb      593 Aug 21 07:38 session.json
-rw-------  1 allenb allenb      564 Jul 17 06:17 session_old.json
-rw-r--r--  1 allenb allenb   327680 Oct 30  2014 signons.sqlite
-rw-r--r--  1 allenb allenb     3161 Aug 20 23:07 SiteSecurityServiceState.txt
-rw-r--r--  1 allenb allenb    98304 Oct 25  2014 storage.sdb
-rw-r--r--  1 allenb allenb      512 May 18  2017 storage.sqlite
-rw-r--r--  1 allenb allenb        4 Dec  7  2014 Telemetry.ShutdownTime.txt
-rw-------  1 allenb allenb       25 Jul 23  2016 times.json
-rw-r--r--  1 allenb allenb   206909 Apr 16  2016 training.dat
-rw-r--r--  1 allenb allenb        8 Apr 16  2016 traits.dat
-rw-r--r--  1 allenb allenb       10 Aug 20 23:07 virtualFolders.dat
-rw-r--r--  1 allenb allenb    98304 Aug 19 08:49 webappsstore.sqlite
-rw-r--r--  1 allenb allenb    32768 Aug 21 07:33 webappsstore.sqlite-shm
-rw-r--r--  1 allenb allenb        0 Aug 21 07:33 webappsstore.sqlite-wal
-rw-------  1 allenb allenb    10921 Aug 21 07:36 xulstore.json
-rw-------  1 allenb allenb    12299 Jul 17 06:13 xulstore_old.json
allenb@arb-P7812 ~/.thunderbird/w388arwk.default $ 

I do have the above backed up so there's no danger that I cannot recover if things go awry.

I have downloaded and unzipped the SQL tools as suggested and extracted them but I have no instructions in how to use them.

Comment 19

[allen.biggins]

I have just noticed that there is a file named Invalidprefs.js in the list of files in the .thunderbird directory. What are the implications of this file being present?

Allen

Comment 20

[Jorg K (CEST = GMT+2)]

storage.sdb is the old Calendar storage. As you can see, it's dated 2014, see:
http://kb.mozillazine.org/Files_and_folders_in_the_profile_-_Thunderbird
This article https://support.mozilla.org/en-US/kb/creating-new-calendars mentioning it is also wrong.

storage.sqlite is not related to the calendar.

Your calendar data is in calendar-data/local.sqlite, no doubt, last changed Aug 18, before the crash.

You didn't do my experiment:
Close TB, rename local.sqlite, start TB and create an event. Do you get a new local.sqlite file in the same location?

For the integrity check, please do some research yourself. As I said, yours is a support case, I'm just trying to help, but your in the completely wrong site for that sort of thing.

This works for me on Windows, the commands need to be adapted for Linux:

sqlite3.exe D:\MAIL-THUNDERBIRD\jorgk.IMAP\calendar-data\local.sqlite
sqlite> PRAGMA integrity_check;
or
sqlite> .selftest
sqlite> .quit

See: https://www.sqlite.org/cli.html

Also, you can inspect the SQLite file with the SQLite Browser also available for Linux: https://sqlitebrowser.org/

If you can't work it out, upload the file to https://wetransfer.com/ and I'll try to take a look.

Comment 21

[Jorg K (CEST = GMT+2)]

Invalidprefs.js indicates that there's something wrong with some preferences. What are the first 10 lines of that file?

Comment 22

[allen.biggins]

Here's the contents of the first page of the Invalidprefs.js file:-

# Mozilla User Preferences

/* Do not edit this file.
 *
 * If you make changes to this file while the application is running,
 * the changes will be overwritten when the application exits.
 *
 * To make a manual change to preferences, you can visit the URL about:config
 */

user_pref("accessibility.typeaheadfind.flashBar", 0);
user_pref("alerts.totalOpenTime", 180000);
user_pref("app.update.lastUpdateTime.addon-background-update-timer", 1534540978);
user_pref("app.update.lastUpdateTime.blocklist-background-update-timer", 1534541099);
user_pref("app.update.lastUpdateTime.search-engine-update-timer", 1534578987);
user_pref("app.update.lastUpdateTime.xpi-signature-verification", 1534541219);
user_pref("browser.cache.disk.capacity", 358400);
user_pref("browser.cache.disk.filesystem_reported", 1);
user_pref("browser.cache.disk.smart_size.first_run", false);
user_pref("browser.cache.disk.smart_size.use_old_max", false);
user_pref("browser.cache.disk.smart_size_cached_value", 358400);
user_pref("browser.download.importedFromSqlite", true);
user_pref("browser.download.lastDir", "/home/allenb/Documents");
user_pref("browser.search.countryCode", "AU");
user_pref("browser.search.region", "AU");
user_pref("calendar.alarms.onforevents", 1);
user_pref("calendar.categories.names", "Anniversary,Birthday,Business,Calls,Clients,Competition,Customer,Favorites,Follow up,Gifts,Holidays,Ideas,Issues,Meeting,Miscellaneous,Personal,Projects,Public Holiday,Status,Suppliers,Travel,Vacation");
user_pref("calendar.category.color.anniversary", "#333333");
user_pref("calendar.category.color.birthday", "#996633");
user_pref("calendar.category.color.business", "#FFFFCC");
user_pref("calendar.category.color.calls", "#99FF99");
user_pref("calendar.category.color.clients", "#FF9900");
user_pref("calendar.category.color.competition", "#CC9933");
user_pref("calendar.category.color.customer", "#CCCCCC");
user_pref("calendar.category.color.favorites", "#3366FF");
user_pref("calendar.category.color.follow_up", "#6600CC");
user_pref("calendar.category.color.gifts", "#FF99FF");
user_pref("calendar.category.color.holidays", "#663366");
Invalidprefs.js

I haven't done the experiment yet due to the (my) confusion as to the whereabouts of the calendar data.

Cheers

Allen

Comment 23

[allen.biggins]

I have run the integrity_check and it came back with ok.

sqlite> PRAGMA integrity_check;
ok

.selftest returned an error

sqlite> .selftest
Error: unknown command or invalid arguments:  "selftest". Enter ".help" for help
sqlite> 

Allen

Comment 24

[allen.biggins]

I'm getting nowhere with this problem and have decided to try a different approach. As a retired experienced database programmer I'm going to revive my sql skills and extract the important data from the local.sqlite file located in the calendar-data directory and manually restore the required calendar entries.

Many thanks to those who have been of help but I cannot waste any more time.

Thank you

Allen

Comment 25

[Jorg K (CEST = GMT+2)]

Allen, I got more information from the Calendar developers:

Every calendar has its ID, you can browse the SQLite file and check the cal_id column of most tables, for example cal_events or cal_properties. Since you only have one calendar, there will only be one ID.

The ID needs to match some preferences stored in TB, Tools > Options, Advanced, Config Editor (on Windows). Search for calendar.registry. - you must have entries matching the ID.

If you're preferences got lost, or are not matching the calendar ID, TB won't recognise the calendar and you will see nothing.

I have a calendar which has only six preferences set, so it shouldn't be hard to re-establish the preferences to match the ID. Most likely all you need to do is correct the IDs in the existing preferences after getting the ID from the cal_id column.

Comment 26

[allen.biggins]

One thing has happened. I have managed to recover my message filter rules. This happened because I had a look at the entries in the ~/.thunderbird/w388arwk.default/ImapMail directory and there were several entries in there. I tried each one in turn and after using the one named imap.googlemail.com and restarted TB the message rules appeared but no calendar. None of the other entries caused the calendar to appear.

I'm wondering if I am using the correct version of Lightning. According to the tables I have found at https://developer.mozilla.org/en-US/docs/Mozilla/Calendar/Calendar_Versions I should be using 5.4.9.1 but I have found that I am using 5.4. I have no idea how this happened and I'm wondering if can change to that version the calendar might re-appear. Problem is I don't know how to change the calendar version.
Do you know how I can fix that?
Cheers
Allen

Comment 27

[Jorg K (CEST = GMT+2)]

Lightning 5.4 goes with TB 52.9.1. If it were incompatible, it wouldn't be activated. If you really want, you can install 5.4.9.1 from here:
http://ftp.mozilla.org/pub/calendar/lightning/candidates/5.4.9.1-candidates/build3/
but it won't make a difference.

Please follow the advice I gave in comment #25.

Comment 28

[allen.biggins]

I did actually do that but it didn't seem to add up to me. I will do it again and send you the results. My apologies.

Allen

Comment 29

[allen.biggins]

Attachment: about:config results

Comment 30

[allen.biggins]

Attachment: cal_properties listing

Comment 31

[allen.biggins]

I have done what you told me to do in comment #25 and here's the results:-

The about:config results are in the attachment 9002974 [details] 

I listed the cal_id entries in the cal_properties column and the entries are listed in the cal_properties.txt attachment number 9002979.

I notice that there are two different cal_id values and neither of them match the id in the about:config attachment.

So this looks like the problem and the next q is, how do I fix it?

Do I have to go into about.config and change the name entry?

Should I try and identify those entries in the cal_properties table see that there's 2 different id's in there?

Cheers
Allen

Comment 32

[Jorg K (CEST = GMT+2)]

(In reply to allen.biggins from comment #31)
> So this looks like the problem and the next q is, how do I fix it?
You have four preferences starting with "calendar.registry.", that's less then I've seen in my own setup.

So simply double-click all four and edit to:
calendar.registry.008d1f5a-f545-4beb-aa29-67dfeefdff19.name, etc.

If that doesn't bring the entries back, try the other ID.

Most likely the preferences got messed up somehow and a new calendar with a new ID was created.

Alternatively, you can edit the four preferences and then create four more with the other id. In this case, make the name "Home2" for the second set.

Comment 33

[allen.biggins]

Thank you very much.

Calendar now appears and although the colours look a bit different to that previously, the information is correct.

I've got 2 calendars now, home1 and home2 but home2 doesn't have anything in it. I'd like to get rid of home2 if I can but I don't know how to remove it.

I've used this id 008d1f5a-f545-4beb-aa29-67dfeefdff19 and not worried about the other.

Cheers

Allen

Comment 34

[Jorg K (CEST = GMT+2)]

I don't quite follow. If you have two calendars now, you must have set up preferences for both, so 008d1f5a-f545-4beb-aa29-67dfeefdff19 and 66ab60d1-8b35-4f59-a2d4-d4ac038197ad, one is home1 and the other home2?

Anyway, look at attachment 9002452 [details] for calendar deletion. "View > Calendar > Calendar Pane > Show Calendar Pane" will make that pane visible, as will dragging the left border of the calendar view.

You can unselect the undesired calendar and then delete it. Make sure not to hit the wrong one ;-)

Comment 35

[allen.biggins]

What I did was to set up new preferences for the 008d1f5a-f545-4beb-aa29-67dfeefdff19 one and named it home1 and I renamed the existing (empty) calendar home2. I didn't bother with the 66ab60d1-8b35-4f59-a2d4-d4ac038197ad because the other one (in cal_properties) had everything that I wanted. As the home1 has all my calendar entries and home2 doesn't have any data in it at all, what I would like to do is to just get rid of the home2 one.

Making it (home2) invisible doesn't get rid of it though. It doesn't seem to want to delete home2. No matter which one I select in that left pane, when I click on delete selected pane, the answer comes back asking if I want to delete home1.

I think that I might just leave it as it is and just ignore home2 to be on the safe side. Now that I am aware of it that will be quite easy to do.

Many thanks

Allen

Comment 36

[Jorg K (CEST = GMT+2)]

You could export all events from the desired calendar, then delete/move/rename calendar-data/local.sqlite and re-import.

Comment 37

[allen.biggins]

Thank you for the suggestion but I'm all calendared out and I think I will leave sleeping dogs lie.

Cheers

Allen

Comment 38

[allen.biggins]

I have discovered what the 'other' entries in the calendar are. They are my birthday reminders and I've tried to resurrect them but it didn't work. There aren't that many of them so I thought I would simply enter them again but I've run into a problem. The date is expressed as an integer and I do not know how to convert that to a dd/mm/yyyy format so that I can type them in again.

Here's the list:-

MUM's Birthday|1379975400000000
DAD's Birthday|1437782400000000
A DREADFUL DAY|1445299200000000
MUM's Birthday|1411516800000000
LIL's Birthday|1412121600000000
SCOTT's Birthday|1412812800000000
CARISSA's Birthday|1413849600000000
JOSH's Birthday|1447632000000000
JOSH's Birthday|1416096000000000
Rose Gratton's birthday|1448150400000000
Rose Gratton's birthday|1416614400000000
Alan's birthday|1416787200000000
LOU's Birthday|1416787200000000
EGA's Birthday|1420070400000000
RORY's Birthday|1453420800000000
RORY's Birthday|1421884800000000
ROBERT's Birthday|1398211200000000
BEC's Birthday|1399593600000000
MELVA's Birthday|1399593600000000
ROSE's Birthday|1400976000000000
GAY's Birthday|1434758400000000
GAY's Birthday|1403222400000000
ANDREW's Birthday|1438041600000000
ANDREW's Birthday|1406505600000000
MOLLY's Birthday|1408147200000000
MAX's Birthday|1408665600000000
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
~                                                                                                                                                                                   
"birthdays.txt" 26L, 875C                                                                                                                                         1,1           All

I notice that some of them are duplicated so I'm going to have to work that out.
I hope you can help.
Many thanks
Allen

Comment 39

[Wayne Mery (:wsmwk)]

reference Bug 1530660 - search preferences, addon preferences, UI customization all reset to default in 67.0a1

Comment 40

[Worcester12345]

(In reply to Jorg K (GMT+2) from comment #7)

Sadly there are some occasions where the Calendar gets a hiccup. Since it's
bundled with TB, this is the way to activate the bundled version no matter
what happened before.

Would going beyond "bundled" be a more solid way of doing this?
See: bug 1493008

Comment 41

[Wayne Mery (:wsmwk)]

WFM per reporter

Comment 42

[Pastor Larry]

It happened again. I logged in and my calendar was gone. I tried the fix from last year and, unlike last year, the calendar is still gone.

Can you help?

Comment 43

[Pastor Larry]

Here is the Thunderbird folder with two sub-folders:

~/.thunderbird 
$ ls -l
total 32
drwxr-xr-x 22 ldurfee ldurfee 4096 Nov 27 17:38  7rkcx2ly.default-20190128-1418   <<----- ?
drwx------  5 ldurfee ldurfee 4096 Nov 27 16:23 'Crash Reports'
drwx------  2 ldurfee ldurfee 4096 Nov 23  2018 'Pending Pings'
drwxr-xr-x  2 ldurfee ldurfee 4096 Jan 28  2019  Profiles
drwx------  7 ldurfee ldurfee 4096 Jan 28  2019  r0pp6knk.default                 <<------- ?
-rw-rw-r--  1 ldurfee ldurfee   59 Nov 27 16:23  installs.ini
-rw-r--r--  1 ldurfee ldurfee  286 Nov 27 16:23  profiles.ini
-rw-r--r--  1 ldurfee ldurfee  335 Feb  8  2012  registry.dat-save-me

 ls -l r*.default
total 14684
drwx------ 2 ldurfee ldurfee    4096 Jan 28  2019 blocklists
drwx------ 3 ldurfee ldurfee    4096 Jan 28  2019 crashes
drwx------ 2 ldurfee ldurfee    4096 Jan 28  2019 datareporting
drwx------ 3 ldurfee ldurfee    4096 Nov 26  2018 gmp
drwx------ 2 ldurfee ldurfee    4096 Nov 23  2018 minidumps
-rw-rw-r-- 1 ldurfee ldurfee    1375 Nov 23  2018 abook.mab
-rw------- 1 ldurfee ldurfee     954 Jan 28  2019 addons.json
-rw------- 1 ldurfee ldurfee    1018 Jan 28  2019 addonStartup.json.lz4
-rw-rw-r-- 1 ldurfee ldurfee       0 Jan 28  2019 AlternateServices.txt
-rw-r--r-- 1 ldurfee ldurfee  524288 Nov 23  2018 blist.sqlite
-rw------- 1 ldurfee ldurfee  395478 Jan 28  2019 blocklist.xml
-rw------- 1 ldurfee ldurfee  229376 Nov 23  2018 cert9.db
-rw------- 1 ldurfee ldurfee     162 Jan 28  2019 compatibility.ini
-rw-r--r-- 1 ldurfee ldurfee  524288 Jan 28  2019 cookies.sqlite
-rw------- 1 ldurfee ldurfee      23 Nov 23  2018 directoryTree.json
-rw------- 1 ldurfee ldurfee    5601 Jan 28  2019 extensions.json
-rw-r--r-- 1 ldurfee ldurfee 5242880 Nov 23  2018 favicons.sqlite
-rw------- 1 ldurfee ldurfee       2 Jan 28  2019 folderTree.json
-rw-r--r-- 1 ldurfee ldurfee 1245184 Nov 23  2018 global-messages-db.sqlite
-rw-rw-r-- 1 ldurfee ldurfee    1375 Nov 23  2018 history.mab
-rw------- 1 ldurfee ldurfee  294912 Nov 23  2018 key4.db
-rw-r--r-- 1 ldurfee ldurfee 1474560 Jan 28  2019 kinto.sqlite
-rw-r--r-- 1 ldurfee ldurfee     482 Nov 23  2018 mailViews.dat
-rw-r--r-- 1 ldurfee ldurfee   98304 Nov 23  2018 permissions.sqlite
-rw------- 1 ldurfee ldurfee     876 Nov 23  2018 pkcs11.txt
-rw-r--r-- 1 ldurfee ldurfee 5242880 Nov 23  2018 places.sqlite
-rw------- 1 ldurfee ldurfee     172 Jan 28  2019 pluginreg.dat
-rw------- 1 ldurfee ldurfee    3574 Jan 28  2019 prefs.js
-rw-rw-r-- 1 ldurfee ldurfee   45475 Jan 28  2019 revocations.txt
-rw------- 1 ldurfee ldurfee    5524 Jan 28  2019 search.json.mozlz4
-rw-rw-r-- 1 ldurfee ldurfee       0 Jan 28  2019 SecurityPreloadState.txt
-rw------- 1 ldurfee ldurfee     204 Jan 28  2019 sessionCheckpoints.json
-rw------- 1 ldurfee ldurfee     203 Jan 28  2019 session.json
-rw-rw-r-- 1 ldurfee ldurfee      65 Jan 28  2019 SiteSecurityServiceState.txt
-rwx------ 1 ldurfee ldurfee      29 Nov 23  2018 times.json
-rw-rw-r-- 1 ldurfee ldurfee      10 Jan 28  2019 virtualFolders.dat
-rw------- 1 ldurfee ldurfee     823 Jan 28  2019 xulstore.json

$ ls -l 7rkcx2ly.default-20190128-1418
total 212460
drwxr-xr-x 2 ldurfee ldurfee      4096 Jan 28  2019 awsomeautoarchive
drwxr-xr-x 2 ldurfee ldurfee      4096 Nov 26 19:39 blocklists
drwxr-xr-x 3 ldurfee ldurfee      4096 Nov 27 15:53 calendar-data
drwxr-xr-x 3 ldurfee ldurfee      4096 Nov 27 17:24 crashes
drwxr-xr-x 2 ldurfee ldurfee      4096 Nov 27 15:53 datareporting
drwxr-xr-x 4 ldurfee ldurfee      4096 Jan 28  2019 Delete-Me-ExternalMailFolders_Expunge
drwxr-xr-x 2 ldurfee ldurfee      4096 Nov 27 06:48 extensions
drwxr-xr-x 2 ldurfee ldurfee      4096 Jan 28  2019 foxclocks
drwxr-xr-x 4 ldurfee ldurfee      4096 Jan 28  2019 gmp
drwxr-xr-x 3 ldurfee ldurfee      4096 Jan 28  2019 ImapMail
drwxr-xr-x 2 ldurfee ldurfee      4096 Aug 27 08:32 lwtheme
drwxr-xr-x 7 ldurfee ldurfee      4096 Mar 11  2019 Mail
drwxr-xr-x 2 ldurfee ldurfee      4096 Jan 28  2019 minidumps
drwxr-xr-x 3 ldurfee ldurfee      4096 Jan 28  2019 News
drwxr-xr-x 2 ldurfee ldurfee      4096 Nov 21 18:42 Photos
drwxr-xr-x 2 ldurfee ldurfee      4096 Sep  9 10:41 quicktext
drwxr-xr-x 2 ldurfee ldurfee      4096 Nov 10 07:45 saved-telemetry-pings
drwxr-xr-x 3 ldurfee ldurfee      4096 Nov 27 16:25 storage
drwxr-xr-x 2 ldurfee ldurfee      4096 Jan 28  2019 TestPilotExperimentFiles
drwxr-xr-x 2 ldurfee ldurfee      4096 Jan 28  2019 webapps
-rw-r--r-- 1 ldurfee ldurfee       903 Jun 21  2015 0xC84BD23570A7EA1B_rev.asc
-rw-r--r-- 1 ldurfee ldurfee     10560 Nov  8 07:37 abook-1.mab
-rw-r--r-- 1 ldurfee ldurfee    151203 Nov 27 14:33 abook.mab
-rw------- 1 ldurfee ldurfee     43260 Nov 26 19:37 addons.json
-rw-r--r-- 1 ldurfee ldurfee    524288 Aug 28  2014 addons.sqlite
-rw------- 1 ldurfee ldurfee      2695 Nov 27 16:47 addonStartup.json.lz4
-rw-r--r-- 1 ldurfee ldurfee         0 Nov 27 17:22 AlternateServices.txt
-rw-r--r-- 1 ldurfee ldurfee    524288 Aug 28  2014 blist.sqlite
-rw-r--r-- 1 ldurfee ldurfee    572507 Nov  5  2018 blocklist-addons.json
-rw-r--r-- 1 ldurfee ldurfee     27953 May 26  2017 blocklist-gfx.json
-rw-r--r-- 1 ldurfee ldurfee    139100 Sep 13  2018 blocklist-plugins.json
-rw------- 1 ldurfee ldurfee    741913 Nov 26 19:39 blocklist.xml
-rw-r--r-- 1 ldurfee ldurfee    327680 Nov  7  2018 cert8.db
-rw-r--r-- 1 ldurfee ldurfee    360448 Sep 23 07:26 cert9.db
-rw-r--r-- 1 ldurfee ldurfee       372 Oct  6  2013 cert_override.txt
-rw-r--r-- 1 ldurfee ldurfee     98304 Feb 16  2012 chromeappsstore.sqlite
-rw-r--r-- 1 ldurfee ldurfee       162 Nov 27 16:23 compatibility.ini
-rw-r--r-- 1 ldurfee ldurfee    229376 Oct 12 13:07 content-prefs.sqlite
-rw-r--r-- 1 ldurfee ldurfee    524288 Nov 27 17:24 cookies.sqlite
-rw-r--r-- 1 ldurfee ldurfee    524704 Nov 27 17:24 cookies.sqlite-wal
-rw-r--r-- 1 ldurfee ldurfee       407 Nov 26 18:34 directoryTree.json
-rw------- 1 ldurfee ldurfee     63775 Nov 26 15:54 downloads.json
-rw------- 1 ldurfee ldurfee       852 Nov 27 16:25 extension-preferences.json
-rw------- 1 ldurfee ldurfee     56935 Nov 27 16:47 extensions.json
-rw-r--r-- 1 ldurfee ldurfee      9232 Mar 22  2014 extensions.log
-rw-r--r-- 1 ldurfee ldurfee    458752 Aug 24  2014 extensions.sqlite
-rw-r--r-- 1 ldurfee ldurfee   5242880 Nov 27 11:38 favicons.sqlite
-rw-r--r-- 1 ldurfee ldurfee         0 Nov 27 16:29 favicons.sqlite-wal
-rw-r--r-- 1 ldurfee ldurfee     11184 Nov 27 17:22 folderTree.json
-rw-r--r-- 1 ldurfee ldurfee    196608 May  7  2018 formhistory.sqlite
-rw-r--r-- 1 ldurfee ldurfee 194805760 Nov 27 16:52 global-messages-db.sqlite
-rw------- 1 ldurfee ldurfee       756 Feb 16  2019 handlers.json
-rw-r--r-- 1 ldurfee ldurfee    122785 Nov 27 10:27 history.mab
-rw------- 1 ldurfee ldurfee     31766 Oct  9 13:34 impab-1.mab
-rw------- 1 ldurfee ldurfee    151667 Nov 23 07:26 impab-2.mab
-rw-r--r-- 1 ldurfee ldurfee     90563 Oct 14 09:21 impab.mab
-rw-r--r-- 1 ldurfee ldurfee      1985 Aug  2 21:23 junklog.html
-rw-r--r-- 1 ldurfee ldurfee     16384 Nov  7  2018 key3.db
-rw-r--r-- 1 ldurfee ldurfee    294912 Nov  7  2018 key4.db
-rw-r--r-- 1 ldurfee ldurfee   2064384 Nov 26 19:39 kinto.sqlite
-rw-r--r-- 1 ldurfee ldurfee     62909 Jun 22  2015 lightweighttheme-footer
-rw-r--r-- 1 ldurfee ldurfee    157627 Jun 22  2015 lightweighttheme-header
-rw-r--r-- 1 ldurfee ldurfee     47769 Jun 22  2015 localstore.rdf
lrwxrwxrwx 1 ldurfee ldurfee        18 Nov 27 17:23 lock -> 192.168.1.40:+3322
-rw------- 1 ldurfee ldurfee      2185 Jul  7 08:02 logins.json
-rw-r--r-- 1 ldurfee ldurfee       504 Feb  8  2012 mailViews.dat
-rw-r--r-- 1 ldurfee ldurfee      6109 Nov  1  2018 mimeTypes.rdf
-rw-r--r-- 1 ldurfee ldurfee    146696 Nov 27 17:29 panacea.dat
-rw-r--r-- 1 ldurfee ldurfee    131072 Nov 27 16:24 permissions.sqlite
-rw-r--r-- 1 ldurfee ldurfee      2771 Nov 27 10:24 persdict.dat
-rw------- 1 ldurfee ldurfee       878 Feb 16  2019 pkcs11.txt
-rw-r--r-- 1 ldurfee ldurfee   5242880 Nov 27 15:53 places.sqlite
-rw-r--r-- 1 ldurfee ldurfee    655872 Nov 27 16:29 places.sqlite-wal
-rw------- 1 ldurfee ldurfee       172 Oct  7 16:11 pluginreg.dat
-rw-r--r-- 1 ldurfee ldurfee     77613 Nov 27 17:36 prefs.js
-rw-r--r-- 1 ldurfee ldurfee     46981 Apr 12  2018 prefs.zal
-rw-r--r-- 1 ldurfee ldurfee     58645 Nov 12 13:29 revocations.txt
-rw-r--r-- 1 ldurfee ldurfee     20552 Apr 10  2016 search.json
-rw------- 1 ldurfee ldurfee      1880 Nov 27 17:23 search.json.mozlz4
-rw-r--r-- 1 ldurfee ldurfee        29 Jul 19  2012 search-metadata.json
-rw-r--r-- 1 ldurfee ldurfee     65536 Apr 25  2012 search.sqlite
-rw-r--r-- 1 ldurfee ldurfee     16384 Feb  8  2012 secmod.db
-rw-r--r-- 1 ldurfee ldurfee         0 Nov 27 17:22 SecurityPreloadState.txt
-rw------- 1 ldurfee ldurfee        53 Nov 27 17:23 sessionCheckpoints.json
-rw------- 1 ldurfee ldurfee       673 Nov 27 17:28 session.json
-rw-r--r-- 1 ldurfee ldurfee    327680 Jun  1  2015 signons.sqlite
-rw-r--r-- 1 ldurfee ldurfee      4985 Nov 27 17:29 SiteSecurityServiceState.txt
-rw-r--r-- 1 ldurfee ldurfee     98304 Feb 16  2012 storage.sdb
-rw-r--r-- 1 ldurfee ldurfee       512 Nov 27 16:24 storage.sqlite
-rw-r--r-- 1 ldurfee ldurfee         1 Apr  4  2019 Telemetry.FailedProfileLocks.txt
-rw-rw-r-- 1 ldurfee ldurfee         4 Nov 27 17:22 Telemetry.ShutdownTime.txt
-rw-r--r-- 1 ldurfee ldurfee   1411206 Apr  9  2014 TestPilotErrorLog.log
-rw-r--r-- 1 ldurfee ldurfee        25 Apr 24  2016 times.json
-rw-r--r-- 1 ldurfee ldurfee    131952 Sep 22 18:54 training.dat
-rw-r--r-- 1 ldurfee ldurfee         8 Sep 22 18:54 traits.dat
-rw-r--r-- 1 ldurfee ldurfee      1052 Nov 27 17:22 virtualFolders.dat
-rw-r--r-- 1 ldurfee ldurfee     98304 Nov 27 11:38 webappsstore.sqlite
-rw-r--r-- 1 ldurfee ldurfee     65616 Nov 27 17:24 webappsstore.sqlite-wal
-rw------- 1 ldurfee ldurfee     18361 Nov 27 17:26 xulstore.json

If there is anything else you need, please let me know. I am lost without a calendar.

Can you help?

Comment 44

[Pastor Larry]

Laptop details-

Thunderbird version:
68.2.1 (64-bit).
OS:
64-bit Ubuntu 18.04.2 LTS
Gnome: 3.28.2
Laptop:
Acer A515-51-50RR
Mem: 7.7 GiB ram; Proc: Intel Core i5-7200U CPU @ 2.50GHz × 4;
Graphics: Intel HD Graphics 620 (Kaby Lake GT2); HDD: 1 TB

If there is any other information needed, please let me know.

I really need my calendar operational again

Can you help?

Comment 45

[Wayne Mery (:wsmwk)]

(In reply to Pastor Larry from comment #42)

It happened again. I logged in and my calendar was gone. I tried the fix from last year and, unlike last year, the calendar is still gone.

Sorry there was no response - Closed bugs tend to get lost in the system, so let's reopen it. I'm not familiar with calendar so I'll copy some people who are. Note comment 32

Comment 46

[Worcester12345]

Any newer successes or failures on this bug?

Comment 47

[Pastor Larry]

Everything seems OK. The last time I encountered the problem (awhile ago), the FIX (mentioned elsewhere in this thread) worked.
Thanks to everyone for your help and support. It is truly appreciated.

Comment 48

[Wayne Mery (:wsmwk)]

Calendar add-on is now integrated with Thunderbird, so it is likely this issue should no longer occur and closing this bug report as a result.

Please comment if you are still seeing a problem when using a current version of Thunderbird.