URL to your eFiction: http://www.trackbunnies.org
Version of eFiction: 3.1 (trying to upgrade to 3.2)
Have you bridged eFiction, if so with what?: None
Version of PHP: 4.4.3
Version of MySQL: 4.1.21-standard
Have you searched for your problem: Yes
If so, what terms did you try: Searched this forum for part of the error: Query: alter table fanfiction_authorinfo add primary key(uid,field);
State the nature of your problem: Trying to upgrade to 3.2 and click the yes on the upgrade page and get the error above
Do you have a test account for us? nope, sorry..
I uploaded all of the files for 3.2 and when I go to the front page, the upgrade.php page comes up.
I click yes...
and I get this
A fatal MySQL error was encountered.
Query: alter table fanfiction_authorinfo add primary key(uid,field);
Error: (1068) Multiple primary key defined
I turned off the news and stats as I was told. I have no idea what to do next here.
http://www.trackbunnies.org
http://blog.trackbunnies.org/
http://karah-leighhancock.avonrepresentative.com/
I'm looking at my database and under the authorinfo table it has this
Indexes: Keyname Type Cardinality Action Field
PRIMARY PRIMARY 2712 uid
field
uid INDEX 904 uid
PRIMARY and INDEX keys should not both be set for column `uid`
http://www.trackbunnies.org
http://blog.trackbunnies.org/
http://karah-leighhancock.avonrepresentative.com/
dbquery("alter table ".$tableprefix."fanfiction_authorinfo add primary key(uid,field);");
dbquery("alter table ".$tableprefix."fanfiction_blocks drop index block_name;");
I deleted those two lines and everything seems to work now.
http://www.trackbunnies.org
http://blog.trackbunnies.org/
http://karah-leighhancock.avonrepresentative.com/
