Products that are part of product kits prevented the updates working with VBO batching enabled. Without VBO batching, they caused a PDO exception when partial updates encountered a product included in a product kit.

Original post:
This module no longer seems to work for bulk updating prices. Tried it with 7.x-1.1 and 7.x-1.x-dev. Views and VBO have been updated several times since the last time it worked on this site. It's apparently a problem with VBO batch processing in relation to this module.

Action: Update price, absolute, Select all items on this page (same results with Select all items on all pages)
Result: 42 of 50 on 1st page updated, then AJAX error. On later pages, even fewer updated before the error occurs.

Error message:
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=10992&op=do StatusText: Service unavailable (with message) ResponseText:

Error page message:
An error occurred while processing views_bulk_operations_active_queue_process with arguments: views_bulk_operations_active_queue_process

Comments

jn2 created an issue. See original summary.

jn2’s picture

jn2 commented

Immediately after submitting this issue, I discovered a workaround. In the view, in the VBO field, Bulk operation settings, check Skip batching. Works now for 50 per page, no problem.

However, it does not work for Select all items on all pages, or even for 100 items on one page. Result:
The website encountered an unexpected error. Please try again later.

jn2’s picture

jn2 commented
Issue summary: View changes
jn2’s picture

jn2 commented
Title: Price changing no longer works » Price changing no longer works with VBO batching

Turns out the problem after disabling VBO batching was caused by something in product kits on this particular site. So this workaround should solve the problem for most sites, even for larger numbers of products.

SeanA’s picture

SeanA commented
Priority: Major » Normal
Status: Active » Postponed (maintainer needs more info)

From the behavoir you've described, there doesn't seem to be a problem with this module. The updating works, but fails at some point... sounds like the site in question is timing out ("Service unavailable") when doing the AJAX updates through VBO.

Which versions of Views and VBO are installed?

jn2’s picture

jn2 commented

Views 7.x-3.18
Views Bulk Operations (VBO) 7.x-3.4

Updated to most recent before the error.

Updating works if VBO batching is disabled. On 200 products that takes 30 seconds, much longer than the VBO batch failure. So it does not seem to be a timeout problem. At best only 42 products were updated using VBO batching.

jn2’s picture

jn2 commented
Status: Postponed (maintainer needs more info) » Closed (works as designed)

After receiving your response, I went back and tried something different. With VBO batching, there was no PDO exception. Without, there was a PDO exception if the process encountered an product included in a product kit. The client did not need the kits, and with them deleted, the update process worked.

Because the PDO exception did not appear with the batching error, I assumed there was a different cause. But I went back onto dev, with kits deleted, and it now works with batching enabled.

I can't say whether the kits on the sites were misconfigured, or whether this might indicate a problem with this module handling products included in product kits. In any case, the problem on my client's site is solved.

jn2’s picture

jn2 commented
Issue summary: View changes
jn2’s picture

jn2 commented
Title: Price changing no longer works with VBO batching » Price changing does not work with some products included in prooduct kits
jn2’s picture

jn2 commented
Title: Price changing does not work with some products included in prooduct kits » Price changing does not work with some products included in product kits