I'm using Drupal Commerce 7.x-1.2 with Drupal 7.12 and have set up two VAT tax rates with machine names alv_23_ and alv_9_. In the store there's exist plenty of orders made of products that use these rates.

Then I installed this module and trying to get it function for the first time. When pressing the button "Rebuild tax database" in tax reports configuration it throws only error:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'alv_23_' in 'field list': INSERT INTO {commerce_reports_tax} (order_id, created, currency_code, alv_23_) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => 4 [:db_insert_placeholder_1] => 1326394349 [:db_insert_placeholder_2] => EUR [:db_insert_placeholder_3] => 186 ) in drupal_write_record() (line 6975 of ... /httpdocs/includes/common.inc).

Comments

jax555’s picture

I am having the same problem and I have only 1 tax to report on.

aidanlis’s picture

You'll need to manually adjust your database schema, as there's no support in the module for handling changes.

aidanlis’s picture

Title: Errors after trying to rebuild tax database with two vat rates » (Tax submodule) Adjust database schema when tax types are changed
Category: bug » task
cvangysel’s picture

Status: Active » Closed (won't fix)

An alpha version of the 3.x version will soon be available.