Taxation error

  • Posts: 15
  • Thank you received: 0
10 years 7 months ago #150168

Hello,i seem to have a error while upgrading from hikashop 2.1 to 2.3,products and taxation goes crazy

-- url of the page with the problem -- : aer-conditionat-inverter-constanta.ro/
-- HikaShop version -- : 2.3.0
-- Joomla version -- : 3.2.3.
-- PHP version -- : 5.3.18
-- Browser(s) name and version -- : XXXXX x.x.x
-- Error-message(debug-mod must be tuned on) -- : Error_message

When i try to create a new product,after i write the price,at with tax it returns "undefined" (the vat is 24%) and it should add it,it worked fine in the prev version.
After that i try to create a new tax rule,but i get this error.

1054 Unknown column 'taxation_post_code' in 'field list' SQL=INSERT IGNORE INTO `suwxv_hikashop_taxation` ( `taxation_id`,`category_namekey`,`tax_namekey`,`taxation_cumulative`,`taxation_post_code`,`zone_namekey`,`taxation_type`,`taxation_date_start`,`taxation_date_end`,`taxation_access`,`taxation_published` ) VALUES ( '0','default_tax','TVA','0','','','','','','all','0' )

After upgrading,i cant access any products from the previous version ,i get same error.

Please Log in or Create an account to join the conversation.

  • Posts: 82910
  • Thank you received: 13379
  • MODERATOR
10 years 7 months ago #150175

Hi,

That's because of this:
www.hikashop.com/support/support/documen...lity-issues.html#SQL
Run the alter query for the taxation_post_code as explained in the documentation and it will work.

Please Log in or Create an account to join the conversation.

Time to create page: 0.038 seconds
Powered by Kunena Forum