[ExpertGeeks]

I’m doing some invoicing today and the export to PDF isn’t working again. I get a blank white screen when I hit ‘Export to PDF’. There’s nothing written to si.log, or php.log since November when we last looked at this. Nor is there anything relevent written to the apache error.log or the mysql error.log. I have tried deleting tmp/pdf_tmp and although the directory gets created, there’s nothing written into it.

I tried using the default template too, so it’s not related to that. I’ve made no changes to the pound symbol settings in the interim. The only things that have happened in the interim are server updates and a reboot. The only folders written to recently are; public and tmp. public is empty.

Do you have any idea where I should look ?

[ExpertGeeks]

Ok, that’s great. Duplicating a database also throws this error.. but if that’s usual operation I’m reassured the database is in good shape. Thank you.

[ExpertGeeks]

The error is;

#1215 - Cannot add foreign key constraint

[ExpertGeeks]

Whenever I try to copy a database within PHPMyAdmin or import a database exported from SimpleInvoices, I need to uncheck;

Other options: Enable foreign key checks

Or the copy/import fails with the errors listed in import_errors.zip. I don’t know, is there something I’m missing ?

[ExpertGeeks]

Is there a way I can fix my database such that referrential integrity is restored?

[ExpertGeeks]

Yup, that’s got it! Cheers 🙂

[ExpertGeeks]

Can’t add attachment. Trying as a zip.

Attachments:

1. import_errors.zip

[ExpertGeeks]

Gah, the few minutes to edit a post is pretty frustrating..

I just wanted to add that print preview, and export to xls and doc are working.

[ExpertGeeks]

N.B. Pound sign issue resolved as I mentioned above. The pound sign was changed to � in Inv Prefs during the upgrade to 2020. It was correct in the 2019 versions. Manually changing it fixed that.

In answer to your questions;

1) Yes.
2) Yes and default has the same issue. I cannot generate a pdf with either. The error is;

Pdf::generate(): exception - Invalid input characters. Did you set $mpdf->in_charset properly?

• This reply was modified 4 years, 1 month ago by ExpertGeeks.

[ExpertGeeks]

We’re halfway there! I got the � instead of £ in Inv Prefs and amended that to £ which now shows the pound sign correctly in the print preview (shown in capture.jpg). Unfortunately, still unable to generate a pdf with the same error.
Apologies for the empty zip, forgot the recursive switch when zipping the directory. N.B. Same pdf problem regardless of template, default or eg-invoice

• This reply was modified 4 years, 1 month ago by ExpertGeeks.

Attachments:

1. 

   Capture-2.jpg
   

1. templates-1.zip

[ExpertGeeks]

Here you go;

localLocale = en_GB
localCurrencyCode = GBP
localPrecision = 2

• This reply was modified 4 years, 1 month ago by ExpertGeeks. Reason: add screenshot

Attachments:

1. 

   Capture-1.jpg
   

1. templates.zip

[ExpertGeeks]

I’ve also noticed that the date is in the wrong format too.. it should be 12/08/2020, not 08/12/2020.

Attachments:

1. 

   Capture.jpg
   

[ExpertGeeks]

I’d love to be able to edit the posts, but it is what it is 😀

I’ve now fixed up the template (with the assistance of the language file lang.php) and it shows the correct labels on all the fields of my invoice template (yay!).. but I still have � instead of £ in the print preview, despite having pound signs on the edit and view pages. I still get a blank page when I try to generate a pdf and the error;

[11-Nov-2020 23:47:26 Europe/London] Pdf::generate(): exception - Invalid input characters. Did you set $mpdf->in_charset properly?

in php.log

Help gratefully recieved ! Thanks.

[ExpertGeeks]

I compared to the default/template.tpl and replaced all the ‘unknown modifier’s. I can get a print preview to appear, although ‘Address:’, ‘Phone:’, ‘Mobile:’, ‘F.A.O’ and ‘Total:’ aren’t being generated and now appear as colons (If I recall correctly, I suspect these were changed in the language file).
Don’t know why ‘Address’ or ‘Total’ don’t appear as they’re the same, but Phone = Ph., Mobile = Mob., F.A.O = Attn.

The GBP pound sign has been replaced with �.
Also, I can’t output a PDF.. I’m getting;

[11-Nov-2020 20:26:16 Europe/London] Pdf::generate(): exception - Invalid input characters. Did you set $mpdf->in_charset properly?

in php.log

• This reply was modified 4 years, 1 month ago by ExpertGeeks.

[ExpertGeeks]

sorry, found it; utilDate

[Author]

Posts