Sorry, I had originally put this in the wrong area:
URL to your eFiction: http://fanfic.jarlylove.com
Version of eFiction: 3.02 (Should be 3.1.1)
Have you bridged eFiction, if so with what?: no
Version of PHP: 4.4.2
Version of MySQL: 5.something (In phpMyAdmin it says: "MySQL client version: 5.0.16")
Have you searched for your problem: Yes
If so, what terms did you try: Error: (1068), and I've looked at this, this, and 3 other threads. The first two were my problem exactly. I tried to follow what it said there, but nothing happened.
State the nature of your problem:
I am trying to upgrade to 3.1.1, but every time I do run update, I get
A fatal MySQL error was encountered.
Query: alter table jarlylov_fanficfanfiction_authorinfo add primary key(uid,field);
Error: (1068) Multiple primary key defined
This thread said that I'm supposed to be told where the error is, but I'm not.
If I'm right, and you have the same problem as I did, it should have said where the Multiple primary key was defined. Like (1, 2). 1 should be the id of the user, profile person's number. If you delete all the instances it should work. If you're like me, you may have too many to correct though.
I don't get this message, and I'm not sure what to look for as in duplicates. What would it look like?
I'm not familiar with phpMyAdmin, I tried to run the SQL, but all I got was an error, and it didn't tell me what was up
Also, if I were to try to comment out everything, I would literally end up commenting out everything.
Do you have a test account for us? I didn't think one was necessary for this, but if I need to make one, I can.
Url: http://fanfic.jarlylove.com/
Efic Version: 3.3.1
Latest Patches: Yes
Bridges: none
Mods: Challenges, Beta-Reader, Recommendations, Story end
PHP: 5.2.2
MySQL: 5
Use phpMyAdmin and delete the key on the authorinfo table. I'm not sure how you ended up with a key on it to begin with though.
Now, I get this:
A fatal MySQL error was encountered.
Query: alter table jarlylov_fanficfanfiction_blocks drop index block_name;
Error: (1091) Can't DROP 'block_name'; check that column/key exists
Edit: Ok, I got it to work after commenting out:
// dbquery("alter table ".$tableprefix."fanfiction_blocks drop index block_name;");
And then re-deleting the primary key.
It worked. However, in phpMyAdmin for author info it gives a warning says:
PRIMARY and INDEX keys should not both be set for column `uid`
Should I do something about that?
Url: http://fanfic.jarlylove.com/
Efic Version: 3.3.1
Latest Patches: Yes
Bridges: none
Mods: Challenges, Beta-Reader, Recommendations, Story end
PHP: 5.2.2
MySQL: 5
You should have only one key that's a primary key on both uid and field.
Ok, I got rid of the second.
Url: http://fanfic.jarlylove.com/
Efic Version: 3.3.1
Latest Patches: Yes
Bridges: none
Mods: Challenges, Beta-Reader, Recommendations, Story end
PHP: 5.2.2
MySQL: 5
