Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
By solanas on
When I upgrade from 4.6.5 to 4.7.1 I get this error because my users table has those names:
jesus
Jesús
user warning: Duplicate entry 'Jesús' for key 2 query: ALTER TABLE users CHANGE `name` `name` varchar(60) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `pass` `pass` varchar(32) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `mail` `mail` varchar(64) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `theme` `theme` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `signature` `signature` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `timezone` `timezone` varchar(8) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `language` `language` varchar(12) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `picture` `picture` varchar(255) CHARACTER SET utf8 DEFAULT '' NOT NULL, CHANGE `init` `init` varchar(64) CHARACTER SET utf8 DEFAULT '' NULL, CHANGE `data` `data` longtext CHARACTER SET utf8 DEFAULT '' NULL in /var/www/drupal465/includes/database.mysql.inc on line 120.
I want to migrate my drupal 4.6.5 installed over mysql 4.0 to a new server with mysql 4.1
First I have migrated my 4.6.5 drupal database over mysql 4.0 to a new mysql 4.1. Later I have upgraded to drupal 4.7.1
Could be it caused because my old 4.6.5 version was with LATIN1 and now with UTF8? I'm not sure what I'm talking about.
These problem was found while I was making tests for the migration. I would like to finish the migration these week and I think I could be usefull to solve this little BUG. Where should I publish this issue?
Best Regards.
