Good morning everyone,
I have a problem when i try to upgrade my installation of Xibo 1.6.3 to 1.7.4.
My final objective is to upgrade up to 1.8.x but i must to pass to 1.7.x before.
So this is my error:
An error occurred running the upgrade. Please take a screen shot of this page and seek help. Statement number: 82. Error Message = [SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’]. File = [Array]. SQL = [INSERT INTO tag (tagId, tag) VALUES (1, ‘template’), (2, ‘background’), (3, ‘thumbnail’)].
So, i tried to upgrade from 1.6.3 to 1.7.9 as you said me, but i have had the same error…
Have you got other idea…
So, in waiting, i’m going to try to upgrade from 1.6.3 to the last one on 1.6 (1.6.4) and after 1.7.0 to 1.7.9 and finish 1.8.0.
Maybe it’s more long but more sure, non?
I’m surprised they came up with exactly the same error. You definitely restored your database backup? Once the upgrade process has started to run, you can’t then have an error part way through and then just try again. You must drop the database, and then restore your backup you took from before the upgrade.
I’m currently doing the update up to 1.7.0. So i’m waiting the end of process.
But i could tell you that i restored my database for my last mysqldump, but maybe it provide from my database.
I have a lot of media inside, maybe i could delete a good part of them before upgrading.
You can’t just delete stuff from the tables. There are all kinds of references kept. Directly editing the database will very definitely cause upgrade failures.
In fact, i had the answer of my problem in first message but i don’t see it , i will need to buy some new eye!!
Into the screen capture, it’s written INTO TAG so i’m seen in this table to find 2 lines.
First named “default” and the second "import"
I have just deleted this two entries and the upgrade is passed
In this table, now there are “template”, “background”, “thumbnail”