Search options (Page 19 of 244)

If it is to be used only on your laptop, then download PHP 5.6 alone and edit the php.ini as needed and run the builtin webserver that PHP has.

Client List - that is possible. Wanna a hand, PM me.

That is one big digital mess indeed and needs careful rectification.

QOH: which field in which table do you refer to?

MySQL host, username, password length restrictions in MySQL 5.5.36 is 60, 16 and 41 respectively but consider the real password length to be less as hashing payload exists. Do not directly try to change the field sizes of the various tables in the mysql db.

MySQL uses PASSWORD(str) to encrypt the cleartext password str. This hashed password string is stored in the mysql.user grant table with a CHAR(41) datatype.

Refer:
https://dev.mysql.com/doc/refman/5.7/en/user-names.html
https://stackoverflow.com/questions/7465204/maximum-mysql-user-password-length

The file create_coy.php in lines 331-335 has these size limits:

        text_row_ex(_("Host"), 'host', 30, 60);
        text_row_ex(_("Port"), 'port', 30, 60);
        text_row_ex(_("Database User"), 'dbuser', 30);
        text_row_ex(_("Database Password"), 'dbpassword', 30);
        text_row_ex(_("Database Name"), 'dbname', 30);

If such size limitations exist as indicated by the findings in this thread, then these sizes should be enforced here.

Generally even if you uninstall XAMPP, better delete the XAMPP folder before installing any other XAMPP.

If it is a new install, delete the database and re-create it anew and delete the contents of the frontaccounting folder as well before unzipping the contents of FA 2.4.9 afresh and make sure you have the post release fixes as well from the 4th post in the release thread to overwrite their counterparts in the release.

If, however, you had data in FA v2.4.8 and upgraded by unzipping the FA 2.4.9 into it or used the change files set in the 3rd post in the release thread, then use the 4th post in the release thread to update to current state and you will be good to go.

Otherwise, if you upgraded from some earlier version prior to getting it into FA 2.4.8 itself, then you should follow instructions in each intervening release thread thereafter before doing the above.

All of this is also dependent on what extensions/languages/themes you additionally installed in each version and tweaks you incorporated each time. Furthermore, there are caveats on which chart of accounts you used for each company in the FA installation and during usage thereafter. Particularly, the order of fields and incorporation of missing settings in each config distribution sample that comes with each FA version that need to have equivalents in the current config.php file and the settings in the sys_prefs table as well in each database that FA companies use.

If it is for a serious production installation, and you are not sufficiently conversant with PHP/MySQL and the basics of webserver based application rollout, please seek professional assistance posting your needs and bounties in the job offers board. There are enough forum users in your country itself and / or those familiar with the local language and laws who are quite knowledgeable and willing to help.

The following are the top posters from your country:
@almohasb
@obahey
@abozeed
@AsimACC
@JavaMan
@AhmedSelim
@Mahmoud Ali

See PM.
FA 2.4.x does not support PHP 8.0 that is in your version of XAMPP.

@joe: Please check and correct it:
Line 202 in inventory/includes/item_adjustments_ui.inc:

            amount_cells(null, 'std_cost', null, null, null, $dec);

needs to be replaced with:

            amount_cells(null, 'std_cost', null, null, null, $dec2);

This line was introduced in commit on 2019-06-28 as Line 194:
Inventory Adjustment: negative adjustment should always use current average item cost.

Post Release Fixes attached.

CHANGELOG

* This also has the PHP compatibility fix stated here. - It is now in the core and in the attachment herein.
* View this post for fixes to this update. - It is now in the core and in the attachment herein.

Yes. This error was introduced in this 2020-11-28 commit.

A whole list of functions used in FA can be extracted from the webroot core folder with:

grep -R "function " core > FAFunctionList.txt

and remove all commented lines (and their multiline continuities) and normalise the tabs between the file name: and the function word besides removing sql and class elements and __construct().

Check your PM.

Attached is the set of changed files between FA 2.4.8 and FA 2.4.9.
This also has the PHP compatibility fix stated here.

First 2 day download stats at SF
Previous release fileset changes in this post.
SF Main Download Page
FA 2.4.9 tar.gz download
MD5 Hash: b05ab536e2193281cd461741f5341c0a
Filesize: 1,597,628 bytes