voting error

[fay8291]

I have got an error on the voting on videos.bellaedward-cullen.com, this is waht it says in the view polls in the admin....

POLL:[Start Date:2008-12-03 End Date:2008-12-31 ]s
Qty: What Do You Think Of The Film?
ERROR: Unable to execute query

SELECT count(*) as poll_id from vote_result WHERE answer='I Haven't Seeen It Yet, Dont Plan too!'

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 't Seeen It Yet, Dont Plan too!'' at line 1

I would delete the poll but it doesnt give me that option.

[bplex]

Your error is due to one of your answers having an apostrophe in it (a ' in Haven't). You will need to remove that.

[fay8291]

thanks, i have sorted it out now as well :D