user warning: Table 'dbxxxxx.node' doesn't exist
| Project: | Pressflow Buzzworthy |
| Version: | 5.x-1.0-rc1 |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Robbie Sternenberg |
| Status: | closed |
Jump to:
I installed the module, set the permissions, and since then I have the warning
user warning: Table 'dbxxxxx.node' doesn't exist query: SELECT n.title, n.nid, nc.nid, nc.totalcount FROM node n, node_counter nc WHERE n.status = 1 AND n.type <> 'page' AND n.type <> 'book' AND (n.nid = nc.nid) AND (created > 1215029947) ORDER BY nc.totalcount DESC LIMIT 0, 5 in /xxx/yyyyy/zzzzz/abc/includes/database.mysql.inc on line 172.
I tried to find any sort of documentation and tried also, to fined out the problem, but no success. The Block obvioulsy is created, I can even rename it and it apprears with the new label. But I am not able to manage, that the message does disappear or that newly created nodes appear within the the block with their titles.
Any suggestion to solve this matter is highly appreciated.
#1
On line 45 of pressflow_buzzworthy.module, there are no braces around the table names.
Lines 44 to 48 are currently:
$result = db_query_range("SELECT n.title, n.nid, nc.nid, nc.totalcountFROM node n, node_counter nc
WHERE n.status = 1 AND n.type <> 'page' AND n.type <> 'book' AND (n.nid = nc.nid) AND (created > %d)
ORDER BY nc.totalcount
DESC", $daysold, 0, variable_get('pressflow_buzzworthy_numlinks', 5));
They should be:
$result = db_query_range("SELECT n.title, n.nid, nc.nid, nc.totalcountFROM {node} n, {node_counter} nc
WHERE n.status = 1 AND n.type <> 'page' AND n.type <> 'book' AND (n.nid = nc.nid) AND (created > %d)
ORDER BY nc.totalcount
DESC", $daysold, 0, variable_get('pressflow_buzzworthy_numlinks', 5));
If you are using prefixes on your table, this is most likely the source of the problem.
#2
This is a bug.
#3
Assigning to self
#4
Fixed in 5.x-1.0-rc2
#5
Automatically closed -- issue fixed for two weeks with no activity.