Thursday, October 11, 2012

CKEditor: Styling the Text Box

In the ckeditor/config.js file add:

config.contentsCss = ['/stylesheets/screen.css','/stylesheets/src/grid2.css',  '/stylesheets/print.css', '/stylesheets/style.css', '/stylesheets/tabs.css'];

Sunday, October 7, 2012

DBMigrate and References

Just wanted to blog about my issues using CFWheels DBMigrate with MySQL.
I am using MySQL 5.5 now, but up until recently had 5.1 on my local box and that meant tables defaulted to MyISAM.
I couldn't create foreign keys through DBMigrate on MyISAM tables. 
I would get errno 150 and errno 152 when attempting to create references.

Now that I've updated it's not so much of an issue anymore. But I am still having issues with removing references.

I can't seem to use dropReference or removeColumn to get rid of references, instead I have to
use a combination of:

dropForeignKey(table='videostatistics', keyName='videostatistics_ibfk_2');removeIndex(table='videostatistics', indexName='FK_videostatistics_agendaitems');
removeColumn(table='videostatistics', columnName='agendaitemid');