OPENFIRE+MYSQL5.6安装中遇见Specified key was too long; max key length is 767 bytes openfire处理办法
来源:互联网 发布:blooming服装 知乎 编辑:程序博客网 时间:2024/05/22 00:59
推荐的安装OPENFIRE的文章:http://blog.csdn.net/ares1201/article/details/7737872
在这篇文章中,当你安装到第25步的时候,填写了相关的数据库配置之后,你点击下一步可能会出现(在MYECLIPSE的控制台中)
CREATE TABLE ofRoster ( rosterID BIGINT NOT NULL, username VARCHAR(64) NOT NULL, jid VARCHAR(1024) NOT NULL, sub TINYINT NOT NULL, ask TINYINT NOT NULL, recv TINYINT NOT NULL, nick VARCHAR(255), PRIMARY KEY (rosterID), INDEX ofRoster_unameid_idx (username), INDEX ofRoster_jid_idx (jid));
报的异常是:
Specified key was too long; max key length is 767 bytes openfire异常的意思是:你创建数据表的时候,你的字段索引总和超过了最大的767 BYTES,所以就创建不了ofRoster这张表,安装就不能进行到下一步。
解决办法:
修改OPENFIRE中的SQL语句:查找到路径 MYECLIPSE工作空间\openfire_src\target\openfire\resources\database
找到下面openfire_mysql.sql,查到到创建ofRoster表的SQL语句,修改VARCHAR后面的值,一般修改第二个JID的值,VARCHAR的总和不要超过767就可以了。
其他数据库如果也遇到这样的情况,在同样的文件夹中改对应的数据表就可以了。
- OPENFIRE+MYSQL5.6安装中遇见Specified key was too long; max key length is 767 bytes openfire处理办法
- Hive部署安装时,Specified key was too long; max key length is 767 bytes
- hive中Specified key was too long; max key length is 767 bytes问题解决
- MySQL中ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes错误的处理
- Specified key was too long; max key length is 767 bytes
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- hive的Specified key was too long; max key length is 767 bytes问题解决
- MySQL: ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes
- Specified key was too long; max key length is 767 bytes问题
- mysql [Err] 1071 - Specified key was too long; max key length is 767 bytes
- MySQL:Specified key was too long; max key length is 767 bytes
- Specified key was too long; max key length is 767 bytes
- Specified key was too long; max key length is 767 bytes
- hive的Specified key was too long; max key length is 767 bytes问题解决
- hive的Specified key was too long; max key length is 767 bytes问题解决
- hive的Specified key was too long; max key length is 767 bytes问题解决
- MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes
- hive的Specified key was too long; max key length is 767 bytes问题解决
- gen_server模块
- 【PAT Advanced Level】1068. Find More Coins (30)
- Lucene学习总结之三:Lucene的索引文件格式(1)
- Java Precondition类
- 四元数与欧拉角间的转换(源代码)
- OPENFIRE+MYSQL5.6安装中遇见Specified key was too long; max key length is 767 bytes openfire处理办法
- 第十周上机实践------乘法口诀
- fzu Problem 2128 最长子串 (注意strstr函数的使用)
- connect函数返回值
- shell 十三问:
- PHP 与 Mysql 视频教程
- 19:46这刻
- Java多线程编程详解
- Android和PHP开发最佳实践