Linea21

Echec de la requête SQL<br />[<em> error n° 1406 : Data too long for column 'workcom_body' at row 1</em> ]<br />

SQL query : INSERT INTO l21_workshop_com (workcom_subject, workcom_body, workcom_parent, workcom_user_id, workcom_workshop_id, workcom_statut, workcom_date_crea, workcom_last_modify ) VALUES('Atelier énergie \"Tu Perds Watts\" - lundi 3 juillet à 18h - Ile d\'Or - Pôle jeunesse Schwartz', '<p>Bonjour,<br />\r\nAu vu du nombre d\'inscriptions, l\'atelier \"Tu Perds Watts\" aura lieu le <u>lundi 3 juillet à 18h, au Pôle Jeunesse Bertrand Schwartz</u> situé dans l\'Ile d\'Or à Amboise.<br />\r\nNotez qu\'il est toujours possible d\'inviter vos voisins, amis, collègues dans la limite de 15 participants.</p>\r\n\r\n<p><span style=\"color: rgb(31, 73, 125); font-family: &quot;Calibri Light&quot;,&quot;sans-serif&quot;; font-size: 11pt;\"><a href=\"http://doodle.com/poll/pf9w9srdh7t227dy\" id=\"LPlnk984058\" target=\"_blank\"><font color=\"#0066cc\">http://doodle.com/poll/pf9w9srdh7t227dy</font></a></span></p>\r\n\r\n<p>N\'hésitez pas à ajouter (dans les commentaires du Doodle) les thématiques que vous souhaitez aborder : rénovation énergétique, systèmes de ventilation, éco-gestes au bureau, consommation énergétique d\'internet et des appareils électroménagers, énergie solaire, équipements permettant des économies d\'énergie...</p>\r\n\r\n<p>A bientôt,<br />\r\nCéline</p>\r\n\r\n<p><span style=\"font-family: &quot;Times New Roman&quot;; font-size: 12pt; mso-fareast-font-family: &quot;Times New Roman&quot;; mso-ansi-language: FR; mso-fareast-language: FR; mso-bidi-language: AR-SA;\"><img height=\"771\" src=\"data:image/png;base64,R0lGODdhHwIDA3cAACH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACwAAAAAHwIDA4f///8Ac8UhOowAe8Wczjrm7+/39//v9/8AhMWlxeZrrc61xe+cveYpjMXF3vcQhM7W5u/3//+11u/Fzu9SnNbe5u8AY6WErd4AhM7v9+8hjM6Mrd7v5u+thFpzrd739+8AWqXO1tbW1uaMreYxlMWMvealezopc71CjNYQGSkpGRCthEql1jG9jErm7/8Ae729paUAY7WlzuYQOoy9nFqElKXmxbXOnGPe7+86WqUpQpTWtWu9jFpSjMWlzil7Y1Lm1s4hIULFnHulc0re1tbOnHOEWiljUjoQEBlzpdbWrYRae60hISmttdZjWlLm5tZrrWve5ualhHtKWoSEhHOMYzoAc60QMYQ6UpTF3uYAAAjWWjHeraUpMVK9jHN7e7WlpaVSUlJChMWcrc5ae5RClMVzKUKEvUq11iEhMTrOta17c1Jze3M6OjFKzt5ardZrpdbOxb06SmN7nMUQjM69hDGlxe/eWlJSOhkZjKVKQjp7xWMxlJzvziHOrZTe1ubmhGu9xdatKSGtWinmIRl7hJQQY7ValJxzvd69tTE6UnulWlJKlHMhQlopc61rUhkZzqWle5xjY6WleyneIWPm5u+tvWuErc6Mzt735ntrQhnevTG1xb0IKdYpKYQ6Y717jMV7hCmtIWPv5v/erSGtKaXWc6UIxd7eKaW1nHtzWoTWrdYZQoRCjCEQjCF73imte9bF5u8ZlGspQnvec9ZSGRAQGUKEvda1KeZztaVKQkpKKULmc0papdZzjN46OiFSKYQ6OlLv5jEAc84Q1iFC3iHFzuaEKYTmKeYZQhlC3mNzIeYQ3mNzIbV7GRCcvUIIhMU6KbVr5qXmeykIOpy17ykIGXtzWt46IebenHveUhm974QIjMUAe861xeaczkLe5tZCnNZ7rRm178XWnFoAY87FpRkpe8WctRnO7/9zrc6tzjoQY6VShOYZWqW11ual1hnm9+/W7+8IjOacreb/7/8Ie8UQhOZrrd5anO+c1kKcvff35v8Qc8UhOnMhOpQI/wBfvBgmkODAgggPKjTIMGHDhQ4jQpz4sKJEixQvaszIEaPHjR87ghwpsmTIkyRRmkzJcqVLlTBbxnwpsybNmx4NChQYY6fPFz1/8hQ6lGhQoUd/JvW5dGfTokiJApX6dKpRqlivao26VWlWrmC9dmX6VWxYsmOdlkV7Vm1aqGbjspXrti3cuXjr0r2rNy/fv1btBqbbc1jhgoUPD0y8kDFDx4gXN5b8mHJkw5MxV9Z8WbFmz5Apg7YsOvNozqU3n15turVq151hp479ujbt27Nzf5a927bu0L1xB/9Nerhx4MiLJ0d9XLlz5qHLJVQIVKfOGNadZue5vfrO692xf//XPp57ee/TxacPz/68eurvwbtvv36+/fr44dPXf59/fvn/kRegeQOi59+BACIooIIEMmhgghAuGGGDEz4o4YUUYmhhhlJJ55NOP4H4oVQinhciiSgSVeJ0J6qYolArUtcijC/OaOOILuZIo443mojjjkD2yOKPQspI5JE+JjmkkkYyGeOTNSK55JRNUgklj1JWqWWJqKn33gvSifdemCCSaaCZO5k5poFgerfml2rqhKZAcabJZp103ummnHqKySece9oJqJ+ClhlonoMS9KahhCLKqKJ/Pnpmn5AW6hOebSY6qaaLXnpoppJ2aqmojm4aaqSeNgpqqpWWOiqqr1r/KutE1GGGo63fHdXddLg6tBSuu9b6a2Qf6uqjdcNKVux5IiLbYq/K1jojtJUty+u0yVJr7JDO3vrrtkZ2W562zGL77Lfl/kgtsbmmy2y26F6rLrwhgttsu97W6y6v9Frb5FPqPXQrk18GvKTAMRaM0cBUKiwRw1o6TOu4BINocJMIU2XxwhQ3vPHDHUf88cQPJzyywCGbzBTHJWu8MsgtG3XywfIiNTPGNSt1M5c5t3nQZvpGaxWwywXda1BEP2d0UkjrWrS1R7PbXLNNo5U0dOFW7dbVpy1ttdNKQ8201E/jG3W0U3u9NdhYU83u0Gx3LfbX7batdlFcZ3Y33HXL/2022IExhrbMLhIEoqJUvkyj4SMiLZXiJzI+nuOPNzii5AhRXvmX42F+kOaPc46Q54hrCfnlMpYe4+mdpz505Za3fvjrsIv+s+ugu7w47okviPrsuRO+O/C9xz4676b7biLj96Z3WdCDAbusrajhGz24pZFmfVLS9/28v9xjv5v27Ia/vODVl+/v4egrtv3601ftNlzdx0Z+tOazOH76+MPv/f24yl/q2pc1vdQve/wLoP/sl8CjCJB9yuJfBKsitKFgziDxuR33IJcxCzFugxjaTgY 

[...]

<p>&nbsp;</p>
&rub=ajout-discussion&id=10&confirm=true&valider=valider<br />

Regarder si la dernière version de ckeditor ne prévient pas déjà ça !
See :

• http://www.isummation.com/blog/block-drag-drop-image-or-direct-image-paste-into-ckeditor-using-firefox/
• https://stackoverflow.com/questions/6582559/ckeditor-preventing-users-from-pasting-images
• http://camerongregor.com/2016/11/14/preventing-pasting-of-images-in-ckeditor/
• http://www.keyvan.net/2012/11/clean-up-html-on-paste-in-ckeditor/