1927048 - Unified folders may not be regenerated in case of database issues

Status: RESOLVED FIXED

(Thunderbird :: Folder and Message Lists, defect)

Description

[Kengetsu]

Attachment: Video of option doing nothing.

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:131.0) Gecko/20100101 Firefox/131.0

Steps to reproduce:

Trying to enable the unified folder results in nothing happening and errors being logged to the debug console.

Error intiating smart mode. : Component returned failure code: 0x80550005 [nsIMsgFolder.msgDatabase]
get dbFolderInfo resource:///modules/VirtualFolderWrapper.sys.mjs:241
get searchFolders resource:///modules/VirtualFolderWrapper.sys.mjs:121
init chrome://messenger/content/about3Pane.js:1062
_initMode chrome://messenger/content/about3Pane.js:2115
_toggleMode chrome://messenger/content/about3Pane.js:2097
set activeModes chrome://messenger/content/about3Pane.js:2000
toggleFolderMode chrome://messenger/content/about3Pane.js:1861
oncommand about:3pane:1
about3Pane.js:2117:17
Uncaught : Component returned failure code: 0x80550005 [nsIMsgFolder.msgDatabase]
get dbFolderInfo resource:///modules/VirtualFolderWrapper.sys.mjs:241
get searchFolders resource:///modules/VirtualFolderWrapper.sys.mjs:121
init chrome://messenger/content/about3Pane.js:1062
regenerateMode chrome://messenger/content/about3Pane.js:1079
_initMode chrome://messenger/content/about3Pane.js:2122
_toggleMode chrome://messenger/content/about3Pane.js:2097
set activeModes chrome://messenger/content/about3Pane.js:2000
toggleFolderMode chrome://messenger/content/about3Pane.js:1861
oncommand about:3pane:1
VirtualFolderWrapper.sys.mjs:241
Source map error: Error: URL constructor: is not a valid URL.
Resource URL: about:3pane
Source Map URL:

​

Actual results:

No unified folder gets displayed and the option becomes unchecked again.

Expected results:

Unified folder gets shown in folder list.

Not sure where else to put extra information but this issue only started occurring after the most recent update in the beta version and was fine prior. I also initially noticed odd behavior where the inbox screen was entirely blank and posted about it on reddit (https://www.reddit.com/r/Thunderbird/comments/1gahzkp/thunderbird_beta_1320b6_odd_display_issues/) and ended up using the troubleshoot mode and resetting settings which resulted in the display working again but the unified folders never started working again.

Comment 1

[Kengetsu]

Attachment: Screenshot of console log error

Comment 2

[Kengetsu]

Bit of system information if it's helpful:

Edition Windows 10 Pro
Version 22H2
Installed on ‎2023-‎10-‎02
OS build 19045.5073
Experience Windows Feature Experience Pack 1000.19060.1000.0

Processor AMD Ryzen 9 7900X 12-Core Processor 4.70 GHz
Installed RAM 64.0 GB (63.6 GB usable)

Comment 3

[Wayne Mery (:wsmwk)]

Thanks for the report.

If 132.0b5 worked and 132.0b6 fails, the possibilities are https://bugzilla.mozilla.org/buglist.cgi?bug_id=1922859%2C1912675%2C1917278%2C1916063&list_id=17349013

Do you still see the problem?

Comment 4

[yolsgens]

I have the exact same bug after update to 128.5.2esr:

• unusable blank thunderbird after update
• thunderbird no longer all blank after troubleshoot mode to restore panels to original
• unified folder does nothing after that (exactly like the video)

When creating a new Thunderbird profile, the unified folder option is working fine, however.

Comment 5

[yolsgens]

This doc helped https://kb.mozillazine.org/Unified_Folders_not_working
Deleting the "<thunderbird-profile>\Mail\smart mailboxes" folder fixed the issue for me.

Comment 6

[Hartmut Welpmann [:welpy-cw]]

Attachment: Bug 1927048 - Fix typo that prevented regenerating of smart mailboxes. r=mkmelin

Comment 8

[Kengetsu]

Sorry I forgot all about this bug report. I tried a couple different versions after that initial update to 128 with that same profile, up to latest 134 beta and none of them fixed/restored the unified folder functionality for me. After I 131 beta came out I went ahead and fully rebuilt my profile (I kept a copy of the old one and tested as mentioned above) but that seemed to be the only way to resolve it. Nothing else I tried was able to get the original profile that was upgraded to work. Pretty much the exact behaviour Yolsgen was seeing as well.

Comment 9

[Kengetsu]

Sorry correction to my comment above, it was after 133 came out that I rebuilt my thunderbird profile. Not 131. (couldn't figure out how to edit my post if that's possible so sorry for the extra spam lol)

Comment 10

[Pulsebot]

Pushed by [e-mail]:
https://hg.mozilla.org/comm-central/rev/2696afd03dc1
Fix typo that prevented regenerating of smart mailboxes. r=mkmelin

Comment 11

[Hartmut Welpmann [:welpy-cw]]

Comment on attachment 9445865 [details]
Bug 1927048 - Fix typo that prevented regenerating of smart mailboxes. r=mkmelin

[Approval Request Comment]
Regression caused by (bug #): bug 1893700
User impact if declined: Smart mailboxes may not be regenerated automatically in case of an error.
Testing completed (on c-c, etc.): c-c
Risk to taking this patch (and alternatives if risky): none, simply typo fix

Comment 12

[Hartmut Welpmann [:welpy-cw]]

Release Note Request (optional, but appreciated)
[Suggested wording]: Fixed: Unified folders could become unusable instead of being automatically rebuilt.

Comment 13

[Corey Bryant]

Comment on attachment 9445865 [details]
Bug 1927048 - Fix typo that prevented regenerating of smart mailboxes. r=mkmelin

[Triage Comment]
This will be included in Monday's merge of cc->beta

Comment 14

[Corey Bryant]

Comment on attachment 9445865 [details]
Bug 1927048 - Fix typo that prevented regenerating of smart mailboxes. r=mkmelin

[Triage Comment]
Approved for esr128

Comment 15

[Corey Bryant]

Thunderbird 128.7.1esr:
https://hg.mozilla.org/releases/comm-esr128/rev/89512216f944