Error installing the EU VAT

  • Posts: 410
  • Thank you received: 15
7 years 5 months ago #253150

-- HikaShop version -- : 2.6.4
-- Joomla version -- : 3.6.3

Hello when you install the archive receive the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(0, '', 'tax_eservices', 'VAT (AT)', 1, 'company_without_vat_number', 'all', 0, ' at line 1 SQL=INSERT IGNORE INTO `#__hikashop_taxation` (`taxation_id`, `zone_namekey`, `category_namekey`, `tax_namekey`, `taxation_published`, `taxation_type`, `taxation_access`, `taxation_cumulative`, `taxation_post_code`, `taxation_date_start`, `taxation_date_end`) VALUES (0, '', 'tax_eservices', 'VAT (AT)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (AT)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (BE)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (BE)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (BG)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (BG)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (HR)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (HR)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (CY)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (CY)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (CZ)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (CZ)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (DK)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (DK)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (EE)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (EE)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (FI)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (FI)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (FR)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (FR)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (FR)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (DE)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (DE)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (GR)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (GR)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (HU)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (HU)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (IE)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (IE)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (IT)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (IT)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (LV)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (LV)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (LT)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (LT)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (LU)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (LU)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (MT)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (MT)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (NL)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (NL)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (PL)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (PL)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (PT)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (PT)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (RO)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (RO)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (SK)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (SK)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (SI)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (SI)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (ES)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (ES)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (SE)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (SE)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (GB)', 1, 'individual', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT (GB)', 1, 'company_without_vat_number', 'all', 0, '', 1420070400, 0) (0, '', 'tax_eservices', 'VAT Exempt', 1, 'company_with_vat_number', 'all', 0, '', 1420070400, 0)

Download page: www.hikashop.com/support/2-uncategorised...urope-vat-rules.html

Attachments:

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

  • Posts: 81379
  • Thank you received: 13037
  • MODERATOR
7 years 5 months ago #253158

Hi,

Thank you for your feedback. We've added a patch on the European tax plugin. Please download it again and it should work.

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

Time to create page: 0.065 seconds
Powered by Kunena Forum