I’m running into error " could not insert: [cbPermission] " during ContentBox3 installation on Windows, Lucee5, MSSQL. (Attached screenshot for reference)
In Application.cfc, I have changed the ORM dialect = “SQLServer”, created Database and DataSource.
During execution on installer i’m getting " could not insert: [cbPermission] " error and I noticed that tables are not generated in the Database.
Can anyone tell me what I’m missing?
Thanks for your reply.
I have made dialect changes as per your comment. But still i’m getting same error.
Contentbox tables are not created in Database.
Contentbox is not certified to work on Lucee 5. Lucee 5 has tons of orm issues that need to be addressed by the lucee team. We have created reports and waiting on fixes by the lucee team.
Getting same error on Lucee 4.5, Adobe CF2016, AdobeCF11. I check tables those are created and user has permission to insert into the cbpermission table. I will do a short video to show you. Thanks
Hi Guys, Here is some information to hopefully help you fix this error with the application trying to do an insert a duplicate value into the cb_permission table. The first thing you need to do is make sure you are using Lucee 4.5 and MySQL. There are some issues that need to be resolved for the MSSQL database and some supported Lucee code only.
The first thing is make sure you start with a clean database. If you have ran the installer your database is not clean. Drop your database and create a new one.
Next go to some files and do some edits there. Go to contentboxmodulesinstaller\contentbox-installer\views\home\steps line 21 and add the value attribute to the hidden field html help function set it to 0.
html.hiddenField(
name = “fullrewrite”,
value = 0
)
This will stop the error cannot convert a string to a boolean.
start server open lucee admin set datasource if it is not already set
Bring up another browser window and try and hit the site.
When you are presented with the installer go to the database using some db tool take the unique constraint off of the cb_permissions table field permission field. Make sure you do that before you run the installer.
Run the installer. Make sure you add dummy content. It does not work without it. You can delete it later.
Once your site is loaded you will need to make false or true to the these values from the cb_settings table cb_site_ssl, cb_site_mail_ssl, cb_site_mail_tls. You will get errors when you delete or try and add pages. The toggles were not set correctly with default values.
I have revised the installer yet again. Seems our move to toggle buttons created some havoc on 3.6.0. Can you please verify the bleeding edge installer?