3.1.0.1 to 3.1.1 upgrade problem

Software Support
1

When try to upgrade from 3.1.0.1 to 3.1.1 I have this error:

“Duplicate entry ‘0-1’ for key ‘citations_submission_seq’”

I tried to locate that key looking for it in phmyadmin but I could not find it.
I need your help. Thank you !.

2

Hi @faud,

Is this an installation that has already had a failed upgrade? If you try an upgrade and it fails, make sure you restore your database from backup before trying again.

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hello, thanks for the answer. No, it is a virtual server so when I fail I return to the previous state. Of first attempt this error arises.

4

Hi @faud,

Are you running the upgrade through the command line? If so, could you post the full output of the command?

Regards,
Alec Smecher
Public Knowledge Project Team

5

Thanks for the help, doing it on the command line worked without problems but I found other things so I went back momentarily.

  1. The article submission history is deleted
  2. I can not get the download statistics that previously worked
6

Hi @faud,

Glad to hear you’re making progress!

Could you post each of those issues as new topics, with as many relevant details as you can? I’m not going to be the person to answer both of those questions, so best not to segue on this thread.

Regards,
Alec Smecher
Public Knowledge Project Team

7

Ok. Thank you Alec !

8

Hello,

I’m having the same issue

Upgrade failed: DB: Duplicate entry ‘0-1’ for key ‘citations_submission_seq’

This issue occurs in both the browser and via command line. I’ve dropped and restored the database on each attempt, but I always get this same upgrade failed notice. Is there a way to delete that key manually in phpmyadmin? If so, where exactly can I find it?

9

Hello,

I was able to get the upgrade to work by renaming the folder and trying again from the command line, but now when I log in, the submissions queue is empty. Is there a way to resolve this issue?

10

Hi @akyeame,

I see you’ve already posted this on another thread. Please don’t double-post; it clutters the forum.

Regards,
Alec Smecher
Public Knowledge Project Team