Issue Queues

After updating to the latest drupal core I'm getting the issue as per below error display, when adding a product in the cart as anonymous user or as admin (the only registered user at the moment).

I've noticed a similar issue with commerce_order was reported some time ago: http://drupal.org/node/1204210
But there is no solution to the issue outside tweaking with the database.
I'll try to do that, but I was wondering if anybody else experienced the same issue upgrading commerce to latest drupal core.

Needless to say that this issue is now blocking the webshop as no normal user can post an order.
Luckily we are in beta, but I need to fix this ASAP.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'commerce_order-9-0-0-und' for key 1: INSERT INTO {field_data_commerce_order_total} (entity_type, entity_id, revision_id, bundle, delta, language, commerce_order_total_amount, commerce_order_total_currency_code, commerce_order_total_data) 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, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8); Array ( [:db_insert_placeholder_0] => commerce_order [:db_insert_placeholder_1] => 9 [:db_insert_placeholder_2] => 74 [:db_insert_placeholder_3] => commerce_order [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => GBP [:db_insert_placeholder_8] => a:1:{s:10:"components";a:1:{i:0;a:3:{s:4:"name";s:10:"base_price";s:5:"price";a:3:{s:6:"amount";i:0;s:13:"currency_code";s:3:"GBP";s:4:"data";a:0:{}}s:8:"included";b:1;}}} ) in field_sql_storage_field_storage_write() (line 448 of /home/shop/modules/field/modules/field_sql_storage/field_sql_storage.module).

I'm implementing a payment gateway module which works fine as long the authorization is successful.

To route the callback from the credit card company I've set-up a success and a failure link as described in http://drupal.org/node/1040318.

If an authorization is accepted it redirects to

However if the authorization fails, non of the callbacks described in commerce_payment.api.php is called. The user is silently redirected back to the checkout page.

How can I do custom processing when the failure back link is called from the credit card company? I want to show the error message from the credit card company to the user.

For now I found this solution. But I don't think that it's really the intention doing it that way:

I implemented hook_commerce_checkout_router to get a hand on the data sent from the credit card company, store it in the $_SESSION variable and check in CALLBACK_commerce_payment_method_submit_form whether there's something stored in $_SESSION.

This is my code:

How should this be implemented in a clean way?

Currently there is no label callback for customer profiles:

So let's have a callback in Commerce that returns the "thoroughfare" value (street, basically) of the address.

This is a followup on #1427144: Notice: Undefined index: revision in commerce_product_product_form() (line 77

Like the title says, when the default value for a product type is to create a new revision, the revision fieldset should be expanded, so that it's visible for admins that a new revision is being made.

Hello:

I have been trying to get rid of this bug for three days with no luck. It all begun when I run modules update via Drush. This triggered massive errors all over the place, from issues with paths (Unsupported operand types in path to "Store") to other kind of EntityMetadataWrapperException errors. It appears this error was introduced by one of those updated modules at random. (I suspect Entity API and Entity Reference are somehow the guilty ones) I slowly worked out all of them, but this one isn't going away. And it is killing me as it is keeping me from starting generating the final feature exports I need for the production server .

Shop Staging: In very advance stage of development (Almost ready to export features, build platform. 60 products, 30 product attributes with images, custom HTML5 widgets, 9 wholesale account types, retail, Quickbooks integration, etc) Renistalling core Drupal Commerce is propably impossible at this stage.

Versions

1. Drupal Core: 7.x-dev
2. Drupal Commerce: 7.x-1.x-dev
3. CTools: 7.x-1.x-dev
4. Entity API : 7.x-2.x-dev
5. Rules : 7.x-2.0+15-dev
6. Views : 7.x-3.x-dev
7. Address Field: 7.x-1.x-dev

Other System Info:

• Multi-site set up (3) thorugh right now working on the master one from which I will spawn the Featues for the smaller sites
• Uses Entity Reference often: 7.x-1.x-dev
• Using UUID: 7.x-1.x-dev
• Originally this was a site started with Commerce Kickstar profile back in June. Because I am building a custom profile for this project, at one point I side-graded to a standard Drupal install so I could have a clean "profiles" folder.

THE ERROR

Note: In case it matters (which I doubt), I posted the error as it was printed in both the page and the log, which it includes three massive blank space gaps between the last three lines. To save space for this post I added "[BLANK SECTION]" manually instead.

Where the errors happen:

1. Front Page or any page with views that uses product content type
2. Views administration as an AJAX error when trying to work with a view that has product content types in it.
3. When running cron either via UI or Drush

Solutions tried:

I followed some of the solutions being suggested by rfay and DC crew :

• I tried the Commerce Repair. Many times, though rfay did explain somewhere that Commerce Repair only works well with DC's core modules. In my case, it did not repair anything at all.
  http://drupal.org/project/commerce_repair
  http://drupal.org/node/1107788#comment-4964956
  http://www.drupalcommerce.org/node/1008#comment-2164 )
• I tried clearing the Entity Info Cache via Devel using entity_info_cache_clear(); every time I tried anything.
  http://drupal.org/node/1316834
• I did find a couple of test orders stuck in the admin, and as suggested by doug over here below, I deleted them. It did clear up most of the other EntityMetadataWrapperExceptions, BUT not this one. I also deleted a Commerce Order fee that was left over from these trassactions.
  http://drupal.org/node/1411032#comment-5506764.
• Based on a comment I cannot find now, I also used Registry Build often via Drush.
  http://drupal.org/project/registry_rebuild.

Since I have this whole thing seriously backed up, I tried a few things a little bit on "wilder side" , not so much to find a solution but to see if they could point me out towards the culprit:

• I tried reinstalling both the Commerce Product Reference and Commerce Line Item using Devel and as expected, it triggered massive errors. Restored from back up.
• I tried to manually compare an older database with a copy of the latest version using the SQL schema version as exported by Schema, but I did not see any major differences in table structure.
• Checked the System table for misconfigured paths, disabled items (0) and the such, but I found nothing out of order.

Closing Oddities

• Checking my schema structure I found at least 27 fields (Field_SQL_Storage) that have mismatching entries, two per field. I doubt this would be in any way related as none are critical and they were already there before all this happened. All 27 fields have the exact same error.
  Example:
  indexes field_dyb_fabric_1_target_entity: missing in database
  indexes field_dyb_fabric_1_target_id: unexpected (not an error)
• I installed and uninstalled some minor modules that I had tried in the pasr and perhaps I forgot to uninstall prior to removing them from contrib: Commerce Coupon, Commerce Product Bundle. I read a couple of comments indicating these modules had some issues when not properly uninstalled. They all checked out and had been uninstalled properly.

If there was one time in the last 3 1/2 years that I have been truly of the edge as far as needing some assis, this is the one.

Thanks

* place an order, in my case with payment method commerce_cheque (but any should give this error)
* mark the cheque as paid
expected
* hook_commerce_payment_order_paid_in_full() should fire and (in my case) change order status
experienced
* hook does not fire

(wow, this was a nasty bug to track down...)
* payment changes $transactio->status from pending to success
* DrupalCommerceEntityController::save fires hook_commerce_payment_transaction_update() before it clears entity cache.
* So commerce_payment_order_balance($order) loads the old $transaction which is still pending
* order balance is calculated wrong
* and hook not fired

see attached patch:
hook invocation should come after cache update.
i think it should also come after releaseLock() - but a DrupalCommerceEntityController guru might consider this.

This might sound a bit silly, but even though the addressfield is called addressfield, you don't actually have to use it for storing addresses, you can limit it to storing name and/or company name. It happened to fit my use case, since I don't need to store addresses during checkout I thought it was easier to just use it for storing the name which I did need.

Doing this I've found this strange bug, that I'm guessing has something to do with the way customer profile saves the address. I remember that some strange things are going on there.

Anyways the actual bug is that if you don't have the address part enabled in the address field, the addressfield won't actually save the name. What's worse is, that is a name is already stored (temporarily turning the address on, entering data, turn address off and go back), the name will be deleted if the form is submitted again.

So clearly something whacky is going on.

Ryan do you have any hunches, been a long time since I looked at the customer profile and addressfield interaction.

Is there any way to abbreviate the output of the state fields? In other words, make Rhode Island display as RI or Maine display as ME?

NOTE: Using Views 7.x-3.1

Not sure what's happening here, but I have attempted to use the In Cart block view to provide a block across the store I am working to indicate the number of items the user has in their cart (a pretty normal implementation of this feature I believe).

I've added screenshots below depicting the scenario.

The Items in Cart is placed as a block at the top of the content and is available on all pages.

Prior to placing any items in the cart the block doesn't show or indicate any items in the cart.

After placing any item in the cart, the total reflected in the block doesn't change.
After removing items from the cart, the total reflected in the block doesn't change.
Emptying the cart still shows the same number of items in the cart.

I'm baffled... could this be a bug in the commerce and/or views modules?