Jump to content

getAssociatedTaxRatesByIdCountry


Recommended Posts

Hi all, i am getting an issue. 1.5 migration was unsuccesffully from 1.4.9 to 1.5.1.0 (missing subdomain table). but now (after haved fixed by creating & inserting www row).

The error is on product page

 

Unknown column 'tr.id_county' in 'where clause'

 

SELECT rg.`id_tax_rules_group`, t.`rate`

FROM `ps_tax_rules_group` rg

LEFT JOIN `ps_tax_rule` tr ON (tr.`id_tax_rules_group` = rg.`id_tax_rules_group`)

LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`)

WHERE tr.`id_country` = 0 AND tr.`id_state` = 0 AND tr.`id_county` = 0

 

I notice an error on id_country filed name having a mistake :

AND tr.`id_county` = 0 "R" is missing....

 

sincerly.

Arnaud

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...