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...

I'll take a look at this.

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

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

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

Try that out.

Ok in changeset:5937