RDF with user authentication produces sql-error [message #33728] |
Mon, 18 September 2006 15:06 |
Erunni
Messages: 7 Registered: October 2002
Karma: 0
|
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!
|
|
|
Re: RDF with user authentication produces sql-error [message #33732 is a reply to message #33728] |
Mon, 18 September 2006 16:16 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
It looks like you put the username NOT the needed user id inside the RSS control panel option that makes feed come through a particular forum account.
This subsequently causes the query to fail.
FUDforum Core Developer
|
|
|
|
Re: RDF with user authentication produces sql-error [message #33754 is a reply to message #33748] |
Tue, 19 September 2006 14:24 |
Ilia
Messages: 13241 Registered: January 2002
Karma: 0
|
Senior Member Administrator Core Developer |
|
|
Because you made RDF/RSS feed come through using a specific user account. If you don't use authentication, then standard process will be used, observing the group permissions system.
As you have it setup right now, no matter who accesses the feed as far as the forum's permissions system is concerned they are the user who's id you've entered in the admin control panel.
FUDforum Core Developer
|
|
|
|
|