@joe: can this be done in the core with a sys_prefs flag for now?

Wiki-ed.

678

(1 replies, posted in Translations)

Read the Wiki.

You will need a custom extension done for this as it is not available in the core.

680

(5 replies, posted in Accounts Receivable)

Changing the primary keys of the respective tables and re-ordering them is possible but must be done carefully or through a separate script / extension.

Please make sure you have tested with the Git Master which has the post release fixes too. The file includes/ui/allocation_cart.inc was updated on these dates:

2020-03-18 (after FA 2.4.8 was released)
2020-01-11
2019-12-26 (after FA 2.4.7 was released)
2017-11-10 (before AF 2.4.6 was released)

FA 2.4.8 was released on 2020-02-05
FA 2.4.7 was released on 2019-06-25
FA 2.4.6 was released on 2018-12-18

@joe: is this desirable for certain restricted tables or can it be taken into the core? Will possibly need to change the permissions in the chart sqls as well.

Make sure you have a valid domain in your /etc/hosts (Windows: C:\Windows\System32\drivers\etc\hosts) for 127.0.0.1 along with localhost (space separated or on a new line with the said IP)

Then the valid domain in your php.ini and the changes to your php script should work fine provided your DNS SPF entry is okay for the IP you will be dishing out.

684

(20 replies, posted in Report Bugs here)

@itronics commit should fix it.

Although the specific rep301.php has not changed in the meanwhile, some functions it directly / indirectly uses may have been changed post release in other files. No harm in putting in the post release changed files - it does not change the db in any manner and any missing sys_prefs variables entries will get auto populated. Then see if the situation changes.

686

(20 replies, posted in Report Bugs here)

Please try the attached fix on both PHP 7.4 and PHP5.x as well.

@joe: please verify and take in the fix into the core ensuring backwards compatibility.

687

(20 replies, posted in Report Bugs here)

An example of curly brace correction is available in another project's commit.

A migration script to automatically make these changes is here.

This is an issue since 2008 when both square and curly brackets were used interchangeably for arrays and string elements though it was the intention to sue them for separate purposes as explained at:

https://wiki.php.net/rfc/deprecate_curly_braces_array_access

Though currently in PHP 7.4, only the square braces can be used to initialise arrays and also assign to them values, the curly braces can generally be used everywhere else where the square bracket is used.

Other threads elsewhere that refer to this problem are at:
https://github.com/squizlabs/PHP_CodeSniffer/issues/2558
https://stackoverflow.com/questions/59158548/array-and-string-offset-access-syntax-with-curly-braces-is-deprecated

688

(3 replies, posted in Reporting)

Try tags for the specific Artisan instead of treating them as salespersons so as not to confuse with counter salesmen. The Artisans could be a profit centre, maybe even a Dimension instead too.

@joe: any SOP for this in FA?

Check if this was a server time zone issue at the time when you tried it. This is a very old thread. Hope you have all the post release fixes in your install. Also a latest change was reverted to await v2.5 but is in mt FA24Mods folder (2019-06-24).

690

(0 replies, posted in Installation)

If you install FA on a platform running MySQL >= 5.7, chances are that the defaults will conflict with FA and cause errors.

Here are some useful links to sort these issues out:

https://www.tutorialspoint.com/how-to-disable-only-full-group-by-in-mysql
https://stackoverflow.com/questions/23921117/disable-only-full-group-by
https://riptutorial.com/mysql/topic/8245/error-1055--only-full-group-by--something--is-not-in-group-by-clause----

You can also download a free MySQL book (2 MB) too.

@x-roast: Kindly share your workaround for peer review to ensure that you are on the right track.

I do not understand what you mean by "entered an arrested client with all the debts". Kindly contact your country users with sufficient experience (if classified by number of posts) like:
@almohasb
@abozeed
@AsimACC
@JavaMan
@Mahmoud Ali

@joe: An alert in both instances before acceptance stating the possible ambiguity may be in order.

How did you "collect all dues"? A Journal entry or by debit note? Only latter is allocatable to the due invoices.

Which version of MySQL / PHP are you using? Later versions of MySQL may prevent blank value for salesman not to be taken as NULL and may wrongly insist in a NOT NULL field definition (with a default of 0) and strict mode enabled in the MySQL settings.  See that there is atleast one entry in the "0_salesman" table and make sure that is chosen for the new company's default salesman.

CREATE TABLE `0_cust_branch` (
...
...
`salesman` int(11) NOT NULL DEFAULT '0',
...
...

The counter value is in the file config_db.php where the variable $tb_pref_counter should refer to the next available array element.

The command to set the auto increment field correctly (self-adjusting) at the end would be:

ALTER TABLE <table_name> AUTO_INCREMENT = 1;

but in FA, there is no "Company" table.

Creation of the DB would require additional privileges that the FA's DB user should have atleast for the duration of the install. Use phpMyAdmin / SQLyog / MySQL Workbench or some such MySQL client tool or just operate from the hosting control panel or the SSH terminal if you have access. Otherwise contact your hosting provider.

What platform are you having your FA hosted (Webserver / PHP / MySQL / OS) and their versions and what privileges and skills you have in manipulating them? If you are handicapped in the above skills, then take professional assistance providing a bounty on the Job Offers board.

Thanks @cedricktshiyoyo for the use case and @joe for the quick update.

Updated Post Release Fixes.

Check if the attachment is what you need.

@joe: if acceptable, it can be placed with a checkbox in the filter fields to achieve this feature.

Try making the "Only Balances" option to "Yes".