• From: Kenya, Nairobi
  • Registered: 05/06/2020
  • Posts: 11

Topic: Unable to access data after php upgrade.

I have a FrontAccounting installation version 2.3 that has been running well until the php version in the server was upgraded to 7.4. any attempt to log in shows a blank page after entering the credentials, without any error message. Any thoughts on possible solution are welcome.

Thank you.

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 550

Re: Unable to access data after php upgrade.

If you have access to the server then look in .../tmp/errors.log and see if any errors are logged there.

rafat's Website

  • From: Vietnam
  • Registered: 09/28/2016
  • Posts: 349

Re: Unable to access data after php upgrade.

You should downgrade to php 5.6, FA 2.3 cannot run in php 7

Phuong

notrinos's Website

  • dz
  • Senior Member
  • Offline
  • From: Pakistan
  • Registered: 10/07/2019
  • Posts: 50

Re: Unable to access data after php upgrade.

1. Seems like you using a shared hosting, try writing the following in your .htaccess this will support php 5.6
<IfModule mime_module>
  AddHandler application/x-httpd-ea-php56___lsphp .php .php5 .phtml
</IfModule>
2. or else ask your hosting provider to downgrade the php version for you.

  • From: Kenya, Nairobi
  • Registered: 05/06/2020
  • Posts: 11

Re: Unable to access data after php upgrade.

Thank you, @rafat, @notrinos, and @dz,

I have downgraded my php to 5.6. The FA installation process is giving the following error after entering loggin credentials;

"SQL script execution failed in line 21: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=2' at line 7"

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Unable to access data after php upgrade.

Check your MySQL version as well.

apmuthu's Website

  • From: Kenya, Nairobi
  • Registered: 05/06/2020
  • Posts: 11

Re: Unable to access data after php upgrade.

Thank you for this. What is the right mysql server version for FA 2.3?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Unable to access data after php upgrade.

MySQL v5.1 should be okay.

apmuthu's Website

  • From: Kenya, Nairobi
  • Registered: 05/06/2020
  • Posts: 11

Re: Unable to access data after php upgrade.

dz wrote:

1. Seems like you using a shared hosting, try writing the following in your .htaccess this will support php 5.6
<IfModule mime_module>
  AddHandler application/x-httpd-ea-php56___lsphp .php .php5 .phtml
</IfModule>
2. or else ask your hosting provider to downgrade the php version for you.

Thank you @dz

This worked.

Now I am working on upgrading to FA 4.8

  • From: Kenya, Nairobi
  • Registered: 05/06/2020
  • Posts: 11

Re: Unable to access data after php upgrade.

apmuthu wrote:

MySQL v5.1 should be okay.

Thank you @apmuthu

I'll see to this as I upgrade FA to 4.8

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Unable to access data after php upgrade.

FA 2.4.11

apmuthu's Website

  • From: Kenya, Nairobi
  • Registered: 05/06/2020
  • Posts: 11

Re: Unable to access data after php upgrade.

This is definitely a version with superior functions compared to 2.3.22., thank you. The upgrade process is what I am not sure about, especially from such an old version. Is there some instruction available I could refer to?

  • From: Singapore, India, Chennai
  • Registered: 05/02/2009
  • Posts: 6,160

Re: Unable to access data after php upgrade.

First get FA 2.3.22 (2014-09-29) to FA 2.3.26  (2017-05-23) the last in that series.

Then get it to FA 2.4 or directly to FA 2.4.11+.

All difference files are in the Announcements sticky topics.

Attached is the v2.3.22 to 2.3.26 changed files.

Post's attachments

frontac_2.3.22_to_2.3.26.zip 657.3 kb, 1 downloads since 2022-05-06 

You don't have the permssions to download the attachments of this post.

apmuthu's Website