RE: [Contribution] Pollbooth v2.0

slicks <[email protected]> 13 Sep 2003 21:39:03 -0000
Newsgroups gmane.comp.web.oscommerce.contributions
Message-ID <37ac334264d9f0a697e8c6b60da9aabc@osCommerce-Forums>
This message was sent from: Contributions
http://forums.oscommerce.com/viewtopic.php?p=229055#229055
----------------------------------------------------------------

ok, i found that file. it is the poll.php in admin that contains the wrong string. ich changed it and most things seems to be ok.
but i get some errors if i give a vote in poll:
[code]1064 - You have an error in your SQL syntax near 'select * from phesis_comments where pollid = \'2\' and language_id = \'2\') as t' at line 1

select count(select * from phesis_comments where pollid = \'2\' and language_id = \'2\') as total 

[TEP STOP][/code]
maybe some wrong in my language setup. ì use only german language (if you read my english here, you know why ;)

i get some other errors too if i make a second vote:

[code]1054 - Unknown column 'warn' in 'where clause'

select optionText from phesis_poll_data where pollid=2&warn=_ALREADY_VOTED and voteid='0' and language_id = '2'

[TEP STOP]
[/code]
maybe someone knows this bug and know how to fix it. this is a really hard hack... 4 days to make it work ... and it doesent work  :roll: 
anyway mucho gracias that i bored you so long time  :D 
regards 
slicks