I do not know what “Multiple primary key defined” MEANS here. I can see only ONE primary key in the table. I changed the field length to 11 to see if that would make the function happy with something to chanage, but it has no effect whatsoever. What is “Multiple primary key defined” supposed to MEAN when the are NOT multiple primary keys?
When I run the query in PHPMyAdmin I get the same 1068 error. Why? Is it a bug in MySQL?
Um . . . and should upgrading Expression Engine be this difficult?
I see that this error is listed in other posts but no clear answer is given to it.
*******************
This is the next database error. Some other field is defined as a primary key?
Actually not. Existing “user_id” is primary key and auto-increment.
In fact, it has all the attributes in the MODIFY COLUMN listed below.
Does the SQL choke when it finds that there is nothing to do?
A Database Error Occurred
Error Number: 1068
Multiple primary key defined
ALTER TABLE `exp_mailing_list` MODIFY COLUMN `user_id` int(10) unsigned NOT NULL PRIMARY KEY auto_increment
Filename: /domains/galorath.com/www/public_html/system/expressionengine/modules/mailinglist/upd.mailinglist.php
Line Number: 239