Import of data into database (starting from 4.1.2) fails

[ewerkstatt]

We created a plugin which imports data from an XML-file (UTF-8) into the WP-database (collation utf8_general_ci) using $wpdb->query("CREATE ....");.

Since version 4.1.2 the import fails due to the usage of german umlauts in field names. The problem persists also in 4.1.3.

The import is possible using wp-includes/wp-db.php from version 4.1.1.

[SergeyBiryukov]

Related: #32090

[pento]

Note for when I look at a fix for this: it's probably failing because wpdb::strip_invalid_text_from_query() fails if the table doesn't exist, which it won't for a CREATE query.

I'm inclined to skip the check for queries that don't return user data, as we do with wpdb::check_safe_collation(). (Though with CREATE added to the regex, of course.)

This will need to be backported to 3.7.

[pento]

In 32374:

WPDB: When sanity checking query character sets, there's no need to check queries that don't return user data.

See #32104.

[pento]

In 32377:

WPDB: When sanity checking query character sets, there's no need to check queries that don't return user data.

Merges [32374] to the 4.2 branch.

See #32104.

[ocean90]

In 32402:

WPDB: When sanity checking query character sets, there's no need to check queries that don't return user data.

Merges [32374] to the 4.1 branch.

props pento.
see #32104.

[ocean90]

In 32403:

WPDB: When sanity checking query character sets, there's no need to check queries that don't return user data.

Merges [32374] to the 4.0 branch.

props pento.
see #32104.

[ocean90]

In 32405:

WPDB: When sanity checking query character sets, there's no need to check queries that don't return user data.

Merges [32374] to the 3.9 branch.

props pento.
see #32104.

[ocean90]

In 32406:

WPDB: When sanity checking query character sets, there's no need to check queries that don't return user data.

Merges [32374] to the 3.8 branch.

props pento.
see #32104.

[ocean90]

In 32407:

WPDB: When sanity checking query character sets, there's no need to check queries that don't return user data.

Merges [32374] to the 3.7 branch.

props pento.
fixes #32104.

[ewerkstatt]

Uuuuuuh, works again!

Thank you guys and dolls!