Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: link shared by email no longer works #48908

Closed
4 of 8 tasks
Azgar1998 opened this issue Oct 26, 2024 · 6 comments
Closed
4 of 8 tasks

[Bug]: link shared by email no longer works #48908

Azgar1998 opened this issue Oct 26, 2024 · 6 comments
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 30-feedback bug

Comments

@Azgar1998
Copy link

Azgar1998 commented Oct 26, 2024

⚠️ This issue respects the following points: ⚠️

Bug description

Hello,

Since I upgraded my nextcloud server, the links shared by email no longer work. the email settings are correct because when I click on the test send mail button, I receive the email. it's also the same problem for other email notifications (application update notification, etc.)

With previous versions I never encountered this bug

Do you know where this could come from?

Steps to reproduce

  1. Go to the folder you want to share in web interface
  2. In "share" tab, entrer l'adresse mail de la personne
  3. Once the person's email address select [email protected] (email)

the email should normally be received within the next few minutes at most

Expected behavior

that the person receives an email with the sharing link

Nextcloud Server version

30

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.3

Web server

Apache (supported)

Database engine version

MariaDB

Is this bug present after an update or on a fresh install?

Upgraded to a MAJOR version (ex. 28 to 29)

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

  • Default user-backend (database)
  • LDAP/ Active Directory
  • SSO - SAML
  • Other

Configuration report

{
"system": {
"instanceid": "REMOVED SENSITIVE VALUE",
"passwordsalt": "REMOVED SENSITIVE VALUE",
"secret": "REMOVED SENSITIVE VALUE",
"filelocking.enabled": true,
"memcache.locking": "\OC\Memcache\Redis",
"redis": {
"host": "REMOVED SENSITIVE VALUE",
"port": 6379,
"timeout": 0
},
"trusted_domains": [
"bijottierescloud.hopto.org",
"192.168.1.116",
"cloud.wikiemmanuel.org"
],
"datadirectory": "REMOVED SENSITIVE VALUE",
"dbtype": "mysql",
"version": "30.0.1.2",
"overwrite.cli.url": "https://cloud.com",
"dbname": "REMOVED SENSITIVE VALUE",
"dbhost": "REMOVED SENSITIVE VALUE",
"dbport": "",
"dbtableprefix": "oc_",
"mysql.utf8mb4": true,
"dbuser": "REMOVED SENSITIVE VALUE",
"dbpassword": "REMOVED SENSITIVE VALUE",
"installed": true,
"memcache.local": "\OC\Memcache\APCu",
"theme": "",
"loglevel": 0,
"maintenance": false,
"mail_smtpmode": "smtp",
"mail_sendmailmode": "smtp",
"mail_smtpauth": 1,
"mail_smtphost": "REMOVED SENSITIVE VALUE",
"mail_smtpport": "465",
"mail_smtpname": "REMOVED SENSITIVE VALUE",
"mail_smtppassword": "REMOVED SENSITIVE VALUE",
"mail_smtpsecure": "ssl",
"mail_smtpauthtype": "LOGIN",
"updater.release.channel": "stable",
"has_rebuilt_cache": true,
"default_phone_region": "FR",
"allow_local_remote_servers": true,
"trusted_proxies": "REMOVED SENSITIVE VALUE",
"forwarded_for_headers": [
"HTTP_X_FORWARDED_FOR"
],
"app_install_overwrite": [
"keeweb",
"social",
"documentserver_community",
"spreed",
"talk_simple_poll",
"hancomoffice",
"wopi",
"files_external_ethswarm",
"extract",
"files_archive",
"cfg_share_links",
"officeonline",
"news",
"video_converter"
],
"onlyoffice": {
"verify_peer_off": true,
"allow_local_remote_servers": true
},
"twofactor_enforced": "true",
"twofactor_enforced_groups": [
"TOTP_Authenticator"
],
"twofactor_enforced_excluded_groups": [
"admin"
],
"mail_from_address": "REMOVED SENSITIVE VALUE",
"mail_domain": "REMOVED SENSITIVE VALUE",
"maintenance_window_start": 1,
"bulkupload.enabled": false
}
}

List of activated Apps

Enabled:

  • activity: 3.0.0
  • admin_audit: 1.20.0
  • app_api: 4.0.0
  • audioplayer: 3.4.1
  • bruteforcesettings: 3.0.0
  • calendar: 5.0.1
  • cfg_share_links: 6.1.1
  • checksum: 1.2.5
  • circles: 30.0.0-dev
  • cloud_federation_api: 1.13.0
  • comments: 1.20.1
  • contacts: 6.1.0
  • contactsinteraction: 1.11.0
  • cospend: 2.0.0
  • dashboard: 7.10.0
  • dav: 1.31.1
  • documentserver_community: 0.1.18
  • drawio: 3.0.3
  • extract: 1.3.6
  • federatedfilesharing: 1.20.0
  • federation: 1.20.0
  • files: 2.2.0
  • files_antivirus: 5.6.0
  • files_archive: 1.2.3
  • files_downloadlimit: 3.0.0
  • files_external: 1.22.0
  • files_pdfviewer: 3.0.0
  • files_reminders: 1.3.0
  • files_sharing: 1.22.0
  • files_trashbin: 1.20.1
  • files_versions: 1.23.0
  • files_zip: 2.1.0
  • firstrunwizard: 3.0.0
  • forms: 4.3.2
  • gestion: 2.6.2
  • integration_google: 3.1.0
  • integration_slack: 1.2.0
  • keeweb: 0.6.20
  • logreader: 3.0.0
  • lookup_server_connector: 1.18.0
  • mail: 4.0.2
  • music: 2.0.1
  • news: 24.0.0
  • nextcloud_announcements: 2.0.0
  • notes: 4.11.0
  • notifications: 3.0.0
  • oauth2: 1.18.1
  • onlyoffice: 9.5.0
  • password_policy: 2.0.0
  • photos: 3.0.2
  • privacy: 2.0.0
  • provisioning_api: 1.20.0
  • quota_warning: 1.20.0
  • recommendations: 3.0.0
  • related_resources: 1.5.0
  • serverinfo: 2.0.0
  • settings: 1.13.0
  • sharebymail: 1.20.0
  • spreed: 20.0.1
  • support: 2.0.0
  • survey_client: 2.0.0
  • suspicious_login: 8.0.0
  • systemtags: 1.20.0
  • text: 4.1.0
  • theming: 2.5.0
  • twofactor_backupcodes: 1.19.0
  • twofactor_totp: 12.0.0-dev
  • updatenotification: 1.20.0
  • user_status: 1.10.0
  • viewer: 3.0.0
  • weather_status: 1.10.0
  • webhook_listeners: 1.1.0-dev
  • workflowengine: 2.12.0
    Disabled:
  • camerarawpreviews: 0.8.5 (installed 0.8.5)
  • electronicsignatures: 3.0.2 (installed 3.0.2)
  • encryption: 2.18.0 (installed 2.13.0)
  • files_mindmap: 0.0.30 (installed 0.0.30)
  • files_rightclick: 0.15.1 (installed 1.6.0)
  • passwords: 2024.9.20 (installed 2024.9.20)
  • ransomware_protection: 1.14.0 (installed 1.14.0)
  • richdocuments: 8.5.2 (installed 8.5.2)
  • richdocumentscode: 24.4.802 (installed 24.4.802)
  • transfer: 0.6.3 (installed 0.6.3)
  • twofactor_nextcloud_notification: 4.0.0
  • unsplash: 3.0.1 (installed 3.0.1)
  • user_ldap: 1.21.0 (installed 1.21.0)
  • video_converter: 1.0.6 (installed 1.0.6)

Nextcloud Signing status

No errors have been found

Nextcloud Logs

\Connection","type":"->"},{"file":"/var/www/cloud_name/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\DB\ConnectionAdapter","type":"->"},{"file":"/var/www/cloud_name/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":1031,"function":"execute","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php","line":927,"function":"getRows","class":"OCA\Circles\Tools\Db\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/circles/lib/Db/ShareWrapperRequestBuilder.php","line":100,"function":"asItems","class":"OCA\Circles\Tools\Db\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/circles/lib/Db/ShareWrapperRequest.php","line":321,"function":"getItemsFromRequest","class":"OCA\Circles\Db\ShareWrapperRequestBuilder","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/circles/lib/Service/ShareWrapperService.php","line":225,"function":"getSharedWith","class":"OCA\Circles\Db\ShareWrapperRequest","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/circles/lib/ShareByCircleProvider.php","line":539,"function":"getSharedWith","class":"OCA\Circles\Service\ShareWrapperService","type":"->"},{"file":"/var/www/cloud_name/htdocs/lib/private/Share20/Manager.php","line":1216,"function":"getSharedWith","class":"OCA\Circles\ShareByCircleProvider","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":102,"function":"getSharedWith","class":"OC\Share20\Manager","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":151,"function":"getShare","class":"OCA\DAV\Connector\Sabre\SharesPlugin","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":192,"function":"getShares","class":"OCA\DAV\Connector\Sabre\SharesPlugin","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/PropFind.php","line":95,"function":"OCA\DAV\Connector\Sabre\{closure}","class":"OCA\DAV\Connector\Sabre\SharesPlugin","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Connector/Sabre/SharesPlugin.php","line":191,"function":"handle","class":"Sabre\DAV\PropFind","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"handleGetProperties","class":"OCA\DAV\Connector\Sabre\SharesPlugin","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\DAV\CorePlugin","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\DAV\Connector\Sabre\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/remote.php","line":146,"args":["/var/www/cloud_name/htdocs/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/cloud_name/htdocs/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT r.id, r.share_type, r.share_with, r.uid_owner, r.uid_initiator, r.parent, r.item_type, r.item_source, r.item_target, r.file_source, r.file_target, r.permissions, r.attributes, r.stime, r.accepted, r.expiration, r.token, r.mail_send, r_b.unique_id AS r_b_unique_id, r_b.name AS r_b_name, r_b.display_name AS r_b_display_name, r_b.sanitized_name AS r_b_sanitized_name, r_b.source AS r_b_source, r_b.description AS r_b_description, r_b.settings AS r_b_settings, r_b.config AS r_b_config, r_b.contact_addressbook AS r_b_contact_addressbook, r_b.contact_groupname AS r_b_contact_groupname, r_b.creation AS r_b_creation, r_b_d.circle_id AS r_b_d_circle_id, r_b_d.member_id AS r_b_d_member_id, r_b_d.single_id AS r_b_d_single_id, r_b_d.user_id AS r_b_d_user_id, r_b_d.instance AS r_b_d_instance, r_b_d.user_type AS r_b_d_user_type, r_b_d.level AS r_b_d_level, r_b_d.status AS r_b_d_status, r_b_d.note AS r_b_d_note, r_b_d.contact_id AS r_b_d_contact_id, r_b_d.cached_name AS r_b_d_cached_name, r_b_d.cached_update AS r_b_d_cached_update, r_b_d.contact_meta AS r_b_d_contact_meta, r_b_d.joined AS r_b_d_joined, r_s.fileid AS r_s_fileid, r_s.path AS r_s_path, r_s.permissions AS r_s_permissions, r_s.storage AS r_s_storage, r_s.path_hash AS r_s_path_hash, r_s.parent AS r_s_parent, r_s.name AS r_s_name, r_s.mimetype AS r_s_mimetype, r_s.mimepart AS r_s_mimepart, r_s.size AS r_s_size, r_s.mtime AS r_s_mtime, r_s.storage_mtime AS r_s_storage_mtime, r_s.encrypted AS r_s_encrypted, r_s.unencrypted_size AS r_s_unencrypted_size, r_s.etag AS r_s_etag, r_s.checksum AS r_s_checksum, r_s_t.id AS r_s_t_id, r_r.id AS child_id, r_r.file_target AS child_file_target, r_r.permissions AS child_permissions FROM *PREFIX*share r LEFT JOIN *PREFIX*circles_circle r_b ON r_b.unique_id = r.share_with LEFT JOIN *PREFIX*filecache r_s ON r.file_source = r_s.fileid LEFT JOIN *PREFIX*circles_member r_b_d ON (r_b_d.circle_id = r_b.unique_id) AND (r_b_d.level = :dcValue2) LEFT JOIN *PREFIX*circles_membership r_j ON r_b.unique_id = r_j.circle_id LEFT JOIN *PREFIX*share r_r ON (r_r.parent = r.id) AND (r_r.share_with = r_j.single_id) LEFT JOIN *PREFIX*storages r_s_t ON r_s.storage = r_s_t.numeric_id WHERE (r.share_type = :dcValue1) AND (r_j.single_id = :dcValue3) AND (r.parent IS NULL) AND (r.file_source = :dcValue4)","tables":["oc_filecache"],"reads":["oc_share","oc_circles_circle","oc_filecache","oc_circles_member","oc_circles_membership","oc_share","oc_storages"],"exception":{},"CustomMessage":"dirty table reads: SELECT r.id, r.share_type, r.share_with, r.uid_owner, r.uid_initiator, r.parent, r.item_type, r.item_source, r.item_target, r.file_source, r.file_target, r.permissions, r.attributes, r.stime, r.accepted, r.expiration, r.token, r.mail_send, r_b.unique_id AS r_b_unique_id, r_b.name AS r_b_name, r_b.display_name AS r_b_display_name, r_b.sanitized_name AS r_b_sanitized_name, r_b.source AS r_b_source, r_b.description AS r_b_description, r_b.settings AS r_b_settings, r_b.config AS r_b_config, r_b.contact_addressbook AS r_b_contact_addressbook, r_b.contact_groupname AS r_b_contact_groupname, r_b.creation AS r_b_creation, r_b_d.circle_id AS r_b_d_circle_id, r_b_d.member_id AS r_b_d_member_id, r_b_d.single_id AS r_b_d_single_id, r_b_d.user_id AS r_b_d_user_id, r_b_d.instance AS r_b_d_instance, r_b_d.user_type AS r_b_d_user_type, r_b_d.level AS r_b_d_level, r_b_d.status AS r_b_d_status, r_b_d.note AS r_b_d_note, r_b_d.contact_id AS r_b_d_contact_id, r_b_d.cached_name AS r_b_d_cached_name, r_b_d.cached_update AS r_b_d_cached_update, r_b_d.contact_meta AS r_b_d_contact_meta, r_b_d.joined AS r_b_d_joined, r_s.fileid AS r_s_fileid, r_s.path AS r_s_path, r_s.permissions AS r_s_permissions, r_s.storage AS r_s_storage, r_s.path_hash AS r_s_path_hash, r_s.parent AS r_s_parent, r_s.name AS r_s_name, r_s.mimetype AS r_s_mimetype, r_s.mimepart AS r_s_mimepart, r_s.size AS r_s_size, r_s.mtime AS r_s_mtime, r_s.storage_mtime AS r_s_storage_mtime, r_s.encrypted AS r_s_encrypted, r_s.unencrypted_size AS r_s_unencrypted_size, r_s.etag AS r_s_etag, r_s.checksum AS r_s_checksum, r_s_t.id AS r_s_t_id, r_r.id AS child_id, r_r.file_target AS child_file_target, r_r.permissions AS child_permissions FROM *PREFIX*share r LEFT JOIN *PREFIX*circles_circle r_b ON r_b.unique_id = r.share_with LEFT JOIN *PREFIX*filecache r_s ON r.file_source = r_s.fileid LEFT JOIN *PREFIX*circles_member r_b_d ON (r_b_d.circle_id = r_b.unique_id) AND (r_b_d.level = :dcValue2) LEFT JOIN *PREFIX*circles_membership r_j ON r_b.unique_id = r_j.circle_id LEFT JOIN *PREFIX*share r_r ON (r_r.parent = r.id) AND (r_r.share_with = r_j.single_id) LEFT JOIN *PREFIX*storages r_s_t ON r_s.storage = r_s_t.numeric_id WHERE (r.share_type = :dcValue1) AND (r_j.single_id = :dcValue3) AND (r.parent IS NULL) AND (r.file_source = :dcValue4)"}}
{"reqId":"3tIVCc0qIFQZMN9uvMXC","level":0,"time":"2024-10-26T19:56:05+00:00","remoteAddr":"192.168.1.104","user":"user_name","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/user_name/commun/","message":"dirty table reads: SELECT name, p.propertypath, p.propertyname, p.propertyvalue, p.valuetype FROM *PREFIX*filecache f LEFT JOIN *PREFIX*properties p ON p.propertypath = CONCAT(:dcValue1, f.name) WHERE (parent = :dcValue2) AND (p.userid = :dcValue3)","userAgent":"Mozilla/5.0 (Windows) mirall/3.14.13.14-Win64 (build 20240927) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT name, p.propertypath, p.propertyname, p.propertyvalue, p.valuetype FROM *PREFIX*filecache f LEFT JOIN *PREFIX*properties p ON p.propertypath = CONCAT(:dcValue1, f.name) WHERE (parent = :dcValue2) AND (p.userid = :dcValue3)","Code":0,"Trace":[{"file":"/var/www/cloud_name/htdocs/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\DB\Connection","type":"->"},{"file":"/var/www/cloud_name/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\DB\ConnectionAdapter","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/DAV/CustomPropertiesBackend.php","line":377,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/DAV/CustomPropertiesBackend.php","line":241,"function":"cacheDirectory","class":"OCA\DAV\DAV\CustomPropertiesBackend","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/PropertyStorage/Plugin.php","line":84,"function":"propFind","class":"OCA\DAV\DAV\CustomPropertiesBackend","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"propFind","class":"Sabre\DAV\PropertyStorage\Plugin","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":1052,"function":"emit","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":984,"function":"getPropertiesByNode","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\DAV\CorePlugin","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\DAV\Connector\Sabre\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/remote.php","line":146,"args":["/var/www/cloud_name/htdocs/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/cloud_name/htdocs/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT name, p.propertypath, p.propertyname, p.propertyvalue, p.valuetype FROM *PREFIX*filecache f LEFT JOIN *PREFIX*properties p ON p.propertypath = CONCAT(:dcValue1, f.name) WHERE (parent = :dcValue2) AND (p.userid = :dcValue3)","tables":["oc_filecache"],"reads":["oc_filecache","oc_properties"],"exception":{},"CustomMessage":"dirty table reads: SELECT name, p.propertypath, p.propertyname, p.propertyvalue, p.valuetype FROM *PREFIX*filecache f LEFT JOIN *PREFIX*properties p ON p.propertypath = CONCAT(:dcValue1, f.name) WHERE (parent = :dcValue2) AND (p.userid = :dcValue3)"}}
{"reqId":"3tIVCc0qIFQZMN9uvMXC","level":0,"time":"2024-10-26T19:56:05+00:00","remoteAddr":"192.168.1.104","user":"user_name","app":"no app in context","method":"PROPFIND","url":"/remote.php/dav/files/user_name/commun/","message":"dirty table reads: SELECT filecache.fileid, storage, path, path_hash, filecache.parent, filecache.name, mimetype, mimepart, size, mtime, storage_mtime, encrypted, etag, filecache.permissions, checksum, unencrypted_size, metadata_etag, creation_time, upload_time, meta.json AS meta_json, meta.sync_token AS meta_sync_token FROM *PREFIX*filecache filecache LEFT JOIN *PREFIX*filecache_extended fe ON filecache.fileid = fe.fileid LEFT JOIN *PREFIX*files_metadata meta ON filecache.fileid = meta.file_id WHERE (filecache.parent = :dcValue1) AND (storage = :dcValue2) ORDER BY name ASC","userAgent":"Mozilla/5.0 (Windows) mirall/3.14.13.14-Win64 (build 20240927) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)","version":"30.0.1.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT filecache.fileid, storage, path, path_hash, filecache.parent, filecache.name, mimetype, mimepart, size, mtime, storage_mtime, encrypted, etag, filecache.permissions, checksum, unencrypted_size, metadata_etag, creation_time, upload_time, meta.json AS meta_json, meta.sync_token AS meta_sync_token FROM *PREFIX*filecache filecache LEFT JOIN *PREFIX*filecache_extended fe ON filecache.fileid = fe.fileid LEFT JOIN *PREFIX*files_metadata meta ON filecache.fileid = meta.file_id WHERE (filecache.parent = :dcValue1) AND (storage = :dcValue2) ORDER BY name ASC","Code":0,"Trace":[{"file":"/var/www/cloud_name/htdocs/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\DB\Connection","type":"->"},{"file":"/var/www/cloud_name/htdocs/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\DB\ConnectionAdapter","type":"->"},{"file":"/var/www/cloud_name/htdocs/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":285,"function":"executeQuery","class":"OC\DB\QueryBuilder\QueryBuilder","type":"->"},{"file":"/var/www/cloud_name/htdocs/lib/private/DB/QueryBuilder/ExtendedQueryBuilder.php","line":53,"function":"executeQuery","class":"OC\DB\QueryBuilder\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/cloud_name/htdocs/lib/private/Files/Cache/Cache.php","line":208,"function":"execute","class":"OC\DB\QueryBuilder\ExtendedQueryBuilder","type":"->"},{"file":"/var/www/cloud_name/htdocs/lib/private/Files/View.php","line":1439,"function":"getFolderContentsById","class":"OC\Files\Cache\Cache","type":"->"},{"file":"/var/www/cloud_name/htdocs/lib/private/Files/Node/Folder.php","line":81,"function":"getDirectoryContent","class":"OC\Files\View","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Connector/Sabre/Directory.php","line":223,"function":"getDirectoryListing","class":"OC\Files\Node\Folder","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Tree.php","line":218,"function":"getChildren","class":"OCA\DAV\Connector\Sabre\Directory","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":900,"function":"getChildren","class":"Sabre\DAV\Tree","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":982,"function":"generatePathNodes","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":1662,"function":"getPropertiesIteratorForPath","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":1647,"function":"writeMultiStatus","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/CorePlugin.php","line":346,"function":"generateMultiStatus","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/event/lib/WildcardEmitterTrait.php","line":89,"function":"httpPropFind","class":"Sabre\DAV\CorePlugin","type":"->"},{"file":"/var/www/cloud_name/htdocs/3rdparty/sabre/dav/lib/DAV/Server.php","line":472,"function":"emit","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Connector/Sabre/Server.php","line":43,"function":"invokeMethod","class":"Sabre\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/lib/Server.php","line":370,"function":"start","class":"OCA\DAV\Connector\Sabre\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/apps/dav/appinfo/v2/remote.php","line":19,"function":"exec","class":"OCA\DAV\Server","type":"->"},{"file":"/var/www/cloud_name/htdocs/remote.php","line":146,"args":["/var/www/cloud_name/htdocs/apps/dav/appinfo/v2/remote.php"],"function":"require_once"}],"File":"/var/www/cloud_name/htdocs/lib/private/DB/Connection.php","Line":402,"message":"dirty table reads: SELECT filecache.fileid, storage, path, path_hash, filecache.parent, filecache.name, mimetype, mimepart, size, mtime, storage_mtime, encrypted, etag, filecache.permissions, checksum, unencrypted_size, metadata_etag, creation_time, upload_time, meta.json AS meta_json, meta.sync_token AS meta_sync_token FROM *PREFIX*filecache filecache LEFT JOIN *PREFIX*filecache_extended fe ON filecache.fileid = fe.fileid LEFT JOIN *PREFIX*files_metadata meta ON filecache.fileid = meta.file_id WHERE (filecache.parent = :dcValue1) AND (storage = :dcValue2) ORDER BY name ASC","tables":["oc_filecache"],"reads":["oc_filecache","oc_filecache_extended","oc_files_metadata"],"exception":{},"CustomMessage":"dirty table reads: SELECT filecache.fileid, storage, path, path_hash, filecache.parent, filecache.name, mimetype, mimepart, size, mtime, storage_mtime, encrypted, etag, filecache.permissions, checksum, unencrypted_size, metadata_etag, creation_time, upload_time, meta.json AS meta_json, meta.sync_token AS meta_sync_token FROM *PREFIX*filecache filecache LEFT JOIN *PREFIX*filecache_extended fe ON filecache.fileid = fe.fileid LEFT JOIN *PREFIX*files_metadata meta ON filecache.fileid = meta.file_id WHERE (filecache.parent = :dcValue1) AND (storage = :dcValue2) ORDER BY name ASC"}}

Additional info

No response

@Azgar1998 Azgar1998 added 0. Needs triage Pending check for reproducibility or if it fits our roadmap bug labels Oct 26, 2024
@adminelix
Copy link

I have the same issue with 30.0.1. before I updated to this version it was working well and the test email is still working.
the issue effects also the calender invites. they are no longer sent.

unfortunalty I was not able to find any relevant logs.

@kluchoslaw
Copy link

kluchoslaw commented Oct 28, 2024

Is there any fix/workaround? I experience the same problem on 30.0.1.
SMTP test is OK but no mail activity after share by email. :(
@Azgar1998 maybe you can change the title of the ticket? now it suggests that link is not working but actually there is no notification email at all when sharing.

@labor4
Copy link
Contributor

labor4 commented Oct 28, 2024

i'm adding to this (30.0.1):

The base notification doesn't work. But:
If I re-edit the link, and add a note, confirming, it will be sent.
If I re-edit the link, and add a password, confirming, it will be sent.

The desktop client (Macos Intel, v 3.14.1) suffers from the same trigger problem, plus more, described below.

Reported in the desktop repo: nextcloud/desktop#7427
What is an additional problem with the client is that the moment, after which these Emails go out, cannot be chosen.
Everything happens at once. (Bad especially in the case of the default note).

@Azgar1998
Copy link
Author

Azgar1998 commented Oct 29, 2024

Hello,

I confirm what you say @labor4

For my part, I did some tests again:

When I create the share, then add a note: it doesn't work

When I create the share, then add a note then a password: it does not work

When I create a share, then I edit this share to add a note: it works

When I create a share, then I edit this share to add a note and a password: it works

In normal operation, the email must be sent in all cases (with or without a note, without having to edit the share to add a note,...).

I tried with the nextcloud desktop client, nextcloud android, and directly on the web interface: same result

This is a bug in version 30. Is there a fix available or a fix on the next version?

@adminelix
Copy link

I can also confirm what you both wrote @labor4 and @Azgar1998.
my workaround would be to add a note atfter creation of a share that the link is sent and than change the password that the password will be sent. my server has a mandatory password config.
so nextcloud is sending separate mails with link and password so you need separate triggers also.

regarding to my issue of missing calender invataiton mails: it was my fault. org.fossify.calender android app is not able to tell nextcloud to send invitation mails. I switched back to etar and it's working again. from web app it's working also.

@skjnldsv
Copy link
Member

duplicate of #48012

@skjnldsv skjnldsv closed this as not planned Won't fix, can't repro, duplicate, stale Oct 29, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
0. Needs triage Pending check for reproducibility or if it fits our roadmap 30-feedback bug
Projects
None yet
Development

No branches or pull requests

6 participants