Active
Project:
Premium Views Filter
Version:
6.x-1.0
Component:
Miscellaneous
Priority:
Major
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
14 Sep 2011 at 07:12 UTC
Updated:
14 Sep 2011 at 07:34 UTC
When I try to add a filter in views for premium content, I get these two warning messages:
user warning: Table 'lawlearn_drpl1.premium' doesn't exist query: SELECT COUNT(*) FROM (SELECT node.nid AS nid FROM node node LEFT JOIN premium premium ON node.nid = premium.nid WHERE premium.start_ts is NULL AND premium.end_ts is NULL ) count_alias in /home/lawlearn/public_html/sites/all/modules/views/includes/view.inc on line 745.
user warning: Table 'lawlearn_drpl1.premium' doesn't exist query: SELECT node.nid AS nid, node.title AS node_title, node.created AS node_created, DATE_FORMAT((FROM_UNIXTIME(node.created) + INTERVAL -25200 SECOND), '%Y%m') AS node_created_month FROM node node LEFT JOIN premium premium ON node.nid = premium.nid WHERE premium.start_ts is NULL AND premium.end_ts is NULL ORDER BY node_created_month DESC LIMIT 0, 20 in /home/lawlearn/public_html/sites/all/modules/views/includes/view.inc on line 771.
Note: lawlearn_drpl1 is the name of the database.
I did do an "update" after adding the module. Same error is generated when I try to add "Premium" as a field in the view.
Additional: found the problem... the base module "premium" was not installed. I had installed a similar module called "premium content" which cased the missing table errors. Views works without errors now.