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,901 07/09/2017 02:11:30 am
Re: font report (5 replies, posted in Reporting)
2,902 07/09/2017 02:02:51 am
Re: erorr direct invoice (1 replies, posted in Items and Inventory)
Setup -> Display Setup -> Show Item Codes: (Uncheck).
2,903 07/09/2017 01:58:11 am
Re: osCommerce Order and Customer Import Module (8 replies, posted in Modules Add-on's)
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 07/08/2017 04:16:10 pm
Re: Yet another problem with utf-8 (22 replies, posted in Report Bugs here)
@joe?
2,905 07/08/2017 04:14:35 pm
Re: reminders in 2.4 (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 07/08/2017 05:20:33 am
Re: Release 2.4.1 (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
2,907 07/08/2017 05:14:40 am
Re: Vietnamese Translations added to FAMods (1 replies, posted in Translations)
The complete Vietnamese Install Language has been added to FAMods for FA v2.4.1.
2,908 07/08/2017 04:23:04 am
Re: COA with 25 digits (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 07/08/2017 04:16:39 am
Re: Yet another problem with utf-8 (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 07/07/2017 05:50:34 pm
Re: Yet another problem with utf-8 (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 07/07/2017 05:40:30 pm
Re: Import Transactions (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 07/07/2017 02:06:52 pm
Re: Import Transactions (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 07/07/2017 01:31:37 pm
Re: reminders in 2.4 (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 07/07/2017 12:46:46 pm
Re: Bank account types (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 07/07/2017 12:43:45 pm
Re: Yet another problem with utf-8 (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 07/06/2017 01:51:21 pm
Re: Bank account types (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 07/06/2017 01:47:35 pm
Re: Yet another problem with utf-8 (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 07/04/2017 04:04:30 pm
Re: reminders in 2.4 (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 07/04/2017 01:35:20 am
Re: reminders in 2.4 (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 07/03/2017 04:24:01 pm
Re: WAMP error in second server action (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 07/03/2017 04:19:36 pm
Re: Bank account types (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 07/03/2017 10:25:51 am
Re: Import Transactions (154 replies, posted in Modules Add-on's)
No. Just replace the said file with the one in the attachment above.
2,923 07/03/2017 10:24:00 am
Re: Importing Multiple Line Journal (5 replies, posted in Accounts Receivable)
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.
2,924 07/03/2017 05:29:35 am
Topic: FA Posters Country Stats (0 replies, posted in Misc. Charts of Accounts)
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.
2,925 07/03/2017 04:25:22 am
Re: Importing Multiple Line Journal (5 replies, posted in Accounts Receivable)
Check this post.