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

Home » FUDforum Development » Bug Reports » "Show Polls" link error
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
"Show Polls" link error [message #4433] Fri, 26 July 2002 20:08 Go to next message
computer_dan is currently offline  computer_dan   Canada
Messages: 58
Registered: July 2002
Location: Toronto
Karma: 0
Member

When the "show polls" link is selected (which is located at the top of the page under "Welcome root...") I get:

query failed: %( SELECT fud21_poll.*, fud21_poll_opt_track.user_id, fud21_users.alias AS login, fud21_users.last_visit, fud21_users.invisible_mode, fud21_msg.id AS msg_id, fud21_msg.approved, fud21_thread.locked FROM fud21_poll LEFT JOIN fud21_poll_opt_track ON fud21_poll.id=fud21_poll_opt_track.poll_id AND fud21_poll_opt_track.user_id=1 INNER JOIN fud21_msg ON fud21_poll.id=fud21_msg.poll_id INNER JOIN fud21_thread ON fud21_msg.thread_id=fud21_thread.id LEFT JOIN fud21_users ON fud21_poll.owner=fud21_users.id WHERE fud21_msg.approved='Y' ORDER BY fud21_poll.creation_date DESC LIMIT 0, )% because %( You have an error in your SQL syntax near '' at line 22 )%

I get it with or without polls existing on the site.

Re: "Show Polls" link error [message #4434 is a reply to message #4433] Fri, 26 July 2002 20:09 Go to previous messageGo to next message
computer_dan is currently offline  computer_dan   Canada
Messages: 58
Registered: July 2002
Location: Toronto
Karma: 0
Member

Sorry, I forgot to give you details.

I had v2.2.3 installed and just installed the RC1 upgrade (without a hitch).

Re: "Show Polls" link error [message #4443 is a reply to message #4434] Fri, 26 July 2002 20:53 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Go to admin control panel, search for option with 'Poll' in its name, set its value to the number of polls to display per page on the poll list. Once the value is set the bug will go away.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: empty name registration
Next Topic: error when adding a blocked login that already is blocked
Goto Forum:
  

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

Current Time: Tue Nov 26 23:29:55 GMT 2024

Total time taken to generate the page: 0.02006 seconds