Posted by Andrzej7 on May 8, 2005 at 3:36pm
Jump to:
| Project: | Node Type Filter |
| Version: | master |
| Component: | Code |
| Category: | bug report |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
Hello,
Thenks for a useful module. But I have some problems:
I don't know, what url is correct:http://mysite.net/index.php?type=story
orhttp://mysite.net/index.php?q=type=story
(the second I get, when I put "type=story" to the menu)
In both cases I get list of the stories, but also an error massage:
user error: Unknown table 'n' in where clause
query: SELECT c.nid, c.* FROM 2_comments c WHERE (n.type IN ('story')) AND c.status = 0 ORDER BY c.timestamp DESC LIMIT 0, 10 in /includes/database.mysql.inc on line 66.Can you help?
Andrzej
PS Drupal 4.6, database prefix
Comments
#1
Yes, even I'm seeing the errors. I don't know if this module works for Drupal 4.6 yet. Also I'm not able to browse through the pagination properly.
#2
Same problem here. Any known solution ?
Nbd
#3
To solve the problem I changed line 22 of the module
from:
if ($primary_field == 'nid') {
to:
if ($primary_field == 'nid' && $primary_table=='n') {
Also the right syntax is ?q=node&type=story
Nbd
#4
Thanks Nbd - this patch works
But I see another qustion: this module shows onlyenties promoted to frontpage. It doesn't show a blog o forum, if it is not promoted. So it makes the module partially useless.
Is there any way to change it?
Andrzej
#5
@nbd: Fix committed (5.x).
@Andrzej7 - This filter requires some type of query that selects nodes, such as the front page query or "taxonomy/term/xxx". The module does not, in and of itself, select nodes.
#6
#7
Automatically closed -- issue fixed for two weeks with no activity.