Did expect one result but found none when executing: query

[c0r3dump3d]

⚠️ This issue respects the following points: ⚠️

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

What went wrong, what did you observe?

Since the update from NC 23 to NC 24 when I try to add a new poll I have this error messsage:

What did you expect, how polls should behave instead?

The creation of a Poll

What steps does it need to replay this bug?

1.Login to Nextcloud

2. Create a Poll

Installation method

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

Installation type

First time installation

Affected polls version

3.8.4

Which browser did you use, when experiencing the bug?

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

Other browser

No response

Which System did you use, when experiencing the bug?

• [X] Windows
• [X] Linux
• [ ] MacOs
• [ ] iOS
• [ ] Android
• [ ] Other/Don't know

Other OS

No response

Add your browser log here

No response

Additional client environment information

No response

NC version

Nextcloud 24 (Nextcloud Hub 2)

Other Nextcloud version

No response

PHP engine version

PHP 7.4

Other PHP version

No response

Database engine

PostgreSQL

Database Engine version or other Database

PostgreSQL 12.12

Which user-backends are you using?

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

Add your nextcloud server log here

message":"Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*polls_polls` WHERE `id` = :dcValue1\";

Additional environment informations

Server version: Apache/2.4.6 (CentOS 7)

php -v
PHP 7.4.33 (cli) (built: Dec 19 2022 13:32:43) ( NTS )

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "********",
            "********",
            "********"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "**********",
        "dbtype": "pgsql",
        "version": "24.0.9.2",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "logtimezone": "Europe\/Madrid",
        "default_language": "es",
        "default_phone_region": "ES",
        "overwriteprotocol": "https",
        "enable_previews": false,
        "authwebauthnenabled": false,
        "lost_password_link": "false",
        "installed": true,
        "ldapIgnoreNamingRules": false,
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "filelocking.enabled": true,
        "memcache.local": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "timeout": 0,
            "password": "***REMOVED SENSITIVE VALUE***"
        },
        "session_lifetime": 3600,
        "session_keepalive": true,
        "remember_login_cookie_lifetime": 86400,
        "mail_smtpmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauthtype": "PLAIN",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "loglevel": 2,
        "logfile": "\/var\/log\/nextcloud\/nextcloud.log",
        "theme": "",
        "mail_smtpsecure": "tls",
        "ldapProviderFactory": "\\OCA\\User_LDAP\\LDAPProviderFactory",
        "activity_expire_days": 15,
        "app_install_overwrite": [
            "files_antivirus",
            "external",
            "quota_warning",
            "circles",
            "fulltextsearch",
            "piwik"
        ],
        "auth.webauthn.enabled": false
    }
}

List of activated Apps

nabled:
  - accessibility: 1.10.0
  - activity: 2.16.0
  - apporder: 0.15.0
  - bookmarks: 11.0.4
  - bruteforcesettings: 2.4.0
  - calendar: 3.5.5
  - circles: 24.0.1
  - cloud_federation_api: 1.7.0
  - comments: 1.14.0
  - contacts: 4.2.4
  - contactsinteraction: 1.5.0
  - dav: 1.22.0
  - deck: 1.7.3
  - drawio: 2.1.0
  - external: 4.0.1
  - federatedfilesharing: 1.14.0
  - federation: 1.14.0
  - files: 1.19.0
  - files_antivirus: 4.0.2
  - files_markdown: 2.3.6
  - files_mindmap: 0.0.27
  - files_pdfviewer: 2.5.0
  - files_rightclick: 1.3.0
  - files_sharing: 1.16.2
  - files_trashbin: 1.14.0
  - files_versions: 1.17.0
  - files_videoplayer: 1.13.0
  - firstrunwizard: 2.13.0
  - impersonate: 1.11.0
  - login_notes: 1.1.0
  - logreader: 2.9.0
  - lookup_server_connector: 1.12.0
  - nextcloud_announcements: 1.13.0
  - notes: 4.5.1
  - notifications: 2.12.1
  - oauth2: 1.12.0
  - onlyoffice: 7.5.8
  - password_policy: 1.14.0
  - photos: 1.6.0
  - piwik: 0.11.1
  - privacy: 1.8.0
  - provisioning_api: 1.14.0
  - quota_warning: 1.15.0
  - recommendations: 1.3.0
  - riotchat: 0.14.1
  - secrets: 1.4.0
  - serverinfo: 1.14.0
  - settings: 1.6.0
  - sharebymail: 1.14.0
  - survey_client: 1.12.0
  - systemtags: 1.14.0
  - talk_matterbridge: 1.25.2
  - tasks: 0.14.5
  - theming: 1.15.0
  - twofactor_backupcodes: 1.13.0
  - twofactor_email: 2.7.1
  - twofactor_totp: 6.4.1
  - updatenotification: 1.14.0
  - user_ldap: 1.14.1
  - user_status: 1.4.0
  - viewer: 1.8.0
  - weather_status: 1.4.0
  - workflowengine: 2.6.0

Nextcloud Signing status

Technical information
=====================
The following list covers which files have failed the integrity check. Please read
the previous linked documentation to learn more about the errors and how to fix
them.

Results
=======
- core
    - INVALID_HASH
        - core/js/mimetypelist.js
    - EXTRA_FILE
        - core/img/filetypes/drawio.svg
        - core/img/filetypes/dwb.svg

Raw output
==========
Array
(
    [core] => Array
        (
            [INVALID_HASH] => Array
                (
                    [core/js/mimetypelist.js] => Array
                        (
                            [expected] => 94195a260a005dac543c3f6aa504f1b28e0078297fe94a4f52f012c16c109f0323eecc9f767d6949f860dfe454625fcaf1dc56f87bb8350975d8f006bbbdf14a
                            [current] => 7261357dcb345c083894f3905c321b735972045aafa6420ecd748d5a60cd8036a9d6a21e6711eae5a1bccfb53909497e955b2cde70fa412eff184fcd4772a832
                        )

                )

            [EXTRA_FILE] => Array
                (
                    [core/img/filetypes/drawio.svg] => Array
                        (
                            [expected] => 
                            [current] => 92e0974cf869bf8ab969c3442dc2b80d55fde36441d22924db74916a06b407520aa2a9dc39336f9157195ebede697ffac0e639360879255ab91932d406e1897d
                        )

                    [core/img/filetypes/dwb.svg] => Array
                        (
                            [expected] => 
                            [current] => 43731dd5f17a048112ea5109b40b02ec019b3ee2324385a0f448e3bd2264cb13dc160ab018d893f92f8e2f168fd09009b51578c8c6b97a02a1617c67ac087701
                        )

                )

        )

)

Additional Information

No response

[c0r3dump3d]

I have resolved the issue with the command:

sudo -u apache php /var/www/html/nextcloud/occ polls:db:rebuil

[github-actions[bot]]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.