Ok, i will deal with the second issue first because i know what is causing this.
Some time ago, when i added the sidebar folder across the bundles, i accidentally committed it with a lowercase folder name. Many servers operate with a case sensitive file system, naturally i changed the folder name to have an uppercase 's'. Essentially it started out as 'sidebar' and then noticed the error and changed it to 'Sidebar'. This is basically because i decided good naming conventions for folders should start with first character being capitalised.
Unfortunately, git by default is not case sensitive and i had to change this. In some instances the folder remained and git refused to notice the changes. The only way to solve the issue was to move the folder out, do a commit, put the folder back and commit again.
I had hoped i had got all the instances of the repo that was causing that issue unless you are using an earlier version of the bundles and not the latest. I will take another look to see if i missed any and update the repos.
I am working on another major update that is due to be pushed out in next day or 2 and its just a matter of getting the unit tests done before pushing out. If your still in early dev, and are not worried about the unit tests then i can push this out early if you like, and it should resolve the issues of the Sidebar at least. You will need to use master though until the unit tests are done and it has a new version tag.
Integrity Constraint Violation
As for the integrity constraint violation, are you updating from an older version of CCDN bundles or is this a fresh install? If it is an update then you need to update your DB as some time ago a major update changed some of the database column names for better SQL naming conventions.
If it is however a fresh install, then i will need to know a bit more.
Can you please state wether you are using master or the latest tagged version.
I need to know:
1) Which tagged version are you using.
2) Which version of symfony are you using?
3) Please paste the error you are getting here.