When I go to mail app I get internal server error

[panoskpv]

Steps to reproduce

I have Nextcloud in docker and after updgrade to latest version, and as i erroneously was in beta channel, I got some migration error and upgrade was not possible. I disabled mail app from commnad line and proceed with the update. Now, i went back to stable channel, when I try to access mail app I get internal server error and the following error in logs "BadFunctionCallException: junkMailboxId is not a valid attribute"

Expected behavior

Access mail app

Actual behavior

Internal server error

Mail app version

3.3.0

Mailserver or service

protonmail bridge

Operating system

docker in ubuntu server

PHP engine version

None

Web server

None

Database

MySQL

Additional info

No response

[dugite-code]

This may be stupid but I just saw a similar error, checked the issue tracker and saw this user solved it by restarting. I restarted my docker container and boom it worked. That was a bit weird, probably some cache issue somewhere.

[panoskpv]

Unfortunately, this is not the case for me. I have tried a lot of things, even deleting app and cleaning the database with worse results, so i reverted back to the state i explain on the initial post using backup

[kesselb]

I have Nextcloud in docker and after updgrade to latest version, and as i erroneously was in beta channel, I got some migration error and upgrade was not possible. I disabled mail app from commnad line and proceed with the update. Now, i went back to stable channel, when I try to access mail app I get internal server error and the following error in logs "BadFunctionCallException: junkMailboxId is not a valid attribute"

A possible explanation is, that some migrations were executed successfully, but a faulty migration interrupted the upgrade. Likely https://github.com/nextcloud/mail/pull/8781 or https://github.com/nextcloud/mail/pull/8800.

Idea 1: Reset the database tables and install the latest stable release https://github.com/nextcloud/mail/blob/main/doc/developer.md#resetting-the-app. You will lose your configurations!

Idea 2: Revert the migrations manually. You find junk_mailbox_id in the table oc_mail_accounts. Drop junk_mailbox_id and move_junk from the table. Change to oc_migrations and delete the row for appid = mail and version = 3001Date20230307113544. Please make a backup before, just in case! If you see an error for quota_percentage drop oc_mail_accounts.quota_percentage and migration for appid = mail and version = 3300Date20230706140531.

[Dual-0]

just restart php-fpm

[c-store-cp]

just restart php-fpm

Confirmed. Had this issue on a few native installations, restarting php-fpm resolved the issue.

[joshtrichards]

I have Nextcloud in docker and after upgrade to latest version, and as i erroneously was in beta channel,

For future reference, which image are you using?

[kesselb]

Thanks for your report again :+1:

I assume the problem is resolved now and will therefore close the issue.

Please log a new issue by using the issue template if that problem still occurs and include a reference to this report.