search

nextcloud / mail

💌 Mail app for Nextcloud
https://apps.nextcloud.com/apps/mail
GNU Affero General Public License v3.0
843 stars 260 forks source link

Data too long for column 'inbound_user' #9978

Open sergiupapuc opened 2 months ago

sergiupapuc commented 2 months ago

Steps to reproduce

1./settings/admin/groupware 2.make settings for mail settings 3.Provision all accounts

Expected behavior

not error...Provision all accounts

Actual behavior

Error 

{
  "reqId": "pc4ivehLDm3ekB9nadz8",
  "level": 3,
  "time": "2024-08-09T09:03:25+00:00",
  "remoteAddr": "192.168.64.22",
  "user": "015D1767-5A9A-415C-ABA1-E4A3CD2183D7",
  "app": "index",
  "method": "PUT",
  "url": "/index.php/apps/mail/api/settings/provisioning/all",
  "message": "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'inbound_user' at row 1",
  "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0",
  "version": "29.0.4.1",
  "exception": {
    "Exception": "OC\\DB\\Exceptions\\DbalException",
    "Message": "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'inbound_user' at row 1",
    "Code": 1406,
    "Trace": [
      {
        "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
        "line": 328,
        "function": "wrap",
        "class": "OC\\DB\\Exceptions\\DbalException",
        "type": "::"
      },
      {
        "file": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
        "line": 137,
        "function": "executeStatement",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
        "line": 220,
        "function": "insert",
        "class": "OCP\\AppFramework\\Db\\QBMapper",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
        "line": 120,
        "function": "provisionSingleUser",
        "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/private/User/Manager.php",
        "line": 561,
        "function": "OCA\\Mail\\Service\\Provisioning\\{closure}",
        "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
        "type": "->",
        "args": [
          "*** sensitive parameters replaced ***"
        ]
      },
      {
        "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
        "line": 123,
        "function": "callForAllUsers",
        "class": "OC\\User\\Manager",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/apps/mail/lib/Controller/SettingsController.php",
        "line": 70,
        "function": "provision",
        "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 232,
        "function": "provision",
        "class": "OCA\\Mail\\Controller\\SettingsController",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
        "line": 138,
        "function": "executeController",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
        "line": 184,
        "function": "dispatch",
        "class": "OC\\AppFramework\\Http\\Dispatcher",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/private/Route/Router.php",
        "line": 338,
        "function": "main",
        "class": "OC\\AppFramework\\App",
        "type": "::"
      },
      {
        "file": "/var/www/nextcloud/lib/base.php",
        "line": 1050,
        "function": "match",
        "class": "OC\\Route\\Router",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/index.php",
        "line": 49,
        "function": "handleRequest",
        "class": "OC",
        "type": "::"
      }
    ],
    "File": "/var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php",
    "Line": 71,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Exception\\DriverException",
      "Message": "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'inbound_user' at row 1",
      "Code": 1406,
      "Trace": [
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1943,
          "function": "convert",
          "class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1885,
          "function": "handleDriverException",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1213,
          "function": "convertExceptionDuringQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php",
          "line": 292,
          "function": "executeStatement",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
          "line": 373,
          "function": "executeStatement",
          "class": "Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
          "line": 393,
          "function": "executeStatement",
          "class": "OC\\DB\\Connection",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
          "line": 280,
          "function": "execute",
          "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
          "line": 326,
          "function": "execute",
          "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
          "line": 137,
          "function": "executeStatement",
          "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
          "line": 220,
          "function": "insert",
          "class": "OCP\\AppFramework\\Db\\QBMapper",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
          "line": 120,
          "function": "provisionSingleUser",
          "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/User/Manager.php",
          "line": 561,
          "function": "OCA\\Mail\\Service\\Provisioning\\{closure}",
          "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
          "type": "->",
          "args": [
            "*** sensitive parameters replaced ***"
          ]
        },
        {
          "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
          "line": 123,
          "function": "callForAllUsers",
          "class": "OC\\User\\Manager",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/apps/mail/lib/Controller/SettingsController.php",
          "line": 70,
          "function": "provision",
          "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
          "line": 232,
          "function": "provision",
          "class": "OCA\\Mail\\Controller\\SettingsController",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
          "line": 138,
          "function": "executeController",
          "class": "OC\\AppFramework\\Http\\Dispatcher",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
          "line": 184,
          "function": "dispatch",
          "class": "OC\\AppFramework\\Http\\Dispatcher",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/Route/Router.php",
          "line": 338,
          "function": "main",
          "class": "OC\\AppFramework\\App",
          "type": "::"
        },
        {
          "file": "/var/www/nextcloud/lib/base.php",
          "line": 1050,
          "function": "match",
          "class": "OC\\Route\\Router",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/index.php",
          "line": 49,
          "function": "handleRequest",
          "class": "OC",
          "type": "::"
        }
      ],
      "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
      "Line": 117,
      "Previous": {
        "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
        "Message": "SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'inbound_user' at row 1",
        "Code": 1406,
        "Trace": [
          {
            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
            "line": 132,
            "function": "new",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
            "type": "::"
          },
          {
            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1207,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php",
            "line": 292,
            "function": "executeStatement",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
            "line": 373,
            "function": "executeStatement",
            "class": "Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
            "line": 393,
            "function": "executeStatement",
            "class": "OC\\DB\\Connection",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
            "line": 280,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
            "line": 326,
            "function": "execute",
            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
            "line": 137,
            "function": "executeStatement",
            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
            "line": 220,
            "function": "insert",
            "class": "OCP\\AppFramework\\Db\\QBMapper",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
            "line": 120,
            "function": "provisionSingleUser",
            "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/User/Manager.php",
            "line": 561,
            "function": "OCA\\Mail\\Service\\Provisioning\\{closure}",
            "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
            "type": "->",
            "args": [
              "*** sensitive parameters replaced ***"
            ]
          },
          {
            "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
            "line": 123,
            "function": "callForAllUsers",
            "class": "OC\\User\\Manager",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/apps/mail/lib/Controller/SettingsController.php",
            "line": 70,
            "function": "provision",
            "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
            "line": 232,
            "function": "provision",
            "class": "OCA\\Mail\\Controller\\SettingsController",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
            "line": 138,
            "function": "executeController",
            "class": "OC\\AppFramework\\Http\\Dispatcher",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
            "line": 184,
            "function": "dispatch",
            "class": "OC\\AppFramework\\Http\\Dispatcher",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/lib/private/Route/Router.php",
            "line": 338,
            "function": "main",
            "class": "OC\\AppFramework\\App",
            "type": "::"
          },
          {
            "file": "/var/www/nextcloud/lib/base.php",
            "line": 1050,
            "function": "match",
            "class": "OC\\Route\\Router",
            "type": "->"
          },
          {
            "file": "/var/www/nextcloud/index.php",
            "line": 49,
            "function": "handleRequest",
            "class": "OC",
            "type": "::"
          }
        ],
        "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
        "Line": 28,
        "Previous": {
          "Exception": "PDOException",
          "Message": "SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'inbound_user' at row 1",
          "Code": "22001",
          "Trace": [
            {
              "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
              "line": 130,
              "function": "execute",
              "class": "PDOStatement",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
              "line": 1207,
              "function": "execute",
              "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php",
              "line": 292,
              "function": "executeStatement",
              "class": "Doctrine\\DBAL\\Connection",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/DB/Connection.php",
              "line": 373,
              "function": "executeStatement",
              "class": "Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
              "line": 393,
              "function": "executeStatement",
              "class": "OC\\DB\\Connection",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
              "line": 280,
              "function": "execute",
              "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php",
              "line": 326,
              "function": "execute",
              "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
              "line": 137,
              "function": "executeStatement",
              "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
              "line": 220,
              "function": "insert",
              "class": "OCP\\AppFramework\\Db\\QBMapper",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
              "line": 120,
              "function": "provisionSingleUser",
              "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/User/Manager.php",
              "line": 561,
              "function": "OCA\\Mail\\Service\\Provisioning\\{closure}",
              "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
              "type": "->",
              "args": [
                "*** sensitive parameters replaced ***"
              ]
            },
            {
              "file": "/var/www/nextcloud/apps/mail/lib/Service/Provisioning/Manager.php",
              "line": 123,
              "function": "callForAllUsers",
              "class": "OC\\User\\Manager",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/apps/mail/lib/Controller/SettingsController.php",
              "line": 70,
              "function": "provision",
              "class": "OCA\\Mail\\Service\\Provisioning\\Manager",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
              "line": 232,
              "function": "provision",
              "class": "OCA\\Mail\\Controller\\SettingsController",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
              "line": 138,
              "function": "executeController",
              "class": "OC\\AppFramework\\Http\\Dispatcher",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
              "line": 184,
              "function": "dispatch",
              "class": "OC\\AppFramework\\Http\\Dispatcher",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/lib/private/Route/Router.php",
              "line": 338,
              "function": "main",
              "class": "OC\\AppFramework\\App",
              "type": "::"
            },
            {
              "file": "/var/www/nextcloud/lib/base.php",
              "line": 1050,
              "function": "match",
              "class": "OC\\Route\\Router",
              "type": "->"
            },
            {
              "file": "/var/www/nextcloud/index.php",
              "line": 49,
              "function": "handleRequest",
              "class": "OC",
              "type": "::"
            }
          ],
          "File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
          "Line": 130
        }
      }
    },
    "message": "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'inbound_user' at row 1",
    "exception": [],
    "CustomMessage": "An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'inbound_user' at row 1"
  },
  "id": "66b5dca84d2f0"
}

Mail app version

3.7.6

Mailserver or service

IMAP (DOVECOT)

Operating system

UBUNTU 22.04

PHP engine version

PHP 8.1

Web server

Apache (supported)

Database

MariaDB

Additional info

No response

ChristophWurst commented 2 months ago

Do you have access to the SQL error log of your database?

sergiupapuc commented 2 months ago

...no...but the table oc_mail_accounts was not filled with the corresponding data (host,etc) only partial...

From: Christoph Wurst @.> Sent: vineri, 9 august 2024 12:24 To: nextcloud/mail @.> Cc: Sergiu Papuc @.>; Author @.> Subject: Re: [nextcloud/mail] Data too long for column 'inbound_user' (Issue #9978)

Do you have access to the SQL error log of your database?

— Reply to this email directly, view it on GitHubhttps://github.com/nextcloud/mail/issues/9978#issuecomment-2277530017, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AZA3VMS42HWRTBG3FSNPYF3ZQSDCFAVCNFSM6AAAAABMICN2HSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENZXGUZTAMBRG4. You are receiving this because you authored the thread.Message ID: <nextcloud/mail/issues/9978/2277 @.**@.>> [ { @.": "http://schema.org", @.": "EmailMessage", "potentialAction": { @.": "ViewAction", "target": "https://github.com/nextcloud/mail/issues/9978#issuecomment-2277530017", "url": "https://github.com/nextcloud/mail/issues/9978#issuecomment-2277530017", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { @.": "Organization", "name": "GitHub", "url": "https://github.com" } } ]

ChristophWurst commented 2 months ago

Try to get access to it, it helps narrowing down the problem.

sergiupapuc commented 2 months ago

...attached

From: Christoph Wurst @.> Sent: vineri, 9 august 2024 13:04 To: nextcloud/mail @.> Cc: Sergiu Papuc @.>; Author @.> Subject: Re: [nextcloud/mail] Data too long for column 'inbound_user' (Issue #9978)

Try to get access to it, it helps narrowing down the problem.

— Reply to this email directly, view it on GitHubhttps://github.com/nextcloud/mail/issues/9978#issuecomment-2277599866, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AZA3VMXG5RHMQP7JQAQJFDLZQSHXRAVCNFSM6AAAAABMICN2HSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENZXGU4TSOBWGY. You are receiving this because you authored the thread.Message ID: <nextcloud/mail/issues/9978/2277 @.**@.>> [ { @.": "http://schema.org", @.": "EmailMessage", "potentialAction": { @.": "ViewAction", "target": "https://github.com/nextcloud/mail/issues/9978#issuecomment-2277599866", "url": "https://github.com/nextcloud/mail/issues/9978#issuecomment-2277599866", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { @.": "Organization", "name": "GitHub", "url": "https://github.com" } } ]

ChristophWurst commented 2 months ago

GitHub doesn't have attachments. Please post the raw SQL

sergiupapuc commented 2 months ago 
        53 Query    SELECT * FROM `oc_mail_accounts` WHERE (`user_id` = '619EDB81-DB08-4E6B-AA7F-C032C532E82F') AND (`provisioning_id` IS NOT NULL)
        53 Query    SELECT `aliases`.*, `accounts`.`provisioning_id` FROM `oc_mail_aliases` `aliases` INNER JOIN `oc_mail_accounts` `accounts` ON `aliases`.`account_id` = `accounts`.`id` WHERE (`accounts`.`user_id` = '619EDB81-DB08-4E6B-AA7F-C032C532E82F') AND (`aliases`.`account_id` = '1179')
        53 Query    SELECT `appid`, `configkey`, `configvalue` FROM `oc_preferences` WHERE `userid` = '2AC41782-DD2C-4930-AB61-8A74F3C719C2'
        53 Query    SELECT `ldap_dn`
        FROM `oc_ldap_user_mapping`
        WHERE `owncloud_name` = '2AC41782-DD2C-4930-AB61-8A74F3C719C2'
        53 Query    SELECT * FROM `oc_mail_accounts` WHERE (`user_id` = '2AC41782-DD2C-4930-AB61-8A74F3C719C2') AND (`provisioning_id` IS NOT NULL)
        53 Query    INSERT INTO `oc_mail_accounts` (`user_id`, `provisioning_id`, `email`, `name`, `inbound_user`, `inbound_host`, `inbound_port`, `inbound_ssl_mode`, `outbound_user`, `outbound_host`, `outbound_port`, `outbound_ssl_mode`) VALUES('2AC41782-DD2C-4930-AB61-8A74F3C719C2', 3, 'discoverysearchmailbox{d919ba05-46a6-415f-80ad-7e09334bb852}@senat.ro', 'Discovery Search Mailbox', 'discoverysearchmailbox{d919ba05-46a6-415f-80ad-7e09334bb852}@senat.ro', 'mailsenat.senat.ro', 993, 'ssl', 'discoverysearchmailbox{d919ba05-46a6-415f-80ad-7e09334bb852}@senat.ro', 'mailsenat.senat.ro', 465, 'ssl')
        53 Quit
sergiupapuc commented 2 months ago

...increased from varchar(64) to varchar(255) all „*_user” in table...now working...

From: Christoph Wurst @.> Sent: vineri, 9 august 2024 13:53 To: nextcloud/mail @.> Cc: Sergiu Papuc @.>; Author @.> Subject: Re: [nextcloud/mail] Data too long for column 'inbound_user' (Issue #9978)

GitHub doesn't have attachments. Please post the raw SQL

— Reply to this email directly, view it on GitHubhttps://github.com/nextcloud/mail/issues/9978#issuecomment-2277681609, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AZA3VMQNJUDDWQGP6FA3FMLZQSNO7AVCNFSM6AAAAABMICN2HSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENZXGY4DCNRQHE. You are receiving this because you authored the thread.Message ID: <nextcloud/mail/issues/9978/2277 @.**@.>> [ { @.": "http://schema.org", @.": "EmailMessage", "potentialAction": { @.": "ViewAction", "target": "https://github.com/nextcloud/mail/issues/9978#issuecomment-2277681609", "url": "https://github.com/nextcloud/mail/issues/9978#issuecomment-2277681609", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { @.": "Organization", "name": "GitHub", "url": "https://github.com" } } ]