Using "New Account" failed after update to 33.0.5

ℹ️ Support
, ,
1

After the update from 31.0.14 → 32.0.9 → 33.0.5 I want to add a new account.
I get the input mask filled up and pressed “Add New Account” and got the message “An error occurred during the request. Unable to proceed.
Bad request”.

The account was created but only the account name and group members was taken.
After this I could change the account with display name and email. So I have no problems with it.

I found a logging entry:
DbalExceptionAn exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘a.has_unread_threads’ in ‘SELECT’
Failed addUser attempt with exception

Is this a bug or was something wrong at the update?

2

@Terkosh please complete the support template since it is unclear what type of installation you have used.

Regardless what installation method was used, that exception points to missing database columns.

did you do any database maintenance after the upgrade? 1 and 2 should solve your issue caused by unknown columns, 3 is optional.

Database actions

1. add missing indecis

occ db:add-missing-indices

2. add missing mimetypes

occ maintenance:repair --include-expensive

3. Rescan and cleanup (optional)

1. repair database tree

occ files:repair-tree

2. rescan files for all users

occ files:scan --all

3. rescan app-data

occ files:scan-app-data

4. cleanup orphaned entries

occ files:cleanup

hth

3

By using the search function in the upper right corner of the forum screen I found the following thread which seems to provide a solution for your issue: