SQL error on creating taxation rule

-- url of the page with the problem -- : dshop.se
-- HikaShop version -- : 2.2.3
-- Joomla version -- : 3.1.0
-- PHP version -- : 5.4.6
-- Browser(s) name and version -- : Safari 6.0.5
-- Error-message(debug-mod must be tuned on) -- : Error_message

I get this sql insert error when I try to create a new taxation rule. It is kind of urgent as now I have no taxation at all for my products.

Hi there,

Could you login phpmySQL and execute this query on your database? This should return an error message and help to understand the issue.

Done, results is in the attached screenshot. I noticed the field taxation_post_code is in the query but not in the database table.

The SQL query starts after the = sign.

Please run the query:

Sorry, my mistake. But my initial suspicion proved right. Result below:

Yes, the issue is that you have a column missing because of a problem during the update. Add that missing column in the hikashop_taxation table and it will then work. You can do it via the phpmyadmin interface.

What datatype is required? Or better still, will you help me formulate the ALTER query so I don't mess things up.

a VARCHAR 255. You can find the ALTER query in the file administrator/components/com_hikashop/install.hikashop.php as explained here:
www.hikashop.com/support/support/documen...lity-issues.html#SQL