Project

General

Profile

Actions

Anomalie #712

closed

prevent bug when copy / paste form Word with images

Added by Simon about 5 years ago. Updated almost 5 years ago.

Status:
Fermé
Priority:
Normal
Assignee:
Category:
general
Target version:
Start date:
06/21/2017
Due date:
% Done:

100%

Estimated time:
4.00 h
Resolution:

Description


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 :


Related issues

Related to Evolution #793: ckeditor : save images when copy-paste from wordFerméSimon10/21/2017

Actions
Actions #1

Updated by Simon about 5 years ago

https://stackoverflow.com/questions/2569838/mysql-data-type-text-erroring-data-too-long


    TEXT[(M)] [CHARACTER SET charset_name] [COLLATE collation_name]

    A TEXT column with a maximum length of 65,535 (2^16 – 1) characters.

    The effective maximum length is less if the value contains multi-byte characters. Each TEXT value is stored using a two-byte length prefix that indicates the number of bytes in the value.

    An optional length M can be given for this type. If this is done, MySQL creates the column as the smallest TEXT type large enough to hold values M characters long.

source : http://dev.mysql.com/doc/refman/5.1/en/string-type-overview.html

Actions #4

Updated by Simon almost 5 years ago

  • Related to Evolution #793: ckeditor : save images when copy-paste from word added
Actions #6

Updated by Simon almost 5 years ago

  • Status changed from Nouveau to Fermé
  • % Done changed from 0 to 100

Applied in changeset linea21|r3285.

Actions

Also available in: Atom PDF