I got this same error for apimanager table creation in following environment. mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes ERROR 1146 (42S02): Table 'apimanager.IDN_OAUTH2_ACCESS_TOKEN' doesn't exist What difference does it make when using "character set latin1" ? On Fri, Apr 17, 2015 at 10:32 AM, Vinod Kavinda <[email protected]> wrote: > Hi Godwin, > It worked. thanks a lot. > > Regards, > Vinod > > On Fri, Apr 17, 2015 at 2:47 PM, Godwin Amila Shrimal <[email protected]> > wrote: > >> Hi, >> >> Use latin1 character set. >> >> >> Thanks >> Godwin >> >> >> On Fri, Apr 17, 2015 at 2:40 PM, Vinod Kavinda <[email protected]> wrote: >> >>> Hi, >>> I'm getting the following error while trying to setup a mysql datastore, >>> when running the dbscript located at >>> '<PRODUCT_HOME>/dbscripts/mysql.sql'. >>> Error - *ERROR 1071 (42000) at line 31: Specified key was too long; max >>> key length is 767 bytes* >>> >>> I tried reducing the REG_PATH_VALUE length to 100(mysql.sql attached), >>> with no luck. >>> There is a similar issue[1] that has already resolved. >>> >>> mysql version - mysql Ver 14.14 Distrib 5.6.22, for osx10.9 (x86_64) >>> mysql command used - mysql -u root -p BAR < mysql.sql >>> >>> Any help is appreciated. >>> >>> [1] - https://wso2.org/jira/browse/CARBON-5917 >>> >>> Regards, >>> Vinod Kavinda >>> >>> -- >>> Vinod Kavinda >>> Software Engineer, *WSO2, Inc <http://www.wso2.com>.* >>> Mobile : +94 (0) 712 415544 >>> [email protected] >>> >>> _______________________________________________ >>> Dev mailing list >>> [email protected] >>> http://wso2.org/cgi-bin/mailman/listinfo/dev >>> >>> >> >> >> -- >> *Godwin Amila Shrimal* >> Senior Software Engineer >> WSO2 Inc.; http://wso2.com >> lean.enterprise.middleware >> >> mobile: *+94772264165* >> linkedin: *http://lnkd.in/KUum6D <http://lnkd.in/KUum6D>* >> twitter: https://twitter.com/godwinamila >> > > > > -- > Vinod Kavinda > Software Engineer, *WSO2, Inc <http://www.wso2.com>.* > Mobile : +94 (0) 712 415544 > [email protected] > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Chamara Ariyarathne* Associate Technical Lead - Quality Assurance WSO2 Inc; http://www.wso2.com/ Mobile; *+94772786766*
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
