menatwork / syncCto

Contao Extension :: Synchronize multiple contao installations with each other
https://packagist.org/packages/menatwork/synccto
25 stars 14 forks source link

Sync database throws exception SQLSTATE[22001]: String data, right truncated #305

Open Enrica-r opened 3 years ago

Enrica-r commented 3 years ago

I use Contao 4.10.5

The database can't be synchronized because of following error (some part cutted)

An exception occurred while executing 'UPDATE tl_user SET session = ? WHERE id = ?' with params ["a:13:{s:21:\"CTOCOM_ConnectionPool\";a:1:{s:32:\"5483d34b8c3fdb1234c10d33940c11ec\";a:3:{s:2:\"id\";s:36:\"5e543e31-436f-11eb-87fe-e4434b959d74\";s:3:\"key\";s:32:\"35622364310302445438443788149776\";s:12:\"codifyengine\";N;}}s:22:\"syncCto_SyncSettings_3\";a:9:{s:9:\"post_data\";a:1:{s:14:\"database_check\";s:1:\"1\";}s:8:\"automode\";b:0;s:12:\"syncCto_Type\";a:0:{}s:20:\"syncCto_SyncDatabase\";b:1;s:19:\"syncCto_SyncTlFiles\";b:0;s:36:\"syncCto_Systemoperations_Maintenance\";a:0:{}s:21:\"syncCto_AttentionFlag\";b:0;s:17:\"syncCto_ShowError\";b:0;s:21:\"syncCto_CompareTables\";a:1:{s:11:\"recommended\";a:57:{s:10:\"categories\";a:7:{s:6:\"server\";a:4: .... cutted ..... onClick=\"openSyncCtoPopUp(); return false;\"\/>\n <\/div>\n <\/div>\n<\/form>\";}}s:5:\"abort\";b:0;}}", "2"]: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'session' at row 1

Tastaturberuf commented 2 years ago

This is your own database config. see https://stackoverflow.com/questions/15949038/error-code-1406-data-too-long-for-column-mysql