Hi guys,
I recently download the development branch of Codex Wiki and am unable to determine where to find the appropriate SQL scripts to create the database. In the development branch there is a workspace/sql folder that contains 3 folders and SQL files. Can someone point me in the right direction as to what SQL file to use for a new install?
Thanks
Nolan
workbench/sql/0.5Beta2/
-MSSQL or
-MySQL
I will be updating the scripts once I migrate to ORM. As of now remember this is the code repository for codex platform now: https://github.com/Ortus-Solutions/codex-platform
Under the development branch
Luis F. Majano
President
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
Thanks for clarifying Luis. And that is the branch I’m using.
Will there be any sort of migration scripts that would allow legacy codex installs to migrate to the ORM enabled version? Also, when do you anticipate the next version being complete? The reason i’m asking is I would like to implement codex in the next two weeks (as well as populate with data) but if there is an advantage to waiting then I will.
But most of all…how do you find the time to build/provide us developers with such great tools! THANK YOU!
Best,
Nolan
LOL, thanks Nolan.
Codex is dear to my heart and it powers the ColdBox docs so I have no choice but to work on it, LOL!
As of now, I have updated it to ColdBox 3.1, removed ColdSpring and upgraded to WireBox and WireBox AOP. The ORM is the toughest part, and it will take some time for all to be migrated. I don’t think the structure of the DB will change that much, so in terms of DB migrations, there won’t be too much that I can expect. If not, I am sure I will create a migration script as I will need it too.
After the ORM is migrated, then I will start thinking of modularizing it and then tackling requests and new features. Already the current code base has lots and lots of fixes that I have found by using it in the docs, from performance tweaks, to rollback fixes, security, etc.
Luis F. Majano
President
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
Thanks Luis.
I was able to get the database created (i think). however, when I try to load up the application I get this error:
I checked the config file and there is no directory named “definitions”. Let me know if you need me to post the full stacktrace.
Any ideas?
Thanks.
Nolan
Create the directory and make sure it is writable.
Luis F. Majano
President
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
Getting closer… 
Now I get this error:
68 : if( findNoCase('index.cfm', listLast(arguments.targetPage, '/')) ){
69 : // On Request Start via ColdBox
**70 : application.cbBootstrap.onRequestStart(arguments.targetPage);**
71 : }
72 : return true;
I'm running CB 3.0.
Thanks Luis.
Nolan
CodexWiki requires 3.1 now.
Luis F. Majano
President
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
Gotcha.
Getting closer… just download and replaced my system directory and now have this error. I have done a fwreinit as well.
Called from /Library/WebServer/Documents/frameworks/coldbox/system/ioc/Injector.cfc: line 141
Called from /Library/WebServer/Documents/frameworks/coldbox/system/ioc/Injector.cfc: line 92
Called from /Library/WebServer/Documents/frameworks/coldbox/system/web/services/LoaderService.cfc: line 159
Called from /Library/WebServer/Documents/frameworks/coldbox/system/web/services/LoaderService.cfc: line 77
Called from /Library/WebServer/Documents/frameworks/coldbox/system/Coldbox.cfc: line 71
Called from /Library/WebServer/Documents/codex/Application.cfc: line 45
Called from /Library/WebServer/Documents/codex/Application.cfc: line 63
37 : }
38 : // Build LogBox DSL Namespace
**39 : instance.logBoxDSL = createObject("component","coldbox.system.ioc.dsl.LogBoxDSL").init( arguments.injector );**
40 :
41 : return this;
I would restart cf to clear anything from 3.0 in memory.
Luis F. Majano
President
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
HI Luis,
Getting closer. Did a full restart to clear everything. Not getting low level CF errors now, but just got this Coldbox/Transfer error when trying to hit the codex index.
Error Messages: transfer.MultipleRecordsFoundException
The query for ‘wiki.Content’ resulted in 2 records in the Query
I can post the full stacktrace if needed. Appreciate the help on this. Thanks much!
Nolan
NOlan that is weird, I just tried a fresh install and worked with no issues. Basically, installed transfer 1.1, coldbox 3.1 and used the MySQL script and it just worked.
Luis F. Majano
President
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
Only difference is i’m running MSSQL. Odd question. How many tables are in the codex db?
thx.
Nolan
did you ever get this fixed? I am getting# The config.xml file does not validate with the framework’s schema. when using coldbox 3.1
I’m getting this java.IO error:
`
Error building: ConfigService -> An error occurred when performing a file operation write on file D:\Websites\wikitest.wwrlah.com\config\definitions\codex.model.wiki.ConfigService.saveCustomHTML.aop.transfer. The cause of this exception was: java.io.FileNotFoundException: D:\Websites\wikitest.wwrlah.com\config\definitions\codex.model.wiki.ConfigService.saveCustomHTML.aop.transfer (The system cannot find the path specified). with constructor arguments: {configBean={[(Component=coldbox.system.core.collections.ConfigBean)]},transaction={[(Component=transfer.com.sql.transaction.Transaction)]},transfer={[(Component=transfer.com.Transfer)]}}
`
Its a fresh install. I’m using Coldbox 3.5.1, Transfer 1.1 and all tables have been created in MSSQL using the script.
Mistake, i’m using coldbox 3.5.0
Ok, created the definitions folder in config and its working now.