Support/Comments for Polls Module

You’re welcome . . . great module by the way! Can’t wait to see how this develops!

still cant use just get the sql error

« Execution of a query to the database failed - You have an error in your SQL syntax near ’; ’ at line 8 »
SQL: CREATE TABLE IF NOT EXISTS `modx_polls` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) default NULL, `question` varchar(255) default NULL, `votes` int(11) default ’0’, PRIMARY KEY (`id`) );

Hi simonok,

Yes, I can reproduce this error now too. It appears that it happens while trying to execute the sql code to create tables at the top of the module. It seems to work when creating the tables for the first time, but when checking if they exist, when they do exist, the sql fails.

As a temporary measure I’ve just deleted all lines in the module that create the tables. Make sure that they exist first before you do that though! The lines are:

Hi there,

I am wondering if there is some way I can get the results of the poll to appear in a pop-up window?

Any help is appreciated

Hi,

I haven’t looked at the code yet, but was just wondering if there is a way to limit the ability to vote only to users of particular groups?

Thanks,
Luke.

Is there any way to view poll results in diagramm mode??

:’(

I am unable to get the results to show on a results page. I put down what was posted, does anyone have a clue as to why it would not show?

I only have one poll which is ID=1 and both codes in the site have that id. It redirects to a page which the id of 28 which I have put that id down in the redirect area. Nothing though..

http://www.louisvillefirefootball.com

does anyone even know if this thing is still supported?

Okay, in reverse order ...

@FireMan: It’s still supported (by me) but I’ve been away from MODx for a month or so with various stuff that’s been going on. Now, to your problem, I could really do with seeing your snippet calls that you have entered for the results page - and you need to make sure that either the snippet call or the page is uncached. I’ll be able to help more if I can see the snippet calls though.

@collst: An overdue response by me (sorry) but what do you mean by diagram mode? Do you mean like a pie chart or a bar chart - if so, then the answer is no. I’d be interested if anybody knows of any open-source PHP libraries that could do that though, that would be a pretty nice option to build in. (I suppose I could always hack something using GD2)

@Lucretia: An even more overdue response to your question. At the moment, the answer is no. I have a new version that I’m writing that will include the ’limit to web group(s)’ option but that is some way from being completed.

@krypto: Popup window could be achieved but you’d have to change the snippet code, make the ’Results’ button render as a link instead (that you could then force to open a new window).