[esteeven]

Hello

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.

Attachments:

1. 

   sql_import_error.png
   

[esteeven]

Hello

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.

[esteeven]

Ah. So the two issues are related. I’ll import the sql file later today and let you know how I get on. Thanks.

[esteeven]

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, 8 months ago by esteeven.

[esteeven]

Here it is.

Attachments:

1. tsp_invoices.zip

[esteeven]

I hope this is enough. Cheers.

[esteeven]

Hello
Sorry for the delay. Other things got in the way yesterday. I’ll get access sometime today and will do this.
Stephen

[esteeven]

I’ll attach it tomorrow. Thanks.

[esteeven]

Hello

mysql version = 5.7
php = 7.2

[esteeven]

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.

Regards

[esteeven]

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

[esteeven]

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.

[esteeven]

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.

Regards

[Author]

Posts