All site crashed after installing Ubercart Views 6.x-3.0

What error messages do you get?

Do you have any of the uc_views blocks enabled - it might be one of those that fails?

What do you mean by 'all products were gone from the site' uc_views shouldn't have any impact on that did you do anything else also?

http://stara.argosmm.com/ the broken page

I can see that your site is running again - did you find the error, or did you decide to leave out uc_views?

From you description, I can't pin point the exact error, I would need to see the logs. But my guess is that some code in some hook fails, and since this was a side-wide problem, I was guessing that the display of a block was the reason.

This is happening to my site.

It is a result of this query...
===========8<========================================

# Time: 100510 11:34:01
# User@Host: k2[k2] @ [208.73.137.188]
# Query_time: 223 Lock_time: 109 Rows_sent: 20 Rows_examined: 97039142

SELECT DISTINCT ao1.aid AS aid1, ao1.name AS name1, ao1.oid AS oid1,
po1.ordering, ao2.aid AS aid2, ao2.name AS name2, ao2.oid AS oid2,
po2.ordering, ao3.aid AS aid3, ao3.name AS name3, ao3.oid AS oid3,
po3.ordering, ao4.aid AS aid4, ao4.name AS name4, ao4.oid AS oid4,
po4.ordering, ao5.aid AS aid5, ao5.name AS name5, ao5.oid AS oid5,
po5.ordering FROM (uc_product_options AS po1 LEFT JOIN
uc_attribute_options AS ao1 ON po1.oid = ao1.oid AND po1.nid = 563),
(uc_product_options AS po2 LEFT JOIN uc_attribute_options AS ao2 ON
po2.oid = ao2.oid AND po2.nid = 563), (uc_product_options AS po3 LEFT JOIN
uc_attribute_options AS ao3 ON po3.oid = ao3.oid AND po3.nid = 563),
(uc_product_options AS po4 LEFT JOIN uc_attribute_options AS ao4 ON
po4.oid = ao4.oid AND po4.nid = 563), (uc_product_options AS po5 LEFT JOIN
uc_attribute_options AS ao5 ON po5.oid = ao5.oid AND po5.nid = 563) WHERE
ao1.aid = 12 AND ao2.aid = 14 AND ao3.aid = 52 AND ao4.aid = 25 AND
ao5.aid = 24 ORDER BY po1.ordering, ao1.name, po2.ordering, ao2.name,
po3.ordering, ao3.name, po4.ordering, ao4.name, po5.ordering, ao5.name
LIMIT 0, 20;

===========8<========================================

This query is returning zero rows, after crawling through 97 million rows of data...

function _uc_stock_extra_combinations is generating and calling this query. Any chance that you guys can tune this query in a hurry? my client hates me right now, and I am starting to really hate ubercart. :)

Only the kindest of regards.

Thanks,

Closing an old issue - if this is still a problem, please reopen.