I was excited to see this new project. So I downloaded the codebase, unpacked it in a web dir, created a site in IIS, created a database called CB and a dsn in CFAdmin called CB, then hit the site. I got the installer which asked if I had a dsn, I chose “Yes” and filled out the form. When I submitted it I get an error:
Table cb_comment defined for cfc contentbox.model.comments.Comment does not exist.
It looks like it’s expecting some tables in the database, but I didn’t see a database install script. I thought that is what the installer was going to do for me.
Thoughts?
Greg
Greg,
Thanks for becoming part of the team 
The installer should take care of creating the entire database for you. Let’s do a few things:
- Does the user that connects to your database from CF have privileges to create tables and indexes? If not, it requires it for the installer to work.
- Can you check if it created ANY tables
Luis F. Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com
ColdBox Platform: http://www.coldbox.org
Linked In: http://www.linkedin.com/pub/3/731/483
Blog: http://www.luismajano.com
IECFUG Manager: http://www.iecfug.com
Social: twitter.com/lmajano facebook.com/lmajano
I have an issue with installation that seems weird to me, if I setup the DB with a Database name of ContentBox2 and then try to run ContentBox, I get the Do you already have a datasource, yada, yada. So I say no, then enter the details of the datasource, then the details of the DB that was just created.
I verify the data and the create datasource pops up, select that and it goes right back to the do you already have a datasource.
Is this expected behavior with Installing 2.0?
Actually they both go back to the asking the question.
Is there an update script for moving older databases over to the new ContentBox?
I get the following error when trying.
Application Execution ExceptionError Type: Expression : [N/A]
Error Messages: Element cbSettings.cb_site_poweredby is undefined in PRC.
Tag Context:
ID: CF_DOTRESOLVER
LINE: 91
Template: D:\Projects\ColdFusion\ContentBox2.0\modules\contentbox-admin\views\settings\index.cfm
ID: CF_INDEX
LINE: 1
Template: D:\Projects\ColdFusion\ContentBox2.0\modules\contentbox-admin\views\settings\index.cfm
ID: CF_INDEX
LINE: 1
Template: D:\Projects\ColdFusion\ContentBox2.0\modules\contentbox-admin\views\settings\index.cfm
ID: CFINCLUDE
LINE: 338
Template: D:\Projects\ColdFusion\ContentBox2.0\coldbox\system\plugins\Renderer.cfc
ID: CF_UDFMETHOD
LINE: 183
Template: D:\Projects\ColdFusion\ContentBox2.0\coldbox\system\plugins\Renderer.cfc
Yes, the user is sa. No tables were created.
Greg
Can you check the dbcreate option in Application.cfc and ensure ORM is enabled. Once the installer completes, CF’s ORM is supposed to take over and create the tables for you based on the entities. Check the logs for errors too in case something went wrong.
Thanks!
~Brad
ColdBox Platform Evangelist
Ortus Solutions, Corp
E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com
I haven’t touched the code. I see a line that says " this.ormEnabled = true;" is that what you are talking about?
Greg
Then it should be a vanilla install. Did you get redirected to the installer?
/cbinstaller
Why don’t you just paste in your application.cfc for us Also, did you check your logs for errors
Thanks!
~Brad
ColdBox Platform Evangelist
Ortus Solutions, Corp
E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com
OK, here is my application.cfc. Like I said, I hadn’t touched it since unpacking the code the other day.
/**
Yes, like I stated initially. I was directed to the installer. It asked if I had a dsn. I had created a database and a dsn pointing to it. When I submitted the form to proceed I get this error:
Table cb_comment defined for cfc contentbox.model.comments.Comment does not exist.
Thanks.
Thanks I don’t see anything wrong in there. What version of ColdFusion/Railo are you using? Have you restarted it? It should be creating those tables when ORM loads. What does the URL look like? Does it redirect you anywhere?
Also, have you checked your error logs?
Thanks!
~Brad
ColdBox Platform Evangelist
Ortus Solutions, Corp
E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com
Coldfusion 9.0.1
Not redirecting that I can see. I am just hitting cb.mydomain.net
Here’s the error I get when I try to hit the site now:
“Error”,“jrpp-205”,“06/26/14”,“14:08:05”,“ContentBox-Shell-B4793EE5ABD145ABF9226D3EA99EEEDB”,"Table cb_comment defined for cfc contentbox.model.comments.Comment does not exist. The specific sequence of files included or processed is: C:\inetpub\wwwroot\CB\index.cfm’’ "
2 coldfusion.orm.mapping.CFPropertyBinder$AttributeValidationException: Table cb_comment defined for cfc contentbox.model.comments.Comment does not exist.
3 at coldfusion.orm.mapping.CFPropertyBinder.readCFCData(CFPropertyBinder.java:371)
4 at coldfusion.orm.mapping.CFPropertyBinder.buildCFCPersistenceMetadata(CFPropertyBinder.java:220)
5 at coldfusion.orm.mapping.CFPropertyBinder.getCFCPersistenceMetadata(CFPropertyBinder.java:200)
6 at coldfusion.orm.hibernate.HibernateConfiguration.generateHbmDocFromCFCs(HibernateConfiguration.java:1004)
7 at coldfusion.orm.hibernate.HibernateConfiguration.generateAndLoadHBMFilesFromCFCs(HibernateConfiguration.java:637)
8 at coldfusion.orm.hibernate.HibernateConfiguration.buildConfiguration(HibernateConfiguration.java:530)
9 at coldfusion.orm.hibernate.HibernateConfiguration.initHibernateConfiguration(HibernateConfiguration.java:179)
10 at coldfusion.orm.hibernate.HibernateConfiguration.(HibernateConfiguration.java:152)
11 at coldfusion.orm.hibernate.ConfigurationManager.initConfiguration(ConfigurationManager.java:67)
12 at coldfusion.orm.hibernate.HibernateProvider.InitializeORMForApplication(HibernateProvider.java:176)
13 at coldfusion.orm.hibernate.HibernateProvider.beforeApplicationStart(HibernateProvider.java:79)
14 at coldfusion.filter.ApplicationFilter.fireBeforeAppStartEvent(ApplicationFilter.java:504)
15 at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:239)
16 at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
17 at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
18 at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
19 at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
20 at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
21 at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
22 at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
23 at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
24 at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
25 at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
26 at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
27 at coldfusion.CfmServlet.service(CfmServlet.java:200)
28 at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
29 at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
30 at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
31 at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
32 at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
33 at jrun.servlet.FilterChain.service(FilterChain.java:101)
34 at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
35 at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
36 at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
37 at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
38 at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
39 at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
40 at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
Can you try upgrading to CF 9.0.2? I see our site actually lists 9.0.1 as compatible, but I know there are a lot of ORM and syntax issues (with struct and array literals) that plagued the first releases of CF9.
And if you can, upgrade to CF11 or Railo 9 is 5 years old and we’ve already had discussions about whether ColdBox MVC should still support it. (ContentBox runs on ColdBox)
Thanks!
~Brad
ColdBox Platform Evangelist
Ortus Solutions, Corp
E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com
Nah, that is too much trouble. If you can’t simply supply a sql script to create the database, then I don’t think I’d be interested in checking out the app further. It sounds like something commercial off the shelf that has to run a web installer. I would prefer to just run the sql script.
Greg Luce
Greg,
At this time we do not offer scripts as we would have to for every single database permutation. That’s why we leverage Hibernate in order to build the database structures for us.
We can give you a script if you like in this help group, but that is not something I will ship the product with.
Also, I will update the requirements as ColdFusion <9.01 is not supported. Only ColdFusion 9.0.2+
Luis F. Majano
CEO
Ortus Solutions, Corp
www.ortussolutions.com
ColdBox Platform: http://www.coldbox.org
Linked In: http://www.linkedin.com/pub/3/731/483
Blog: http://www.luismajano.com
IECFUG Manager: http://www.iecfug.com
Social: twitter.com/lmajano facebook.com/lmajano
OK, I just did the exact same thing on another server with CF10.0.12. Same exact thing happened. I created a blank database (MSSQL2012), tried to run the dsncreator “/modules/contentbox-dsncreator/” and nothing happened. I then manually created the dsn and went back to the dsn creator and checked “Yes” where it asks if you have a dsn. I typed in the name of the dsn “contentbox” and hit submit and nothing happens. No tables were created in the database. And if I try to hit the site root again I get redirected to the dsncreator again.
I am using firefox.
Greg