I'm running Drupal 5. I enabled Voting API 5.x-1.2 and then Advanced Poll 5.x-1.x-dev but these three waring apperas and the module doesn't work:
- user warning: 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 'ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */' at line 1 query: CREATE TABLE advpoll ( `nid` int(10) NOT NULL, `quorum` int(10) NOT NULL, `mode` varchar(32) NOT NULL, `uselist` tinyint default '0', `active` tinyint default '1', `runtime` int NOT NULL default '0', `maxchoices` int unsigned NOT NULL default '0', `algorithm` VARCHAR(100), `showvotes` tinyint, `startdate` int unsigned, PRIMARY KEY (`nid`) ) ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */ in /home/bryoit/public_html/d3ypaj/includes/database.mysql.inc on line 167.
- user warning: 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 'ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */' at line 5 query: CREATE TABLE advpoll_electoral_list ( `nid` int(10) NOT NULL, `uid` int(10) NOT NULL, PRIMARY KEY (`nid`,`uid`) ) ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */ in /home/bryoit/public_html/d3ypaj/includes/database.mysql.inc on line 167.
- user warning: 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 'ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */' at line 7 query: CREATE TABLE advpoll_choices ( `nid` int(10) NOT NULL, `label` text NOT NULL, `vote_offset` int(2) unsigned default NULL, PRIMARY KEY (`nid`, `vote_offset`), KEY `vote_offset` (`vote_offset`) ) ENGINE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */ in /home/bryoit/public_html/d3ypaj/includes/database.mysql.inc on line 167.
Comments
Comment #1
ChrisKennedy commentedHmm... what version of MySQL are you using?
Comment #2
pmonte commentedVersion 4.0.16
Comment #3
ChrisKennedy commentedOkay it should be fixed. Thanks for the bug report.
http://drupal.org/cvs?commit=53722
Comment #4
(not verified) commented