FrontAccounting forum — Unable to access data after php upgrade.

Re: Unable to access data after php upgrade.

null@example.com (apmuthu) — Fri, 06 May 2022 16:12:02 +0000

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.

Re: Unable to access data after php upgrade.

null@example.com (pmaina) — Fri, 06 May 2022 10:20:41 +0000

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?

Re: Unable to access data after php upgrade.

null@example.com (apmuthu) — Thu, 05 May 2022 14:53:30 +0000

FA 2.4.11

Re: Unable to access data after php upgrade.

null@example.com (pmaina) — Thu, 05 May 2022 10:37:05 +0000

apmuthu wrote:

MySQL v5.1 should be okay.

Thank you @apmuthu

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

Re: Unable to access data after php upgrade.

null@example.com (pmaina) — Thu, 05 May 2022 10:35:33 +0000

dz wrote:

1. Seems like you using a shared hosting, try writing the following in your .htaccess this will support php 5.6

AddHandler application/x-httpd-ea-php56___lsphp .php .php5 .phtml

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

Re: Unable to access data after php upgrade.

null@example.com (apmuthu) — Tue, 03 May 2022 15:39:33 +0000

MySQL v5.1 should be okay.

Re: Unable to access data after php upgrade.

null@example.com (pmaina) — Tue, 03 May 2022 07:02:56 +0000

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

Re: Unable to access data after php upgrade.

null@example.com (apmuthu) — Wed, 27 Apr 2022 14:38:55 +0000

Check your MySQL version as well.

Re: Unable to access data after php upgrade.

null@example.com (pmaina) — Wed, 27 Apr 2022 04:33:38 +0000

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"

Re: Unable to access data after php upgrade.

null@example.com (dz) — Sat, 23 Apr 2022 14:28:53 +0000

1. Seems like you using a shared hosting, try writing the following in your .htaccess this will support php 5.6

AddHandler application/x-httpd-ea-php56___lsphp .php .php5 .phtml

2. or else ask your hosting provider to downgrade the php version for you.

Re: Unable to access data after php upgrade.

null@example.com (notrinos) — Sat, 23 Apr 2022 13:53:51 +0000

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

Re: Unable to access data after php upgrade.

null@example.com (rafat) — Sat, 23 Apr 2022 12:51:07 +0000

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

Unable to access data after php upgrade.

null@example.com (pmaina) — Sat, 23 Apr 2022 11:08:10 +0000

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.