Friday, September 14, 2012

Pisc Euvat extension error

I was implementing this module https://support.pillwax.com/open-source/doku.php?id=magento:euvat

but got the below mentioned error

Column not found: 1054 Unknown column '_table_taxvat.value' in 'where clause'";i:1;s:7921:"#0


To resolve this i just removed the sql conditions like below in file Grid.php
at path: app/code/local/Pisc/Euvat/Block/Adminhtml/Customer/Invalidstatus

change the below lines
"(_table_taxvat.value IS NOT NULL AND (".$collection->getTable('euvat/vies_cache').".response LIKE '%valid=1;%') AND tax_class_id<>".$config->getTaxClass_EuBusiness()." AND tax_class_id<>".$config->getTaxClass_DefaultCountry().")".

to

"( (".$collection->getTable('euvat/vies_cache').".response LIKE '%valid=1;%') AND tax_class_id<>".$config->getTaxClass_EuBusiness()." AND tax_class_id<>".$config->getTaxClass_DefaultCountry().")".

As u can see i just removed the red colored line  "_table_taxvat.value IS NOT NULL AND" , just do the same for all occurance of that  line.