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

ChrisKennedy’s picture

Hmm... what version of MySQL are you using?

pmonte’s picture

Version 4.0.16

ChrisKennedy’s picture

Status: Active » Fixed

Okay it should be fixed. Thanks for the bug report.

http://drupal.org/cvs?commit=53722

Anonymous’s picture

Status: Fixed » Closed (fixed)