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
or
http://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

inspiredbylife’s picture

inspiredbylife commented
Priority: Normal » Critical

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.

nbd’s picture

nbd commented

Same problem here. Any known solution ?
Nbd

nbd’s picture

nbd commented

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

Andrzej7’s picture

Andrzej7 commented

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

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

@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.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Active » Fixed
Anonymous’s picture

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

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