After installing and making one test sitenote I get this warning after trying to access sitenotes from site-construction menu.

user warning: Unknown table 'n' in field list query: SELECT DISTINCT(n.nid) FROM node WHERE type = 'sitenotes' LIMIT 0, 10 in /home/sterwind/public_html/drpl5/includes/database.mysql.inc on line 172.

It's a pity. It is a very usefull module for me.
Please let me know how to correct this problem.

Kind regards,

Sjaak Terwindt

CommentFileSizeAuthor
#3 sitenotes.patch1.19 KBmdroste

Comments

mdroste’s picture

mdroste commented
Title: Error running sitenotes form site-construction menu. » sitenotes_list

Change this line

$result = pager_query(db_rewrite_sql("SELECT nid FROM {node}  WHERE type = 'sitenotes'"));

to

$result = pager_query(db_rewrite_sql("SELECT n.nid FROM {node} n WHERE type = 'sitenotes'"));
sjaakter’s picture

sjaakter commented

Thanks. Works fine now.

Regards, Sjaak Terwindt.

mdroste’s picture

mdroste commented
Status: Active » Needs review
StatusFileSize
new sitenotes.patch1.19 KB

Here's the patch

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Assigned: Unassigned » nancydru
Status: Needs review » Fixed

The SQL part of the patch is fine, but there is other stuff there too. I am committing a fix. It will roll in tonight.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Fixed » Closed (fixed)