Error when downloading from filesharing link

RaidJan · February 7, 2023, 10:33am

Hello everyone,

First time for me to come here, usually I found my answer but on this case… no :]
I just upgrade my owncloud server from 10.0.5 to 10.11.0 and I have one issue with file sharing.

From one user account, I create a public link to share any data, the link can be open, but I got an error when I’m downloading.

Expected behaviour

Before the update the user could download

Actual behaviour

Since the last update cannot download

Server configuration

Debian shared server (ionos)

Web server:

Database:
MySQL 5.7

PHP version:
PHP 7.4

ownCloud version: (see ownCloud admin page)
10.11.0

Updated from an older ownCloud or fresh install:
Updated from 10.0.5

Where did you install ownCloud from:
Manual upgrade with official link

Signing status (ownCloud 9.0 and above):

Login as admin user into your ownCloud and access 
http://example.com/index.php/settings/integrity/failed 
paste the results into https://gist.github.com/ and puth the link here.
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.

cannot add file as new user

**The content of config/config.php:**
<?php
$CONFIG = array (
  'instanceid' => 'ocyjkmd7k1vq',
  'passwordsalt' => 'qWgQMxjTeCPHKdV9KuDe8COdThJUNs',
  'secret' => 'MlFSIr46JLBYl6ZLAXBsEEBMdCAGfC4juxhtswlo.sWvw6NN',
  'trusted_domains' => 
  array (
    0 => ****** hidden*******,
    1 => ****** hidden*******,
    2 => ****** hidden*******,
  ),
  'datadirectory' => ****** hidden*******,
  'overwrite.cli.url' => ****** hidden*******,
  'dbtype' => 'mysql',
  'version' => '10.11.0.6',
  'dbname' => ****** hidden*******,
  'dbhost' => ****** hidden*******,
  'dbtableprefix' => 'oc_',
  'dbuser' => ****** hidden*******,
  'dbpassword' => ****** hidden*******,
  'filelocking.enabled' => true,
  'installed' => true,
  'mail_smtpmode' => 'php',
  'mail_from_address' => 'contact',
  'mail_domain' => ****** hidden*******,
  'mail_smtphost' => ****** hidden*******,
  'mail_smtpport' => '465',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'loglevel' => 2,
  'log_rotate_size' => 104857600,
  'mail_smtpauthtype' => 'LOGIN',
  'mail_smtpauth' => 1,
  'mail_smtpname' => ****** hidden*******,
  'mail_smtppassword' => ****** hidden*******,
  'theme' => '',
  'maintenance' => false,
  'singleuser' => false,
  'trashbin_retention_obligation' => 'auto',
  'allow_user_to_change_mail_address' => '',
);

Log in to the web-UI with an administrator account and click on
‘admin’ → ‘Generate Config Report’ → ‘Download ownCloud config report’
This report includes the config.php settings, the list of activated apps
and other details in a well sanitized form.

→ it’s not allowed to upload a json to this thread no ?

or

List of activated apps:

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your ownCloud installation folder.

Enabled:
  - activity:
    - Version: 2.7.1
    - Path: /homepages/9/d579927651/htdocs/dms/apps/activity
  - announcementcenter:
    - Version: 1.2.2
    - Path: /homepages/9/d579927651/htdocs/dms/apps/announcementcenter
  - calendar:
    - Version: 2.0.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/calendar
  - comments:
    - Version: 0.3.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/comments
  - configreport:
    - Version: 0.2.1
    - Path: /homepages/9/d579927651/htdocs/dms/apps/configreport
  - customgroups:
    - Version: 0.7.1
    - Path: /homepages/9/d579927651/htdocs/dms/apps/customgroups
  - dav:
    - Version: 0.7.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/dav
  - encryption:
    - Version: 1.5.3
    - Path: /homepages/9/d579927651/htdocs/dms/apps/encryption
  - external:
    - Version: 1.4.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/external
  - federatedfilesharing:
    - Version: 0.5.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/federatedfilesharing
  - federation:
    - Version: 0.1.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/federation
  - files:
    - Version: 1.5.2
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files
  - files_external:
    - Version: 0.9.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_external
  - files_external_dropbox:
    - Version: 2.0.1
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_external_dropbox
  - files_external_ftp:
    - Version: 0.2.1
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_external_ftp
  - files_mediaviewer:
    - Version: 1.0.5
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_mediaviewer
  - files_pdfviewer:
    - Version: 1.0.1
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_pdfviewer
  - files_sharing:
    - Version: 0.14.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_sharing
  - files_texteditor:
    - Version: 2.4.1
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_texteditor
  - files_trashbin:
    - Version: 0.9.1
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_trashbin
  - files_versions:
    - Version: 1.3.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_versions
  - firstrunwizard:
    - Version: 1.2.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/firstrunwizard
  - graphapi:
    - Version: 0.3.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/graphapi
  - guests:
    - Version: 0.12.2
    - Path: /homepages/9/d579927651/htdocs/dms/apps/guests
  - market:
    - Version: 0.7.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/market
  - notifications:
    - Version: 0.5.4
    - Path: /homepages/9/d579927651/htdocs/dms/apps/notifications
  - oauth2:
    - Version: 0.5.3
    - Path: /homepages/9/d579927651/htdocs/dms/apps/oauth2
  - provisioning_api:
    - Version: 0.5.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/provisioning_api
  - systemtags:
    - Version: 0.3.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/systemtags
  - templateeditor:
    - Version: 0.4.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/templateeditor
  - theme-example:
    - Version: 1.0.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/theme-example
  - updatenotification:
    - Version: 0.2.1
    - Path: /homepages/9/d579927651/htdocs/dms/apps/updatenotification
  - user_external:
    - Version: 0.6.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/user_external
  - web:
    - Version: 6.0.0
    - Path: /homepages/9/d579927651/htdocs/dms/apps/web
Disabled:
  - admin_audit:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/admin_audit
  - enterprise_key:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/enterprise_key
  - files_antivirus:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_antivirus
  - files_classifier:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_classifier
  - files_ldap_home:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_ldap_home
  - files_lifecycle:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/files_lifecycle
  - firewall:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/firewall
  - metrics:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/metrics
  - openidconnect:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/openidconnect
  - password_policy:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/password_policy
  - ransomware_protection:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/ransomware_protection
  - sharepoint:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/sharepoint
  - systemtags_management:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/systemtags_management
  - theme-enterprise:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/theme-enterprise
  - user_ldap:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/user_ldap
  - user_shibboleth:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/user_shibboleth
  - windows_network_drive:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/windows_network_drive
  - wopi:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/wopi
  - workflow:
    - Path: /homepages/9/d579927651/htdocs/dms/apps/workflow

Are you using external storage, if yes which one: local/smb/sftp/…

no

Are you using encryption: /no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/…

no

Client configuration

Firefox / Edge

Operating system:

Logs

Web server error log

Insert your webserver log here

ownCloud log (data/owncloud.log)

Insert your ownCloud log here

next message i’m limited as new user

RaidJan · February 7, 2023, 10:37am

Finally as new user I cannot add file and i’m limited to 32000 character

Owncloud log:

{"reqId":"Y@IbctGmHjA6XtI0A5p51AAAAA4","level":3,"time":"2023-02-07T09:35:46+00:00","remoteAddr":"2a01:cb19:8699:f200:d871:4721:c86f:aa5d","user":"--","app":"index","method":"GET","url":"\/index.php\/s\/YINPvkz9ek0hRg8\/download?path=%2F&files=","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\NotNullConstraintViolationException\",\"Message\":\"An exception occurred while executing 'INSERT INTO `oc_activity` (`app`, `subject`, `subjectparams`, `message`, `messageparams`, `file`, `link`, `user`, `affecteduser`, `timestamp`, `priority`, `type`, `object_type`, `object_id`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [\\\"files_sharing\\\", \\\"public_shared_folder_downloaded\\\", \\\"[\\\\\\\"\\\\\\\\\\\\\\\/5 PA\\\\\\\\\\\\\\\/1 2020\\\\\\\\\\\\\\\/1 Permis d'am\\\\\\\\u00e9nager\\\\\\\\\\\\\\\/1 D\\\\\\\\u00e9p\\\\\\\\u00f4t de la demande et du r\\\\\\\\u00e9c\\\\\\\\u00e9piss\\\\\\\\u00e9\\\\\\\\\\\\\\\/1DPRADELLESU000124022020\\\\\\\"]\\\", \\\"\\\", \\\"[]\\\", \\\"\\\\\\\/5 PA\\\\\\\/1 2020\\\\\\\/1 Permis d'am\\\\u00e9nager\\\\\\\/1 D\\\\u00e9p\\\\u00f4t de la demande et du r\\\\u00e9c\\\\u00e9piss\\\\u00e9\\\\\\\/1DPRADELLESU000124022020\\\", \\\"\\\", null, \\\"106\\\", 1675762546, 30, \\\"public_links\\\", \\\"files\\\", 59316]:\\n\\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column 'user' cannot be null\",\"Code\":0,\"Trace\":\"#0 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(182): Doctrine\\\\DBAL\\\\Driver\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception))\\n#1 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(159): Doctrine\\\\DBAL\\\\DBALException::wrapException(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\MySQL\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception), 'An exception oc...')\\n#2 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(2226): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\MySQL\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception), 'INSERT INTO `oc...', Array)\\n#3 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1538): Doctrine\\\\DBAL\\\\Connection->handleExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception), 'INSERT INTO `oc...', Array, Array)\\n#4 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement('INSERT INTO `oc...', Array, Array)\\n#5 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement('INSERT INTO `oc...', Array, Array)\\n#6 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#7 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/apps\\\/activity\\\/lib\\\/Data.php(126): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#8 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/apps\\\/activity\\\/lib\\\/Consumer.php(76): OCA\\\\Activity\\\\Data->send(Object(OC\\\\Activity\\\\Event))\\n#9 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/Activity\\\/Manager.php(195): OCA\\\\Activity\\\\Consumer->receive(Object(OC\\\\Activity\\\\Event))\\n#10 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/apps\\\/files_sharing\\\/lib\\\/Controllers\\\/ShareController.php(510): OC\\\\Activity\\\\Manager->publish(Object(OC\\\\Activity\\\\Event))\\n#11 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(170): OCA\\\\Files_Sharing\\\\Controllers\\\\ShareController->downloadShare('YINPvkz9ek0hRg8', '', '\\\/', '')\\n#12 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(89): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OCA\\\\Files_Sharing\\\\Controllers\\\\ShareController), 'downloadShare')\\n#13 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/AppFramework\\\/App.php(100): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OCA\\\\Files_Sharing\\\\Controllers\\\\ShareController), 'downloadShare')\\n#14 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/public\\\/AppFramework\\\/App.php(132): OC\\\\AppFramework\\\\App::main('ShareController', 'downloadShare', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer))\\n#15 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/core\\\/routes.php(142): OCP\\\\AppFramework\\\\App->dispatch('ShareController', 'downloadShare')\\n#16 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/Route\\\/Router.php(344): OC\\\\Route\\\\Router->{closure}(*** sensitive parameters replaced ***)\\n#17 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/base.php(914): OC\\\\Route\\\\Router->match('\\\/s\\\/YINPvkz9ek0h...')\\n#18 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/index.php(54): OC::handleRequest()\\n#19 {main}\",\"File\":\"\\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractMySQLDriver.php\",\"Line\":125}"}
{"reqId":"Y@IbctGmHjA6XtI0A5p51AAAAA4","level":3,"time":"2023-02-07T09:35:46+00:00","remoteAddr":"2a01:cb19:8699:f200:d871:4721:c86f:aa5d","user":"--","app":"index","method":"GET","url":"\/index.php\/s\/YINPvkz9ek0hRg8\/download?path=%2F&files=","message":"Caused by: {\"Exception\":\"Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception\",\"Message\":\"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'user' cannot be null\",\"Code\":\"23000\",\"Trace\":\"#0 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php(119): Doctrine\\\\DBAL\\\\Driver\\\\PDO\\\\Exception::new(Object(PDOException))\\n#1 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1527): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#2 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement('INSERT INTO `oc...', Array, Array)\\n#3 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement('INSERT INTO `oc...', Array, Array)\\n#4 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/apps\\\/activity\\\/lib\\\/Data.php(126): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/apps\\\/activity\\\/lib\\\/Consumer.php(76): OCA\\\\Activity\\\\Data->send(Object(OC\\\\Activity\\\\Event))\\n#7 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/Activity\\\/Manager.php(195): OCA\\\\Activity\\\\Consumer->receive(Object(OC\\\\Activity\\\\Event))\\n#8 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/apps\\\/files_sharing\\\/lib\\\/Controllers\\\/ShareController.php(510): OC\\\\Activity\\\\Manager->publish(Object(OC\\\\Activity\\\\Event))\\n#9 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(170): OCA\\\\Files_Sharing\\\\Controllers\\\\ShareController->downloadShare('YINPvkz9ek0hRg8', '', '\\\/', '')\\n#10 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(89): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OCA\\\\Files_Sharing\\\\Controllers\\\\ShareController), 'downloadShare')\\n#11 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/AppFramework\\\/App.php(100): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OCA\\\\Files_Sharing\\\\Controllers\\\\ShareController), 'downloadShare')\\n#12 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/public\\\/AppFramework\\\/App.php(132): OC\\\\AppFramework\\\\App::main('ShareController', 'downloadShare', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer))\\n#13 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/core\\\/routes.php(142): OCP\\\\AppFramework\\\\App->dispatch('ShareController', 'downloadShare')\\n#14 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/Route\\\/Router.php(344): OC\\\\Route\\\\Router->{closure}(*** sensitive parameters replaced ***)\\n#15 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/base.php(914): OC\\\\Route\\\\Router->match('\\\/s\\\/YINPvkz9ek0h...')\\n#16 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/index.php(54): OC::handleRequest()\\n#17 {main}\",\"File\":\"\\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDO\\\/Exception.php\",\"Line\":18}"}
{"reqId":"Y@IbctGmHjA6XtI0A5p51AAAAA4","level":3,"time":"2023-02-07T09:35:46+00:00","remoteAddr":"2a01:cb19:8699:f200:d871:4721:c86f:aa5d","user":"--","app":"index","method":"GET","url":"\/index.php\/s\/YINPvkz9ek0hRg8\/download?path=%2F&files=","message":"Caused by: {\"Exception\":\"PDOException\",\"Message\":\"SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'user' cannot be null\",\"Code\":\"23000\",\"Trace\":\"#0 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php(117): PDOStatement->execute(NULL)\\n#1 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(1527): Doctrine\\\\DBAL\\\\Driver\\\\PDOStatement->execute()\\n#2 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/DB\\\/Connection.php(238): Doctrine\\\\DBAL\\\\Connection->executeStatement('INSERT INTO `oc...', Array, Array)\\n#3 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Query\\\/QueryBuilder.php(216): OC\\\\DB\\\\Connection->executeStatement('INSERT INTO `oc...', Array, Array)\\n#4 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/DB\\\/QueryBuilder\\\/QueryBuilder.php(142): Doctrine\\\\DBAL\\\\Query\\\\QueryBuilder->execute()\\n#5 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/apps\\\/activity\\\/lib\\\/Data.php(126): OC\\\\DB\\\\QueryBuilder\\\\QueryBuilder->execute()\\n#6 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/apps\\\/activity\\\/lib\\\/Consumer.php(76): OCA\\\\Activity\\\\Data->send(Object(OC\\\\Activity\\\\Event))\\n#7 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/Activity\\\/Manager.php(195): OCA\\\\Activity\\\\Consumer->receive(Object(OC\\\\Activity\\\\Event))\\n#8 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/apps\\\/files_sharing\\\/lib\\\/Controllers\\\/ShareController.php(510): OC\\\\Activity\\\\Manager->publish(Object(OC\\\\Activity\\\\Event))\\n#9 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(170): OCA\\\\Files_Sharing\\\\Controllers\\\\ShareController->downloadShare('YINPvkz9ek0hRg8', '', '\\\/', '')\\n#10 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/AppFramework\\\/Http\\\/Dispatcher.php(89): OC\\\\AppFramework\\\\Http\\\\Dispatcher->executeController(Object(OCA\\\\Files_Sharing\\\\Controllers\\\\ShareController), 'downloadShare')\\n#11 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/AppFramework\\\/App.php(100): OC\\\\AppFramework\\\\Http\\\\Dispatcher->dispatch(Object(OCA\\\\Files_Sharing\\\\Controllers\\\\ShareController), 'downloadShare')\\n#12 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/public\\\/AppFramework\\\/App.php(132): OC\\\\AppFramework\\\\App::main('ShareController', 'downloadShare', Object(OC\\\\AppFramework\\\\DependencyInjection\\\\DIContainer))\\n#13 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/core\\\/routes.php(142): OCP\\\\AppFramework\\\\App->dispatch('ShareController', 'downloadShare')\\n#14 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/private\\\/Route\\\/Router.php(344): OC\\\\Route\\\\Router->{closure}(*** sensitive parameters replaced ***)\\n#15 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/base.php(914): OC\\\\Route\\\\Router->match('\\\/s\\\/YINPvkz9ek0h...')\\n#16 \\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/index.php(54): OC::handleRequest()\\n#17 {main}\",\"File\":\"\\\/homepages\\\/9\\\/d579927651\\\/htdocs\\\/dms\\\/lib\\\/composer\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/PDOStatement.php\",\"Line\":117}"}

rkaussow · February 7, 2023, 12:10pm

I’ve edited your posts. Please use code blocks for better readability.

RaidJan · February 7, 2023, 12:53pm

Hello, thanks !
I was a bit lost at the end when I noticed I couldn’t paste more than 32000 characters, trying to cut correctly

jvillafanez · February 7, 2023, 5:22pm

Works for me, fresh install though.

Integrity constraint violation: 1048 Column 'user' cannot be null

I guess you’ll have to explain that. The “user” column should be nullable, it should have been there from the beginning, and there is no migration targeting that column as far as I know, so I don’t see any reason why the column could have changed to non-nullable or your system.

MariaDB [owncloud]> describe oc_activity;
+---------------+---------------+------+-----+---------+----------------+
| Field         | Type          | Null | Key | Default | Extra          |
+---------------+---------------+------+-----+---------+----------------+
| activity_id   | bigint(20)    | NO   | PRI | NULL    | auto_increment |
| timestamp     | int(11)       | NO   | MUL | 0       |                |
| priority      | int(11)       | NO   |     | 0       |                |
| type          | varchar(255)  | YES  |     | NULL    |                |
| user          | varchar(64)   | YES  |     | NULL    |                |
| affecteduser  | varchar(64)   | NO   | MUL | NULL    |                |
| app           | varchar(255)  | NO   |     | NULL    |                |
| subject       | varchar(255)  | NO   |     | NULL    |                |
| subjectparams | longtext      | NO   |     | NULL    |                |
| message       | varchar(255)  | YES  |     | NULL    |                |
| messageparams | longtext      | YES  |     | NULL    |                |
| file          | varchar(4000) | YES  |     | NULL    |                |
| link          | varchar(4000) | YES  |     | NULL    |                |
| object_type   | varchar(255)  | YES  | MUL | NULL    |                |
| object_id     | bigint(20)    | NO   |     | 0       |                |
+---------------+---------------+------+-----+---------+----------------+
15 rows in set (0.001 sec)

RaidJan · February 7, 2023, 10:24pm

Thanks for your reply, so I add the null option to this column and it’s works…

ALTER TABLE oc_activityCHANGEuser user VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NULL;

Honestly I didn’t change it don’t know what’s happen.

system · May 8, 2023, 10:25pm

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.