VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: Guy-How on January 30, 2014, 13:43:17 PM

Title: Deleted product appearing on every order
Post by: Guy-How on January 30, 2014, 13:43:17 PM
Hi,
I have an odd problem that whenever an order is created, an extra product is added to the order.
The added product no longer exists in VM and I have removed all other extra plugins/Modules/components etc.
I have cleared all caches and tmp directories, and had a developer look at the database and remove all references to the product.
It is creating problems with checkout, as the totals don't match.

Here is an extract of the logfile

The error message is:

2014-01-22 15:41:35 ERROR

Line:262 Error getting Form Fields: Order total (348.00) and sum of item rows (558) do not match within precision (0.02)


There are two products in the cart:

Items:
   item[0]
     name:      Karl Höfner Conservatoire-sarjan 3/4-viulusetti
     qty:       1
     unitPrice: 210.00
     vatClass:  24.00
     sku:       AS-160-V 3/4
     type:      1
     discount:  0
   item[1]
     name:      Karl Höfner kiinalainen 4/4-viulusetti AS-260-V
     qty:       1
     unitPrice: 348.00
     vatClass:  24.00
     sku:       AS-260-V 4/4
     type:      1
     discount:  0


1 x 210 + 1 x 348 should be 558 euros. Just like the "sum of item rows"
calculated by the payment moduel is.

But for some wierd reason VirtueMart says that the order total is 348 euros. Then the payment module has no option but to throw an error message, because its own calculation and VirtueMart's calculation don't match.


in this case, the first product was never added to the cart at all. AS-160-V 3/4 Just appeared in the backend, and on the order view in VM the price has a strikethrough.
This is most odd indeed.

Removing this product from VM And the database does not help.

Any thoughts? Help much appreciated!

Best regards,
Guy

VM 2.0.26d
Joomla! 2.5.17

PHP Built On    Linux
Database Version    5.5.32-31.0-log
Database Collation    utf8_general_ci
PHP Version    5.3.28
Web Server    Apache
WebServer to PHP Interface    cgi-fcgi
Joomla! Version    Joomla! 2.5.17 Stable
Joomla! Platform Version    Joomla Platform 11.4.0 Stable

dbtype    mysqli
Title: Re: Deleted product appearing on every order
Post by: Milbo on January 31, 2014, 03:16:55 AM
Unbelievable. Link?
Title: Re: Deleted product appearing on every order
Post by: Guy-How on February 04, 2014, 09:18:19 AM
Hi Milbo,
The site in question is
www.howviolins.fi
If you would like to see the issue in the backend I can PM login credentials

Best regards,
Guy