FrontAccounting forum — Unable to access data after php upgrade.

Re: Unable to access data after php upgrade.

2022-05-06T16:12:02Z

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.

2022-05-06T10:20:41Z

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.

2022-05-05T14:53:30Z

FA 2.4.11

Re: Unable to access data after php upgrade.

2022-05-05T10:37:05Z

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.

2022-05-05T10:35:33Z

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.

2022-05-03T15:39:33Z

MySQL v5.1 should be okay.

Re: Unable to access data after php upgrade.

2022-05-03T07:02:56Z

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

Re: Unable to access data after php upgrade.

2022-04-27T14:38:55Z

Check your MySQL version as well.

Re: Unable to access data after php upgrade.

2022-04-27T04:33:38Z

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.

2022-04-23T14:28:53Z

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.

2022-04-23T13:53:51Z

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

Re: Unable to access data after php upgrade.

2022-04-23T12:51:07Z

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.

2022-04-23T11:08:10Z

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.