<div>jira.freeswitch.org is a better place for this</div><div><div><br></div></div>
<p style="color: #A0A0A8;">On Tuesday, October 9, 2012 at 7:56 AM, Muhammad Shahzad wrote:</p>
<blockquote type="cite" style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px;">
<span><div><div>Hi,<div><br></div><div>I have compiled FS with core odbc support and get below error at start up,</div><div><br></div><div>=======================================================</div><div><div>2012-10-09 01:49:33.596802 [ERR] switch_odbc.c:494 ERR: [create index complete11 on complete (a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,hostname)]</div>
<div>[STATE: HY000 CODE 1071 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Specified key was too long; max key length is 1000 bytes</div><div>]</div><div>2012-10-09 01:49:33.596864 [ERR] switch_core_sqldb.c:526 SQL ERR [STATE: HY000 CODE 1071 ERROR: [unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.1.63-0+squeeze1]Specified key was too long; max key length is 1000 bytes</div>
<div>]</div><div>create index complete11 on complete (a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,hostname)</div><div>=======================================================</div><div><br></div><div>I know its MySQL specific error as specified at,</div>
<div><br></div><div><a href="http://stackoverflow.com/questions/7846298/max-key-length-is-1000-bytes-in-mysql-workbench">http://stackoverflow.com/questions/7846298/max-key-length-is-1000-bytes-in-mysql-workbench</a></div>
<div><br></div><div>However, i was wondering if there is any work around for it? </div><div><br></div><div>Can we ignore this error or it has to be fixed before putting FS in production?</div><div><br></div><div>Thank you.</div>
<div><br></div><div><br></div>-- <br>Muhammad Shahzad<br>-----------------------------------<br>CISCO Rich Media Communication Specialist (CRMCS)<br>CISCO Certified Network Associate (CCNA)<br>Cell: +49 176 99 83 10 85<br>
MSN: <a href="mailto:shari_786pk@hotmail.com">shari_786pk@hotmail.com</a><br>Email: <a href="mailto:shaheryarkh@googlemail.com">shaheryarkh@googlemail.com</a><br>
</div>
</div><div><div>_________________________________________________________________________</div><div>Professional FreeSWITCH Consulting Services:</div><div><a href="mailto:consulting@freeswitch.org">consulting@freeswitch.org</a></div><div><a href="http://www.freeswitchsolutions.com">http://www.freeswitchsolutions.com</a></div><div><br></div><div>FreeSWITCH-powered IP PBX: The CudaTel Communication Server</div><div><a href="http://www.cudatel.com">http://www.cudatel.com</a></div><div><br></div><div>Official FreeSWITCH Sites</div><div><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></div><div><a href="http://wiki.freeswitch.org">http://wiki.freeswitch.org</a></div><div><a href="http://www.cluecon.com">http://www.cluecon.com</a></div><div><br></div><div>FreeSWITCH-users mailing list</div><div><a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a></div><div><a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a></div><div>UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users">http://lists.freeswitch.org/mailman/options/freeswitch-users</a></div><div><a href="http://www.freeswitch.org">http://www.freeswitch.org</a></div></div></div></span>
</blockquote>
<div>
<br>
</div>