Total_Price_Tax_Excl Is Not Valid

[rdas]

Hi,

 

after I confirm an order i get this error:

 

[PrestaShopException]

Property OrderDetail->total_price_tax_excl is not valid.

 

Shop has been running for over a year without any changes, there was no change made in code recently. With some products error appears, with others not. Even within the same product some product combinations are working and some not.

I have found out that if the "problem products" are 3pcs (or 6, 9, 12, 15....any number divisible by 3) in a cart then the order is OK, without error. Others amounts (e.g. 1pc, 10pcs, 22pcs.) ordered get the error.

 

Error is dependent also on the type of delivery.If it is "collect personally" then it is fine, if it is courier or post then error appears.

 

Shop is running online. It is currently in debug mode.

 

Thank you very much for your help.

Server information

Server information: Linux #111-Ubuntu SMP Fri Nov 6 18:18:09 UTC 2015 i686

Server software version: Apache

PHP version: 5.3.29

Memory limit: 256M

Max execution time: 120

Database information

MySQL version: 5.5.43-37.2-log

MySQL engine: InnoDB

Tables prefix: hlg_

Store information

PrestaShop version: 1.5.4.1

Shop URL: http://heligonky.sk.uvirt28.active24.cz/shop/

Current theme in use: stn_heligonky

Mail configuration

Mail method: You are using the PHP mail function.

Your information

Your web browser: Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.86 Safari/537.36

 

validation.html

MailAlert.php

Tools.php

[rdas]

I have also found that some products are working when they are ordered as an unregistered user, but do not work when they are bought as a registered user who has 5% discount. Price changed because of the “register“ discount so I guess there is a problem with rounding.

 

Another finding: problem products are those whose price withou VAT are periodic numbers.

 

price with VAT: 7.9€ 

price w/o VAT (assumed 20% VAT): 7.9/1.2 = 6,5833333333333333333333333333333

 

When I create new product and set first price with VAT (7.9€) on a product page then Presta calculates price w/o VAT 6.583333 , after saving a product it is rounded to 6,58.

 

Although price w/o VAT been rounded maybe it still makes some troubles at the end of order when validates.

Edited December 9, 2015 by rdas (see edit history)

[flo62134]

Hi !

Did you find a solution to your first problem ?

 

Thank you very much !

[rdas]

Hi, the problem was with an infinite periodic number. We have set rounding on 3 decimal places and everything go fine since then. But we still do not know why this have happened, we are not aware of any changes made to prestashop before the problem arise.