Phocacart beta75 -> 87 update

[Webguy]

When I apply the update I get the following error:

1054
Unknown column 'change_tax' in 'field list'

[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

[Jan]

Great, thank you Benno for this information. Unfortunately the database update does not work between different Beta versions.

[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?

[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

[sulpher]

Oh, yes... The dev site have had this column while another site had not...

Thank you so much for explanations, Benno!

[Benno]

You're welcome!

Kind regards,
Benno