FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » RDF with user authentication produces sql-error
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
RDF with user authentication produces sql-error [message #33728] Mon, 18 September 2006 15:06 Go to previous message
Erunni is currently offline  Erunni   Germany
Messages: 7
Registered: October 2002
Karma:
Junior Member
Hi,

I tried to enable the RDF Feed for my forum. It is a private forum, so I enabled user authentication and set the user to "acturos".

The only thing I get is an sql error:

(/home/www/web7/html/forum/rdf.php:95
/home/www/web7/html/forum/rdf.php:454
) 1054: Unknown column 'acturos' in 'on clause'
Query: SELECT m.*, u.alias, t.forum_id, p.name AS poll_name, p.total_votes, m2.subject AS th_subject, m3.subject AS reply_subject, f.name AS frm_name, c.name AS cat_name FROM fud23_msg m INNER JOIN fud23_thread t ON m.thread_id=t.id INNER JOIN fud23_forum f ON t.forum_id=f.id INNER JOIN fud23_cat c ON c.id=f.cat_id INNER JOIN fud23_msg m2 ON t.root_msg_id=m2.id LEFT JOIN fud23_msg m3 ON m3.id=m.reply_to LEFT JOIN fud23_users u ON m.poster_id=u.id LEFT JOIN fud23_poll p ON m.poll_id=p.id INNER JOIN fud23_group_cache g1 ON g1.user_id=2147483647 AND g1.resource_id=f.id LEFT JOIN fud23_group_cache g2 ON g2.user_id=acturos AND g2.resource_id=f.id LEFT JOIN fud23_mod mm ON mm.forum_id=f.id AND mm.user_id=acturos WHERE t.moved_to=0 AND m.apr=1 AND t.last_post_date >=1158159766 AND (mm.id IS NOT NULL OR (COALESCE(g2.group_cache_opt, g1.group_cache_opt) & 2) > 0) ORDER BY m.post_stamp DESC LIMIT 0,10
_GET: array ( 'mode' => 'm', 'l' => '1', 'n' => '10', 'basic' => '1', )
Server Version: 4.0.24_Debian-10sarge2-log


I use fudform 2.6.5. Is there anyway I can fix that? Thank You!
[Message index]
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Originally Posted By
Next Topic: Spell-check for 2 languages
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 07 20:13:03 GMT 2024

Total time taken to generate the page: 0.04185 seconds