Forum Replies Created
Sorry but illness got in the way of doing this. I have just tried to import the sql table and got the message in the attached screenshot. Is this normal?
Many thanks for your help and patience with this.
I’m going to leave this change for a week. I’m away for a few days and if something goes wrong, I won’t have time to fix it or seek a solution before I go away. The SI user is able to “function” for another week without the missing functions.
I’ll report back (with positive results!! 🙂 ) in a week.
Thanks for your help.
Ah. So the two issues are related. I’ll import the sql file later today and let you know how I get on. Thanks.
No response data available for this request
I was just looking at the tables in phpMyAdmin and I can’t see a reference to table id=si-data-table : this is referenced in the error message.
DataTables warning: table id=si-data-table – Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
Is this a missing table?
It’s the same zip file .sql as for my other issue.
- This reply was modified 4 years, 1 month ago by esteeven.
I hope this is enough. Cheers.
Sorry for the delay. Other things got in the way yesterday. I’ll get access sometime today and will do this.
I’ll attach it tomorrow. Thanks.
mysql version = 5.7
php = 7.2
Thanks for getting back to me.
My initial issue with my old install of SI was PDFs stopped working. I installed your latest current version and that’s when I noticed the currency symbol issue. PDFs printed fine.
I tried the _beta version, as suggested and hit lots of error messages with patching MySQL (see my earlier post in this thread.)
I returned to the latest current version as the production of PDFs is a pressing invoicing issue.
Obviously, having the £ symbol throughout SI would be an aesthetic improvement. The £ symbol appears on the invoice itself so I’m not being paid in dollars : though that might be better in the coming months as the £ falls in value compared to the dollar 🙁
Having read what you said, I hoped that changing the local.locale setting in my custom.config.php file would fix this slight issue. The changes you suggest (to en_GB etc.) are there but so is the $ sign.
Am I missing something?
I can’t return to _beta as there is a warning about production use. I think I have lost my .zip of 2019.2.1 – 20190613 – but that doesn’t work because of the patch issue.
I just uploaded a change that uses the local.locale setting in the custom.config.php file to format the amount fields in the invoices and payments lists. I believe this will address the issue you pointed out.
Can I add this local.locale setting to the custom.config.php Master_2019? If so, what is the setting?
Regards and thanks
I’m so sorry for the delay in getting back to you on this. I realise that not getting feedback for changes you make must be really irritating 🙁
I am trying to use this version but I am getting errors when trying to use the new version.
Patches up to #307 work but after that there is a failure for #308 – #318.
How do I apply these patches? The [update] button does not work.
I get this error:
SqlPatchManager::runSqlPatch() error. See error log for more information.
Thanks for replying. Unfortunately, what you suggest has already been done.
The currency symbol is set, as are the language and the locale.
The invoice itself is fine and show £.
It’s the invoices listed in [money][invoices] that show $ in the list of invoices. This is what I wish to change.