VirtueMart Forum

VirtueMart 2 + 3 + 4 => Administration & Configuration => Topic started by: WVQ on February 15, 2012, 12:21:42 PM

Title: ORDERS: Items are duplicated and triplicated!
Post by: WVQ on February 15, 2012, 12:21:42 PM
Hi,

All orders have all items duplicated or triplicated and I don't get to find out why. The Subtotal and Total fields are correct, duplicated items have not been added to the total amount (see pic attached).

Something not set up correctly or a bug?

J1.7.5 and VM2.0.1f

thanks in advance for your help.






[attachment cleanup by admin]
Title: Re: ORDERS: Items are duplicated and triplicated!
Post by: WVQ on February 28, 2012, 12:12:15 PM
Hello,

could somebody help me please.

Construido sobre PHP    SunOS localhost 5.10 Generic_139556-08 i86pc
versión Base de datos    5.0.91-log
Cotejamiento base de datos    utf8_general_ci
Vesión PHP    5.3.8
Servidor Web    Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8r
Interfaz WebServer de PHP    cgi-fcgi
Versión Joomla!    Joomla! 2.5.1 Stable [ Ember ] 2-Feb-2012 14:00 GMT
Joomla! Versión de la Plataforma    Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent    Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20100101 Firefox/10.0.2
Title: Re: ORDERS: Items are duplicated and triplicated!
Post by: TITUS8 on February 29, 2012, 15:43:21 PM
I found, by experience, that if you make an item/product, when you hit the save button, be patient, If you happened to have triple clicked the save button it will duplicate the item on the data base.

Recommended: If this happens you may want to enter through phpmyadmin, and find the duplicate errors and simply delete the tables unwanted. take note to the "ID#" of the ones you want to keep, and/or delete....

I use english, so the database table is: jml_virtuemart_products_en_gb

virtuemart_product_id 1 (example product) <-- Keep
virtuemart_product_id 2 (example product) <--delete, duplication
virtuemart_product_id 3 (example product) <--delete, duplication

above should not affect the original product...

Optional: You may also be able to simply delete through the VM2 manager, but watch the ID# to make sure not to dete the one you wish to keep, sometimes it may delete all 3, then you would just have to retype...


hope this helps...