Search options (Page 13 of 244)

FA 2.4.11

MySQL v5.1 should be okay.

Try using {YY}-{MM}/{0001} so that it is sortable and properly incrementable.

Add .06 as shipping cost.

It appears that you have upgraded from FA v2.3.x to 2.4.x and in the latter, the reference number template has been expanded and does not follow the defaults of the older version.
As the Invoice number cannot be looked up or there is some hiccup in the debtors_master.

There is a duplicate of this translation string after typo correction that needs to be removed and the line number appended to the first one.

https://github.com/apmuthu/frontac24/commit/3934434612e12a8cfa9e9bb768b15d04ce445106#diff-465628ddde1c50a790501494b783e03db9b036aca42a922e5afe0c25396e5a3f

Sell Donation tickets.

My unofficial github repo is only for the extension files and fixes. Only the official extensions are supported in a default install.

The said link has been updated with alternative Internet Archive links for Singapore.

You can also refer my unofficial repo at:
https://github.com/apmuthu/frontac24
https://github.com/apmuthu/FA24extensions

0_grn_batch.delivery_date has a DEFAULT of 0000-00-00 which is acceptable in MySQL 5.x but in MySQL 8, a setting in the my.ini is necessary to override it's rejection.

A dumb solution would be:

SET sql_mode = 'allow_invalid_dates';

Alternatively in /etc/my.cnf, add the following:

sql-mode=ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION 

and restart MySQL.

References:
https://gokhan.ozar.net/blog/how-to-fix-incorrect-datetime-value-mysql-mariadb/
https://dba.stackexchange.com/questions/20638/dates-changed-to-0000-00-00
https://developpaper.com/problems-with-mysql-8-0-13-setting-date-0000-00-000000/

The Invoice Number alone should suffice as a GET parameter to get the other details from the FA Database and generate the payment link in FA as a QRCode. If all the details are to be provided, then it should be encrypted so as not to be atleast easily spoofable.

Also, the QRCode can be parsed for data or have a url encoded info that can be clickable.

On http call, a check if https exists and if so an appropriate https redirection in FA would be good.