New Install - Error in executing the DDL

I am trying to do a new install on my dev machine and received an “Error in executing DDL” error with a cause of “Specified key was too long; max key length is 1000 bytes”. Does anyone have any thoughts on what might be causing this? I am running CF 10 on OS X 10.8.5 with a MySql ver. 5.5.28 datasource.

Does the error indicate what table has a key that’s too long? What character encoding are you using for your database?

Thanks!

~Brad

ColdBox Platform Evangelist
Ortus Solutions, Corp

E-mail: brad@coldbox.org
ColdBox Platform: http://www.coldbox.org
Blog: http://www.codersrevolution.com

Brad,

Unfortunately, the error does not indicate any particular file or table that is generating the error. The database tables are being created as MyISAM using UTF-8 encoding. I have deleted the install a couple of times and here are the tables that do get created before the error.

cb_author,
cb_authorPermissions,
cb_category,
cb_comment,
cb_content,
cb_contentCategories,
cb_contentStore,
cb_contentVersion,
cb_customHTML,
cb_customfield,
cb_entry,
cb_module,
cb_page,
cb_permission,
cb_role,
cb_rolePermissions,
cb_securityRule,
cb_setting

Thanks for your help.

The problem is MyISAM. They need to be InnoDB.

I would suggest chaning the default in the DB or use a specific driver in the Application.cfc. Usually InnoDB is the default in MySQL, but maybe it is not in yours.

MySQLWithInnoDB is the string for the orm driver setting.

That worked Luis, thanks!

Luis,

I also double checked and per the MySql documentation (http://dev.mysql.com/doc/refman/5.0/en/storage-engines.html), MyISAM is actually the default engine. You should probably add the InnoDB requirement to the install docs.

Thanks again,

Dean

WOW, weird. I will, gracias!!

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

Added to a few places:

http://www.gocontentbox.org/resources/faq
http://www.gocontentbox.org/resources/docs/current/installation

Thanks

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

signature0.jpg