I get the following error message after updating ubercart views

Removed database views - please install the new submodule uc_views_marketing to get you old views to work

How do I fix this please?

Comments

vip_sa’s picture

vip_sa commented

Here is the whole error message:

* user warning: Unknown table 'uc_order_products_qty_vw' query: DROP VIEW uc_order_products_qty_vw in /home/gigguide/public_html/hosted/usagigguide.com/sites/all/modules/uc_views/uc_views.install on line 21.
* user warning: Unknown table 'uc_order_products_user_vw' query: DROP VIEW uc_order_products_user_vw in /home/gigguide/public_html/hosted/usagigguide.com/sites/all/modules/uc_views/uc_views.install on line 22.
* user warning: Unknown table 'uc_order_products_pair_vw' query: DROP VIEW uc_order_products_pair_vw in /home/gigguide/public_html/hosted/usagigguide.com/sites/all/modules/uc_views/uc_views.install on line 23.

Now my views slide show is also not working

madsph’s picture

madsph commented

Go to the modules administration and enable the modules in the new uc_views group.

vip_sa’s picture

vip_sa commented

Why am I getting this:

user warning: CREATE VIEW command denied to user 'gigguide_corne'@'localhost' for table 'uc_order_products_pair_vw' query: CREATE VIEW uc_order_products_pair_vw (nid,pair_nid,pair_sum_qty,order_count) AS SELECT op1.`nid` AS `nid`, op2.`nid` AS `pair_nid`, SUM(op2.`qty`) AS `pair_sum_qty`, COUNT(op2.`nid`) AS `order_count` FROM uc_order_products op1, uc_order_products op2 WHERE op1.`order_id` = op2.`order_id` AND op1.`nid` <> op2.`nid` GROUP BY `nid`, `pair_nid` ORDER BY `nid`, `order_count` DESC, `pair_sum_qty` DESC in /home/gigguide/public_html/hosted/usagigguide.com/sites/all/modules/uc_views/uc_views_marketing/uc_views_marketing.install on line 11.

madsph’s picture

madsph commented
Status: Active » Closed (fixed)

No prob ;-)