When I tried to view the product sales report, it has an error like this:

user warning: Unknown column 'node.uid' in 'where clause' query: SELECT COUNT(nid) FROM tbl_node WHERE node.uid = 3 AND type IN ('product') in /home/ctestneb/public_html/nemtree/includes/database.mysql.inc on line 172.

In the watchdog logs:

Unknown column 'node.uid' in 'where clause' query: SELECT COUNT(nid) FROM tbl_node WHERE node.uid = 3 AND type IN ('product') in /home/ctestneb/public_html/nemtree/includes/database.mysql.inc on line 172.

Let me know what causes the problem, thanks.

Comments

rszrama’s picture

rszrama commented
Status: Active » Fixed

This looks like an issue w/ table prefixing. However, that query is no longer in 1.5 apparently, so the solution is to update to the latest version of UC. This must have been fixed but not recorded here.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.