Hello! I want to use the "Popular products" view, but error occurs:

user warning: Table 'k0001345_shop2.uc_order_products_qty_vw' doesn't exist query: SELECT node.nid AS nid, node.type AS node_type, node.vid AS node_vid, node.title AS node_title, node_revisions.teaser AS node_revisions_teaser, node_revisions.format AS node_revisions_format, uc_products.sell_price AS uc_products_sell_price, uc_order_products_qty_vw.sum_qty AS uc_order_products_qty_vw_sum_qty FROM node node LEFT JOIN uc_order_products_qty_vw uc_order_products_qty_vw ON node.nid = uc_order_products_qty_vw.nid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid LEFT JOIN uc_products uc_products ON node.vid = uc_products.vid WHERE uc_order_products_qty_vw.sum_qty >= 1 ORDER BY uc_order_products_qty_vw_sum_qty DESC LIMIT 0, 10 in /home/k0001345/domains/dmkos.ru/public_html/shop2/sites/all/modules/views/includes/view.inc on line 731.

Comments

Island Usurper’s picture

Island Usurper commented
Project: Ubercart » Ubercart Views
Version: 6.x-2.0-rc3 » 6.x-2.0
Status: Active » Postponed (maintainer needs more info)

uc_order_product_qty_vw comes from the Ubercart Views module. Please, make sure it is correctly enabled and configured, and then update the issue.

madsph’s picture

madsph commented
Category: bug » support

It appears that you are missing the database views that uc_views is using.

Two common causes of this problem:

1. The views where not created during install of uc_views because of insufficient rights of you database user
2. You are using the backup and migrate module to create the database - this module does not treat database views correct at the moment.

What you can do to get further with this is to reinstall uc_views and check if there are any errors reported.

Vetkhy’s picture

Vetkhy commented

uc_order_product_qty_vw comes from the Ubercart Views module

Oh, sorry...

You are using the backup and migrate module to create the database - this module does not treat database views correct at the moment.

Well, It seems to be my accident. So I disable Ubercart Views and enable it again, but next I saw error about SQL syntax, because on my hosting MySql 4.x used which (AFAIK) cannot use views (CREATE VIEW...). :(

So thank you all very much and excuse me once again.

madsph’s picture

madsph commented
Status: Postponed (maintainer needs more info) » Closed (fixed)