Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Error in update script 2.9.0-b7 #6696

Closed
sgiehl opened this issue Nov 19, 2014 · 4 comments
Closed

Error in update script 2.9.0-b7 #6696

sgiehl opened this issue Nov 19, 2014 · 4 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone
2.9.1

Comments

@sgiehl
Copy link
Member

sgiehl commented Nov 19, 2014

Several users in the german forum reported the following error while updating to 2.9.0:

Error trying to execute the query 'INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2010_01', 508)'.
The error was: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'piwik_archive_numeric_2010_01' for key 'PRIMARY'

Guess it should be enough to use INSERT IGNORE instead, or to set the updater to ignore this error in that query.
@sgiehl sgiehl added the Bug For errors / faults / flaws / inconsistencies etc. label Nov 19, 2014
@sgiehl sgiehl added this to the Piwik 2.9.1 milestone Nov 19, 2014
@tsteur
Copy link
Member

tsteur commented Nov 19, 2014

Looking at the code I am wondering how this can happen in this update? Any idea? Are there also non- German users having this issue? Of course could just add an "ignore", most likely we will then have this problem again.

Is this reported in Forum?

@sgiehl
Copy link
Member Author

sgiehl commented Nov 19, 2014

see http://forum.piwik.org/read.php?5,122015
I have no idea how this can happen.

@mattab
Copy link
Member

mattab commented Nov 19, 2014

FYI I didn't hear of this problem in english forums

@mattab mattab closed this as completed in 0f5f79e Nov 19, 2014
@tsteur
Copy link
Member

tsteur commented Dec 4, 2014

Where there any more reports of this? Both users said they used the regular one click updater in the browser and got this error on the first try. It could be related to a European locale on the server or something else.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Milestone
2.9.1
Development

No branches or pull requests
3 participants
@tsteur @mattab @sgiehl