Check for existence of invalid characters when importing
mdlueck - January 8, 2008 - 16:52
| Project: | Wordpress Import |
| Version: | 5.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | yrocq |
| Status: | active |
Jump to:
Description
The import seems to have worked other than one error as follows:
user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' query: SELECT COUNT(cid) FROM comments WHERE pid = 0 AND nid = 1323 AND subject = 'THE MIND OF THE LONG\n\nTHE' AND comment = '<strong>THE MIND OF THE LONG</strong>\n\nTHE MIND OF THE LONG WINTERS HAS A LIFE OF ITS VERY OWNVUE Weekly, Canada -7 hours agoâThe guitar in the' in /homepages/26/d222149051/htdocs/sites/christians-in-recovery.org/www/includes/database.mysqli.inc on line 151.
Any clues? I do not see "swedish" anywhere in the export/import file (WXR). Likewise for your module.
#1
It looks like a mySQL problem. In which context this error occured exactly ?
#2
It appeared to be some bogus comment made to a blog posting. Possibly the user who posted the comment copy/pasted the quote character from a GUI word processor, thus the fancy quote character.
It happened at the end of the import process. The box just above the pink error box showed the Taxonomy creations, etc... then this pink error, and below it a note of success.
The export had been done by the module for WordPress I asked about in my other posting... finally had success with that after I upgraded the server to the latest WordPress code.
I foresee keeping WordPress for a little while yet... Drupal just does not seem as robust of a Blogging platform compared to WordPress.
#3
#4
#5
Different collations are not compatible for mysql databases tables. More, before you try to import latin1 data into utf8 website you must use iconv (on GNU) to convert charset.