By zoliky on

I want to upgrade Drupal 4.7.6 to Drupal 5.1. Ok I do this.. Now I have Drupal 5.1, but exist a problem. When I want to activate the "poll" module I get the following error:

    * user warning: Table 'poll' already exists query: CREATE TABLE poll ( nid int unsigned NOT NULL default '0', runtime int NOT NULL default '0', active int unsigned NOT NULL default '0', PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in D:\Wamp\www\drupal\includes\database.mysql.inc on line 172.
    * user warning: Table 'poll_votes' already exists query: CREATE TABLE poll_votes ( nid int unsigned NOT NULL, uid int unsigned NOT NULL default 0, chorder int NOT NULL default -1, hostname varchar(128) NOT NULL default '', INDEX (nid), INDEX (uid), INDEX (hostname) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in D:\Wamp\www\drupal\includes\database.mysql.inc on line 172.
    * user warning: Table 'poll_choices' already exists query: CREATE TABLE poll_choices ( chid int unsigned NOT NULL auto_increment, nid int unsigned NOT NULL default '0', chtext varchar(128) NOT NULL default '', chvotes int NOT NULL default '0', chorder int NOT NULL default '0', PRIMARY KEY (chid), KEY nid (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in D:\Wamp\www\drupal\includes\database.mysql.inc on line 172.

This happen because Drupal 4.7.6 has the 3 table: poll, poll_votes, poll_choices and Drupal 5.1 try to create again the tables.

Exist a way to solve this problem ? I need an answer, please help me !

Comments

zoliky’s picture

zoliky commented

This is my "system" table in drupal 4.7 (fresh install):

http://home.wplink.net/~yo2lux/sql1.html

And this is my "system" table after 4.7 updated to 5.1:

http://home.wplink.net/~yo2lux/sql2.html

Not enabled modules has schema_version value: -1
This -1 value cause the following errors:

* user warning: Table 'poll' already exists query: CREATE TABLE poll ( nid int unsigned NOT NULL default '0', runtime int NOT NULL default '0', active int unsigned NOT NULL default '0', PRIMARY KEY (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in D:\Wamp\www\drupal\includes\database.mysql.inc on line 172.

When I change -1 to 0, I don't get the error messages. Someone has an idea how to solve this problem ?