[RRowley]

Couple of questions:

1) In the INV PREFS currency sign field, did you set the sign by entering this code: & # 163; (spaces suppressed)?
2) Are you using the eg-invoice template from the zip file?

I’ve done both these, set same values as you in custom.config.ini and set en_GB as Language and Locale fields in the INV PREFS. Using this both the default and the eg-invoice templates work correctly.

• This reply was modified 4 years, 5 months ago by RRowley.
• This reply was modified 4 years, 5 months ago by RRowley.

[RRowley]

The templates.zip file is empty. Also, access the Inv Pref Invoice records in edit mode and give me that screen shot.

[RRowley]

Can you zip and attach the template directory? Then I can test what you have. I need an image of your INV PREFS for Invoice record and the custom.config.ini settings for: localLocale, localCurrencyCode & localPrecision.

[RRowley]

In tpl files use urlSafe and htmlSafe with this letter case.

[RRowley]

Fixed in latest update.

[RRowley]

Looked into it further and find this list of special characters to avoid with the associated explanation:

Note that these special characters are must NOT be used in the key and have special meaning in the value: ?{}|&~!()^”

[RRowley]

Never tried a curly brace special character. I use a # and it works fine.

[RRowley]

Fixed in latest update.

[RRowley]

This is a multi-use table. The value field in the database is varchar(60). The PHP function that retrieves the data returns a type int value. 0 or 1 meet this qualification. Or at least that is for my development and my production systems. My development system is Win 10 using xampp. My production is a hosted LAMP web service. Both are at the 7.4x PHP version.

There is no strict_type declaration in SI, therefore as long as the value being returned begins with a number (at least as I understand it), the number will be converted per the type declaration. So if the value in the database is 0 or 1, or even “0 ” or “1 “, it should be converted to the correct int and no type error thrown.

Bottom line, I am not sure why you are having an issue.

[RRowley]

Just upload changes to fix path references for images. Please download and let me know if it works OK.

[RRowley]

The si_system_defaults record with the NAME of “delete” should have a value of 1 or 0. I recommend you manually set it to 0 (aka false) before running the update. Then you can set it via SI after the update if you want to enable the ability to delete invoices from the database.

[RRowley]

Check the Version Update Process link on the left. It has specific instructions for update from master_2019.2 to master_2020. Your problem is like that you did not run the si2020Converter.php program to convert your custom.config.php to custom.config.ini. This would account for not being able to connect to the database.

Please keep me informed of your progress and anything that you find unclear or confusing with this upgrade.

[RRowley]

Update to the master_2019.2 version.

[RRowley]

Which version of xampp are you on? What version of SI are you on (see version and date in the config file.

[RRowley]

I’m at a loss since I can’t replicate this. I’d like info from your setup to see if it is something I can set up and replicate.

1) Verify you are on the most current SI version, 2019.2.30 / 20200805 (in custom.config.php).
2) custom.config.php settings for local.locale, local.currencu_code & local.precision.
3) In INV PREFS (in Settings), for the Description “Invoice”, what are the settings for Currency Sign, Currency Code, Language and Locale?

[Author]

Posts