Topic: Upgrade from 2.4.2 to 2.4.4

I am using FA 2.4.2 and want to upgrade to 2.4.4. When I go through Setup, Upgrade, it shows the current version as 2.4.1 and says that Upgrade is upto date.

Anything that I am missing out?

Re: Upgrade from 2.4.2 to 2.4.4

Just create a Backup and keep it.  And download a fresh copy of FA2.4.4 from either Github or SourceForge. You can download a new unstable version.

install the New FA separate, Than goto backup and Restore. Just restore with Exported Backup from 2.4.2.

There is not much changes in Database. And also the version of Database kept same. So its not showing the new version to update.

After importing that backup. it will be flushed with new your FA2.4.2 data's.

And than manually Login to your mysql database and run the below query.

INSERT INTO `0_sys_prefs` VALUES ('shortname_name_in_list','setup.company', 'tinyint', 1, '0');
INSERT INTO `0_sys_prefs` VALUES ('company_logo_report','setup.company', 'tinyint', 1, '0');
INSERT INTO `0_sys_prefs` VALUES ('barcodes_on_stock','setup.company', 'tinyint', 1, '0');

That's it. these three parameters are new.

hope it helps to upgrade it.

Subscription service based on FA
HRM CRM POS batch Themes

Re: Upgrade from 2.4.2 to 2.4.4

Thanks kvvaradha. Will attempt to try this out.

Regds

Re: Upgrade from 2.4.2 to 2.4.4

The change file list between the said versions and the changed files thereafter are all available in the Announcement thread.

FA_2.4.2_to_FA_2.4.4_changed_files.zip

FA24_post_release_fixes_2018-09-15.zip

Re: Upgrade from 2.4.2 to 2.4.4

Hello all,

I have come to a stage where my web services provider has finally decided to upgrade to php 7.1 by mid Nov and so I have no choice but to upgrade from 5.6 to 7.1.

Also as I am running 2.4.2, with a lot of minor changes in reporting names, etc I didn't upgrade to 2.4.3, that means I have no choice but to move to 2.4.4 directly and as I have lot of different transactions I am not keen to re-enter them all in fresh install.

I like the steps I see above in post 2 and hopefully I won't encounter any problems, but I have a few questions which I really need help with before I take any adventurous steps.


1. I am running 2.4.2 with php5.6. I believe 2.4.2 is compatible with php7.0, but when I change from php5.6 to php7.0 within my web hosting control panel (I am with www.one.com) for some reason I start getting "fatal errors" as below.
Am I correct in understanding that my installation was done on php5.6 which is why I get this error if I now switch to php7.0 ?

Fatal error: Uncaught Error: Call to undefined function user_company() in /customers/4/6/2/portuk.com/httpd.www/fa/includes/errors.inc:85 Stack trace: #0 /customers/4/6/2/portuk.com/httpd.www/fa/includes/session.inc(376): error_handler(8192, 'Methods with th...', '/customers/4/6/...', 19, Array) #1 /customers/4/6/2/portuk.com/httpd.www/fa/includes/session.inc(376): include_once() #2 /customers/4/6/2/portuk.com/httpd.www/fa/index.php(18): include_once('/customers/4/6/...') #3 {main} thrown in /customers/4/6/2/portuk.com/httpd.www/fa/includes/errors.inc on line 85

2. If installation has to be done on certain php version for 2.4.4 to work, can I change the version to php7.2 (in web hosting) and then install 2.4.4 as mentioned in steps above by @kvvaradha's post 2 ???

3. If I follow steps in post 2 above to install a fresh copy of 2.4.4 and then use backup to restore data from 2.4.2 production, do I need to use the same database that I have used in 2.4.2 ? Or can I create and use a new database for 2.4.4 installation and still use backup file from 2.4.2 ?



I would be really grateful if someone could help me with above.

Thanking you all
GJ

Re: Upgrade from 2.4.2 to 2.4.4

@GJ You can backup from 2.4.2 and install a fresh FA 2.4.4 separately.
Than import the exported backup from 2.4.2.  The new database will be replaced with old one. After that you can make the changes i told above.  hope it will help you.

Subscription service based on FA
HRM CRM POS batch Themes

Re: Upgrade from 2.4.2 to 2.4.4

Thank you for your reply.

With new database I meant the one I create within we hosting.

Also, can someone please let me know about the php7.1 or php7.2 usage?

Re: Upgrade from 2.4.2 to 2.4.4

The function user_company() is in includes/current_user.inc and expects the default company to be defined in the config_db.php file for use on the login screen if no company is available / selected as yet.

The files that changed from FA v2.4.2 to FA 2.4.4 and those that changed thereafter to the current GitMaster are available in the announcements page from where you can sequentially overwrite the existing ones without having to install them (the install folder's files may be ignored).

The databases may have to be upgraded on first admin login into each company.

Along with the PHP 7.1/7.2 upgrade you also run the risk of getting your MySQL version upgraded too to 5.7.x which may need some strict setting to be switched off like zero date.

Re: Upgrade from 2.4.2 to 2.4.4

apmuthu wrote:

The function user_company() is in includes/current_user.inc and expects the default company to be defined in the config_db.php file for use on the login screen if no company is available / selected as yet.

The files that changed from FA v2.4.2 to FA 2.4.4 and those that changed thereafter to the current GitMaster are available in the announcements page from where you can sequentially overwrite the existing ones without having to install them (the install folder's files may be ignored).

The databases may have to be upgraded on first admin login into each company.

Along with the PHP 7.1/7.2 upgrade you also run the risk of getting your MySQL version upgraded too to 5.7.x which may need some strict setting to be switched off like zero date.

I need to update to 2.4.4 and with php7.1 or 7.2, as php5.6 and 7.0 won't be supported by one.com post mid Nov 18.

But I want to make sure i can have continuity of system in order to avoid manual entry or re-entry of transactions.

If I check mysql version via myphp, I think it is 10.x.x something, way ahead than 5.7.x.

I really need some help and clarity on how to go about this.

10 (edited by poncho1234 10/19/2018 04:49:54 pm)

Re: Upgrade from 2.4.2 to 2.4.4

To clarify on MySQL version: You are running MariaDB not MySQL, MariaDB 10.0 is compatible with MySQL 5.6, and MariaDB 10.2 is compatible with MySQL 5.7.

So it depends on what your last digit is?


Read about it here

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/

Re: Upgrade from 2.4.2 to 2.4.4

i have question from you, well i have installed the FA 2.4.4 but when i goto setup-> software upgrade it show me lower then version to 2.4.4 and said upto date * show current version 2.4.1 .... what is this?

Re: Upgrade from 2.4.2 to 2.4.4

@emiangel - 2.4.1 is database version. Usually FA has two versions,

   * FA version  2.4.4
   * DB version 2.4.1

Subscription service based on FA
HRM CRM POS batch Themes

Re: Upgrade from 2.4.2 to 2.4.4

poncho1234 wrote:

To clarify on MySQL version: You are running MariaDB not MySQL, MariaDB 10.0 is compatible with MySQL 5.6, and MariaDB 10.2 is compatible with MySQL 5.7.

So it depends on what your last digit is?


Read about it here


Hi Ponocho1234,

You are right, I am running below MariaDB, which according to link in your post is equivalent of MySQL 5.6.

Software version: 10.1.30-MariaDB-1~xenial - mariadb.org binary distribution

Thank you

Re: Upgrade from 2.4.2 to 2.4.4

Hi,

Sorry to pick your brains again but, the problem I have in next few days is that my web services provider is going to stop supporting both php 5.6 and 7.0 completely, so I need to make sure that my existing installation 2.4.2 keeps working smoothly on php 7.1 or if possible php 7.2.

Right now when I change my php from 5.6 to 7.1, within my web services control panel, I encounter below error message, which I did try solving using this post but, it gave few more errors.

Fatal error: Uncaught Error: Call to undefined function user_company() in /customers/4/6/2/portuk.com/httpd.www/fa/includes/errors.inc:85 Stack trace: #0 /customers/4/6/2/portuk.com/httpd.www/fa/includes/session.inc(376): error_handler(8192, 'Methods with th...', '/customers/4/6/...', 19, Array) #1 /customers/4/6/2/portuk.com/httpd.www/fa/includes/session.inc(376): include_once() #2 /customers/4/6/2/portuk.com/httpd.www/fa/index.php(18): include_once('/customers/4/6/...') #3 {main} thrown in /customers/4/6/2/portuk.com/httpd.www/fa/includes/errors.inc on line 85

For now I want to make sure that I can keep working on 2.4.2, and if possible update to 2.4.4 in order to avoid more complications when it comes to updating to new versions.


Along with the PHP 7.1/7.2 upgrade you also run the risk of getting your MySQL version upgraded too to 5.7.x which may need some strict setting to be switched off like zero date.

As for above, I don't mind strict settings switched off, but I really don't know where or how to switch them off.


apmuthu wrote:

The function user_company() is in includes/current_user.inc and expects the default company to be defined in the config_db.php file for use on the login screen if no company is available / selected as yet.

The files that changed from FA v2.4.2 to FA 2.4.4 and those that changed thereafter to the current GitMaster are available in the announcements page from where you can sequentially overwrite the existing ones without having to install them (the install folder's files may be ignored).

The databases may have to be upgraded on first admin login into each company.

Along with the PHP 7.1/7.2 upgrade you also run the risk of getting your MySQL version upgraded too to 5.7.x which may need some strict setting to be switched off like zero date.

Re: Upgrade from 2.4.2 to 2.4.4

Switch service provider or check if they allow multiple versions of PHP to co-exist (CGI?).

Take a backup of the FA DB and the scripts (if you have specific versions of extensions / customisations).

The DB v10.x is that of the MySQL plugin replacement called MariaDB.

There are no real MySQL DB changes from v2.4.2 to v2.4.4 other than some records for the sys_prefs table records and their dependencies.

Re: Upgrade from 2.4.2 to 2.4.4

Am I correct in understanding below ?

1. I can install 2.4.2 and 2.4.4 both on php7.1 and php7.2?

2. Once 2.4.x is installed on certain php version, the php version cannot be updated for same installation to work with higher php version ? (e.g. I have 2.4.2 installed on php5.6, but when I upgrade to php7.1, I start getting errors).

Re: Upgrade from 2.4.2 to 2.4.4

There is no real difference in installing FA 2.4.2 or 2.4.4 and moving it across PHP versions since only a few config files are generated during the install. If the code in the core and the extensions used are compatible with the appropriate version of PHP, then all should be okay.

The upgrade, however may not be that straightforward across PHP versions. Various users experiences on and off the wiki/forum will need to be referred.

Upgrade of PHP version will affect older FA installs. The older PHP functions / syntax may have gotten removed in later PHP versions.

Re: Upgrade from 2.4.2 to 2.4.4

@gj6n68 - you need to keep the version of php also same.

Because upto FA 2.4.3 ,it throws error on php 7.0 and above. But from 2.4.4 it works fine there.

So if you want to use 2.4.2 on php 5.6 its fine. But if you upgraded the server php version. you need to swtich to FA2.4.4.

Otherwise you need to update the program manually by checking the changes log of FA.

anyway, you need to upgrade program of FA to 2.4.4.  and connect the 2.4.2 database. only few field differences are there. That i already stated above for your understanding purpose

Subscription service based on FA
HRM CRM POS batch Themes

Re: Upgrade from 2.4.2 to 2.4.4

Thank you all.

I am going to try and move to 2.4.4 along with php 7.2 over the weekend.

I am planning to do a fresh install and use the back from my prod of 2.4.2 before I migrate over completely.

Hope it all goes well or else I'll be back with lot of questions again.

Re: Upgrade from 2.4.2 to 2.4.4

@gj6n68 -  Read this and get new version of FA before you install it on your new PHP version.   

https://frontaccounting.com/punbb/viewtopic.php?pid=33023#p33023 Hoping to hear, it worked

Subscription service based on FA
HRM CRM POS batch Themes

Re: Upgrade from 2.4.2 to 2.4.4

Hello,

I managed to upgrade to 2.4.4 from 2.4.2 on php 7.2 directly, and the process was relatively straight forward, though I have to say I did manage to delete a few things on 2.4.2 before I upgraded 2.4.4. and had no choice but to make it work. Luckily I had created backup from FA itself.

One problem I came across was similar to what has been discussed in this post https://frontaccounting.com/punbb/viewtopic.php?id=7778 

I got an error before installation begins and pointed it to "maintenance_db.inc" file at line 186, but I applied same logic as mentioned in the link and replaced count  by count_array and installation was successful.

    // update per company files
     $cnt = max(1, count($db_connections));
    for($i = 0; $i < $cnt; $i++) 

So far so good, and everything seems to be working fine.
I haven't been able to use import items extension on 2.4.4 though I tried everything but that can wait.

Thank you all for all the help.