mail icon indicating copy to clipboard operation
mail copied to clipboard

Data too long for column 'inbound_user'

Open sergiupapuc opened this issue 1 year ago β€’ 7 comments

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

sergiupapuc avatar Aug 09 '24 09:08 sergiupapuc

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

ChristophWurst avatar Aug 09 '24 09:08 ChristophWurst

...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" } } ]

sergiupapuc avatar Aug 09 '24 09:08 sergiupapuc

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

ChristophWurst avatar Aug 09 '24 10:08 ChristophWurst

...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" } } ]

sergiupapuc avatar Aug 09 '24 10:08 sergiupapuc

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

ChristophWurst avatar Aug 09 '24 10:08 ChristophWurst

	    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 avatar Aug 09 '24 12:08 sergiupapuc

...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" } } ]

sergiupapuc avatar Aug 10 '24 07:08 sergiupapuc