By solanas on

I'm using the /drupal/databse/updates.inc revision 1230 and I get those warnings:

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. 
user warning: Can't DROP 'vid'; check that column/key exists query: ALTER TABLE node DROP INDEX vid in /var/www/drupal465/includes/database.mysql.inc on line 120.

What should I do? I'm not very experimented whit mysql.

Best regards.

⋅ Categories: Drupal 4.7.x

Comments

cmsproducer’s picture

cmsproducer commented

It seems that the data column with the cell that contains 'Jesus' is a key column (should not have another row matching the same data... primary key) since the DBMS uses keys to uniquely identify rows (like ID card numbers - should never have duplicates).. a quick walk-around it to go into the pre-updates copy of the DB and modify the cells in that column that have the same cotnent slightly (Jesus to Jesus1) temporarily to that they are unique, and then upgrade.
-----
iDonny - Web Content Management System Design, Development. & CRM

solanas’s picture

solanas commented

If I executed this line in my phpadmin 

SELECT * 
FROM `users` 
WHERE `name` LIKE 'Jes%'

I just get ONE record. There are no duplicates in my table with that content. Some idea?

If I run

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

I got the same error 

#1062 - Duplicate entry 'Jesús' for key 2

I don't understand nothing.

Marco Solanas