Version Details Page

[landed]

Hi
I always like to check what was changed when a new version is released. Is there a page containing details of the changes?
I am alerted to my 5.0.0Beta79 now going to 5.0.0 but I can't see how risky it is, having had a release break previously I'm now a late adopter. Thank you.

[Jan]

Hi, yes, everything is stored in GIT: https://github.com/PhocaCz/PhocaCart/tree/dev

If you have used Beta, then the important file for you is the update/sql/mysql/5.0.0.sql

There are SQL quries which were added in development vesion and needs to be added manually (if mission in your installation)

Jan

[landed]

I don't see this file from the root - please can you elaborate. So if I just instal it will not run the right SQL?

[Jan]

https://github.com/PhocaCz/PhocaCart/bl ... /5.0.0.sql

If you have 5.0.0Beta, this file will not run so you need to check the last SQL queries if they were applied in your installation (e.g. if you add new column, your database will tell you, it was successful or such column exists yet)

Jan

[landed]

I'm hoping that if you release a download it doesn't break things like this. There was a post here saying it was ok to install ths beta version. Are you saying now I need to run some SQL. I can do that but need to know which.

[Jan]

Hi, the communication is still the same:

The Beta was in fact as stable because it was tested properly and it only missed the new Joomla mail templates integration, so it was safe to use it. But between development versions the update of database does not work (as these are still the same versions and the update feature cannot differentiate between them). So in such case some SQL queries need to be run after update.

Such can be found here:
administrator/components/com_phocacart/update/sql/mysql/5.0.0.sql

In fact, it is a trivial copy paste operation, for example, let's say your system tells you that change_tax column is missing in your database:

So, just open this file:

administrator/components/com_phocacart/update/sql/mysql/5.0.0.sql

find the "change_tax" string

ALTER TABLE `#__phocacart_shipping_methods` ADD COLUMN `change_tax` tinyint(1) NOT NULL DEFAULT '0';

Replace to your database prefix (e.g. jos_):

ALTER TABLE `jos_phocacart_shipping_methods` ADD COLUMN `change_tax` tinyint(1) NOT NULL DEFAULT '0';

and open on your server phpMyAdmin and paste (run) this command, so the column will be updated.

Joomla has in administration "fix database" feature but this may not always work, so it is better just copy the query (change the prefix) and run in phpMyAdmin.

If you have problems in this area, just paste the error message in this forum, so we can write here the right query.

Jan

[landed]

Thanks, helpful.