Hello,
Upgrading a CMS that was 1.7.?? to 1.8.11.
Upgrade wizard popped up and running smooth until hit a problem.
1.8.0-alpha Populate Permission Entities
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘5’ for key 'PRIMARY’Skip this step
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘5’ for key ‘PRIMARY’
Any help is appreciated. Thanks
You need to go to 1.7.9 first, and then go to 1.8.9, then 1.8.11.
In theory you can go from 1.7.9 or 1.7.10 to 1.8.11, but there’s a bug in 1.8.11 for upgrades from 1.7 series that prevents that from going through successfully.
In all cases, we strongly recommend being on 1.7.9 or 1.7.10 before upgrading to 1.8.
It was 1.7.9… (newest 1.7.x version )
Was a Xibo cloud instance.
Thanks
1.7.10 is the newest 1.7 version.
My recommendations above still stand. You won’t be able to go directly to 1.8.11 at the moment, you’ll have to go via 1.8.9.
Dear Alex do the installation of XIBO as indicated in the manual, all right until the start of the session in XIBO since I can not access the system because I can not change the administrator password as samples in the tutorial.
I’d appreciate your help
Xibo 1.8.9 with Docker on Ubuntu 16.04
The default username and password are xibo_admin and password. You should change them as soon as you log in.
Please don’t tag new questions on to other peoples posts however!
Have 1.7.10 installed … upgrading to 1.8.9 and get the following error
can i skip this step ?
Step #
Version
Step
Requested On
Complete?
Run On
1
1.8.0-alpha
Alter the Log Table - Part 1
October 10, 2018 13:25
2018-10-10 13:25
2
1.8.0-alpha
Alter the Log Table - Part 2
October 10, 2018 13:25
2018-10-10 13:26
3
1.8.0-alpha
Alter the Log Table - Part 3
October 10, 2018 13:25
2018-10-10 13:26
4
1.8.0-alpha
Alter the Module Table
October 10, 2018 13:25
2018-10-10 13:26
5
1.8.0-alpha
Add Permissions Table
October 10, 2018 13:25
2018-10-10 13:26
6
1.8.0-alpha
Add Permission Entity Table
October 10, 2018 13:25
2018-10-10 13:26
1.8.0-alpha
Populate Permission Entities
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘5’ for key 'PRIMARY’Skip this step
Xibo Digital Signage - www.xibo.org.uk . Version 1.7.10
It looks as if you’ve run that step previously in another failed upgrade attempt. The table doesn’t exist prior to the previous step so I don’t see any other viable explaination.
You need to restore the database export I sent over originally, upgrade that to 1.7.10. Then take a new backup, and upgrade to 1.8.9.
If at any point you have a failure, you must roll back to the last good backup (eg the exported one, or 1.7.10) before you try again, otherwise you’ll hit these issues.
What version was the cms 1.7.10 ?
Thought it was already .10
When I setup .10 working new cms
Copy db… change library folder in db
Get a “too many redirect “ errors
Ran the upgrade from 1.7.10 to 1.8.9 said upgrade successful but keep this error in log
Problem copying provided file into the Library Folder
Cannot copy /home/.../librarytemp/fonts.css to /home/.../libraryfonts.cssYou likely have filesystem permission issues. The webserver needs to be able to write to the library directory.
Have tried on 2 different servers and get same error.
Any ideas ?
going from 1.7.10 > 1.8.9
Cannot copy /home1/signagenet/.../ByronATCFilestemp/fonts.css to
/home1/signagenet/…/ByronATCFilesfonts.css
cant find any files in "temp" and ByrtonATCFilestemp doesnt exist
…
I messaged you 2 file links. Copy of the xibo instance and database as it is on my server. I have tried on 2 different servers and upgrade says successful … then says " clikc here to continue" … click on it then says " configuration error" …
check log and it says “…fonts.css” couldnt be copied.
Please let me know what you can fiqure out. Don’t see a fonts.css in any folder right now (searched server).
Thanks !