Entities HTML causes problems in WXR Import !

[momo360modena]

I have a problem with importer.

If categories have entites HTML, as "&" or "&" in name
During importing, Importer create "a zillion duplicate categories"

Because, in importer you clean title with

$categories[$cat_index] = $wpdb->escape($this->unhtmlentities(str_replace(array ('<![CDATA[', ']]>'), '', $category)));

And after the query return false...

Example : In DB you have
Category NAME : 'Toto & Blurps'
In Query (l.319) : 'Toto & Blurps'

"SELECT cat_ID FROM $wpdb->categories WHERE cat_name = '$category'"

See patch for one possible solution.
See XML for an example of the problem...

[westi]

I'll take a look at this.

Is it possible to have an example import file with the issue?

[ryan]

The WP importer needs to be updated to use taxonomy and the sanitize term API.

[ryan]

(In [5937]) Update WP importer to use taxonomy and query cat based on slug. see #4613

[ryan]

Try that out.

[momo360modena]

Ok in changeset:5937