Execute alter table tag modify user_id varchar(9999) issue.

[mkma...@gmail.com]

I am getting this exception when starting tomcat server from dotCMS. 

Could some body help me out this problem. Your effort should be highly appreciated.

[12/06/14 05:36:37:484 EDT]  INFO db.DotConnect: Executing alter table tag modify user_id varchar(9999)

[12/06/14 05:36:37:519 EDT] FATAL runalways.Task00001LoadSchema: Error: Index column size too large. The maximum column size is 767 bytes.while trying to execute alter table tag modify user_id varchar(9999) proccessed 475 statements

java.sql.SQLException: Index column size too large. The maximum column size is 767 bytes.

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)

Thanks 

Madhab

[Jason Tesser]

not sure your exact issue BUT it would appear you have issues with the
collation you have configured in Mysql for your DB
Thanks,
Jason S. Tesser
Director, Product Development, Lead Engineer
Dotcms, Inc.
T: 305.858.1422 x7003
http://twitter.com/dotCMS
www.dotcms.com

> --
> You received this message because you are subscribed to the Google Groups
> "Dotcms User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to dotcms+un...@googlegroups.com.
> To post to this group, send email to dot...@googlegroups.com.
> Visit this group at http://groups.google.com/group/dotcms.
> For more options, visit https://groups.google.com/d/optout.

[Brent Griffin]

Please make sure that your MySQL database is configured with the proper character set and collate as indicated here:  http://dotcms.com/docs/latest/DatabaseConfiguration

Please let us know what version of dotcms you are running.  Is this a fresh install, an upgrade, or ???

Brent Griffin

Sr. Java Architect

Director of Quality Assurance

Dotcms