zonkeyweb

This may help anyone waiting for a fix on this issue

Root cause: In src/DataMapper/DriverBase.php, _parse_where_clause() splits a comma-separated value list back into an array only for the IN operator, not NOT IN:

if ( 'in' === $operator ) {
    $values = preg_split( "/'?\s?(,)\s?'?/i", $value );
}

Because exclusions generate a NOT IN clause, the list stays a single string ("437,607,608,609,610"). TableDriver::add_where_clause() then casts that string with (float), collapsing it to 437, so the SQL becomes pid NOT IN (437) instead of pid NOT IN (437,607,608,609,610).

Suggested fix (one line, _parse_where_clause()):

if ( 'in' === $operator || 'not in' === $operator ) {
    $values = preg_split( "/'?\s?(,)\s?'?/i", $value );
}

I’ve found a solution for this for you.

WooCommerce in the latest version isnt creating a table called wp_woocommerce_tax_rate_locations which is why its failing.

Use this code to create the table for your install, resave woocommerce settings and you’ll be good to go.

http://pastebin.com/rVGcPpZ5

Did you find a solution to this?

I managed to fix this on my installation by upgrading PHP to 5.5.x from 5.4.x. Tried a load of other stuff first to do with WordPress versions etc but the PHP upgrade sorted it for me.