After upgrade from Drupal 5, ecommerce 3.6
Anonymous buyer, Generic product, EC_PaperPayment payment

user warning: Duplicate entry '0' for key 1 query: INSERT INTO ec_transaction (ecid, type, mail, payment_method, allocation, workflow, shippable, gross, allocated, balance, created, changed, duedate, token) VALUES (6, '', 'a@b.ru', '', 0, 1, 0, 0, 0, 0, 1260773080, 1260773080, 0, '') in /home/myusername/data/www/mysitename.ru/includes/common.inc on line 3468.

insert into ec_transaction and into ec_transaction_product
txnid = 0, always!!!

Comments

Soren Jones’s picture

Soren Jones commented
Title: Cannon chechout » Duplicate entry '0' for key 1 query in common.inc on checkout after upgrading from D5 to D6

Updating title. See also #683566: Duplicate entry '0' error when returning to site after paypal transaction..

NikolajNikitin29’s picture

NikolajNikitin29 commented
Title: Duplicate entry '0' for key 1 query in common.inc on checkout after upgrading from D5 to D6 » Re:

Недорогая раскрутка сайта с гарантией