Creating a poll orientated site - Need advice
Bobuido - August 28, 2007 - 19:41
Hi,
I've been set the task of creating a poll to stimulate public debate
I only have "extend" control panel access
I believe the webhost has disabled temporary tables
(not sure how this will affect my requirements)
I also have a PHP memory limit which currently won't allow the modules I have enabled plus views :(
Relevant Enabled Modules
- Poll
- Advanced poll (+Voting API)
- Profile (Thought I needed an extra module. Turns out I hadn't enabled "Profile")
- Forums
- Advanced user
Basic Requirements
- New Poll every month (Calendar month)
- Discuss issues arising from the polls topics and their results
- Register users with profession / status
So half the task was pretty simple thanks to Drupal and its users
Advanced Requirements - In order of importance
- Option to Mass mail poll results to flagged users profiles every month
(Installed "advanced user" but shows errors :S) - Query profile and poll to mix results (e.g. give me all votes for A from Drupal Lovers)
- Create user and submit vote in one submit
Questions
- Will views allow me to accomplish "Query profile and poll to mix results"? - If so...
- Could anyone provide a rough guide to how to go about this?
- Any other mass mailer options other than "advanced user"?
Any help / advice with the above would be great
Thanks in advance
Rob

Views / VotingAPI / Memory / MySQL - Update 290807
Now have enough memory - Luckily I was able to drop in a php.ini to up the memory limit a bit
One more problem solved
Also our I.T. consultant seems to think his hosting company will enable temporary tables if we ask - Which is nice
Having now got enough memory to enable views - It seems to be what I'm looking for
What I'm looking to do is have a table of results per poll with
Username - Profession - Vote
From what I can see you need to give node ID as an argument to give you a per poll set of results
:S
Do I need to do anything particular for the relationships?
(i.e. This user has cast this vote)
Even with Node: ID as an arg (and viewing the node) I was still getting a list of all nodes
Also the voting API fields didn't show anything - Just blank rows
Did see a votingAPI patch which I may as well give a go
Slightly baffled, appreciate some help from the views / Drupal masters
Thanks in advance
Too much info
Think maybe no-one will read my long waffly post
Started a new topic here
http://drupal.org/node/172482