One of our users reported an issue with Xibo ‘hanging’ when trying to replace media in the Library category. Specifically, the media in question is an mp4 file. I tried to do the same myself, and actually had a SQL error show up once it had hit 100%:
“SQLSTATE[21000]: Cardinality violation: 1242 Subquery returns more than 1 row”
However when I hit ‘Done’ after receiving this error, I can see the new file is in place (no thumbnail is showing, though, and the screen displaying this Media hasn’t updated to the new version, and I gave it almost an hour to update).
The error suggests that when you try and revise the media item, it’s finding more than one current version, and that’s why it’s erroring.
You’ll need a direct database modification to resolve it completely, unless it will allow you to delete all versions of that file yourself and then upload from scratch. Please take a database backup before doing anything else.
Thanks for your reply. We were on version 1.8.1, but we just updated to 1.8.3. Looks like we were able to resolve the issue.
We backed up the database and then modified it, we noticed that the database was holding on to old versions of files (even though we have it set to remove the old version when a new one is replacing it). We had to manually remove the entries from the database and rebuild the Library, and that seemed to fix it.
We also believe there is something wrong with the way the mp4 file was exported from Adobe After Effects, so I’m having the user try to export it again, then replace the current media with the new one.