Posted by wipeout_630 on August 7, 2012 at 9:48pm
4 followers
Jump to:
| Project: | Drupal core |
| Version: | 7.15 |
| Component: | mysql database |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (works as designed) |
| Issue tags: | bug fix |
Issue Summary
When copying number lists from Microsoft Word into Drupal's rich text editor I receive the error message below. The only work around I have found is to use the number list in the rich text editor. Using the "Copy from Word" feature does not resolve the problem either.
Error messagePDOException: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xE2\x80\x8BCli...' for column 'body_value' at row 1: INSERT INTO {field_data_body} (entity_type, entity_id, revision_id, bundle, delta, language, body_value, body_summary, body_format) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 265 [:db_insert_placeholder_2] => 312 [:db_insert_placeholder_3] => book [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => <p> </p> [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => filtered_html ) in field_sql_storage_field_storage_write() (line 448 of /var/www/html/42/modules/field/modules/field_sql_storage/field_sql_storage.module).
Comments
#1
This is not a core bug. Are you using the WYSIWYG module?
If the editor "copy from word" doesn't work, this is a bug in the library, not drupal or drupal's module.
#2
wipeout_630
A couple of things to try would be to cut and paste the numbered list from Word into notepad before copying and pasting into the rich editor. Or secondly instead of having the word doc as a doc or docx format try making the doc you are copying from an HTML formatted doc.
I have not tested this but only suggest it as a solution
#3
what's the step to reproduce this bug.
#4
I thought I would run a further test on this.
I copied and pasted a numbered list to a new page and everything was fine. I am using Drupa 7 with cck enabled and have the filed set to full HTML when I pasted it in. It was perfect. If there is a need for the version of Word I have, it is 2003 office on this box.
I do not have a stock D7.14 to work with so this is about as far as I can got helping diagnose the problem. Again what I have tested worked fine. Best of luck!
#5
I think the problem is with the CKEditor I have installed, judging by the comments here. I was using the CKEditor (3.6.3) module downloaded directly from Drupal. When I reverted to using Wysiwyg and then an older version of CKEditor (3.5.1) the SQL error disappeared. It's not as visually appealing as 3.6.3 but we can deal with that for now.
#6
#7