2,901

(5 replies, posted in Reporting)

https://frontaccounting.com/punbb/viewtopic.php?id=3688
https://frontaccounting.com/fawiki/index.php?n=Help.InstallUpdateLanugages
https://frontaccounting.com/punbb/viewtopic.php?id=6780

2,902

(1 replies, posted in Items and Inventory)

Setup -> Display Setup -> Show Item Codes: (Uncheck).

The corrections have been ported to the FA v2.4.1's module osc_orders.

Check the commits on this fork as well.

2,904

(22 replies, posted in Report Bugs here)

@joe?

2,905

(19 replies, posted in Setup)

The variable $use_date_picker is not in the config.default.php file in FA 2.4.1+.

2,906

(9 replies, posted in Announcements)

All fixes since release of FA 2.4.1 are attached herewith as of 2017-07-21.

All FA 2.4.1 extensions are at:
https://github.com/apmuthu/FA24extensions

The complete Vietnamese Install Language has been added to FAMods for FA v2.4.1.

2,908

(4 replies, posted in FA Modifications)

Approximately 16 bytes are necessary to store 25 decimal digit number (number of bytes length of 10^26 converted to Hex). Hence without changing the field size, you can store and retrieve the nearly 25 digit number when passed through Hex to dec conversion and vice-versa or have a trigger to do so in the database on the fly. USING a higher base than 16 would bring the field width down further.

2,909

(22 replies, posted in Report Bugs here)

From the same link:

You might want to use mb_send_mail(). It uses mail() internally, but encodes subject and body of the message automatically. Again, use with care.

The mb_encode_mimeheader() method is also listed.

2,910

(22 replies, posted in Report Bugs here)

The db collation (utf8_unicode_ci) is different from the connection collation (utf8mb4_unicode_ci).

Try some url encoding.

Use the quoted string format:
"psicopedagógico"@gmail.com

2,911

(154 replies, posted in Modules Add-on's)

We need to find equivalents in the reflines class for the functions in the old file.

2,912

(154 replies, posted in Modules Add-on's)

The file includes/db/references_db.inc was in FA 2.3.x but is not there in FA 2.4.x anymore.

2,913

(19 replies, posted in Setup)

Did you just swap the last part without wrapping any of the functions? If so we may need it to be as you described. There is no $use_date_picker at all in FA 2.4.1 as it is only a property in the user_prefs class.

Actually, the said function text_input is just defined in the extension with extra parameters and different order as well since a new parameter is at the beginning. It is not used anywhere in the extension. It is also not used in the dashboard_theme as well. We may consider removing this function in the extension. If this function gets used anywhere then the parameters and their order will affect such usage.

All instances in the core use the following construct:

$js = "";
if (user_use_date_picker())
    $js = get_js_date_picker();

@joe?

The original function in the core is used in the standard functions text_cells() and editor_view().

Committed in my FA24Extensions Repo.

2,914

(5 replies, posted in FA Modifications)

This is best "translated" in the .po/.mo files. They are translatable strings and not hardcoded.

Refer my commit of the en_US.po file for the default en_US.mo file

2,915

(22 replies, posted in Report Bugs here)

Try:

SHOW VARIABLES LIKE 'collation%';
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

If they are different, look in your /etc/[mysql/]my.cnf, find the contents below near collation_server:

[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_unicode_ci 
skip-character-set-client-handshake

2,916

(5 replies, posted in FA Modifications)

Take a backup and search and replace of the words you want (if they are unique) and then restore it in FA.

2,917

(22 replies, posted in Report Bugs here)

Make sure that the collation of the db is the same as that of the specific field(s) used here and that the said locale is installed in the OS (Linux).

2,918

(19 replies, posted in Setup)

The function text_input() is available in modules/dashboard/includes/dashboard_ui.inc and is executed first. Therefore when the same function defined in includes/ui/ui_input.inc gets executed later, the said error arises. Hence we need to modify the function in the latter file to be executed only if the said function is not defined as yet when it is executed. The code in the latter file at line 507 onwards:

function text_input($name, $value=null, $size='', $max='', $title='', $params='')
{
    if ($value === null)
        $value = get_post($name);

    return "<input $params type=\"text\" name=\"$name\" size=\"$size\" maxlength=\"$max\" value=\"$value\""
        .($title ? " title='$title'" : '')
        .">";
}

should be wrapped like:

if (!function_exists('text_input')) {
function text_input($name, $value=null, $size='', $max='', $title='', $params='')
{
    if ($value === null)
        $value = get_post($name);

    return "<input $params type=\"text\" name=\"$name\" size=\"$size\" maxlength=\"$max\" value=\"$value\""
        .($title ? " title='$title'" : '')
        .">";
}
}

2,919

(19 replies, posted in Setup)

Take latest Git Master or take the changed files from this post.

Dashboard is included in the FA 2.4.1. You may at best need the extension and make sure that the includes/dashboard.inc does not get overwritten or superseded. You can try to remove the old dashboard theme and extension first before upgrading and then install them afresh aferwards.

Do not forget to activate the dashboard for your specific company when logged in on the default company. When in the target company, make sure to enable ti for the access roles and permissions, logout, clear cache, close all browser instances and login again.

2,920

(3 replies, posted in Installation)

MySQL 5.7 may be the issue. By default the strict mode is on in MySQL v5.7 onwards. Hence all dates and timestamp fields no longer respect the 0000-00-00 00:00:00 values. Details are in this post.

PHP 5.6 too may have issues with array declaration syntax.

2,921

(5 replies, posted in FA Modifications)

The chart_master table is where you change the account name. The bank_accounts table is where you change the name of the Bank Account and it's assignment to the account in the chart_master table's account code.

2,922

(154 replies, posted in Modules Add-on's)

No. Just replace the said file with the one in the attachment above.

In the file at <web_fa_root>/modules/import_transactions/includes/import_transactions.inc,
Search for mysql_fetch_assoc
Replace with db_fetch_array

There is no need for any mysqli changes as the connection choice is automatic.

Among the top 50 posters as on date in the FA Forum, Canada leads with 6, followed by UK and USA with 5 and then by India with 4. Australia, Netherlands and Pakistan each have 3 posters in this list.

Caveat:
Some users may have multiple accounts (aliases) and from more than one country as well.

These stats would serve to enable users from those regions to follow these users posts and ask for targeted assistance possibly assuming they possess regional operational info and experience.

Check this post.