Multi Editor Support

Hi everybody,

Just a quick update that I just committed an almost finalized 1.0.7 version for ContentBox. Please try it out on the development branch.

This includes a big features: Multi-Editor support.

We now have interfaces to build any editor you want for pages, blogs and custom htmls. We built 3 for you: CKEditor, EditArea (coders editor), and text area. We also added a user preferences API and GUI, so now user’s can have preferenes in the system. So you can select your preferred editor.

You can also now switch editors right from within the UI:

I also updated the EditArea ColdFusion language to support cf9 syntax highlighting and will add cf10/railo support soon.

To make this work, just add this to your DB:
ALTER TABLE cb_author ADD COLUMN preferences longtext NULL;

This is a major hurdle we needed to resolve in order to finally build our Wiki modules. So please test it out. Also, I welcome the feedback on the editors implementation as well.

signature0.jpg

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

The update script patches/1-0-7/Update.cfc doesn’t work. syntax error near COLUMN.

ALTER TABLE cb_author ADD COLUMN preferences longtext NULL;

should be

ALTER TABLE cb_author ADD preferences #getLongTextColumn()# NULL;

auto update failed “syntax near column” and upload update failed “invalid mime type”

after manually adding the column and files I got to see the multi editor option on the pages. however selecting either option simply refreshed the page without changing editor.

the excerpt update looks good. i was able to add pictures and better text formatting. thanks.

But when I went to the settings page in admin, it gave me the error “CB blog entry point is undefined in prc.” so i tried reloading the app and now I can’t get passed the login page becuase I get this:

Error while loading the entity.
java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name ‘preferences’.

Tag Context:
ID: CF_CFPAGE
LINE: 278
Template: D:\Websites\gotest\coldbox\system\orm\hibernate\BaseORMService.cfc
ID: CF_UDFMETHOD
LINE: 105
Template: D:\Websites\gotest\coldbox\system\orm\hibernate\VirtualEntityService.cfc
ID: CF_TEMPLATEPROXY
LINE: 134
Template: D:\Websites\gotest\modules\contentbox\model\security\SecurityService.cfc

And visiting the site gives me this error:

could not initialize a collection: [cbContent.activeContent#26]

Tag Context:
ID: CF_PERSISTENTBAG
LINE: 146
Template: D:\Websites\gotest\modules\contentbox\model\content\BaseContent.cfc
ID: CF_UDFMETHOD
LINE: 137
Template: D:\Websites\gotest\modules\contentbox\model\content\BaseContent.cfc
ID: CF_UDFMETHOD
LINE: 438
Template: D:\Websites\gotest\modules\contentbox\model\content\BaseContent.cfc
ID: CF_UDFMETHOD
LINE: 416
Template: D:\Websites\gotest\modules\contentbox\model\content\BaseContent.cfc
ID: CF_TEMPLATEPROXY
LINE: 54
Template: D:\Websites\gotest\modules\contentbox\layouts\bootstrap\templates\entry.cfm

i’ll try the auto update again after i fix the sql statement. I really want the auto update to work, since I still don’t fully understand the manual update requirements.

I see that. I will try and fix a new patch release.

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

For some reason github was not updating our repo. I contacted them and now all the patch updates should be ok. So please try the auto update features now. I just did on all our local machines and all ok. ALso added a fix for the table generation for MSSQL

Perhaps something is wrong with my 1.0.6 install that doesn’t work well with auto update.

The auto updates last week would error out instantly, but today it seemed to be processing more since it wasn’t until a minute when it error out with : Error while loading the entity.

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name ‘preferences’.

Tag Context:
ID: CF_CFPAGE
LINE: 278
Template: D:\Websites\gotest\coldbox\system\orm\hibernate\BaseORMService.cfc

Anyways, its still just a test site, so I will try to install 1.0.6 again then try auto update again…

With a fresh install of 1.0.6 (new db and restarting cf service) the auto update failed again with Invalid column name ‘preferences’. A fresh new install of 1.0.8 was ok.

if there is anything i can do or info i can gather for you, let me know.

Hmm. I tried and it adds the column fine. Do you have alter permissions

Yes, in cf admin the dsn has alter rights and the user in sql server has db_owner rights. Again I am working with MSSQL Now the preferences column is added succesfully, but somehow ORM is not accepting it.

Can anybody else confirm this?