Hello,

I'm updating my site from beta2 to the latest dev. and I seem to get this error when ever I try to checkout (after inputing the personal information (shipping, billing address and email fields).

here's the error:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'revision_id': INSERT INTO {commerce_customer_profile} (revision_id, type, uid, status, created, changed) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => billing [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 1312735930 [:db_insert_placeholder_5] => 1312735930 ) in drupal_write_record() (line 6776 of /var/www/vhosts/koziol.co.il/httpdocs/testsite/includes/common.inc

I'm at a bit of a loss at what to do here.

Comments

rszrama’s picture

rszrama commented

It's odd that your customer profiles aren't receiving valid revision IDs. A lot has changed since beta2, though. There are even some manual steps you had to take during the update process. Did you follow along through the release notes for beta3/4 and rc1?

rszrama’s picture

rszrama commented
Status: Active » Closed (cannot reproduce)

I don't suppose you still have problems here?

pachirulo’s picture

pachirulo commented

I've same exact issue, can you send some links of manual updates during process?? sorry I'm really new at drupal

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'revision_id': INSERT INTO {commerce_customer_profile} (revision_id, type, uid, status, created, changed) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => billing [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 1329250366 [:db_insert_placeholder_5] => 1329250366 ) en drupal_write_record() (línea 6884 de /home/toneles/public_html/includes/common.inc).