[Freeswitch-users] FS Core ODBC Support - Specified key was too long; max key length is 1000 bytes

[Muhammad Shahzad]

Hi,

I have compiled FS with core odbc support and get below error at start up,

=======================================================
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)]
[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
]
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
]
create index complete11 on complete
(a1,a2,a3,a4,a5,a6,a7,a8,a9,a10,hostname)
=======================================================

I know its MySQL specific error as specified at,

http://stackoverflow.com/questions/7846298/max-key-length-is-1000-bytes-in-mysql-workbench

However, i was wondering if there is any work around for it?

Can we ignore this error or it has to be fixed before putting FS in
production?

Thank you.


-- 
Muhammad Shahzad
-----------------------------------
CISCO Rich Media Communication Specialist (CRMCS)
CISCO Certified Network Associate (CCNA)
Cell: +49 176 99 83 10 85
MSN: shari_786pk at hotmail.com
Email: shaheryarkh at googlemail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20121009/58c676da/attachment.html