i want to create a multiple choice poll.
active relevant modules:
- Actions 5.x-1.x-dev
- Decisions 5.x-1.x-dev (Selection 5.x-1.x-dev)
- Actions 5.x-1.x-dev
- Voting API 5.x-1.2
- Voting API Actions 5.x-1.2
when i create an new decision with three choices and default settings the preview looks like it should be. but the final poll seems to be closed, there are no new database tables and i get a failure messsage:
- user warning: Table 'konvent.decisions' doesn't exist query: SELECT * FROM decisions WHERE nid = 24 in /usr/local/WWW/docs/Organe/Konvent/test/includes/database.mysql.inc on line 167.
- user warning: Table 'konvent.decisions_choices' doesn't exist query: SELECT vote_offset, label FROM decisions_choices WHERE nid = 24 ORDER BY vote_offset in /usr/local/WWW/docs/Organe/Konvent/test/includes/database.mysql.inc on line 167.
- user warning: You have an error in your SQL syntax near 'ON role.rid = permission.rid WHERE FIND_IN_SET(' vote on decisions', perm) AND r' at line 1 query: SELECT COUNT(*) AS hit FROM permission JOIN role ON role.rid = permission.rid WHERE FIND_IN_SET(' vote on decisions', perm) AND role.name = 'authenticated user' in /usr/local/WWW/docs/Organe/Konvent/test/includes/database.mysql.inc on line 167.
- user warning: You have an error in your SQL syntax near 'ON ur.rid = p.rid WHERE FIND_IN_SET(' vote on decisions', p.perm) AND ur.uid != ' at line 1 query: SELECT COUNT(DISTINCT ur.uid) AS num FROM users_roles ur JOIN permission p ON ur.rid = p.rid WHERE FIND_IN_SET(' vote on decisions', p.perm) AND ur.uid != 0 in /usr/local/WWW/docs/Organe/Konvent/test/includes/database.mysql.inc on line 167.
- user warning: You have an error in your SQL syntax near 'ON role.rid = permission.rid WHERE FIND_IN_SET(' vote on decisions', perm) AND r' at line 1 query: SELECT COUNT(*) AS hit FROM permission JOIN role ON role.rid = permission.rid WHERE FIND_IN_SET(' vote on decisions', perm) AND role.name = 'authenticated user' in /usr/local/WWW/docs/Organe/Konvent/test/includes/database.mysql.inc on line 167.
- user warning: You have an error in your SQL syntax near 'ON ur.rid = p.rid WHERE FIND_IN_SET(' vote on decisions', p.perm) AND ur.uid != ' at line 1 query: SELECT COUNT(DISTINCT ur.uid) AS num FROM users_roles ur JOIN permission p ON ur.rid = p.rid WHERE FIND_IN_SET(' vote on decisions', p.perm) AND ur.uid != 0 in /usr/local/WWW/docs/Organe/Konvent/test/includes/database.mysql.inc on line 167.
- user warning: You have an error in your SQL syntax near 'ON role.rid = permission.rid WHERE FIND_IN_SET(' vote on decisions', perm) AND r' at line 1 query: SELECT COUNT(*) AS hit FROM permission JOIN role ON role.rid = permission.rid WHERE FIND_IN_SET(' vote on decisions', perm) AND role.name = 'authenticated user' in /usr/local/WWW/docs/Organe/Konvent/test/includes/database.mysql.inc on line 167.
- user warning: You have an error in your SQL syntax near 'ON ur.rid = p.rid WHERE FIND_IN_SET(' vote on decisions', p.perm) AND ur.uid != ' at line 1 query: SELECT COUNT(DISTINCT ur.uid) AS num FROM users_roles ur JOIN permission p ON ur.rid = p.rid WHERE FIND_IN_SET(' vote on decisions', p.perm) AND ur.uid != 0 in /usr/local/WWW/docs/Organe/Konvent/test/includes/database.mysql.inc on line 167.
- user warning: You have an error in your SQL syntax near 'ON role.rid = permission.rid WHERE FIND_IN_SET(' vote on decisions', perm) AND r' at line 1 query: SELECT COUNT(*) AS hit FROM permission JOIN role ON role.rid = permission.rid WHERE FIND_IN_SET(' vote on decisions', perm) AND role.name = 'authenticated user' in /usr/local/WWW/docs/Organe/Konvent/test/includes/database.mysql.inc on line 167.
- user warning: You have an error in your SQL syntax near 'ON ur.rid = p.rid WHERE FIND_IN_SET(' vote on decisions', p.perm) AND ur.uid != ' at line 1 query: SELECT COUNT(DISTINCT ur.uid) AS num FROM users_roles ur JOIN permission p ON ur.rid = p.rid WHERE FIND_IN_SET(' vote on decisions', p.perm) AND ur.uid != 0 in /usr/local/WWW/docs/Organe/Konvent/test/includes/database.mysql.inc on line 167.
Comments
Comment #1
tatien commentedApparently your tables have not been created. Try running the update script (update.php) or try uninstalling then reinstall the module.
Comment #2
anarcat commentedThis looks like a broken install. Please reopen if this still happens after our eventual 6.x release.