search

nextcloud / polls

🗳️ Polls app for Nextcloud
https://apps.nextcloud.com/apps/polls
GNU Affero General Public License v3.0
257 stars 73 forks source link

Cant create new polls with error: BadFunctionCallException: userEmail is not a valid attribute #2201

Closed hartsberger closed 2 years ago

hartsberger commented 2 years ago

What is going wrong? What did you observe?

Describe the bug

It is not possible to create polls. The "create new poll" button is not there. Additionally there are some errors created in nextcloud.log every time I open the polls app via the menu on the top. The strange thing is, that it worked the first few hours after activation without problems.

Worth to mention is, that the app was used for a few weeks a year ago. Then it was removed. Now after an update to Nextcloud 21 I reinstalled the app.

I guess it is the same as #2199 but with different NC version.

Steps to reproduce the behavior

  1. Install and activate polls app from appstore.
  2. Click on the new polls app in the top menu.
  3. Recognize, that there is no "create new poll" button.
  4. See errors in nextcloud.log

Add a screenshot of the misbehavior

Productive instance, not working:

polls app not working

Test instance without any errors:

polls app working fine

How should it work?

What you expected to happen?

I would expect the "create new poll" button and also that there are no errors generated when opening the polls app.

Information about your polls installation

Polls version: 3.4.2

Fresh installation or update from a prior version (from which one)?

But as I mentioned, it think the app was installed long time ago in a much lower version. Then was removed. Now a new install.

How did you install this version?(Appstore or describe installation)

Information about your Instance of Nextcloud

Nextcloud version: 21.0.7.1

List of activated apps ``` Enabled: - accessibility: 1.7.0 - activity: 2.14.3 - admin_audit: 1.11.0 - bookmarks: 10.0.3 - cloud_federation_api: 1.4.0 - comments: 1.11.0 - contactsinteraction: 1.2.0 - dashboard: 7.1.0 - dav: 1.17.1 - deck: 1.4.7 - federatedfilesharing: 1.11.0 - files: 1.16.0 - files_accesscontrol: 1.11.1 - files_automatedtagging: 1.11.0 - files_mindmap: 0.0.26 - files_pdfviewer: 2.1.1 - files_rightclick: 1.0.0 - files_sharing: 1.13.1 - files_trashbin: 1.11.0 - files_versions: 1.14.0 - files_videoplayer: 1.10.0 - forms: 2.4.0 - groupfolders: 9.0.4 - guests: 2.1.0 - impersonate: 1.8.0 - integration_discourse: 1.0.0 - integration_whiteboard: 0.0.14 - integration_zammad: 1.0.1 - logreader: 2.6.0 - lookup_server_connector: 1.9.0 - notes: 4.3.0 - notifications: 2.9.0 - notify_push: 0.3.0 - oauth2: 1.9.0 - onlyoffice: 7.3.0 - password_policy: 1.11.0 - photos: 1.3.0 - polls: 3.4.2 - privacy: 1.5.0 - provisioning_api: 1.11.0 - quota_warning: 1.13.0 - recommendations: 1.0.0 - sendent: 1.2.10 - serverinfo: 1.11.0 - settings: 1.3.0 - sharebymail: 1.11.0 - spreed: 11.3.4 - support: 1.4.0 - survey_client: 1.9.0 - systemtags: 1.11.0 - tasks: 0.14.2 - text: 3.2.0 - theming: 1.12.0 - theming_customcss: 1.10.0 - twofactor_backupcodes: 1.10.0 - updatenotification: 1.11.0 - user_ldap: 1.11.1 - user_status: 1.1.1 - viewer: 1.5.0 - weather_status: 1.1.0 - welcome: 1.0.0 - workflowengine: 2.3.1 Disabled: - encryption - federation - files_external - firstrunwizard - nextcloud_announcements - suspicious_login ```
Nextcloud Configuration ``` { "system": { "passwordsalt": "***REMOVED SENSITIVE VALUE***", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "localhost", "***REMOVED SENSITIVE VALUE***", "***REMOVED SENSITIVE VALUE***", "***REMOVED SENSITIVE VALUE***", "***REMOVED SENSITIVE VALUE***" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "overwrite.cli.url": "***REMOVED SENSITIVE VALUE***", "overwritehost": "***REMOVED SENSITIVE VALUE***", "dbtype": "pgsql", "version": "21.0.7.1", "dbname": "***REMOVED SENSITIVE VALUE***", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbport": "", "dbtableprefix": "oc_", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "installed": true, "instanceid": "***REMOVED SENSITIVE VALUE***", "mail_smtpmode": "smtp", "log_rotate_size": "10485760", "memcache.local": "\\OC\\Memcache\\Redis", "filelocking.enabled": true, "memcache.distributed": "\\OC\\Memcache\\Redis", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0, "timeout": 0.5, "dbindex": 0, "password": "***REMOVED SENSITIVE VALUE***" }, "htaccess.RewriteBase": "\/", "maintenance": false, "ldapIgnoreNamingRules": false, "ldapProviderFactory": "\\OCA\\User_LDAP\\LDAPProviderFactory", "mail_smtpauthtype": "LOGIN", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "25", "theme": "", "loglevel": 2, "updater.release.channel": "enterprise", "data-fingerprint": "4d81d8bf08bb1066bf515ac3c774a519", "skeletondirectory": "\/var\/www\/nc-skeleton", "updater.server.url": "https:\/\/updates.nextcloud.com\/customers\/***REMOVED SENSITIVE VALUE***", "trusted_proxies": "***REMOVED SENSITIVE VALUE***", "updater.secret": "***REMOVED SENSITIVE VALUE***", "default_phone_region": "DE" } } ```

Server configuration (decide, if you think it is helpful)

Database:

PHP version:

Are you using an external user-backend, if yes which one: ActiveDirectory

Client configuration

Device:

Browser:

Logs

Nextcloud log (data/nextcloud.log) ``` {"reqId":"8WZnhV7d4JsI3xrh1IP0","level":3,"time":"2022-01-21T06:40:02+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":{"Exception":"BadFunctionCallException","Message":"message is not a valid attribute","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":151,"function":"setter","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":73,"function":"__call","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":316,"function":"fromRow","class":"OCP\\AppFramework\\Db\\Entity","type":"::"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"mapRowToEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Db/LogMapper.php","line":82,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Service/MailService.php","line":219,"function":"findUnprocessed","class":"OCA\\Polls\\Db\\LogMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Cron/NotificationCron.php","line":49,"function":"sendNotifications","class":"OCA\\Polls\\Service\\MailService","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OCA\\Polls\\Cron\\NotificationCron","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":61,"function":"execute","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":128,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","Line":122,"CustomMessage":"Error while running background job (class: OCA\\Polls\\Cron\\NotificationCron, arguments: )"},"userAgent":"--","version":"21.0.7.1"} {"reqId":"tSp5hNzgZEcoJbVxzPCd","level":3,"time":"2022-01-21T06:45:02+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":{"Exception":"BadFunctionCallException","Message":"message is not a valid attribute","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":151,"function":"setter","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":73,"function":"__call","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":316,"function":"fromRow","class":"OCP\\AppFramework\\Db\\Entity","type":"::"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"mapRowToEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Db/LogMapper.php","line":82,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Service/MailService.php","line":219,"function":"findUnprocessed","class":"OCA\\Polls\\Db\\LogMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Cron/NotificationCron.php","line":49,"function":"sendNotifications","class":"OCA\\Polls\\Service\\MailService","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OCA\\Polls\\Cron\\NotificationCron","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":61,"function":"execute","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":128,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","Line":122,"CustomMessage":"Error while running background job (class: OCA\\Polls\\Cron\\NotificationCron, arguments: )"},"userAgent":"--","version":"21.0.7.1"} {"reqId":"GKrv24W1Z6tzeVebxkp0","level":3,"time":"2022-01-21T06:50:02+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":{"Exception":"BadFunctionCallException","Message":"message is not a valid attribute","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":151,"function":"setter","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":73,"function":"__call","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":316,"function":"fromRow","class":"OCP\\AppFramework\\Db\\Entity","type":"::"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"mapRowToEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Db/LogMapper.php","line":82,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Service/MailService.php","line":219,"function":"findUnprocessed","class":"OCA\\Polls\\Db\\LogMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Cron/NotificationCron.php","line":49,"function":"sendNotifications","class":"OCA\\Polls\\Service\\MailService","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OCA\\Polls\\Cron\\NotificationCron","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":61,"function":"execute","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":128,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","Line":122,"CustomMessage":"Error while running background job (class: OCA\\Polls\\Cron\\NotificationCron, arguments: )"},"userAgent":"--","version":"21.0.7.1"} {"reqId":"JRCeIXQocCkm8RhWILHL","level":3,"time":"2022-01-21T06:52:31+00:00","remoteAddr":"10.1.1.148","user":"3257C2FB-1EF6-4205-9AD3-20497462EF98","app":"index","method":"GET","url":"/apps/polls/polls?time=1642747951055","message":{"Exception":"BadFunctionCallException","Message":"userEmail is not a valid attribute","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":151,"function":"setter","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":73,"function":"__call","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":316,"function":"fromRow","class":"OCP\\AppFramework\\Db\\Entity","type":"::"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"mapRowToEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Db/ShareMapper.php","line":73,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":371,"function":"findByPoll","class":"OCA\\Polls\\Db\\ShareMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":293,"function":"getIsDelegatedAdmin","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":193,"function":"getHasAdminAccess","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":170,"function":"getIsAllowed","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":238,"function":"getIsAllowed","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":126,"function":"request","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Service/PollService.php","line":102,"function":"setPollId","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/PollController.php","line":77,"function":"list","class":"OCA\\Polls\\Service\\PollService","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/ResponseHandle.php","line":42,"function":"OCA\\Polls\\Controller\\{closure}","class":"OCA\\Polls\\Controller\\PollController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/PollController.php","line":80,"function":"response","class":"OCA\\Polls\\Controller\\PollController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"list","class":"OCA\\Polls\\Controller\\PollController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":303,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","Line":122,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36 Edg/97.0.1072.62","version":"21.0.7.1"} {"reqId":"84vlCBItwGfKsilJfR6e","level":3,"time":"2022-01-21T06:52:14+00:00","remoteAddr":"10.1.1.148","user":"3257C2FB-1EF6-4205-9AD3-20497462EF98","app":"index","method":"GET","url":"/apps/polls/polls?time=1642747934003","message":{"Exception":"BadFunctionCallException","Message":"userEmail is not a valid attribute","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":151,"function":"setter","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":73,"function":"__call","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":316,"function":"fromRow","class":"OCP\\AppFramework\\Db\\Entity","type":"::"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"mapRowToEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Db/ShareMapper.php","line":73,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":371,"function":"findByPoll","class":"OCA\\Polls\\Db\\ShareMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":293,"function":"getIsDelegatedAdmin","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":193,"function":"getHasAdminAccess","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":170,"function":"getIsAllowed","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":238,"function":"getIsAllowed","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":126,"function":"request","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Service/PollService.php","line":102,"function":"setPollId","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/PollController.php","line":77,"function":"list","class":"OCA\\Polls\\Service\\PollService","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/ResponseHandle.php","line":42,"function":"OCA\\Polls\\Controller\\{closure}","class":"OCA\\Polls\\Controller\\PollController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/PollController.php","line":80,"function":"response","class":"OCA\\Polls\\Controller\\PollController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"list","class":"OCA\\Polls\\Controller\\PollController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":303,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","Line":122,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36 Edg/97.0.1072.62","version":"21.0.7.1"} {"reqId":"LhMciwYiPrQBOafLHcIZ","level":3,"time":"2022-01-21T06:52:35+00:00","remoteAddr":"10.1.1.148","user":"3257C2FB-1EF6-4205-9AD3-20497462EF98","app":"index","method":"GET","url":"/apps/polls/polls?time=1642747955540","message":{"Exception":"BadFunctionCallException","Message":"userEmail is not a valid attribute","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":151,"function":"setter","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":73,"function":"__call","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":316,"function":"fromRow","class":"OCP\\AppFramework\\Db\\Entity","type":"::"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"mapRowToEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Db/ShareMapper.php","line":73,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":371,"function":"findByPoll","class":"OCA\\Polls\\Db\\ShareMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":293,"function":"getIsDelegatedAdmin","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":193,"function":"getHasAdminAccess","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":170,"function":"getIsAllowed","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":238,"function":"getIsAllowed","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":126,"function":"request","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Service/PollService.php","line":102,"function":"setPollId","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/PollController.php","line":77,"function":"list","class":"OCA\\Polls\\Service\\PollService","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/ResponseHandle.php","line":42,"function":"OCA\\Polls\\Controller\\{closure}","class":"OCA\\Polls\\Controller\\PollController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/PollController.php","line":80,"function":"response","class":"OCA\\Polls\\Controller\\PollController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"list","class":"OCA\\Polls\\Controller\\PollController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":303,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","Line":122,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/97.0.4692.71 Safari/537.36 Edg/97.0.1072.62","version":"21.0.7.1"} {"reqId":"7PflGteElRAc9U1Gj00b","level":3,"time":"2022-01-21T06:55:03+00:00","remoteAddr":"","user":"--","app":"core","method":"","url":"--","message":{"Exception":"BadFunctionCallException","Message":"message is not a valid attribute","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":151,"function":"setter","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":73,"function":"__call","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":316,"function":"fromRow","class":"OCP\\AppFramework\\Db\\Entity","type":"::"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"mapRowToEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Db/LogMapper.php","line":82,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Service/MailService.php","line":219,"function":"findUnprocessed","class":"OCA\\Polls\\Db\\LogMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Cron/NotificationCron.php","line":49,"function":"sendNotifications","class":"OCA\\Polls\\Service\\MailService","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/Job.php","line":80,"function":"run","class":"OCA\\Polls\\Cron\\NotificationCron","type":"->"},{"file":"/var/www/nextcloud/lib/public/BackgroundJob/TimedJob.php","line":61,"function":"execute","class":"OCP\\BackgroundJob\\Job","type":"->"},{"file":"/var/www/nextcloud/cron.php","line":128,"function":"execute","class":"OCP\\BackgroundJob\\TimedJob","type":"->"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","Line":122,"CustomMessage":"Error while running background job (class: OCA\\Polls\\Cron\\NotificationCron, arguments: )"},"userAgent":"--","version":"21.0.7.1"} {"reqId":"587VlOETpY3foKqusE5Y","level":3,"time":"2022-01-21T07:01:12+00:00","remoteAddr":"10.1.9.1","user":"A7B36162-A321-4998-B2B7-9AF697988A4D","app":"index","method":"GET","url":"/apps/polls/polls?time=1642748465657","message":{"Exception":"BadFunctionCallException","Message":"userEmail is not a valid attribute","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":151,"function":"setter","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":73,"function":"__call","class":"OCP\\AppFramework\\Db\\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":316,"function":"fromRow","class":"OCP\\AppFramework\\Db\\Entity","type":"::"},{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":335,"function":"mapRowToEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Db/ShareMapper.php","line":73,"function":"findEntities","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":371,"function":"findByPoll","class":"OCA\\Polls\\Db\\ShareMapper","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":293,"function":"getIsDelegatedAdmin","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":193,"function":"getHasAdminAccess","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":170,"function":"getIsAllowed","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":238,"function":"getIsAllowed","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Model/Acl.php","line":126,"function":"request","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Service/PollService.php","line":102,"function":"setPollId","class":"OCA\\Polls\\Model\\Acl","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/PollController.php","line":77,"function":"list","class":"OCA\\Polls\\Service\\PollService","type":"->"},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/ResponseHandle.php","line":42,"function":"OCA\\Polls\\Controller\\{closure}","class":"OCA\\Polls\\Controller\\PollController","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/nextcloud/apps/polls/lib/Controller/PollController.php","line":80,"function":"response","class":"OCA\\Polls\\Controller\\PollController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"list","class":"OCA\\Polls\\Controller\\PollController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":303,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","Line":122,"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:91.0) Gecko/20100101 Firefox/91.0","version":"21.0.7.1"} ```
Browser console log ``` Insert your browser console log here ```
Other browser logs ``` Insert additional logs from your browser here ```
dartcafe commented 2 years ago

Worth to mention is, that the app was used for a few weeks a year ago. Then it was removed. Now after an update to Nextcloud 21 I reinstalled the app.

Unfortunately tables are not removed, if an app gets uninstalled. So it can happen, that the database cannot be updated correctly, if it is a very old schema.

Have you tried the procedure mentioned in https://github.com/nextcloud/polls/issues/2199#issuecomment-1017984680?

So please try to

hartsberger commented 2 years ago

Yes, now it is working again. No more errors.

I was just unsure if it is save to delete those tables and rows. But with your reply I felt confident enough :)

Thanks you very much!

AndyScherzinger commented 2 years ago

@dartcafe so given your workaround is there a way to (easily) fix this within the app's code so one would not have to do the manual steps but the app could self-heal such a situation?

tzugen commented 2 years ago

For others affected:

I used these mysql commands:

show databases;
use [databasename];
show tables;
DROP TABLE oc_polls_votes; (and all others)
DELETE FROM oc_migrations WHERE app = 'polls';
dartcafe commented 2 years ago

@dartcafe so given your workaround is there a way to (easily) fix this within the app's code so one would not have to do the manual steps but the app could self-heal such a situation?

The migration to the next version will fix that. The problem is, if someone skipped some versions while polls was disabled or uninstalled.

Generally this could be a solution for issues like that: https://github.com/nextcloud/server/issues/28283 Also for privacy reasons, because the databases of a uninstalled spp stays in the database until manually intervention.

github-actions[bot] commented 6 months ago

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.