Search options (Page 116 of 245)

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.

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

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).

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.

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.

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.

Check this post.

Clear browser cache. State versions of PHP/MySQL and OS and make sure you have the latest GitMaster version of FA.

The latest version of XAMPP uses PP 7.0.x and 7.1.x. What versions of PHP/MySQL are you using? It is safe ti use FA on PHP version upto 5.3.x and MySQL upto v5.5 and some tweaks may be needed thereafter.

Also see if this post is helpful.

Just take a sql backup from within FA (hope it is version 2.4.1) and upload it somewhere and paste the link here.

The standard Chart of Accounts for de_DE language is at:
https://github.com/apmuthu/FA24extensio … eneral.sql

Thanks for the explanation and the edge case. Rather than use PHP to compute the last day of the financial year, it might be prudent to use the MySQL function:

SELECT DATE_SUB(DATE_ADD('2015-03-01', INTERVAL 1 YEAR), INTERVAL 1 DAY)

which will yield 2016-02-29.

Similarly

SELECT DATE_SUB(DATE_ADD('2016-03-01', INTERVAL 1 YEAR), INTERVAL 1 DAY);

will get us 2017-02-28.

Also, how did it affect the JOURNAL entries alone?