search

PhocaCz / PhocaCart

Phoca Cart is Joomla! CMS extension. Component - e-commerce solution for Joomla! CMS
http://www.phoca.cz/phocacart
Other
29 stars 10 forks source link

[4.0.6 RC] Can't save tax setting #149

Closed Heart1010 closed 1 year ago

Heart1010 commented 1 year ago

Installed v4.0.6RC and imported the demo data. Now I want to change the tax name from VAT to MWST but when clicking SAVE button I get this error message:

image

PhocaCz commented 1 year ago

Hi, it seems like there is wrong column structure.

Are you able to change it, e.g. in phpMyAdmin? Just run this SQL query:

ALTER TABLE `#__phocacart_taxes` CHANGE `tax_hide` `tax_hide` text;

Change the #__ prefix to your own, in your case to j51bi_phocacart_taxes

And let me know.

Thank you, Jan

Heart1010 commented 1 year ago

Thanks, Jan - that worked 👍

1) I can't find tax_hide in the sql install file - is it missing/forgotten? 2) In file 4.0.6.sql the wrong ALTER command is in

ALTER TABLE `#__phocacart_taxes` ADD COLUMN `tax_hide` tinyint(1) NOT NULL default '0';

P.S.: tax_hide was tinyint(1) after installing v4.0.6rc

PhocaCz commented 1 year ago

Hi, yes, this was wrong, should be "text", I have changed it in RC

install.utf8.sql img

4.0.6.sql img

It is fixed here: https://github.com/PhocaCz/PhocaCart/releases/download/4.0.6RC/com_phocacart_v4.0.6RC.zip but of course, reinstalling does not have any effect (because the column is included in database and upgrade does not change it - so it is needed to fix it in database)