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

Home » FUDforum Development » Bug Reports » poll delete bug?
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
poll delete bug? [message #29526] Thu, 29 December 2005 10:46 Go to next message
[mef] is currently offline  [mef]   Russian Federation
Messages: 4
Registered: December 2005
Karma: 0
Junior Member
Hi,
maybe it's only my problem, but when i try to delete one of the answers variants i saw this message:

/forum/index.php:76
forum/index.php:136
/forum/theme/default/poll.php:48
/forum/theme/default/poll.php:967
/forum/index.php:1181
) 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'id=4' at line 1
Query: SELECT SUM(count) FROM fud26_poll_opt poll_id id=4
_GET: array ( 't' => 'poll', 'frm_id' => '2', 'pl_id' => '4', 'del_id' => '12', )
Server Version: 4.0.25
[Referring Page] http://www.server.ru/forum/index.php?t=poll

p.s. but variant was deleted
Re: poll delete bug? [message #29534 is a reply to message #29526] Thu, 29 December 2005 19:39 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
Fixed in CVS here is the patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7501


FUDforum Core Developer
Re: poll delete bug? [message #29540 is a reply to message #29534] Fri, 30 December 2005 05:46 Go to previous messageGo to next message
[mef] is currently offline  [mef]   Russian Federation
Messages: 4
Registered: December 2005
Karma: 0
Junior Member
hi,
i just used patch but the mistake all the same is, but the line of query has changed
was

Query: SELECT SUM(count) FROM fud26_poll_opt poll_id id=4

now

Query: SELECT SUM(count) FROM fud26_poll_opt WHERE poll_id id=4

Re: poll delete bug? [message #29543 is a reply to message #29540] Fri, 30 December 2005 14:56 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You did not apply the patch properly.

FUDforum Core Developer
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: How do i fix this..
Next Topic: Banned accounts email
Goto Forum:
  

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

Current Time: Sun Nov 24 00:21:25 GMT 2024

Total time taken to generate the page: 0.02341 seconds