Page 1 of 1
Phocacart beta75 -> 87 update
Posted: 18 Nov 2024, 14:36
by Webguy
When I apply the update I get the following error:
1054
Unknown column 'change_tax' in 'field list'
Re: Phocacart beta75 -> 87 update
Posted: 18 Nov 2024, 14:55
by Benno
Hi,
backup your Database first and then run this query:
Code: Select all
ALTER TABLE `#__phocacart_shipping_methods` ADD COLUMN `change_tax` tinyint(1) NOT NULL DEFAULT '0';
Kind regards,
Benno
Re: Phocacart beta75 -> 87 update
Posted: 23 Nov 2024, 19:22
by Jan
Great, thank you Benno for this information. Unfortunately the database update does not work between different Beta versions.
Re: Phocacart beta75 -> 87 update
Posted: 24 Nov 2024, 09:15
by sulpher
Hello,
I am using beta79. And there were older beta versions earlier. I just installed the latest beta at that moment over existing ones.
I do not see the issue described in this topic or could not reproduce it.
Should the user performs this DB query after the update to beta 87 or keep it as is if no problem occurs?
Re: Phocacart beta75 -> 87 update
Posted: 24 Nov 2024, 11:02
by Benno
@sulpher,
Just check whether the column 'change_tax' already exists in the table '#__phocacart_shipping_methods'. If 'Yes' everything is fine, if 'No' create it with the above database query. Note that you first replace '#_' with your database prefix:
Kind regards,
Benno
Re: Phocacart beta75 -> 87 update
Posted: 25 Nov 2024, 11:30
by sulpher
Oh, yes... The dev site have had this column while another site had not...
Thank you so much for explanations, Benno!
Re: Phocacart beta75 -> 87 update
Posted: 25 Nov 2024, 12:39
by Benno
You're welcome!
Kind regards,
Benno