Guests app is incompatible with Polls app (which becomes unusable when Guests is installed)

[Moini]

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github (I've searched it).
• I agree to follow Nextcloud's Code of Conduct.

What went wrong, what did you observe?

I created a (date) poll with only the 'names' option, also one with optional email option, shared via public link, and then opened a private Firefox window / Chromium to test whether it works.

No matter which name I enter, I always get a red warning that the name is invalid or reserved. There is no way to use a poll at all. The tested names do not exist as user names on the instance.

What did you expect, how polls should behave instead?

I should be able to enter a name. (also, any name. No matter whether it's already registered (people may have the same name) and just a name at all.) I don't want to use the anonymous option for our team.

From the logs, it looks as if a migration for the email column were missing. My admin settings do not currently complain about missing migrations, I've done them all recently.

What steps does it need to replay this bug?

1. Create a poll
2. Share a public link
3. Open the link in a different browser / private window / tab environment where you're not logged in to Nextcloud.
4. Try to fill out the poll

Affected polls version

Current (9.1.1)

Installation method

Installed/updated from the appstore (Apps section of your site)

Installation type

Updated from a minor version within same major version (i.e. 8.0.0 to 8.1.2)

Can you rule out that any extension you use is involved in the issue?

• I have checked all browser extension

Which browser did you use, when experiencing the bug?

• Firefox
• Chrome
• Chromium/Chromium based (i.e. Edge)
• Safari
• Other/Don't know

Other browser

No response

Add your browser log here

runtime-core.esm-bundler.js:8631 AxiosError: Request failed with status code 500
    at GA (index.js:23:5)
    at XMLHttpRequest.f (index.js:23:5)
(anonym)	@	runtime-core.esm-bundler.js:8631

Additional client environment information

No response

NC version

Nextcloud 33 (Hub 26 Winter)

Other Nextcloud version

No response

PHP engine version

PHP 8.3

Other PHP version

No response

Database engine

MariaDB

Database Engine version or other Database

No response

Which user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other/Don't know

Add your nextcloud server log here

[index] Fehler: An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'
	POST /apps/polls/check/username
	von xxx von -- um 08.05.2026, 16:38:56
{
    "reqId": "xxx",
    "level": 3,
    "time": "2026-05-08T14:38:56+00:00",
    "remoteAddr": "xxx",
    "user": "--",
    "app": "index",
    "method": "POST",
    "url": "/apps/polls/check/username",
    "scriptName": "/index.php",
    "message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'",
    "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; ) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/126.0.6478.61 Chrome/126.0.6478.61 Not/A)Brand/8  Safari/537.36",
    "version": "33.0.3.2",
    "exception": {
        "Exception": "OC\\DB\\Exceptions\\DbalException",
        "Message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'",
        "Code": 1054,
        "Trace": [
            {
                "file": "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
                "line": 53,
                "function": "wrap",
                "class": "OC\\DB\\Exceptions\\DbalException",
                "type": "::"
            },
            {
                "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
                "line": 268,
                "function": "executeQuery",
                "class": "OC\\DB\\ConnectionAdapter",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/apps/guests/lib/UserBackend.php",
                "line": 241,
                "function": "executeQuery",
                "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/apps/guests/lib/UserBackend.php",
                "line": 383,
                "function": "getDisplayNames",
                "class": "OCA\\Guests\\UserBackend",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/lib/private/User/Manager.php",
                "line": 260,
                "function": "getUsers",
                "class": "OCA\\Guests\\UserBackend",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/apps/polls/lib/Model/User/User.php",
                "line": 113,
                "function": "search",
                "class": "OC\\User\\Manager",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/apps/polls/lib/Service/SystemService.php",
                "line": 381,
                "function": "search",
                "class": "OCA\\Polls\\Model\\User\\User",
                "type": "::"
            },
            {
                "file": "/var/www/nextcloud/apps/polls/lib/Service/SystemService.php",
                "line": 263,
                "function": "validatePublicUsername",
                "class": "OCA\\Polls\\Service\\SystemService",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/apps/polls/lib/Controller/PublicController.php",
                "line": 403,
                "function": "validatePublicUsernameByToken",
                "class": "OCA\\Polls\\Service\\SystemService",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/apps/polls/lib/Controller/BaseController.php",
                "line": 42,
                "function": "OCA\\Polls\\Controller\\{closure}",
                "class": "OCA\\Polls\\Controller\\PublicController",
                "type": "->",
                "args": [
                    "*** sensitive parameters replaced ***"
                ]
            },
            {
                "file": "/var/www/nextcloud/apps/polls/lib/Controller/PublicController.php",
                "line": 402,
                "function": "response",
                "class": "OCA\\Polls\\Controller\\BaseController",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
                "line": 205,
                "function": "validatePublicDisplayName",
                "class": "OCA\\Polls\\Controller\\PublicController",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
                "line": 118,
                "function": "executeController",
                "class": "OC\\AppFramework\\Http\\Dispatcher",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
                "line": 153,
                "function": "dispatch",
                "class": "OC\\AppFramework\\Http\\Dispatcher",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/lib/private/Route/Router.php",
                "line": 321,
                "function": "main",
                "class": "OC\\AppFramework\\App",
                "type": "::"
            },
            {
                "file": "/var/www/nextcloud/lib/base.php",
                "line": 1155,
                "function": "match",
                "class": "OC\\Route\\Router",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/index.php",
                "line": 25,
                "function": "handleRequest",
                "class": "OC",
                "type": "::"
            }
        ],
        "File": "/var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php",
        "Line": 56,
        "Previous": {
            "Exception": "Doctrine\\DBAL\\Exception\\InvalidFieldNameException",
            "Message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'",
            "Code": 1054,
            "Trace": [
                {
                    "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
                    "line": 1976,
                    "function": "convert",
                    "class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
                    "line": 1918,
                    "function": "handleDriverException",
                    "class": "Doctrine\\DBAL\\Connection",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
                    "line": 1111,
                    "function": "convertExceptionDuringQuery",
                    "class": "Doctrine\\DBAL\\Connection",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
                    "line": 420,
                    "function": "executeQuery",
                    "class": "Doctrine\\DBAL\\Connection",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
                    "line": 50,
                    "function": "executeQuery",
                    "class": "OC\\DB\\Connection",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
                    "line": 268,
                    "function": "executeQuery",
                    "class": "OC\\DB\\ConnectionAdapter",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/apps/guests/lib/UserBackend.php",
                    "line": 241,
                    "function": "executeQuery",
                    "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/apps/guests/lib/UserBackend.php",
                    "line": 383,
                    "function": "getDisplayNames",
                    "class": "OCA\\Guests\\UserBackend",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/lib/private/User/Manager.php",
                    "line": 260,
                    "function": "getUsers",
                    "class": "OCA\\Guests\\UserBackend",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/apps/polls/lib/Model/User/User.php",
                    "line": 113,
                    "function": "search",
                    "class": "OC\\User\\Manager",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/apps/polls/lib/Service/SystemService.php",
                    "line": 381,
                    "function": "search",
                    "class": "OCA\\Polls\\Model\\User\\User",
                    "type": "::"
                },
                {
                    "file": "/var/www/nextcloud/apps/polls/lib/Service/SystemService.php",
                    "line": 263,
                    "function": "validatePublicUsername",
                    "class": "OCA\\Polls\\Service\\SystemService",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/apps/polls/lib/Controller/PublicController.php",
                    "line": 403,
                    "function": "validatePublicUsernameByToken",
                    "class": "OCA\\Polls\\Service\\SystemService",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/apps/polls/lib/Controller/BaseController.php",
                    "line": 42,
                    "function": "OCA\\Polls\\Controller\\{closure}",
                    "class": "OCA\\Polls\\Controller\\PublicController",
                    "type": "->",
                    "args": [
                        "*** sensitive parameters replaced ***"
                    ]
                },
                {
                    "file": "/var/www/nextcloud/apps/polls/lib/Controller/PublicController.php",
                    "line": 402,
                    "function": "response",
                    "class": "OCA\\Polls\\Controller\\BaseController",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
                    "line": 205,
                    "function": "validatePublicDisplayName",
                    "class": "OCA\\Polls\\Controller\\PublicController",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
                    "line": 118,
                    "function": "executeController",
                    "class": "OC\\AppFramework\\Http\\Dispatcher",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
                    "line": 153,
                    "function": "dispatch",
                    "class": "OC\\AppFramework\\Http\\Dispatcher",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/lib/private/Route/Router.php",
                    "line": 321,
                    "function": "main",
                    "class": "OC\\AppFramework\\App",
                    "type": "::"
                },
                {
                    "file": "/var/www/nextcloud/lib/base.php",
                    "line": 1155,
                    "function": "match",
                    "class": "OC\\Route\\Router",
                    "type": "->"
                },
                {
                    "file": "/var/www/nextcloud/index.php",
                    "line": 25,
                    "function": "handleRequest",
                    "class": "OC",
                    "type": "::"
                }
            ],
            "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
            "Line": 69,
            "Previous": {
                "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
                "Message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'",
                "Code": 1054,
                "Trace": [
                    {
                        "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
                        "line": 132,
                        "function": "new",
                        "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
                        "type": "::"
                    },
                    {
                        "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
                        "line": 1104,
                        "function": "execute",
                        "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
                        "line": 420,
                        "function": "executeQuery",
                        "class": "Doctrine\\DBAL\\Connection",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
                        "line": 50,
                        "function": "executeQuery",
                        "class": "OC\\DB\\Connection",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
                        "line": 268,
                        "function": "executeQuery",
                        "class": "OC\\DB\\ConnectionAdapter",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/apps/guests/lib/UserBackend.php",
                        "line": 241,
                        "function": "executeQuery",
                        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/apps/guests/lib/UserBackend.php",
                        "line": 383,
                        "function": "getDisplayNames",
                        "class": "OCA\\Guests\\UserBackend",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/lib/private/User/Manager.php",
                        "line": 260,
                        "function": "getUsers",
                        "class": "OCA\\Guests\\UserBackend",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/apps/polls/lib/Model/User/User.php",
                        "line": 113,
                        "function": "search",
                        "class": "OC\\User\\Manager",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/apps/polls/lib/Service/SystemService.php",
                        "line": 381,
                        "function": "search",
                        "class": "OCA\\Polls\\Model\\User\\User",
                        "type": "::"
                    },
                    {
                        "file": "/var/www/nextcloud/apps/polls/lib/Service/SystemService.php",
                        "line": 263,
                        "function": "validatePublicUsername",
                        "class": "OCA\\Polls\\Service\\SystemService",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/apps/polls/lib/Controller/PublicController.php",
                        "line": 403,
                        "function": "validatePublicUsernameByToken",
                        "class": "OCA\\Polls\\Service\\SystemService",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/apps/polls/lib/Controller/BaseController.php",
                        "line": 42,
                        "function": "OCA\\Polls\\Controller\\{closure}",
                        "class": "OCA\\Polls\\Controller\\PublicController",
                        "type": "->",
                        "args": [
                            "*** sensitive parameters replaced ***"
                        ]
                    },
                    {
                        "file": "/var/www/nextcloud/apps/polls/lib/Controller/PublicController.php",
                        "line": 402,
                        "function": "response",
                        "class": "OCA\\Polls\\Controller\\BaseController",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
                        "line": 205,
                        "function": "validatePublicDisplayName",
                        "class": "OCA\\Polls\\Controller\\PublicController",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
                        "line": 118,
                        "function": "executeController",
                        "class": "OC\\AppFramework\\Http\\Dispatcher",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
                        "line": 153,
                        "function": "dispatch",
                        "class": "OC\\AppFramework\\Http\\Dispatcher",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/lib/private/Route/Router.php",
                        "line": 321,
                        "function": "main",
                        "class": "OC\\AppFramework\\App",
                        "type": "::"
                    },
                    {
                        "file": "/var/www/nextcloud/lib/base.php",
                        "line": 1155,
                        "function": "match",
                        "class": "OC\\Route\\Router",
                        "type": "->"
                    },
                    {
                        "file": "/var/www/nextcloud/index.php",
                        "line": 25,
                        "function": "handleRequest",
                        "class": "OC",
                        "type": "::"
                    }
                ],
                "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
                "Line": 24,
                "Previous": {
                    "Exception": "PDOException",
                    "Message": "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'",
                    "Code": "42S22",
                    "Trace": [
                        {
                            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
                            "line": 130,
                            "function": "execute",
                            "class": "PDOStatement",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
                            "line": 1104,
                            "function": "execute",
                            "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
                            "line": 420,
                            "function": "executeQuery",
                            "class": "Doctrine\\DBAL\\Connection",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
                            "line": 50,
                            "function": "executeQuery",
                            "class": "OC\\DB\\Connection",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
                            "line": 268,
                            "function": "executeQuery",
                            "class": "OC\\DB\\ConnectionAdapter",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/apps/guests/lib/UserBackend.php",
                            "line": 241,
                            "function": "executeQuery",
                            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/apps/guests/lib/UserBackend.php",
                            "line": 383,
                            "function": "getDisplayNames",
                            "class": "OCA\\Guests\\UserBackend",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/lib/private/User/Manager.php",
                            "line": 260,
                            "function": "getUsers",
                            "class": "OCA\\Guests\\UserBackend",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/apps/polls/lib/Model/User/User.php",
                            "line": 113,
                            "function": "search",
                            "class": "OC\\User\\Manager",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/apps/polls/lib/Service/SystemService.php",
                            "line": 381,
                            "function": "search",
                            "class": "OCA\\Polls\\Model\\User\\User",
                            "type": "::"
                        },
                        {
                            "file": "/var/www/nextcloud/apps/polls/lib/Service/SystemService.php",
                            "line": 263,
                            "function": "validatePublicUsername",
                            "class": "OCA\\Polls\\Service\\SystemService",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/apps/polls/lib/Controller/PublicController.php",
                            "line": 403,
                            "function": "validatePublicUsernameByToken",
                            "class": "OCA\\Polls\\Service\\SystemService",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/apps/polls/lib/Controller/BaseController.php",
                            "line": 42,
                            "function": "OCA\\Polls\\Controller\\{closure}",
                            "class": "OCA\\Polls\\Controller\\PublicController",
                            "type": "->",
                            "args": [
                                "*** sensitive parameters replaced ***"
                            ]
                        },
                        {
                            "file": "/var/www/nextcloud/apps/polls/lib/Controller/PublicController.php",
                            "line": 402,
                            "function": "response",
                            "class": "OCA\\Polls\\Controller\\BaseController",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
                            "line": 205,
                            "function": "validatePublicDisplayName",
                            "class": "OCA\\Polls\\Controller\\PublicController",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
                            "line": 118,
                            "function": "executeController",
                            "class": "OC\\AppFramework\\Http\\Dispatcher",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
                            "line": 153,
                            "function": "dispatch",
                            "class": "OC\\AppFramework\\Http\\Dispatcher",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/lib/private/Route/Router.php",
                            "line": 321,
                            "function": "main",
                            "class": "OC\\AppFramework\\App",
                            "type": "::"
                        },
                        {
                            "file": "/var/www/nextcloud/lib/base.php",
                            "line": 1155,
                            "function": "match",
                            "class": "OC\\Route\\Router",
                            "type": "->"
                        },
                        {
                            "file": "/var/www/nextcloud/index.php",
                            "line": 25,
                            "function": "handleRequest",
                            "class": "OC",
                            "type": "::"
                        }
                    ],
                    "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
                    "Line": 130
                }
            }
        },
        "message": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'",
        "exception": "{\"class\":\"OC\\DB\\Exceptions\\DbalException\",\"message\":\"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'\",\"code\":1054,\"file\":\"/var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php:56\",\"trace\":\"#0 /var/www/nextcloud/lib/private/DB/ConnectionAdapter.php(53): OC\\DB\\Exceptions\\DbalException::wrap()\\n#1 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\\DB\\ConnectionAdapter->executeQuery()\\n#2 /var/www/nextcloud/apps/guests/lib/UserBackend.php(241): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#3 /var/www/nextcloud/apps/guests/lib/UserBackend.php(383): OCA\\Guests\\UserBackend->getDisplayNames()\\n#4 /var/www/nextcloud/lib/private/User/Manager.php(260): OCA\\Guests\\UserBackend->getUsers()\\n#5 /var/www/nextcloud/apps/polls/lib/Model/User/User.php(113): OC\\User\\Manager->search()\\n#6 /var/www/nextcloud/apps/polls/lib/Service/SystemService.php(381): OCA\\Polls\\Model\\User\\User::search()\\n#7 /var/www/nextcloud/apps/polls/lib/Service/SystemService.php(263): OCA\\Polls\\Service\\SystemService->validatePublicUsername()\\n#8 /var/www/nextcloud/apps/polls/lib/Controller/PublicController.php(403): OCA\\Polls\\Service\\SystemService->validatePublicUsernameByToken()\\n#9 /var/www/nextcloud/apps/polls/lib/Controller/BaseController.php(42): OCA\\Polls\\Controller\\PublicController->OCA\\Polls\\Controller\\{closure}()\\n#10 /var/www/nextcloud/apps/polls/lib/Controller/PublicController.php(402): OCA\\Polls\\Controller\\BaseController->response()\\n#11 /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(205): OCA\\Polls\\Controller\\PublicController->validatePublicDisplayName()\\n#12 /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(118): OC\\AppFramework\\Http\\Dispatcher->executeController()\\n#13 /var/www/nextcloud/lib/private/AppFramework/App.php(153): OC\\AppFramework\\Http\\Dispatcher->dispatch()\\n#14 /var/www/nextcloud/lib/private/Route/Router.php(321): OC\\AppFramework\\App::main()\\n#15 /var/www/nextcloud/lib/base.php(1155): OC\\Route\\Router->match()\\n#16 /var/www/nextcloud/index.php(25): OC::handleRequest()\\n#17 {main}\",\"previous\":{\"class\":\"Doctrine\\DBAL\\Exception\\InvalidFieldNameException\",\"message\":\"An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'\",\"code\":1054,\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:69\",\"trace\":\"#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1976): Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter->convert()\\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1918): Doctrine\\DBAL\\Connection->handleDriverException()\\n#2 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1111): Doctrine\\DBAL\\Connection->convertExceptionDuringQuery()\\n#3 /var/www/nextcloud/lib/private/DB/Connection.php(420): Doctrine\\DBAL\\Connection->executeQuery()\\n#4 /var/www/nextcloud/lib/private/DB/ConnectionAdapter.php(50): OC\\DB\\Connection->executeQuery()\\n#5 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\\DB\\ConnectionAdapter->executeQuery()\\n#6 /var/www/nextcloud/apps/guests/lib/UserBackend.php(241): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#7 /var/www/nextcloud/apps/guests/lib/UserBackend.php(383): OCA\\Guests\\UserBackend->getDisplayNames()\\n#8 /var/www/nextcloud/lib/private/User/Manager.php(260): OCA\\Guests\\UserBackend->getUsers()\\n#9 /var/www/nextcloud/apps/polls/lib/Model/User/User.php(113): OC\\User\\Manager->search()\\n#10 /var/www/nextcloud/apps/polls/lib/Service/SystemService.php(381): OCA\\Polls\\Model\\User\\User::search()\\n#11 /var/www/nextcloud/apps/polls/lib/Service/SystemService.php(263): OCA\\Polls\\Service\\SystemService->validatePublicUsername()\\n#12 /var/www/nextcloud/apps/polls/lib/Controller/PublicController.php(403): OCA\\Polls\\Service\\SystemService->validatePublicUsernameByToken()\\n#13 /var/www/nextcloud/apps/polls/lib/Controller/BaseController.php(42): OCA\\Polls\\Controller\\PublicController->OCA\\Polls\\Controller\\{closure}()\\n#14 /var/www/nextcloud/apps/polls/lib/Controller/PublicController.php(402): OCA\\Polls\\Controller\\BaseController->response()\\n#15 /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(205): OCA\\Polls\\Controller\\PublicController->validatePublicDisplayName()\\n#16 /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(118): OC\\AppFramework\\Http\\Dispatcher->executeController()\\n#17 /var/www/nextcloud/lib/private/AppFramework/App.php(153): OC\\AppFramework\\Http\\Dispatcher->dispatch()\\n#18 /var/www/nextcloud/lib/private/Route/Router.php(321): OC\\AppFramework\\App::main()\\n#19 /var/www/nextcloud/lib/base.php(1155): OC\\Route\\Router->match()\\n#20 /var/www/nextcloud/index.php(25): OC::handleRequest()\\n#21 {main}\",\"previous\":{\"class\":\"Doctrine\\DBAL\\Driver\\PDO\\Exception\",\"message\":\"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'\",\"code\":1054,\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php:24\",\"trace\":\"#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(132): Doctrine\\DBAL\\Driver\\PDO\\Exception::new()\\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1104): Doctrine\\DBAL\\Driver\\PDO\\Statement->execute()\\n#2 /var/www/nextcloud/lib/private/DB/Connection.php(420): Doctrine\\DBAL\\Connection->executeQuery()\\n#3 /var/www/nextcloud/lib/private/DB/ConnectionAdapter.php(50): OC\\DB\\Connection->executeQuery()\\n#4 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\\DB\\ConnectionAdapter->executeQuery()\\n#5 /var/www/nextcloud/apps/guests/lib/UserBackend.php(241): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#6 /var/www/nextcloud/apps/guests/lib/UserBackend.php(383): OCA\\Guests\\UserBackend->getDisplayNames()\\n#7 /var/www/nextcloud/lib/private/User/Manager.php(260): OCA\\Guests\\UserBackend->getUsers()\\n#8 /var/www/nextcloud/apps/polls/lib/Model/User/User.php(113): OC\\User\\Manager->search()\\n#9 /var/www/nextcloud/apps/polls/lib/Service/SystemService.php(381): OCA\\Polls\\Model\\User\\User::search()\\n#10 /var/www/nextcloud/apps/polls/lib/Service/SystemService.php(263): OCA\\Polls\\Service\\SystemService->validatePublicUsername()\\n#11 /var/www/nextcloud/apps/polls/lib/Controller/PublicController.php(403): OCA\\Polls\\Service\\SystemService->validatePublicUsernameByToken()\\n#12 /var/www/nextcloud/apps/polls/lib/Controller/BaseController.php(42): OCA\\Polls\\Controller\\PublicController->OCA\\Polls\\Controller\\{closure}()\\n#13 /var/www/nextcloud/apps/polls/lib/Controller/PublicController.php(402): OCA\\Polls\\Controller\\BaseController->response()\\n#14 /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(205): OCA\\Polls\\Controller\\PublicController->validatePublicDisplayName()\\n#15 /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(118): OC\\AppFramework\\Http\\Dispatcher->executeController()\\n#16 /var/www/nextcloud/lib/private/AppFramework/App.php(153): OC\\AppFramework\\Http\\Dispatcher->dispatch()\\n#17 /var/www/nextcloud/lib/private/Route/Router.php(321): OC\\AppFramework\\App::main()\\n#18 /var/www/nextcloud/lib/base.php(1155): OC\\Route\\Router->match()\\n#19 /var/www/nextcloud/index.php(25): OC::handleRequest()\\n#20 {main}\",\"previous\":{\"class\":\"PDOException\",\"message\":\"SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'\",\"code\":\"42S22\",\"file\":\"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php:130\",\"trace\":\"#0 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php(130): PDOStatement->execute()\\n#1 /var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(1104): Doctrine\\DBAL\\Driver\\PDO\\Statement->execute()\\n#2 /var/www/nextcloud/lib/private/DB/Connection.php(420): Doctrine\\DBAL\\Connection->executeQuery()\\n#3 /var/www/nextcloud/lib/private/DB/ConnectionAdapter.php(50): OC\\DB\\Connection->executeQuery()\\n#4 /var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(268): OC\\DB\\ConnectionAdapter->executeQuery()\\n#5 /var/www/nextcloud/apps/guests/lib/UserBackend.php(241): OC\\DB\\QueryBuilder\\QueryBuilder->executeQuery()\\n#6 /var/www/nextcloud/apps/guests/lib/UserBackend.php(383): OCA\\Guests\\UserBackend->getDisplayNames()\\n#7 /var/www/nextcloud/lib/private/User/Manager.php(260): OCA\\Guests\\UserBackend->getUsers()\\n#8 /var/www/nextcloud/apps/polls/lib/Model/User/User.php(113): OC\\User\\Manager->search()\\n#9 /var/www/nextcloud/apps/polls/lib/Service/SystemService.php(381): OCA\\Polls\\Model\\User\\User::search()\\n#10 /var/www/nextcloud/apps/polls/lib/Service/SystemService.php(263): OCA\\Polls\\Service\\SystemService->validatePublicUsername()\\n#11 /var/www/nextcloud/apps/polls/lib/Controller/PublicController.php(403): OCA\\Polls\\Service\\SystemService->validatePublicUsernameByToken()\\n#12 /var/www/nextcloud/apps/polls/lib/Controller/BaseController.php(42): OCA\\Polls\\Controller\\PublicController->OCA\\Polls\\Controller\\{closure}()\\n#13 /var/www/nextcloud/apps/polls/lib/Controller/PublicController.php(402): OCA\\Polls\\Controller\\BaseController->response()\\n#14 /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(205): OCA\\Polls\\Controller\\PublicController->validatePublicDisplayName()\\n#15 /var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php(118): OC\\AppFramework\\Http\\Dispatcher->executeController()\\n#16 /var/www/nextcloud/lib/private/AppFramework/App.php(153): OC\\AppFramework\\Http\\Dispatcher->dispatch()\\n#17 /var/www/nextcloud/lib/private/Route/Router.php(321): OC\\AppFramework\\App::main()\\n#18 /var/www/nextcloud/lib/base.php(1155): OC\\Route\\Router->match()\\n#19 /var/www/nextcloud/index.php(25): OC::handleRequest()\\n#20 {main}\"}}}}",
        "CustomMessage": "An exception occurred while executing a query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email' in 'WHERE'"
    },
    "id": "69fdf610745e9"
}

Additional environment informations

No response

Configuration report

I don't have access to this currently. Please ask if it's important despite the traceback.

List of activated Apps

I don't have access to this currently. Please ask if it's important despite the traceback.

Nextcloud Signing status

All good.

Additional Information

No response

[dartcafe]

Looks like the error is thrown from the guests app. Please try to disable the app and check again.

{
     "Trace": [
            {
                "file": "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
                "line": 53,
                "function": "wrap",
                "class": "OC\\DB\\Exceptions\\DbalException",
                "type": "::"
            },
            {
                "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
                "line": 268,
                "function": "executeQuery",
                "class": "OC\\DB\\ConnectionAdapter",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/apps/guests/lib/UserBackend.php",
                "line": 241,
                "function": "executeQuery",
                "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/apps/guests/lib/UserBackend.php",
                "line": 383,
                "function": "getDisplayNames",
                "class": "OCA\\Guests\\UserBackend",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/lib/private/User/Manager.php",
                "line": 260,
                "function": "getUsers",
                "class": "OCA\\Guests\\UserBackend",
                "type": "->"
            },
            {
                "file": "/var/www/nextcloud/apps/polls/lib/Model/User/User.php",
                "line": 113,
                "function": "search",
                "class": "OC\\User\\Manager",
                "type": "->"
            }
    ]
}

[Moini]

Yes, you're right, @dartcafe - after that, it works.

Now:

Is this a bug in Polls or in Guests (if polls is asking guests for something it cannot provide, instead of asking whichever app can provide it - it would be in polls; and if guests is doing something sneaky it should not be doing, it would be there. Or it could also be that the mechanisms make it so that they are incompatible (but that should be marked upon installation, and I guess no two apps should be incompatible.) ?

As it affects the interplay between both.

I kind of don't want to be pingponged between app devs, hence I'm asking someone who would likely have more insight into how user objects are fetched.

[dartcafe]

Polls calls an endpoint from the Nextcloud core (OCP\User\Manager::search()), which then uses the search provider of the Guests app.

You have to read the stack from bottom to top. From Poll's view it lies behind the Nextcloud endpoint and so outside of Poll's influence.

So yes, I would consider it a bug inside the Guests app.

[dartcafe]

@nickvergessen I transferred this issue to this repo, since I assume the bug is to fix here.

[Moini]

@dartcafe Thank you!