Geeklog Forums

tried to use the custom COM_whatsnew for lib_common.php after uploading the filemgmnt pluging so new downloads would appear in the what's new block however this is the error i get after doing so



09/02/2004 01:18:10 AM - 1109: Unknown table 'comments' in where clause. SQL in question: SELECT DISTINCT *,count(*) AS dups,type,question,gl_stories.title,gl_stories.sid,qid FROM gl_comments LEFT JOIN gl_stories ON ((gl_stories.sid = gl_comments.sid) AND ((gl_stories.owner_id = 2 AND gl_stories.perm_owner >= 2) OR (gl_stories.group_id IN (2,4,7,17,18,11,16,5,13,12,10,8,1,14,3,6,9,15) AND gl_stories.perm_group >= 2) OR (gl_stories.perm_members >= 2) OR (gl_stories.perm_anon >= 2))) LEFT JOIN gl_pollquestions ON ((qid = gl_comments.sid) AND ((gl_pollquestions.owner_id = 2 AND gl_pollquestions.perm_owner >= 2) OR (gl_pollquestions.group_id IN (2,4,7,17,18,11,16,5,13,12,10,8,1,14,3,6,9,15) AND gl_pollquestions.perm_group >= 2) OR (gl_pollquestions.perm_members >= 2) OR (gl_pollquestions.perm_anon >= 2))) WHERE (gl_comments.date >= (NOW() - INTERVAL 172800 SECOND)) AND ((((gl_stories.owner_id IS NOT NULL AND gl_stories.perm_owner IS NOT NULL) OR (gl_stories.group_id IS NOT NULL AND gl_stories.perm_group IS NOT NULL) OR (gl_stories.perm_members IS NOT NULL) OR (gl_stories.perm_anon IS NOT NULL)) OR ((gl_pollquestions.owner_id IS NOT NULL AND gl_pollquestions.perm_owner IS NOT NULL) OR (gl_pollquestions.group_id IS NOT NULL AND gl_pollquestions.perm_group IS NOT NULL) OR (gl_pollquestions.perm_members IS NOT NULL) OR (gl_pollquestions.perm_anon IS NOT NULL))) OR (comments.type='filemgmt')) GROUP BY gl_comments.sid ORDER BY gl_comments.date DESC LIMIT 15


any help?

---

Got Hot wheels? http://www.dcmotoring.com

It's about this bit:

The code you've added seems to use 'comments' instead of the actual table name ('gl_comments' in your case).

That's either a bug in the code or a mistake you made when you added it.

bye, Dirk