I'm getting this same error running v1.5.6.2 - is there any chance that one of you guys who is NOT getting this error might do the following for those of us who are getting the error? That way, we could drop and recreate the ps_tax_rule table to be exactly as yours is. Even after creating an "active" column, I get the error.
SHOW CREATE TABLE ps_tax_rule;
This is the result of that query on my system:
CREATE TABLE `ps_tax_rule` ( `id_tax_rule` int(11) NOT NULL AUTO_INCREMENT, `id_tax_rules_group` int(11) NOT NULL, `id_country` int(11) NOT NULL, `id_state` int(11) NOT NULL, `zipcode_from` varchar(12) NOT NULL, `zipcode_to` varchar(12) NOT NULL, `id_tax` int(11) NOT NULL, `behavior` int(11) NOT NULL, `description` varchar(100) NOT NULL, `active` tinyint(1) NOT NULL, PRIMARY KEY (`id_tax_rule`), KEY `id_tax_rules_group` (`id_tax_rules_group`), KEY `id_tax` (`id_tax`), KEY `category_getproducts` (`id_tax_rules_group`,`id_country`,`id_state`,`zipcode_from`) ) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8