No events after auto-update to 91.1.2
I have been using Thunderbird for at least 15 years with no problems until today, when TB updated from 78.14.0 to 91.1.2. No events nor tasks appeared in my Today Pane. All my email accounts and their folders seem to be intact and working correctly. I do not use any cloud or network storage service and do not use any other mail client on my computer, a Windows 10 Pro. Is it possible to undo the update back to 78.14.0 and have all my events and tasks restored? That would allow me to export the events and tasks and import them after redoing the update to 91.1.2. If the answer is yes, what is the most reliable way to undo the update? Thank you. If you need clarification or more details, please be patient. I use 5x magnification and see only 1/25th of the window at a time; allow a day for followup.
Chosen solution
Try this:
- Menu app icon > Help > Troubleshooting Information
- Under 'Application Basics' - about 11th in list is 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.
- Start the addon - you should see a new icon on the toolbar near the menu app icon - hover over icon and it will say SQLite Manager - clickon it.
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 in the yellow area
Searched for items with null id: SELECT * from cal_events WHERE id IS NULL LIMIT 100
If you find any... So then use the following to deleted it: DELETE FROM cal_events WHERE id IS NULL
Saved the database file, 'Save' located at the bottom - save is usually saved in the 'Downloads' folder.
- Access the 'Downloads' folder to locate downloaded saved version of 'local.sqlite'.
- put the saved 'local.sqlite' back into the 'calendar-data' folder
restart Thunderbird and report on results.
Read this answer in context 👍 1All Replies (3)
Chosen Solution
Try this:
- Menu app icon > Help > Troubleshooting Information
- Under 'Application Basics' - about 11th in list is 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.
- Start the addon - you should see a new icon on the toolbar near the menu app icon - hover over icon and it will say SQLite Manager - clickon it.
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 in the yellow area
Searched for items with null id: SELECT * from cal_events WHERE id IS NULL LIMIT 100
If you find any... So then use the following to deleted it: DELETE FROM cal_events WHERE id IS NULL
Saved the database file, 'Save' located at the bottom - save is usually saved in the 'Downloads' folder.
- Access the 'Downloads' folder to locate downloaded saved version of 'local.sqlite'.
- put the saved 'local.sqlite' back into the 'calendar-data' folder
restart Thunderbird and report on results.
Modified by Toad-Hall
It worked! The sqlite search found one null entry. After replacing the original local.sqlite file with the one with no null entries and restarting TB 91.1.2, all of my events, past and future, and tasks from TB 78.14.0 appeared. Thank you so much, Toad-Hall, for taking the time to provide not only step-by-step instructions but also the navigation cues that allowed me to quickly find the applicable information and buttons despite my very narrow "tunnel" vision.
Good to hear all is now ok and it is up and running again.