Looks like bug in Polls!

[abeez]

Looks like bug in Polls!
Ok I created a poll now I can't remove it from admin, It shows up in frontend with errors on index page, if I disable from admin not to show I hve no errors.

Now within Admin when I go to > View polls
I get this:>
POLL:[Start Date:2008-01-01 End Date:2009-01-01 ]s
Qty: Like The Site Design
ERROR: Unable to execute query

SELECT count(*) as poll_id from vote_result WHERE answer='It's OK'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 's OK'' at line 1

Anyone tell me what's happening?
Anyone tell me how to manually remove this querry from mysql please

[scwebmaster]

Hello:

I ran into this problem as well. What is happening is that your using contractions with apostropie such as "its's." Anything that goes into mysql with and apostropie needs to be run through php function stripslash before it is put into mysql. You can fix the error by using phpmyadmin opening up your database for vshare and browse poll_questions. Eithier drop the row with the question or answer with apostropie in it or change your question and answer to not use apostropie. ex change "it's" to "it is"

Brian H.