re :possible solution around replacing local.sqlite in calendar-data by backup version

I presume you did make sure Thunderbird was not running whilst doing this otherwise you would not see any change.

Did you also do this:

• Menu icon > Help > More Troubleshooting Information
• Under 'Application Basics' - half way is Profile Folders - click on 'Open Folder' (Windows OS)

In a Mac it may be called 'Open Finder' In Linux it may be called 'Open directory'

window opens showing contents of your profile name folder

• Exit Thunderbird now - this is important

Scroll down and delete the following files:

• folderCache.json
• folderTree.json
• virtualFolders.dat
• session.json
• xulstore.json

Click on 'Mail' folder

• delete 'smart mailboxes' folder

(do not worry if it does not exist - it just means you have never used Unified)

Start Thunderbird.

Clear the error console and restart Thunderbird. then open the Error console and post an image.

Test: If using addon with a calendar eg: Provider for google calendar Suggest uninstall addon. Restart Thunderbird. Report on results. If ok then get a fresh download of addon and install.

Same stuff. Unfortunately no change :-( Console shows :

15:43:46,119 1666446226119 naddons.xpi WARN Checking /Applications/Thunderbird.app/Contents/Resources/distribution/extensions for addons 15:43:48,953 Uncaught (in promise) Exception { name: "NS_ERROR_FAILURE", message: "error executing async statement", result: 2147500037, filename: "resource:///modules/calendar/CalStorageDatabase.jsm", lineNumber: 263, columnNumber: 0, data: null, stack: "handleCompletion@resource:///modules/calendar/CalStorageDatabase.jsm:263:33\n", location: XPCWrappedNative_NoHelper } CalStorageDatabase.jsm:263

I understand that every folder and file is there, TB knows where they are (since it shows the profile and corresponding files), TB knows the adresses, knows history (recent folders are OK), TB can even retrieve mails and send some new ones with right profiles ... it just does not open the folders right ; would it be useful to know where in the code this is programmed and what parameters/variables would need to be changed/adapted ?

(as you can easily imagine when reading ... I am very very very far from being an expert, please excuse any nonsense above)

Hello again,

A few precisions :

after the above attempts and after restarting then closing TB :

folderTree has not been recreated the folderCache file reappeared with right info inside (= same as before, with all my folders correctly described) session is missing virtualFolders is missing xulstore was recreated, only lighter

taking a look at session.json and the session.json.backup file that was saved apparently a few minutes before the "crash/upgade" last week, I see the following differences :

session.json.backup says

{"rev":0,"windows":[{"type":"3pane","tabs":{"rev":0,"selectedIndex":1,"tabs":[{"mode":"folder","state":{"folderURI":"mailbox://nobody@Local%20Folders/Inbox","folderPaneVisible":true,"messagePaneVisible":false,"firstTab":true},"ext":{"quickFilter":{"filterValues":{"text":{"text":null,"states":{"sender":true,"recipients":true,"subject":true}}},"visible":false}}},{"mode":"message","state":{"messageURI":"mailbox-message://nobody@Local%20Folders/Inbox#7437"},"ext":{}}]}}]}

session.json says

{"rev":0,"windows":[{"type":"3pane","tabs":{"rev":0,"selectedIndex":0,"tabs":[{"mode":"folder","state":{"folderURI":"mailbox://nobody@Local%20Folders/Inbox","folderPaneVisible":true,"messagePaneVisible":false,"firstTab":true},"ext":{"quickFilter":{"filterValues":{"text":{"text":null,"states":{"sender":true,"recipients":true,"subject":true}}},"visible":true}}}]}}]}

Obviously, as mentioned above, I am totally unable to understand this, but is it normal that "selectedIndex" changed from 1 to 0 with the upgrade ?

Thanks for your - past and future - help

re : lineNumber: 263, columnNumber: 0, data: null,

I'm wondering if this is implying there is a null value perhaps for events in Calendar and it is causing an issue.

Try this:

• Menu app icon > Help > More Troubleshooting Information
• Under 'Application Basics' - Profile Folder - Click on 'Open folder'

A new window opens showing the contents of your 'profile name' folder.

• Exit Thunderbird if running....this is important

• Click on 'calendar-data' folder to see contents.
• Copy 'local.sqlite' file and put copy onto desktop.
• In calendar-data folder - Rename 'local.sqlite' to 'local.sqlite.bak' -

Download install addon - Firefox sqlite DB manager add-on into Firefox browser.

• https://addons.mozilla.org/en-GB/firefox/addon/sqlite-manager-webext/

• Start the addon - in Firefox browser -you should see a new icon on the toolbar near the menu app icon - hover over icon and it will say SQLite Manager - click on it. It opens in a new tab in the browser.

Use addon to open the desktop copy of the local.sqlite DB

• drag the desktop copy of 'local.sqlite' into the opened addon.

run two SQL queries - you type this - I've highlighted in bold - in the yellow area Searched for items with null id: SELECT * from cal_events WHERE id IS NULL LIMIT 100

If you find any... then use the following to deleted it: DELETE FROM cal_events WHERE id IS NULL

Saved the database file, click on 'Save' located at the bottom - save is usually saved in the 'Downloads' folder.

• Access the 'Downloads' folder on computer to locate the downloaded saved version of 'local.sqlite'.
• put the saved 'local.sqlite' back into the 'calendar-data' folder

restart Thunderbird Note: you may need to use the right click on Thunderbird shortcut icon, select Properties and then 'Run as Administrator'

Please report back on results.

Hello Toad-Hall and thank you for your time,

I fear the above may be too complicated for me : I do not use Firefox as usual browser ... I have downloaded updated Firefox with the add-on but I do not know how to activate it (see enclosed image) = unfortunately, I was not able to perform the recommended test.

Please note that the local.sqlite file is among the numerous files that did not change since the problem and last update (14 octobre 2022 à 14:26, a date and time I now know too well).

I fear I am realizing that TB is too complicated for me and that I may have to move to a more "dumb-user" friendly solution ... :-(

re : I have downloaded updated Firefox with the add-on but I do not know how to activate it (see enclosed image) = unfortunately, I was not able to perform the recommended test.

Image shows you have installed the addon. That looks ok. Please note. You will not cause a problem because the original file - currently called 'local.sqlite.bak' is still in the 'calendar-data' folder. You are doing the following on a copy. But it will tell us if the issue is in any events that have a null id.

The addon would have put an icon on the toolbar - top right near the menu icon (3 lines). Hover over the icon and it says 'SQLite Manager' - click on that icon to start it. It opens in a new tab in Firefox. - See image as guide then left click on the copy of 'local.sqlite' file on desktop and drag file onto the sqlite manager window

• clear the contents from the top yellow section
• Copy this: SELECT * from cal_events WHERE id IS NULL LIMIT 100
• Paste it into the top yellow section - see second image as guide.
• click on 'Execute'

If it returns 'Empty' then it proves the problem is not in that section. Ignore anything shown in the section below. In which case, you can close that Sqlite tab in Firefox and then go back into Thunderbird profile > Calendar-data and rename 'local.sqlite.bak' as 'local.sqlite'.

If it does NOT say 'Empty' and it returns some information then it means there is a null id.

• Clear all the text from the top yellow
• copy this text: DELETE FROM cal_events WHERE id IS NULL
• paste it into the top yellow area
• click on 'Execute'
• Then you need to save the file - look at the very bottom of window - click on 'Save'

check your 'Downloads' folder for a 'local.sqlite' file Put that file into the 'calendar-data' folder.

Please test starting Thunderbird using the following:

Right click on the Thunderbird shortcut icon Click on 'Run as Administrator'

Hello Toad-Hall, Sorry, there is no icon (except one for Pocket) near the menu icon (3 lines) ... I cannot perform the test :-(

As mentioned, it says : SQLite Manager (désactivé) (désactivé mean not activated) Like the add-on has been uploaded but is not operating ... and I cannot find a way to launch it.

Best regards.

I notice there is no button next to the 3 dots. The enable/disable button is not displaying. Did you restart Firefox after installing addon ? Maybe it cannot be enabled because it is currently not available on Toolbar.

Try this:

• Right click on Firefox Toolbar near the 'pocket icon' and select 'Customise Toolbar'
• The 'Sqlite Manager' icon should be in the list.
• Drag and drop it onto the Toolbar next to 'Pocket'.
• click on 'Done' (bottom right)
• Close the 'Customise' tab.

Then check the addon to see if it is now enabled and let me know if the enable/disable slide button has appeared next to the 3 dots.

Hello, Not showing after restart ... Not present in the list shown by "Customise Toolbar" which I had tried before.

-(

Additional information :

I see that in another part of the console BEFORE the above Calendar problem :

15:17:06,532 services.settings: Failed to load last_modified.json: TypeError: NetworkError when attempting to fetch resource. Utils.jsm:330 15:17:06,673 Calendar: XPCWrappedNative_NoHelper { QueryInterface: QueryInterface(), result: Getter, message: Getter, ERROR: 1, INTERNAL: 2, PERM: 3, ABORT: 4, BUSY: 5, LOCKED: 6, NOMEM: 7, … } CalStorageDatabase.jsm:249

Rings any bell ? What's the use of last_modified.json ?

Thanks in advance.

Do you have any Imap mail accounts ? If yes, Try this: Delete just one of the imap accounts then add it back again. check the Folder Pane. If you see accounts and folders then all ok. Otherwise, delete another imap account and then add it back again.

Report on results.

• Menu icon > Help > More Troubleshooting Information
• Under 'Application Basics' - half way is Profile Folders - click on 'Open Folder' (Windows OS)

In a Mac it may be called 'Open Finder' In Linux it may be called 'Open directory'

window opens showing contents of your profile name folder

• Exit Thunderbird now - this is important

• click on 'calendar-data' folder to see contents.

The file called 'local.sqlite' has all calendar stuff.

• Please rename the 'local.sqlite' as 'local.sqlite.old'
• Click on 'backup' folder

You should see a file called 'local.v22.sqlite'

• Copy the 'local.v22.sqlite' file
• go back up to the 'calendar-data' folder
• paste the 'local.v22.sqlite' file into the 'calendar-data' folder
• then rename the 'local.v22.sqlite' file as 'local.sqlite'

Start Thunderbird.

Hello,

I have unfortunately the same problem, I tried with the solution below (sqllite) but all my network Calandars (CalDav) remain empty. It's very annoying.

Note that I was using TBSync and Provider for CalDav that I uninstalled because apparently not necessary since version 102.

My version : 102.5.1 on windows 10, attached a console log when i try to sync

Hello, I have unfortunately the same problem, I tried with the solution below (sqllite) but all my network Calandars (CalDav) remain empty. It's very annoying. Note that I was using TBSync and Provider for CalDav that I uninstalled because apparently not necessary since version 102. My version : 102.5.1 on windows 10, attached a console log when i try to sync

You mention your calendar is empty and you cannot sync them. Q: But is the entire Folder Pane completely empty - no mail accounts - no folders - and there is no message list - everything is blank? If you can see folders in folder pane then it is not the same issue. This means you need to create a new separate question. But in the meantime, if you can see all maila ccounts, folders and emails, then I would remove the Calendars and recreate them.

If all empty then try this simple test: Exit Thunderbird Start Thunderbird using the 'Run as Administrator' command. In Windows : right click on the Thunderbird shortcut icon and select 'Run as Administrator'

Dear Toad-Hall,

I just notice that maybe I'm not into the exact topic As i don't have any issue with my e-mails and folder pane.

All my concern is about the Calendar, and all my appointments that has recently disappear. Specially the CalDav, as you can see on the attached picture, it's empty. I'm using Thunderbird from many years and i never had this kind of issue.

Thanks for your help.

Unable to solve the problem, I finally switched to Apple mail.