Polls: Error with username while using public poll
What is going wrong?
Due to this bug: https://github.com/nextcloud/polls/issues/766 I upgraded polls to 1.1.2RC. Adding a public Link now works.
I opened the poll with that link while I was NOT logged in to Nextcloud as an outside user with no nextcloud account would do. In the upper field "username" I enter an arbitary Name and clicked the arrow. A error appears "Fehler beim Speichern des Benutzernamens" (Error saving Username).
Steps to reproduce
- Create a new time-based poll
- Add some time options
- Add a public link
- Logout from Nextcloud (or open another Browser)
- Open the public link
- Enter random characters in the "username" field, it gets green
- Click the arrow
Expected behaviour
A new line below the options is added with the name so the user can click the options.
Actual behaviour
Error "Fehler beim Speichern des Benutzernamens" (Error saving username) appears.
BTW: The helptext in the username field sais "Enter a valid username" and I'm wondering what is meant with "valid username"? I assume it has to be a name which has NO Nextcloud account? Cause when entering a username which is a Nextcloud account the field turns red, otherwise with an arbitary name it turns green.
Server configuration detail
Polls Version: 1.12RC
Operating system: Linux 4.15.0-72-generic #81-Ubuntu SMP Tue Nov 26 12:20:02 UTC 2019 x86_64
Webserver: Apache (fpm-fcgi)
Database: mysql 5.7.28
PHP version:
7.2.25-1+ubuntu18.04.1+deb.sury.org+1
Modules loaded: Core, date, libxml, openssl, pcre, zlib, filter, hash, Reflection, SPL, sodium, session, standard, cgi-fcgi, mysqlnd, PDO, xml, apcu, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, igbinary, imagick, intl, json, ldap, exif, memcache, msgpack, mysqli, pdo_mysql, Phar, posix, readline, redis, shmop, SimpleXML, smbclient, soap, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xmlreader, xmlwriter, xsl, zip, memcached, libsmbclient, Zend OPcache, xdebug
Nextcloud version: 17.0.2 - 17.0.2.1
Updated from an older Nextcloud/ownCloud or fresh install: Update
Where did you install Nextcloud from: Manual Download
Signing status
List of activated apps
Enabled:
- calendar: 2.0.1
- cloud_federation_api: 1.0.0
- contacts: 3.1.8
- cookbook: 0.5.7
- dav: 1.13.0
- deck: 0.8.0
- drawio: 0.9.4
- federatedfilesharing: 1.7.0
- federation: 1.7.0
- files: 1.12.0
- files_accesscontrol: 1.7.0
- files_external: 1.8.0
- files_pdfviewer: 1.6.0
- files_readmemd: 1.1.3
- files_rightclick: 0.15.1
- files_sharing: 1.9.0
- files_trashbin: 1.7.0
- files_versions: 1.10.0
- gallery: 18.4.0
- issuetemplate: 0.6.0
- keeweb: 0.6.1
- logreader: 2.2.0
- lookup_server_connector: 1.5.0
- maps: 0.1.4
- news: 14.1.2
- nextcloud_announcements: 1.6.0
- notifications: 2.5.0
- oauth2: 1.5.0
- onlyoffice: 4.1.1
- ownnote: 1.08
- password_policy: 1.7.0
- polls: 1.1.2
- previewgenerator: 2.2.0
- privacy: 1.1.0
- provisioning_api: 1.7.0
- recommendations: 0.5.0
- sharebymail: 1.7.0
- sharerenamer: 2.7.3
- spreed: 7.0.2
- systemtags: 1.7.0
- tasks: 0.11.3
- text: 1.1.1
- theming: 1.8.0
- theming_customcss: 1.5.0
- twofactor_backupcodes: 1.6.0
- twofactor_totp: 4.1.2
- updatenotification: 1.7.0
- uploaddetails: 0.1.2
- user_ldap: 1.7.0
- viewer: 1.2.0
- workflowengine: 1.7.0
Disabled:
- accessibility
- activity
- admin_audit
- apporder
- audioplayer
- bookmarks
- bruteforcesettings
- carnet
- comments
- encryption
- external
- files_automatedtagging
- files_videoplayer
- firstrunwizard
- gpxedit
- metadata
- mindmaps
- notes
- phonetrack
- quicknotes
- richdocuments
- serverinfo
- support
- survey_client
Configuration (config/config.php)
{
"instanceid": "***REMOVED SENSITIVE VALUE***",
"passwordsalt": "***REMOVED SENSITIVE VALUE***",
"secret": "***REMOVED SENSITIVE VALUE***",
"trusted_domains": [
"webix.gallien.gal",
"192.168.42.201",
"None",
"webix",
"portal.leitold.koeln",
"mauskater.dd-dns.de",
"t0mcat.dd-dns.de",
"wolke.leitold.koeln",
"nak.leitold.koeln"
],
"datadirectory": "***REMOVED SENSITIVE VALUE***",
"dbtype": "mysql",
"version": "17.0.2.1",
"dbname": "***REMOVED SENSITIVE VALUE***",
"dbhost": "***REMOVED SENSITIVE VALUE***",
"dbtableprefix": "oc_",
"dbuser": "***REMOVED SENSITIVE VALUE***",
"dbpassword": "***REMOVED SENSITIVE VALUE***",
"logtimezone": "Europe\/Berlin",
"installed": true,
"ldapIgnoreNamingRules": false,
"appstore.experimental.enabled": true,
"theme": "",
"loglevel": 2,
"filesystem_check_changes": 1,
"mail_from_address": "***REMOVED SENSITIVE VALUE***",
"mail_smtpmode": "smtp",
"mail_domain": "***REMOVED SENSITIVE VALUE***",
"mail_smtpauthtype": "LOGIN",
"mail_smtpauth": 1,
"mail_smtphost": "***REMOVED SENSITIVE VALUE***",
"mail_smtpport": "25",
"mail_smtpname": "***REMOVED SENSITIVE VALUE***",
"mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
"updatechecker": false,
"maintenance": false,
"ldapProviderFactory": "\\OCA\\User_LDAP\\LDAPProviderFactory",
"updater.release.channel": "stable",
"overwrite.cli.url": "https:\/\/wolke.leitold.koeln",
"memcache.local": "\\OC\\Memcache\\Redis",
"mysql.utf8mb4": true,
"memcache.locking": "\\OC\\Memcache\\Redis",
"redis": {
"host": "***REMOVED SENSITIVE VALUE***",
"port": 0,
"timeout": 0,
"password": "***REMOVED SENSITIVE VALUE***",
"dbindex": 0
},
"overwriteprotocol": "https",
"htaccess.RewriteBase": "\/",
"app_install_overwrite": [
"apporder",
"calendar",
"external",
"files_accesscontrol",
"files_automatedtagging",
"spreed",
"mindmaps",
"keeweb"
]
}
Are you using external storage, if yes which one: smb
Are you using encryption:
Are you using an external user-backend, if yes which one: LDAP
LDAP configuration (delete this par if not used)
background_sync_interval: 43200background_sync_offset: 0background_sync_prefix: s02cleanUpJobOffset: 0enabled: yesinstalled_version: 1.7.0s02_lastChange: 1579772642s02has_memberof_filter_support: 1s02home_folder_naming_rule: attr:uids02last_jpegPhoto_lookup: 0s02ldap_agent_password: cm9vdHZhZGVys02ldap_attributes_for_group_search: cn
description
mailPrimaryAddresss02ldap_attributes_for_user_search: uid
givenName
sn
description
employeeNumber
mailPrimaryAddress
displayNames02ldap_backup_host: s02ldap_backup_port: s02ldap_base: dc=gallien,dc=gals02ldap_base_groups: dc=gallien,dc=gals02ldap_base_users: cn=users,dc=gallien,dc=gals02ldap_cache_ttl: 600s02ldap_configuration_active: 1s02ldap_default_ppolicy_dn: s02ldap_display_name: displaynames02ldap_dn: uid=Administrator,cn=users,dc=gallien,dc=gals02ldap_dynamic_group_member_url: s02ldap_email_attr: mailPrimaryAddresss02ldap_experienced_admin: 0s02ldap_expert_username_attr: uids02ldap_expert_uuid_group_attr: s02ldap_expert_uuid_user_attr: s02ldap_gid_number: gidNumbers02ldap_group_display_name: cns02ldap_group_filter: (|(cn=wolke_app_bookmarks)(cn=wolke_apps_phonetrack)(cn=wolke_apps_rainloop)(cn=wolke_apps_deck)(cn=wolke_apps_keeweb)(cn=wolke_apps_news)(cn=wolke_apps_cookbook)(cn=wolke_apps_polls)(cn=wolke_apps_notes))s02ldap_group_filter_mode: 1s02ldap_group_member_assoc_attribute: gidNumbers02ldap_groupfilter_groups: wolke_app_bookmarks
wolke_apps_phonetrack
wolke_apps_rainloop
wolke_apps_deck
wolke_apps_keeweb
wolke_apps_news
wolke_apps_cookbooks02ldap_groupfilter_objectclass: s02ldap_host: authentix2.gallien.gals02ldap_login_filter: (&(&(|(objectclass=person))(|(memberof=cn=media_wolke,cn=groups,dc=gallien,dc=gal)))(uid=%uid))s02ldap_login_filter_mode: 0s02ldap_loginfilter_attributes: s02ldap_loginfilter_email: 0s02ldap_loginfilter_username: 1s02ldap_nested_groups: 0s02ldap_override_main_server: 0s02ldap_paging_size: 500s02ldap_port: 7389s02ldap_quota_attr: ownCloudQuotas02ldap_quota_def: s02ldap_tls: 0s02ldap_turn_off_cert_check: 0s02ldap_turn_on_pwd_change: 0s02ldap_user_display_name_2: s02ldap_user_filter_mode: 0s02ldap_userfilter_groups: media_wolkes02ldap_userfilter_objectclass: persons02ldap_userlist_filter: (&(|(objectclass=person))(|(memberof=cn=media_wolke,cn=groups,dc=gallien,dc=gal)))s02use_memberof_to_detect_membership: 1types: authentication
Client configuration
Browser: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:72.0) Gecko/20100101 Firefox/72.0
Operating system:
Logs
Web server error log
No error
Nextcloud log
No error
Browser log
jquery-migrate.min.js:2 JQMIGRATE: Migrate is installed, version 1.4.1
ProxyBus.js:74 Proxying an event bus of version 0.2.1 with 1.1.2
e @ ProxyBus.js:74
(anonymous) @ index.js:22
i @ bootstrap:63
(anonymous) @ requesttoken.js:9
i @ bootstrap:63
(anonymous) @ index.js:25
i @ bootstrap:63
(anonymous) @ index.js:12
i @ bootstrap:63
(anonymous) @ polls.js?v=07c04cf0-4:1035
i @ bootstrap:63
(anonymous) @ bootstrap:198
(anonymous) @ polls.js?v=07c04cf0-4:1
1f766cec5f3763ac13.js:1 Refused to load the script 'https://protesidenext.com/optout/get?jsonp=__mtz_cb_229569856&key=1f766cec5f3763ac13&t=1579775156360' because it violates the following Content Security Policy directive: "script-src 'nonce-d0IzUDM3NUdOa2lNVXBwUGIxTTRHcjROdlhOUC9TcGxEbTYxWklvbE9NOD06ckMrazdvNStUaXlqUHQwQ0poQjJVL2hpMVR3Z3BGc25TeW5nTmVaeGFyYz0='". Note that 'script-src-elem' was not explicitly set, so 'script-src' is used as a fallback.
script @ 1f766cec5f3763ac13.js:1
jsonp @ 1f766cec5f3763ac13.js:1
(anonymous) @ 1f766cec5f3763ac13.js:2
(anonymous) @ 1f766cec5f3763ac13.js:2
ready @ 1f766cec5f3763ac13.js:1
b @ 1f766cec5f3763ac13.js:1
(anonymous) @ 1f766cec5f3763ac13.js:2
(anonymous) @ 1f766cec5f3763ac13.js:2
n3b4DSL1V5hbEWlW:1 Refused to load the image 'https://protesidenext.com/metric/?mid=&wid=52437&sid=&tid=8054&rid=LAUNCHED&t=1579775156350' because it violates the following Content Security Policy directive: "img-src 'self' data: blob:".
n3b4DSL1V5hbEWlW:1 Refused to load the image 'https://protesidenext.com/metric/?mid=&wid=52437&sid=&tid=8054&rid=LOADED&custom1=wolke.leitold.koeln&custom2=%2Fapps%2Fpolls%2Fs%2Fn3b4DSL1V5hbEWlW&custom3=protesidenext.com&t=1579775156358' because it violates the following Content Security Policy directive: "img-src 'self' data: blob:".
n3b4DSL1V5hbEWlW:1 Refused to load the image 'https://protesidenext.com/metric/?mid=&wid=52437&sid=&tid=8054&rid=BEFORE_OPTOUT_REQ&t=1579775156359' because it violates the following Content Security Policy directive: "img-src 'self' data: blob:".
n3b4DSL1V5hbEWlW:1 Refused to load the image 'https://protesidenext.com/metric/?mid=&wid=52437&sid=&tid=8054&rid=FINISHED&custom1=wolke.leitold.koeln&t=1579775156362' because it violates the following Content Security Policy directive: "img-src 'self' data: blob:".
xhr.js:178 POST https://wolke.leitold.koeln/apps/polls/share/create/s/ 409 (Conflict)
(anonymous) @ xhr.js:178
e.exports @ xhr.js:12
e.exports @ dispatchRequest.js:50
Promise.then (async)
c.request @ Axios.js:61
r.forEach.c.<computed> @ Axios.js:86
(anonymous) @ bind.js:9
createPersonalShare @ shares.js:116
(anonymous) @ vuex.esm.js:747
l.dispatch @ vuex.esm.js:438
dispatch @ vuex.esm.js:332
writeUserName @ polls.3.4f2c689be03e701d1362.js:279
We @ vue.esm.js:1863
n @ vue.esm.js:2188
Xr.a._wrapper @ vue.esm.js:7565
shares.js:120 Error writing share {error: {鈥} {payload: {鈥}
(anonymous) @ shares.js:120
Promise.then (async)
createPersonalShare @ shares.js:117
(anonymous) @ vuex.esm.js:747
l.dispatch @ vuex.esm.js:438
dispatch @ vuex.esm.js:332
writeUserName @ polls.3.4f2c689be03e701d1362.js:279
We @ vue.esm.js:1863
n @ vue.esm.js:2188
Xr.a._wrapper @ vue.esm.js:7565
bug
t0mcat1337
👍2
All 34 comments
Should be resolved in https://github.com/nextcloud/polls/releases/tag/v1.1.3-RC
dartcafe
on 23 Jan 2020
Just tested 1.1.3RC and issue is NOT resolved, error is identical
t0mcat1337
on 23 Jan 2020
👍1
I added some debug logging. Could you replace https://github.com/nextcloud/polls/blob/master/lib/Controller/ShareController.php and activate debug logging in the nextcloud log?
Or deploy polls-1.1.4.zip.
dartcafe
on 23 Jan 2020
I installed polls-1.1.4.zip, set log level to debug and tried the same as described above... now, when opening the Logging View in Admin it remains empty... some other bug?
But I think I extracted the important part in nextcloud.log directly:
{"reqId":"f0BpyqdVZGZJmwZEUio1","level":0,"time":"2020-01-23T18:15:46+01:00","remoteAddr":"192.168.41.1","user":"--","app":"user_ldap","method":"POST","url":"\/apps\/polls\/share\/create\/s\/","message":"getGroups getGroups--500-","userAg
ent":"Mozilla\/5.0 (Android 9; Mobile; rv:71.0) Gecko\/71.0 Firefox\/71.0","version":"17.0.2.1"}
{"reqId":"f0BpyqdVZGZJmwZEUio1","level":0,"time":"2020-01-23T18:15:46+01:00","remoteAddr":"192.168.41.1","user":"--","app":"user_ldap","method":"POST","url":"\/apps\/polls\/share\/create\/s\/","message":"getGroups(): read 9 at offset (li
mit: 500)","userAgent":"Mozilla\/5.0 (Android 9; Mobile; rv:71.0) Gecko\/71.0 Firefox\/71.0","version":"17.0.2.1"}
{"reqId":"f0BpyqdVZGZJmwZEUio1","level":0,"time":"2020-01-23T18:15:46+01:00","remoteAddr":"192.168.41.1","user":"--","app":"polls","method":"POST","url":"\/apps\/polls\/share\/create\/s\/","message":"Create share: {\"id\":7,\"token\":\"Hs
jwMPoGmnu8V2lP\",\"type\":\"external\",\"pollId\":7,\"userId\":\"test\",\"userEmail\":\"\",\"user\":\"\"}","userAgent":"Mozilla\/5.0 (Android 9; Mobile; rv:71.0) Gecko\/71.0 Firefox\/71.0","version":"17.0.2.1"}
{"reqId":"f0BpyqdVZGZJmwZEUio1","level":0,"time":"2020-01-23T18:15:46+01:00","remoteAddr":"192.168.41.1","user":"--","app":"polls","method":"POST","url":"\/apps\/polls\/share\/create\/s\/","message":"Exception: {\"xdebug_message\":\"<tr><
th align='left' bgcolor='#f57900' colspan=\\\"5\\\"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )<\\\/span> Doctrine\\\\DBAL\\\\Exception\\\\NotNullConstraintViolationException: An exception occurred w
hile executing 'INSERT INTO `oc_polls_share` (`type`, `poll_id`, `user_id`, `token`) VALUES(?, ?, ?, ?)' with params [\\\"external\\\", 7, \\\"test\\\", \\\"HsjwMPoGmnu8V2lP\\\"]:\\n\\nSQLSTATE[HY000]: General error: 1364 Field 'user' doe
sn't have a default value in \\\/srv\\\/www\\\/wolke.leitold.koeln\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php on line <i>103<\\\/i><\\\/th><\\\/tr>\\n<tr><th align='left' bgcolor='#e9b9
6e' colspan='5'>Call Stack<\\\/th><\\\/tr>\\n<tr><th align='center' bgcolor='#eeeeec'>#<\\\/th><th align='left' bgcolor='#eeeeec'>Time<\\\/th><th align='left' bgcolor='#eeeeec'>Memory<\\\/th><th align='left' bgcolor='#eeeeec'>Function<\\\
/th><th align='left' bgcolor='#eeeeec'>Location<\\\/th><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>1<\\\/td><td bgcolor='#eeeeec' align='center'>0.0001<\\\/td><td bgcolor='#eeeeec' align='right'>393792<\\\/td><td bgcolor='#eeeeec'
>{main}( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/index.php' bgcolor='#eeeeec'>...\\\/index.php<b>:<\\\/b>0<\\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>2<\\\/td><td bgcolor='#eeeeec' align='center'>0.07
28<\\\/td><td bgcolor='#eeeeec' align='right'>2620936<\\\/td><td bgcolor='#eeeeec'>OC::handleRequest( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/index.php' bgcolor='#eeeeec'>...\\\/index.php<b>:<\\\/b>42<\\\/td><\\\/tr>
\\n<tr><td bgcolor='#eeeeec' align='center'>3<\\\/td><td bgcolor='#eeeeec' align='center'>0.2135<\\\/td><td bgcolor='#eeeeec' align='right'>5656040<\\\/td><td bgcolor='#eeeeec'>OC\\\\Route\\\\CachingRouter->match( )<\\\/td><td title='\\\
/srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/base.php' bgcolor='#eeeeec'>...\\\/base.php<b>:<\\\/b>997<\\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>4<\\\/td><td bgcolor='#eeeeec' align='center'>0.2294<\\\/td><td bgcolor='#ee
eeec' align='right'>5985648<\\\/td><td bgcolor='#eeeeec'><a href='http:\\\/\\\/www.php.net\\\/function.call-user-func:{\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/private\\\/Route\\\/Router.php:297}' target='_new'>call_user_func:{\\\/
srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/private\\\/Route\\\/Router.php:297}<\\\/a>\\n( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/private\\\/Route\\\/Router.php' bgcolor='#eeeeec'>...\\\/Router.php<b>:<\\\/b>
297<\\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>5<\\\/td><td bgcolor='#eeeeec' align='center'>0.2294<\\\/td><td bgcolor='#eeeeec' align='right'>5985648<\\\/td><td bgcolor='#eeeeec'>OC\\\\AppFramework\\\\Routing\\\\RouteActi
onHandler->__invoke( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/private\\\/Route\\\/Router.php' bgcolor='#eeeeec'>...\\\/Router.php<b>:<\\\/b>297<\\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>6<\\\/t
d><td bgcolor='#eeeeec' align='center'>0.2294<\\\/td><td bgcolor='#eeeeec' align='right'>5985648<\\\/td><td bgcolor='#eeeeec'>OC\\\\AppFramework\\\\App::main( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/private\\\
/AppFramework\\\/Routing\\\/RouteActionHandler.php' bgcolor='#eeeeec'>...\\\/RouteActionHandler.php<b>:<\\\/b>47<\\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>7<\\\/td><td bgcolor='#eeeeec' align='center'>0.2575<\\\/td><td bg
color='#eeeeec' align='right'>6223240<\\\/td><td bgcolor='#eeeeec'>OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/private\\\/AppFramework\\\/App.php' bgcolor='#eeee
ec'>...\\\/App.php<b>:<\\\/b>126<\\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>8<\\\/td><td bgcolor='#eeeeec' align='center'>0.2605<\\\/td><td bgcolor='#eeeeec' align='right'>6225736<\\\/td><td bgcolor='#eeeeec'>OC\\\\AppFram
ework\\\\Http\\\\Dispatcher->executeController( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php' bgcolor='#eeeeec'>...\\\/Dispatcher.php<b>:<\\\/b>99<\\\/td><\\\/tr>\\
n<tr><td bgcolor='#eeeeec' align='center'>9<\\\/td><td bgcolor='#eeeeec' align='center'>0.2607<\\\/td><td bgcolor='#eeeeec' align='right'>6227032<\\\/td><td bgcolor='#eeeeec'>OCA\\\\Polls\\\\Controller\\\\ShareController->createPersonalSh
are( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php' bgcolor='#eeeeec'>...\\\/Dispatcher.php<b>:<\\\/b>170<\\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>
10<\\\/td><td bgcolor='#eeeeec' align='center'>0.3155<\\\/td><td bgcolor='#eeeeec' align='right'>6336728<\\\/td><td bgcolor='#eeeeec'>OCA\\\\Polls\\\\Db\\\\ShareMapper->insert( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\
/apps\\\/polls\\\/lib\\\/Controller\\\/ShareController.php' bgcolor='#eeeeec'>...\\\/ShareController.php<b>:<\\\/b>227<\\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>11<\\\/td><td bgcolor='#eeeeec' align='center'>0.3159<\\\/td
><td bgcolor='#eeeeec' align='right'>6340128<\\\/td><td bgcolor='#eeeeec'>OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/public\\\/AppFramework\\\/Db\\\/QBMapper.php
' bgcolor='#eeeeec'>...\\\/QBMapper.php<b>:<\\\/b>121<\\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>12<\\\/td><td bgcolor='#eeeeec' align='center'>0.3159<\\\/td><td bgcolor='#eeeeec' align='right'>6340128<\\\/td><td bgcolor='
#eeeeec'>Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php' bgcolor='#eeeeec'>...\\\/QueryBuilder.php<b>:<\\\/b>214<\
\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeeec' align='center'>13<\\\/td><td bgcolor='#eeeeec' align='center'>0.3159<\\\/td><td bgcolor='#eeeeec' align='right'>6340288<\\\/td><td bgcolor='#eeeeec'>OC\\\\DB\\\\Connection->executeUpdate( )<\\\/
td><td title='\\\/srv\\\/www\\\/wolke.leitold.koeln\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php' bgcolor='#eeeeec'>...\\\/QueryBuilder.php<b>:<\\\/b>203<\\\/td><\\\/tr>\\n<tr><td bgcolor='#eeeee
c' align='center'>14<\\\/td><td bgcolor='#eeeeec' align='center'>0.3159<\\\/td><td bgcolor='#eeeeec' align='right'>6340448<\\\/td><td bgcolor='#eeeeec'>OC\\\\DB\\\\Connection->executeUpdate( )<\\\/td><td title='\\\/srv\\\/www\\\/wolke.le
itold.koeln\\\/lib\\\/private\\\/DB\\\/Connection.php' bgcolor='#eeeeec'>...\\\/Connection.php<b>:<\\\/b>216<\\\/td><\\\/tr>\\n\"}","userAgent":"Mozilla\/5.0 (Android 9; Mobile; rv:71.0) Gecko\/71.0 Firefox\/71.0","version":"17.0.2.1"}
{"reqId":"jCbvvyLnh1JCq3dnOEbX","level":0,"time":"2020-01-23T18:15:46+01:00","remoteAddr":"192.168.41.1","user":"--","app":"user_ldap","method":"POST","url":"\/apps\/polls\/check\/username","message":"getGroups getGroups--500-","userAgent
":"Mozilla\/5.0 (Android 9; Mobile; rv:71.0) Gecko\/71.0 Firefox\/71.0","version":"17.0.2.1"}
{"reqId":"jCbvvyLnh1JCq3dnOEbX","level":0,"time":"2020-01-23T18:15:46+01:00","remoteAddr":"192.168.41.1","user":"--","app":"user_ldap","method":"POST","url":"\/apps\/polls\/check\/username","message":"getGroups(): read 9 at offset (limit
: 500)","userAgent":"Mozilla\/5.0 (Android 9; Mobile; rv:71.0) Gecko\/71.0 Firefox\/71.0","version":"17.0.2.1"}
could you send me structure of your oc_polls_share? Seems something weird here
dartcafe
on 23 Jan 2020
Did you test other test releases of the 1.x version?
dartcafe
on 23 Jan 2020
I think, the column user with tyoe 'TEXT' has a problem on some database settings, because the default is not set on this field type. I removed this column, because it is not needed now and I hope, to avoid this bug this way. Updated version: polls-1.1.5.zip
@t0mcat1337 If you are in the mood, to try again?
dartcafe
on 23 Jan 2020
Public anonymous voting seems to be working again.
But there are still problems with the invitations.
Add a user works.
If you want to invite a group, there is a 409 status code. However, no error is logged.
tristanlins
on 23 Jan 2020
And not to forget, adding a public link works again too ;-)
tristanlins
on 23 Jan 2020
🎉1
If you want to invite a group, there is a 409 status code. However, no error is logged.
I am really getting mad. I have 3 test and 3 productions systems, which do not have these errors.
Can you give me some more information?
How many members are in this group?
Any log information from the js console?
dartcafe
on 23 Jan 2020
Did you test other test releases of the 1.x version?
Yes, I tested every 1.X version ;)
t0mcat1337
on 23 Jan 2020
could you send me structure of your oc_polls_share? Seems something weird here
Here it is:
mysql> describe oc_polls_share;
+------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| token | varchar(64) | NO | | NULL | |
| type | varchar(64) | NO | | NULL | |
| poll_id | int(11) | NO | | NULL | |
| user_id | varchar(64) | YES | | NULL | |
| user_email | varchar(254) | YES | | NULL | |
+------------+--------------+------+-----+---------+----------------+
6 rows in set (0.00 sec)
Oh dear, when I just reopened the survey, I found that the invitation worked.
Just adding a group results in an error.
After reloading the page, the group is invited.
There are a couple of very strange things happening.
When I open the survey, I first see a 404 in the log.
GET https://example.com/apps/polls/subscription/get/8 404
Response Headers
cache-control: no-cache, no-store, must-revalidate
content-length: 4
content-security-policy: default-src 'none';base-uri 'none';manifest-src 'self'
content-type: application/json; charset=utf-8
date: Thu, 23 Jan 2020 21:06:04 GMT
expires: Thu, 19 Nov 1981 08:52:00 GMT
feature-policy: autoplay 'none';camera 'none';fullscreen 'none';geolocation 'none';microphone 'none';payment 'none'
pragma: no-cache
referrer-policy: no-referrer
server: nginx/1.17.7
status: 404
strict-transport-security: max-age=15768000; includeSubDomains; preload;
vary: Accept-Encoding
x-content-type-options: nosniff
x-download-options: noopen
x-frame-options: SAMEORIGIN
x-permitted-cross-domain-policies: none
x-robots-tag: none
x-xss-protection: 1; mode=block
Request Headers
:authority: example.com
:method: GET
:path: /apps/polls/subscription/get/8
:scheme: https
accept: application/json, text/plain, */*
accept-encoding: gzip, deflate, br
accept-language: de-DE,de;q=0.9,en-US;q=0.8,en;q=0.7
cookie: ...
requesttoken: ...
sec-fetch-mode: cors
sec-fetch-site: same-origin
user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/79.0.3945.79 Chrome/79.0.3945.79 Safari/537.36
But all other XHR requests work.
GET https://example.com/apps/polls/comments/get/8 200
GET https://example.com/apps/polls/options/get/8 200
GET https://example.com/apps/polls/shares/get/8 200
GET https://example.com/apps/polls/votes/get/8 200
POST https://thw.lins.io/apps/polls/share/write/ 409
Response Body
{}
Response Headers
cache-control: no-cache, no-store, must-revalidate
content-length: 2
content-security-policy: default-src 'none';base-uri 'none';manifest-src 'self'
content-type: application/json; charset=utf-8
date: Thu, 23 Jan 2020 21:13:59 GMT
expires: Thu, 19 Nov 1981 08:52:00 GMT
feature-policy: autoplay 'none';camera 'none';fullscreen 'none';geolocation 'none';microphone 'none';payment 'none'
pragma: no-cache
referrer-policy: no-referrer
server: nginx/1.17.7
status: 409
strict-transport-security: max-age=15768000; includeSubDomains; preload;
vary: Accept-Encoding
x-content-type-options: nosniff
x-download-options: noopen
x-frame-options: SAMEORIGIN
x-permitted-cross-domain-policies: none
x-robots-tag: none
x-xss-protection: 1; mode=block
Request Headers
:authority: thw.lins.io
:method: POST
:path: /apps/polls/share/write/
:scheme: https
accept: application/json, text/plain, */*
accept-encoding: gzip, deflate, br
accept-language: de-DE,de;q=0.9,en-US;q=0.8,en;q=0.7
content-length: 100
content-type: application/json;charset=UTF-8
cookie: _ga=GA1.2.1655683447.1574406146; __Host-nc_sameSiteCookielax=true; __Host-nc_sameSiteCookiestrict=true; nc_username=tril; ajs_group_id=null; ajs_user_id=%22545oz6yekjgafboor568c1wsqa%22; ajs_anonymous_id=%2200000000000000000000000000%22; _gid=GA1.2.1037056167.1579693322; oc_sessionPassphrase=JKSxVOdkfKnx1srpj564CQGPhA%2BgXVs%2FTcUh%2B3%2BqHi9pMHBoL7Kku2oB6fuuNM3nQ6m762cXFko3Oouim71IOqhfZT2wftSUDDmRmpPlg5yKVMEDJzAYA090qihIf%2F3v; ocomuxttsipm=37ec349d6faeff54d46f3492fd1fab20; nc_token=bYzdzlufhYC%2FlT2EDx5KGxRUE6ljx4Uu; nc_session_id=37ec349d6faeff54d46f3492fd1fab20
origin: https://thw.lins.io
requesttoken: t8TCFyFjmK9iW4IyTjNE0gIIkUVttQr7n4ahXpTuWOM=:wID6cRENqZkvaegAOQoVkWlb1g4Z2V262MLGOPXYbNs=
sec-fetch-mode: cors
sec-fetch-site: same-origin
user-agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Ubuntu Chromium/79.0.3945.79 Chrome/79.0.3945.79 Safari/537.36
Request Payload
{"pollId":8,"share":{"type":"group","userId":"My Group","pollId":8,"userEmail":"","token":""}}
And in the console
With these two objects logged
{
"error": {
"data": {},
"status": 409,
"statusText": "",
"headers": {
"cache-control": "no-cache, no-store, must-revalidate",
"content-length": "2",
"content-security-policy": "default-src 'none';base-uri 'none';manifest-src 'self'",
"content-type": "application/json; charset=utf-8",
"date": "Thu, 23 Jan 2020 21:13:59 GMT",
"expires": "Thu, 19 Nov 1981 08:52:00 GMT",
"feature-policy": "autoplay 'none';camera 'none';fullscreen 'none';geolocation 'none';microphone 'none';payment 'none'",
"pragma": "no-cache",
"referrer-policy": "no-referrer",
"server": "nginx/1.17.7",
"status": "409",
"strict-transport-security": "max-age=15768000; includeSubDomains; preload;",
"vary": "Accept-Encoding",
"x-content-type-options": "nosniff",
"x-download-options": "noopen",
"x-frame-options": "SAMEORIGIN",
"x-permitted-cross-domain-policies": "none",
"x-robots-tag": "none",
"x-xss-protection": "1; mode=block"
},
"config": {
"url": "/apps/polls/share/write/",
"method": "post",
"data": "{\"pollId\":8,\"share\":{\"type\":\"group\",\"userId\":\"My Group\",\"pollId\":8,\"userEmail\":\"\",\"token\":\"\"}}",
"headers": {
"Accept": "application/json, text/plain, */*",
"Content-Type": "application/json;charset=utf-8",
"requesttoken": "t8TCFyFjmK9iW4IyTjNE0gIIkUVttQr7n4ahXpTuWOM=:wID6cRENqZkvaegAOQoVkWlb1g4Z2V262MLGOPXYbNs="
},
"transformRequest": [
null
],
"transformResponse": [
null
],
"timeout": 0,
"xsrfCookieName": "XSRF-TOKEN",
"xsrfHeaderName": "X-XSRF-TOKEN",
"maxContentLength": -1
},
"request": {}
}
}
{
"payload": {
"share": {
"type": "group",
"userId": "My Group",
"pollId": 8,
"userEmail": "",
"token": ""
}
}
}
Systeminfo
Nextcloud 17.0.2.1 (Docker Edition)
Enabled Apps:
- accessibility: 1.3.0
- activity: 2.10.1
- bruteforcesettings: 1.5.0
- calendar: 2.0.1
- cloud_federation_api: 1.0.0
- comments: 1.7.0
- contacts: 3.1.8
- dav: 1.13.0
- federatedfilesharing: 1.7.0
- federation: 1.7.0
- files: 1.12.0
- files_pdfviewer: 1.6.0
- files_rightclick: 0.15.1
- files_sharing: 1.9.0
- files_trashbin: 1.7.0
- files_versions: 1.10.0
- files_videoplayer: 1.6.0
- firstrunwizard: 2.6.0
- gallery: 18.4.0
- logreader: 2.2.0
- lookup_server_connector: 1.5.0
- nextcloud_announcements: 1.6.0
- notes: 3.1.1
- notifications: 2.5.0
- oauth2: 1.5.0
- password_policy: 1.7.0
- polls: 1.1.5
- privacy: 1.1.0
- provisioning_api: 1.7.0
- quota_warning: 1.6.0
- recommendations: 0.5.0
- registration: 0.4.7
- serverinfo: 1.7.0
- sharebymail: 1.7.0
- social: 0.2.101
- spreed: 7.0.2
- support: 1.0.1
- survey_client: 1.5.0
- systemtags: 1.7.0
- tasks: 0.11.3
- text: 1.1.1
- theming: 1.8.0
- twofactor_backupcodes: 1.6.0
- updatenotification: 1.7.0
- viewer: 1.2.0
- workflowengine: 1.7.0
Disabled Apps:
- admin_audit
- encryption
- files_external
- user_ldap
tristanlins
on 23 Jan 2020
I think, the column user with tyoe 'TEXT' has a problem on some database settings, because the default is not set on this field type. I removed this column, because it is not needed now and I hope, to avoid this bug this way. Updated version: polls-1.1.5.zip
@t0mcat1337 If you are in the mood, to try again?
Yes, I am :) ... I installed 1.1.5 and public polls are now working without problems for me.
t0mcat1337
on 23 Jan 2020
Sorry, missed the stacktrace of the second error:
tristanlins
on 23 Jan 2020
The second error says "Error in share comment". This is a typo I fixed yesterday. Sure, you have 1.1.5?
That's right. 404 says no existing subscription. Maybe a bad solution for checking that.
dartcafe
on 24 Jan 2020
The second error says "Error in share comment". This is a typo I fixed yesterday. Sure, you have 1.1.5?
I downloaded and installed the polls-1.1.5.zip you suggested.
Nextcloud also thinks I have installed version 1.1.5.
tristanlins
on 24 Jan 2020
??? String search for "share comment" over the complete package gives no result.
https://github.com/nextcloud/polls/commit/1af986ba025ba9a6edbcc25f864d7c2b9c155b8a#diff-a1c3d8d7458c88e04be0bbe50ca4e77e
dartcafe
on 24 Jan 2020
Same problem here. Using 1.1.5 (Posted above) and Nextcloud Docker image.
diegombeltran
on 24 Jan 2020
@diegombeltran Which one? Meanwhile, there are several issues in this topic.
dartcafe
on 24 Jan 2020
@tristanlins @diegombeltran
I added some extra debug logging. Could you try this one? please activate debug logging in the admin's logging section and filter to the app polls. Ther should be seome detaled infomation about the way the shares are created: --deleted--
If you have the 1.1.5 RC,y you can replace it with this (only the debug logging is added). Make sure, your polls directory is empty before.
dartcafe
on 24 Jan 2020
I have the same behavior, but the logs do not tell me much, it shows an empty exception when creating the user:
{"reqId":"VZgcvZq8BvjrlMjZWTlF","level":0,"time":"2020-01-24T19:17:47+00:00","remoteAddr":"###.###.###.###,"user":"--","app":"polls","method":"POST","url":"\/nextcloud\/apps\/polls\/share\/create\/s\/","message":"Create share: {\"id\":15,\"token\":\"bKib9i7O4KXYqvTW\",\"type\":\"external\",\"pollId\":1,\"userId\":\"feo\",\"userEmail\":\"\"}","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/79.0.3945.130 Safari\/537.36","version":"17.0.2.1"}
{"reqId":"VZgcvZq8BvjrlMjZWTlF","level":0,"time":"2020-01-24T19:17:47+00:00","remoteAddr":"###.###.###.###","user":"--","app":"polls","method":"POST","url":"\/nextcloud\/apps\/polls\/share\/create\/s\/","message":"Exception: {}","userAgent":"Mozilla\/5.0 (X11; Linux x86_64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/79.0.3945.130 Safari\/537.36","version":"17.0.2.1"}
I'm using PostgreSQL 11.5. PHP-FPM 7.3.11 and NGINX 1.14.2 with Nextcloud 17.0.2.
Tell me if I can try anything else to help.
sto
on 24 Jan 2020
I had a typo in the source and some nonsense from testing.
Updated version: polls-1.1.5-debug.zip
replace existing polls app with the package above, set the logging options to debug and filter to polls.
When adding a share, more will be logged than normal. Please be aware, that personal information is logged, so please use only test data or anoymize them. Also an upload of the log file (extract) is possible at https://nc.yagst.de/index.php/s/i8LrNyJRyAcjc72
This would give me some information about the data collected and where the error occures.
dartcafe
on 24 Jan 2020
I'm seeing the same behavior, in my case the error happens in the line 226 of the file lib/Controller/ShareController.php:
225 $this->logger->debug('Create share: '. json_encode($userShare));
226 $userShare = $this->mapper->insert($userShare);
227 }
228
229 } catch (\Exception $e) {
230 $this->logger->debug('Exception: '. json_encode($e));
231 return new DataResponse($e, Http::STATUS_CONFLICT);
232 }
So my guess is that the failure is on the call:
$this->mapper->insert($userShare);
It probably is a database issue, but I don't know how to view what is failing (the exception is empty but the catch is processed, so something is wrong somewhere)
sto
on 24 Jan 2020
For the moment, I am blind, because I don't have these issue on my instances (on MySQL). That's why I need the debug log. So I can see, which data should be written.
dartcafe
on 25 Jan 2020
I've commented out the try / catch and it seems that the poll_id is missing:
{
"reqId": "nX4MHiqQbTzRW0xD6cYY",
"level": 3,
"time": "2020-01-25T09:39:30+00:00",
"remoteAddr": "###.xxx.yyy.zzz",
"user": "--",
"app": "index",
"method": "POST",
"url": "/nextcloud/apps/polls/share/create/s/",
"message": {
"Exception": "Doctrine\\DBAL\\Exception\\NotNullConstraintViolationException",
"Message": "An exception occurred while executing 'INSERT INTO \"nc_polls_share\" (\"type\", \"user_id\", \"token\") VALUES(?, ?, ?)' with params [\"external\", \"Xxx\", \"be4SBEsB1stAKMjG\"]:\n\nSQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"poll_id\" violates not-null constraint\nDETAIL: Failing row contains (38, be4SBEsB1stAKMjG, external, null, Xxx, null).",
"Code": 0,
"Trace": [
{
"file": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php",
"line": 169,
"function": "convertException",
"class": "Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver",
"type": "->",
"args": [
"An exception occurred while executing 'INSERT INTO \"nc_polls_share\" (\"type\", \"user_id\", \"token\") VALUES(?, ?, ?)' with params [\"external\", \"Xxx\", \"be4SBEsB1stAKMjG\"]:\n\nSQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"poll_id\" violates not-null constraint\nDETAIL: Failing row contains (38, be4SBEsB1stAKMjG, external, null, Xxx, null).",
{
"errorInfo": [
"23502",
7,
"ERROR: null value in column \"poll_id\" violates not-null constraint\nDETAIL: Failing row contains (38, be4SBEsB1stAKMjG, external, null, Xxx, null)."
],
"__class__": "Doctrine\\DBAL\\Driver\\PDOException"
}
]
},
{
"file": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php",
"line": 145,
"function": "wrapException",
"class": "Doctrine\\DBAL\\DBALException",
"type": "::",
"args": [
{
"__class__": "Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver"
},
{
"errorInfo": [
"23502",
7,
"ERROR: null value in column \"poll_id\" violates not-null constraint\nDETAIL: Failing row contains (38, be4SBEsB1stAKMjG, external, null, Xxx, null)."
],
"__class__": "Doctrine\\DBAL\\Driver\\PDOException"
},
"An exception occurred while executing 'INSERT INTO \"nc_polls_share\" (\"type\", \"user_id\", \"token\") VALUES(?, ?, ?)' with params [\"external\", \"Xxx\", \"be4SBEsB1stAKMjG\"]:\n\nSQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"poll_id\" violates not-null constraint\nDETAIL: Failing row contains (38, be4SBEsB1stAKMjG, external, null, Xxx, null)."
]
},
{
"file": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",
"line": 1063,
"function": "driverExceptionDuringQuery",
"class": "Doctrine\\DBAL\\DBALException",
"type": "::",
"args": [
{
"__class__": "Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver"
},
{
"errorInfo": [
"23502",
7,
"ERROR: null value in column \"poll_id\" violates not-null constraint\nDETAIL: Failing row contains (38, be4SBEsB1stAKMjG, external, null, Xxx, null)."
],
"__class__": "Doctrine\\DBAL\\Driver\\PDOException"
},
"INSERT INTO \"nc_polls_share\" (\"type\", \"user_id\", \"token\") VALUES(?, ?, ?)",
{
"1": "external",
"2": "Xxx",
"3": "be4SBEsB1stAKMjG"
}
]
},
{
"file": "/srv/nextcloud/lib/private/DB/Connection.php",
"line": 216,
"function": "executeUpdate",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO \"nc_polls_share\" (\"type\", \"user_id\", \"token\") VALUES(?, ?, ?)",
[
"external",
"Xxx",
"be4SBEsB1stAKMjG"
],
[
2,
2,
2
]
]
},
{
"file": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php",
"line": 203,
"function": "executeUpdate",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO \"nc_polls_share\" (\"type\", \"user_id\", \"token\") VALUES(:dcValue1, :dcValue2, :dcValue3)",
{
"dcValue1": "external",
"dcValue2": "Xxx",
"dcValue3": "be4SBEsB1stAKMjG"
},
{
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2
}
]
},
{
"file": "/srv/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 214,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/srv/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
"line": 121,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/srv/nextcloud/apps/polls/lib/Controller/ShareController.php",
"line": 226,
"function": "insert",
"class": "OCP\\AppFramework\\Db\\QBMapper",
"type": "->",
"args": [
{
"id": 37,
"__class__": "OCA\\Polls\\Db\\Share"
}
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 170,
"function": "createPersonalShare",
"class": "OCA\\Polls\\Controller\\ShareController",
"type": "->",
"args": [
"EwFMOfh2bcjmvMT2",
"Xxx"
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 99,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\Polls\\Controller\\ShareController"
},
"createPersonalShare"
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/App.php",
"line": 126,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\Polls\\Controller\\ShareController"
},
"createPersonalShare"
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",
"line": 47,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\Polls\\Controller\\ShareController",
"createPersonalShare",
{
"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
},
{
"_route": "polls.share.createPersonalShare"
}
]
},
{
"function": "__invoke",
"class": "OC\\AppFramework\\Routing\\RouteActionHandler",
"type": "->",
"args": [
{
"_route": "polls.share.createPersonalShare"
}
]
},
{
"file": "/srv/nextcloud/lib/private/Route/Router.php",
"line": 297,
"function": "call_user_func",
"args": [
{
"__class__": "OC\\AppFramework\\Routing\\RouteActionHandler"
},
{
"_route": "polls.share.createPersonalShare"
}
]
},
{
"file": "/srv/nextcloud/lib/base.php",
"line": 997,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/apps/polls/share/create/s/"
]
},
{
"file": "/srv/nextcloud/index.php",
"line": 42,
"function": "handleRequest",
"class": "OC",
"type": "::",
"args": []
}
],
"File": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php",
"Line": 45,
"Previous": {
"Exception": "Doctrine\\DBAL\\Driver\\PDOException",
"Message": "SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"poll_id\" violates not-null constraint\nDETAIL: Failing row contains (38, be4SBEsB1stAKMjG, external, null, Xxx, null).",
"Code": "23502",
"Trace": [
{
"file": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",
"line": 1054,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDOStatement",
"type": "->",
"args": []
},
{
"file": "/srv/nextcloud/lib/private/DB/Connection.php",
"line": 216,
"function": "executeUpdate",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO \"nc_polls_share\" (\"type\", \"user_id\", \"token\") VALUES(?, ?, ?)",
[
"external",
"Xxx",
"be4SBEsB1stAKMjG"
],
[
2,
2,
2
]
]
},
{
"file": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php",
"line": 203,
"function": "executeUpdate",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO \"nc_polls_share\" (\"type\", \"user_id\", \"token\") VALUES(:dcValue1, :dcValue2, :dcValue3)",
{
"dcValue1": "external",
"dcValue2": "Xxx",
"dcValue3": "be4SBEsB1stAKMjG"
},
{
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2
}
]
},
{
"file": "/srv/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 214,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/srv/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
"line": 121,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/srv/nextcloud/apps/polls/lib/Controller/ShareController.php",
"line": 226,
"function": "insert",
"class": "OCP\\AppFramework\\Db\\QBMapper",
"type": "->",
"args": [
{
"id": 37,
"__class__": "OCA\\Polls\\Db\\Share"
}
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 170,
"function": "createPersonalShare",
"class": "OCA\\Polls\\Controller\\ShareController",
"type": "->",
"args": [
"EwFMOfh2bcjmvMT2",
"Xxx"
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 99,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\Polls\\Controller\\ShareController"
},
"createPersonalShare"
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/App.php",
"line": 126,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\Polls\\Controller\\ShareController"
},
"createPersonalShare"
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",
"line": 47,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\Polls\\Controller\\ShareController",
"createPersonalShare",
{
"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
},
{
"_route": "polls.share.createPersonalShare"
}
]
},
{
"function": "__invoke",
"class": "OC\\AppFramework\\Routing\\RouteActionHandler",
"type": "->",
"args": [
{
"_route": "polls.share.createPersonalShare"
}
]
},
{
"file": "/srv/nextcloud/lib/private/Route/Router.php",
"line": 297,
"function": "call_user_func",
"args": [
{
"__class__": "OC\\AppFramework\\Routing\\RouteActionHandler"
},
{
"_route": "polls.share.createPersonalShare"
}
]
},
{
"file": "/srv/nextcloud/lib/base.php",
"line": 997,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/apps/polls/share/create/s/"
]
},
{
"file": "/srv/nextcloud/index.php",
"line": 42,
"function": "handleRequest",
"class": "OC",
"type": "::",
"args": []
}
],
"File": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",
"Line": 119,
"Previous": {
"Exception": "PDOException",
"Message": "SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"poll_id\" violates not-null constraint\nDETAIL: Failing row contains (38, be4SBEsB1stAKMjG, external, null, Xxx, null).",
"Code": "23502",
"Trace": [
{
"file": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",
"line": 117,
"function": "execute",
"class": "PDOStatement",
"type": "->",
"args": [
null
]
},
{
"file": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php",
"line": 1054,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDOStatement",
"type": "->",
"args": []
},
{
"file": "/srv/nextcloud/lib/private/DB/Connection.php",
"line": 216,
"function": "executeUpdate",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO \"nc_polls_share\" (\"type\", \"user_id\", \"token\") VALUES(?, ?, ?)",
[
"external",
"Xxx",
"be4SBEsB1stAKMjG"
],
[
2,
2,
2
]
]
},
{
"file": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php",
"line": 203,
"function": "executeUpdate",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO \"nc_polls_share\" (\"type\", \"user_id\", \"token\") VALUES(:dcValue1, :dcValue2, :dcValue3)",
{
"dcValue1": "external",
"dcValue2": "Xxx",
"dcValue3": "be4SBEsB1stAKMjG"
},
{
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2
}
]
},
{
"file": "/srv/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 214,
"function": "execute",
"class": "Doctrine\\DBAL\\Query\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/srv/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
"line": 121,
"function": "execute",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/srv/nextcloud/apps/polls/lib/Controller/ShareController.php",
"line": 226,
"function": "insert",
"class": "OCP\\AppFramework\\Db\\QBMapper",
"type": "->",
"args": [
{
"id": 37,
"__class__": "OCA\\Polls\\Db\\Share"
}
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 170,
"function": "createPersonalShare",
"class": "OCA\\Polls\\Controller\\ShareController",
"type": "->",
"args": [
"EwFMOfh2bcjmvMT2",
"Xxx"
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 99,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\Polls\\Controller\\ShareController"
},
"createPersonalShare"
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/App.php",
"line": 126,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\Polls\\Controller\\ShareController"
},
"createPersonalShare"
]
},
{
"file": "/srv/nextcloud/lib/private/AppFramework/Routing/RouteActionHandler.php",
"line": 47,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\Polls\\Controller\\ShareController",
"createPersonalShare",
{
"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
},
{
"_route": "polls.share.createPersonalShare"
}
]
},
{
"function": "__invoke",
"class": "OC\\AppFramework\\Routing\\RouteActionHandler",
"type": "->",
"args": [
{
"_route": "polls.share.createPersonalShare"
}
]
},
{
"file": "/srv/nextcloud/lib/private/Route/Router.php",
"line": 297,
"function": "call_user_func",
"args": [
{
"__class__": "OC\\AppFramework\\Routing\\RouteActionHandler"
},
{
"_route": "polls.share.createPersonalShare"
}
]
},
{
"file": "/srv/nextcloud/lib/base.php",
"line": 997,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/apps/polls/share/create/s/"
]
},
{
"file": "/srv/nextcloud/index.php",
"line": 42,
"function": "handleRequest",
"class": "OC",
"type": "::",
"args": []
}
],
"File": "/srv/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php",
"Line": 117
}
},
"CustomMessage": "--"
},
"userAgent": "Mozilla/5.0 (Linux; Android 8.1.0; Nexus 6P) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/79.0.3945.136 Mobile Safari/537.36",
"version": "17.0.2.1"
}
👍1
I did it the hard way and generated a new share object with explicit setting the properties. Could you try again?
polls-1.1.5-debug3.zip
dartcafe
on 25 Jan 2020
I did it the hard way and generated a new share object with explicit setting the properties. Could you try again?
polls-1.1.5-debug3.zip
This version worked!
sto
on 25 Jan 2020
🎉1
Puh. Thanks. Now I understand what happened. At least I understand the problem and know how to avoid this. Seems to be a DB and DB settings related behavior.
I will remove the debug infos and merge this then.
dartcafe
on 25 Jan 2020
diego
Sorry for the delay. First error. BTW it is resolved with 1.1.6. Thank you!
diegombeltran
on 27 Jan 2020
It is still not working when the anon link is being used from a smartphone. The desktop version does work indeed.
HolyMacarony
on 28 May 2020
@HolyMacarony Please do not use resoved issues for new bug reports. And please explain exactly, what does not work. I tested a public link on mobile and it works as expected.
dartcafe
on 28 May 2020
It still doesn't work for arbitary users. Only if you add a number to the name. "John" is not accepted, "John1" is accepted. It seems like a weak password check, which shouldn't be in place here.
eichenbrenner
on 28 Jan 2021
@eichenbrenner You are answering to an old issue, closed months ago. Please open a new issue and describe what you expect and what happens. I need more information for beeing able to reproduce the issue.
dartcafe
on 28 Jan 2021
Was this page helpful?
0 / 5 - 0 ratings
Related issues
khayman123
路
3Comments
dartcafe
路
6Comments
Dubidubiduu
路
5Comments
andriusign
路
6Comments
hanzei
路
6Comments