[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?

[RRowley]

The content of the si_invoice_item_attachments table should be empty. So DROP it, then try accessing SI again.

[RRowley]

The 500 error is most likely due to you system not being properly set up. Did you have a previous version of SI running or is this a new set up? What is the webserver package you are running? Is this a Linux or Windows system?

If you were running a previous version, can you restore to it and run correctly?

[RRowley]

First, make sure you have loaded the most current version of master_2019.2. Then, go to Settings, Inv Prefs and select the preference (probably Invoice) that you have to the invoices, quotes, etc. displaying incorrectly.

In that setting, click on the Help for the Currency Sign. Copy and paste the HTML code for the Pound currency sign to the Currency Sign field. Next put GBP in the Currency Code field. Then at the bottom of the screen set by Language and Locale to en_GB. Save these settings.

I’ve tested this and it does put the pound sign on all currency fields including the Owing at the bottom of the screen.

[RRowley]

You need to upgrade your SI version. Check out the Version Update Process topic on simpleinvoices.group.

[RRowley]

You need to use the html currency code for pound. This is explained in the help for the field settings in the Inv Prefs records. See attached picture.

Attachments:

1. 

   CurrSignHelp.jpg
   

[RRowley]

Check the tmp/log/php.log file for additional information. If info present, please zip it and attach to a replay to this message.

[Author]

Posts