Archived Front Accounting Upgrade Notes
From Proxmox VE
Contents |
Upgrading from FrontAccounting v2.2.9 to v2.2.10
File changes between these versions have been extracted, permissioned and packaged to seamlessly get integrated with the base install as below:
cd /var/www/frontaccount wget http://www.sacollege.net/files/appliances/fac229_to_2210.tar.gz tar -zxvpf fac229_to_2210.tar.gz sed -i 's#"2.2.9";#"2.2.10";#' /var/www/frontaccount/config.php rm fac229_to_2210.tar.gz
There is one MySQL DB record change that needs to be done for the default company for this version:
UPDATE `0_security_roles` SET `areas`='257;258;259;260;513;514;515;516;517;518;519;520;521;522;523;524;525;769;770;771;772;773;774;2817;2818;2819;2820;2821;2822;2823;3073;3074;3082;3075;3076;3077;3078;3079;3080;3081;3329;3330;3331;3332;3333;3334;3335;5377;5633;5634;5635;5636;5637;5641;5638;5639;5640;5889;5890;5891;7937;7938;7939;7940;8193;8194;8195;8196;8197;8449;8450;8451;10497;10753;10754;10755;10756;10757;11009;11010;11011;11012;13057;13313;13314;13315;15617;15618;15619;15620;15621;15622;15623;15624;15628;15625;15626;15627;15873;15874;15875;15876;15877;15878;15879;15880;15883;15881;15882;16129;16130;16131;16132' WHERE `id`='2';
Upgrading to FrontAccounting v2.2.7
FA v2.2.7 was released on 5th March, 2010, and is available as a full 940 KB package at:-
http://downloads.sourceforge.net/sourceforge/frontaccounting/frontaccount-2.2.7.tar.gz
This package has changes in the MySQL DB schema with respect to the v2.1.x series and sports a new ACL with Roles and Sections.
Kindly refer to the official update page for detailed info. The FA Wiki has a new v2.2 update page.
Upgrading from FrontAccounting v2.2.6 to v2.2.7 CVS 10th March 2010
cd /var/www/frontaccount wget http://www.sacollege.net/files/appliances/fac226_to_cvs20100310.tar.gz tar -zxvpf fac226_to_cvs20100310.tar.gz rm fac226_to_cvs20100310.tar.gz sed -i 's#"2.2.6";#"2.2.7";#' /var/www/frontaccount/config.php
Also delete the last two significant lines (due to redundancy) from /var/www/frontaccount/config.php which are:
/* allow using of multi level sub-types when digits are of same length in account types */ $use_new_account_types = 0;
Upgrading to FrontAccounting v2.1.7
FA v2.1.7 was released on 17th October 2009 and is available as a full 840 KB package at:- http://downloads.sourceforge.net/sourceforge/frontaccounting/frontaccount-2.1.7.tar.gz
Log on to the console and execute the following commands:
If you are upgrading an existing install (v2.1.6) that is currently being used with companies and data, then backup the config files and alter the version number in config.php thus:
cp /var/www/frontaccount/config_db.php /var/www/config_db.php cp /var/www/frontaccount/config.php /var/www/config.php sed -i 's#"2.1.6";#"2.1.7";#' /var/www/config.php cp /var/www/frontaccount/installed_extensions.php /var/www/installed_extensions.php cp /var/www/frontaccount/modules/installed_modules.php /var/www/installed_modules.php
Get and place the new files:
cd /tmp wget http://downloads.sourceforge.net/sourceforge/frontaccounting/frontaccount-2.1.7.tar.gz tar -zxvf frontaccount-2.1.7.tar.gz chown -R www-data:www-data frontaccount cp -r frontaccount/* /var/www/frontaccount rm -r frontaccount rm frontaccount-2.1.7.tar.gz
If you are upgrading an existing install that is currently being used with companies and data, then restore the config files with:
mv /var/www/config_db.php /var/www/frontaccount/config_db.php mv /var/www/config.php /var/www/frontaccount/config.php chown www-data:www-data /var/www/frontaccount/config_db.php chown www-data:www-data /var/www/frontaccount/config.php mv /var/www/installed_extensions.php /var/www/frontaccount/installed_extensions.php mv /var/www/installed_modules.php /var/www/frontaccount/modules/installed_modules.php chown www-data:www-data /var/www/frontaccount/installed_extensions.php chown www-data:www-data /var/www/frontaccount/modules/installed_modules.php
Database changes if any are done on first execution - hence the upgrade is now done!
