apmuthu / frontac24 Goto Github PK

FA 2.4.14 using PHP 8.1.6:

When activating an extension/module for a company I get this error:
mysqli_set_charset(): Passing null to parameter #2 ($charset) of type string is deprecated in file: /usr/share/webapps/frontaccounting/includes/db/connect_db_mysqli.inc at line 298

my temporary fix:
function db_set_charset($db, $charset)
{
global $db;

if (!empty( $charset)) {  // <--------------- fix
	return mysqli_set_charset($db, $charset);
}

}

Can I get the ER Diagram and process flow of application ????
I've to add some more features for current version ...

Version FA 2.4.14
When modifying a journal the existing journal gets voided using todays date
/usr/share/webapps/frontaccounting/gl/includes/db/gl_journal.inc
$msg = void_transaction($trans_type, $cart->order_id, Today(), _("Document reentered."));

That causes a DB error in /usr/share/webapps/frontaccounting/includes/db/audit_trail_db.inc
function add_audit_trail($trans_type, $trans_no, $trans_date, $descr='')
Line 34

Example: the exiting journals transaction date is '2012-05-12' but the query tries to find a financial year for today and fails with error "Column 'fiscal_year' cannot be null". I am using the "demo" company with active financial year in 2012
"UPDATE 0_audit_trail audit LEFT JOIN 0_fiscal_year year ON year.begin<='2022-12-11' AND year.end>='2022-12-11'
SET audit.gl_seq = IF(audit.id=601, 0, NULL),audit.fiscal_year=year.id WHERE type='0' AND trans_no='53'"

For most other transaction types , the original transaction's date is used for voiding:
Example: /usr/share/webapps/frontaccounting/gl/includes/db/gl_db_banking.inc:
$msg = void_transaction($trans_type, $old_trans, $date_, _("Document reentered."));

Hi, Nice work!!!!

A installed this version of FA with a glance, but i have a problem when i want to switch languages for user in Setup=>User Accounts Setup. I unsuccessfully trying to switch between English, Slovenian and German language. All languages are installed and shown in installed_languages.inc. In my.ini i have activated sql-mode="".

I think that there is an problem with update table sql.

in config.php i enable audit trail
$sql_trail = 1; // save all sql queries in sql_trail
$select_trail = 1; // track also SELECT queries
because i am on win machine also enabled
$no_check_edit_conflicts = 1;

but the table 0_audit_trail is empty?!?

How to debug this update?

Thanks,
Rok

Hi,
it's me again. Now i started to work with translations. I have made some work on previous fa language files, and now merged it with new one(using msgmerge). So far so good, but i figured out, that some of the original(English) worlds is missing. So i cannot translate them.

Is there any procedure to add them to .po file?

Rok

p.s.
I will try adding new tags as shown in manual at the last post (.zip archive).
http://frontaccounting.com/punbb/viewtopic.php?id=6411

As on date, FA 2.4's reports do not display correctly as the path has back slash characters in part.
The forum has the Fix.
Replace line 759 of includes/current_user.inc:

return ($comp_path[0]=='.' ? $path_to_root.'/'.basename($comp_path) : $comp_path);

with

return $path_to_root.'/'.(in_array($comp_path[0], Array('.', '/')) ? $comp_path : basename($comp_path));

A separate FA PKG Repo has been created for the 2.4 branch. If you get an error message stating that there is some old Themes.gz file, delete it from the modules/_cache folder and try again.

The following screenshots list the Languages, Extensions, Themes and Charts currently available - some may not be up-to-date as yet to suit FA 2.4. Screenshots as of 2015-07-26.