Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.Hello, I have problems while I try to install and use Advanced Poll, perhaps the problem is that, unfortunatly, I'm using mysql3.
Error message are like:
user warning: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead query: CREATE TABLE drupal_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`) ) /*!40100 DEFAULT CHARACTER SET utf8 */ in /var/www/html/fcen/decaysec/segraspr/divulgadores/sitio/includes/database.mysql.inc on line 172.
I hope this could be fixed.
See you.
Matías.
Comments
Comment #1
mlopez commentedMore errors
* user warning: Table 'mambob.drupal_advpoll_choices' doesn't exist query: DELETE FROM drupal_advpoll_choices WHERE nid = 9 in /var/www/html/fcen/decaysec/segraspr/divulgadores/sitio/includes/database.mysql.inc on line 172.
* user warning: Table 'mambob.drupal_advpoll_choices' doesn't exist query: INSERT INTO drupal_advpoll_choices (nid, label, vote_offset) VALUES (9, 'Martes 17 de 9 a 11', 1) in /var/www/html/fcen/decaysec/segraspr/divulgadores/sitio/includes/database.mysql.inc on line 172.
* user warning: Table 'mambob.drupal_advpoll_choices' doesn't exist query: INSERT INTO drupal_advpoll_choices (nid, label, vote_offset) VALUES (9, 'Martes 17 de 11 a 13', 2) in /var/www/html/fcen/decaysec/segraspr/divulgadores/sitio/includes/database.mysql.inc on line 172.
* user warning: Table 'mambob.drupal_advpoll_choices' doesn't exist query: INSERT INTO drupal_advpoll_choices (nid, label, vote_offset) VALUES (9, 'Martes 17 de 13 a 15', 3) in /var/www/html/fcen/decaysec/segraspr/divulgadores/sitio/includes/database.mysql.inc on line 172.
* user warning: Table 'mambob.drupal_advpoll_choices' doesn't exist query: SELECT vote_offset, label FROM drupal_advpoll_choices WHERE nid = 9 ORDER BY vote_offset in /var/www/html/fcen/decaysec/segraspr/divulgadores/sitio/includes/database.mysql.inc on line 172.
Comment #2
mlopez commentedI just fixed removing
PRIMARY KEY (`nid`, `vote_offset`),
It seems like if Mysql 3 doesn't accept this kind of KEYS
I hope this could help someone.
Bye.
Matías.