Hi folks,

While testing the checkout process with the marketplace module I ran into the following problem. Upon initial submission of the checkout form, Drupal reported an issue with the credit card. Upon resubmission of the checkout form, I got a white screen and the following error was logged in the DB:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '23-22' for key 'PRIMARY': INSERT INTO {mp_quote_shipping_rates} (uid, order_id, rate) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 23 [:db_insert_placeholder_1] => 22 [:db_insert_placeholder_2] => 22 ) in mp_quote_uc_order() (line 397 of /var/www/sites/all/modules/contrib/ubercart_marketplace/mp_quote/mp_quote.module).

So it looks like resubmitting a checkout form may require the function mp_quote_uc_order to check first if the form was submitted previously and therefore run an update or nothing at all. Has anyone run into the same problem?

Regards,
Mitch

Comments

bearstar’s picture

bearstar commented

Yes, just experienced the same thing with test gateway. Did you ever find a way around this?

sadist’s picture

sadist commented
Issue summary: View changes

I am also encountering the same kinda problem.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '5-3' for key 'PRIMARY': INSERT INTO {mp_quote_shipping_rates} (uid, order_id, rate) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( [:db_insert_placeholder_0] => 5 [:db_insert_placeholder_1] => 3 [:db_insert_placeholder_2] => 92 ) in mp_quote_uc_order() (line 397 of /home/www/modules/ubercart_marketplace/mp_quote/mp_quote.module).

And for payment, I only enabled these modules:
Payment
Payment method pack
Credit card
Test gateway

Is there any solution yet? Don't other people have this problem?