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

Home » FUDforum Development » Bug Reports » Bug in RDF access in 1.6.14RC2
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Bug in RDF access in 1.6.14RC2 [message #26182] Fri, 08 July 2005 08:16 Go to next message
lstep is currently offline  lstep   France
Messages: 50
Registered: June 2003
Karma: 0
Member

When trying to access the rdf from the help, in FUDforum 2.6.14rc2, I get the following error:

(/var/www/twistedfud/rdf.php:164
 /var/www/twistedfud/rdf.php:158
 /var/www/twistedfud/rdf.php:477
 ) : ERROR: syntax error at or near "OFFSET" at character 685
 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 fud26_msg m INNER JOIN fud26_thread t 
ON m.thread_id=t.id INNER JOIN fud26_forum f ON t.forum_id=f.id INNER JOIN fud26_cat c ON c.id=f.cat_id INNER JOIN fud26_msg m2 ON t.root_msg_id=m2.id 
LEFT JOIN fud26_msg m3 ON m3.id=m.reply_to LEFT JOIN fud26_users u ON m.poster_id=u.id LEFT JOIN fud26_poll p ON m.poll_id=p.id WHERE t.moved_to=0 
AND m.apr=1 AND t.last_post_date >=1120378298 ORDER BY m.post_stamp DESC LIMIT OFFSET 0
 _GET: mode=m&l=1&n=10&basic=1&


I'm using postgresql v7.4.6-3 (debian version from sarge)
Re: Bug in RDF access in 1.6.14RC2 [message #26185 is a reply to message #26182] Fri, 08 July 2005 12:31 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
It looks to me like you don't have a max limit set inside the forum's RDF configuration panel.

FUDforum Core Developer
Re: Bug in RDF access in 1.6.14RC2 [message #26186 is a reply to message #26185] Fri, 08 July 2005 12:36 Go to previous messageGo to next message
lstep is currently offline  lstep   France
Messages: 50
Registered: June 2003
Karma: 0
Member

Ilia wrote on Fri, 08 July 2005 14:31

It looks to me like you don't have a max limit set inside the forum's RDF configuration panel.


Hu, you're right, I didn't provide a max number. As I didn't put anything in it, I thought it would set a "default" value.
FUD didn't tell me anything wrong when I saved the config without a max Confused
Re: Bug in RDF access in 1.6.14RC2 [message #26187 is a reply to message #26186] Fri, 08 July 2005 14:04 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Future versions will have a default limit built-in.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Empty forums
Next Topic: Smilies in [code] boxes
Goto Forum:
  

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

Current Time: Sun Nov 10 13:31:53 GMT 2024

Total time taken to generate the page: 0.02366 seconds