Invoice showing incorrect totals

Hi there,
I just installed the app and I was really amazed by it and thinking would solve all my needs so I'm in the process of moving my old expenses etc and see if I buy the extra apps like strip payment to make the tool as good as the one I'm using at the moment but.


When I create an Invoice the item total and the subtotal just ads crazy numbers. If my item is 450€ then when the invoice is created it shows €4.500.000,00.

the total of the invoice will show 450 correctly but obviously, there is an issue here as this is not a valid invoice. Any idea where could the problem be?.

thanks

Here a screenshot of what I mean:
https://prnt.sc/vtgtwd

I added more info to other similar topics.
My currencies ad a bunch of 0 on the exchange rate on their own (so exchange is not 1 is 1.0000000) I can not change this and when I do the system ad them back.

I tried to change the . and , meaning (decimals and thousands) on the currencies this worked only when the amounts are full numbers and decimals are 00, otherwise, the invoices add two extra 00 to the total.

I'm quite lost in here and I don't think this is a problem from the uses side but from the software side.
Any help would be appreciated. Thanks

You can check the following topic:

https://akaunting.com/forum/discussion/development/double-read-as-integer-prices-multiplied-by-10000

Just did,
I got in tich with the hosting and seems that MySQL Native Driver should be already on so that is not the problem. I'm using MySQL Version 10.3.24-MariaDB-cll-lve

Solved.
As Stan pointed: I needed to disable pdo_mysql and enable nd_pdo_mysql.

Thank you for the support, the tool looks great, looking forward to test it and get some extensions ;)

Glad to hear you solved it, enjoy ;)

Hey.. so bad news.
The currency extra 00000 was sorted but this still gives issues on the invoice.
I have a currency that exchange is 1 with a precision of 2 (i need it as I do not work with closed amounts) so now the issue is as follows:

If the thousand separator is . and the decimal , :
The currency exchange doesn't allow me to put 1,2 (only using the .)
When I ad a nee item to the invoice if it's a closed number (for example 450,00) no problem but does not allow me to add for example 79,41 because the system ads two 00 at the end and does not take my "," as my decimal transforming it in 7.941,00 €

I'm quite lost at this point. and as I have seen this seems to be a general issue around self-hosted installs.

Why do you use '.' for thousand separator? Use '.' as decimal and ',' as thousand separator from setting->currencies->edit as default.

To try to solve the issue Kamal the currency is shown 1.1 not 1,1 and I could not change it as I mentioned above. Neither the default
Anyway, I gave up so in any case, I'm using something else now as there was no way to make it work.