主题 : 好麻烦,好不容易数据库 |
级别: 状元
![]() |
23# 发表于:2013-07-30 15:43:45 IP:59.244.*.*
root cause
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'cmsconfig0_.EMAIL_VALIDATE' in 'field list' sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) java.lang.reflect.Constructor.newInstance(Unknown Source) com.mysql.jdbc.Util.handleNewInstance(Util.java:406) com.mysql.jdbc.Util.getInstance(Util.java:381) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648) 从你错误信息来看肯定您的数据库有问题,没有 Unknown column 'cmsconfig0_.EMAIL_VALIDATE' in 'field |
||
---|---|---|---|
级别: 童生
![]() |
27# 发表于:2013-07-30 15:59:33 IP:14.177.*.*
这是自动创建数据库提交后显示的
———————————————————————— HTTP Status 500 - type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: install failed! com.jeecms.cms.InstallServlet.doPost(InstallServlet.java:71) javax.servlet.http.HttpServlet.service(HttpServlet.java:641) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) root cause com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) java.lang.reflect.Constructor.newInstance(Unknown Source) com.mysql.jdbc.Util.handleNewInstance(Util.java:406) com.mysql.jdbc.Util.getInstance(Util.java:381) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2642) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2571) com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:769) com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:612) com.jeecms.cms.Install.createTable(Install.java:106) com.jeecms.cms.InstallServlet.doPost(InstallServlet.java:48) javax.servlet.http.HttpServlet.service(HttpServlet.java:641) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) note The full stack trace of the root cause is available in the Apache Tomcat/7.0.23 logs. Apache Tomcat/7.0.23 |
||
---|---|---|---|
级别: 状元
![]() |
28# 发表于:2013-07-30 16:02:57 IP:59.244.*.*
那问题就是出现在你的数据,com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Specified key was too long; max key length is 767 byte 你用的数据库版本是?
|
||
---|---|---|---|
级别: 状元
![]() |
29# 发表于:2013-07-30 16:04:53 IP:59.244.*.*
到mysql中的hive数据库里执行 alter database hive character set latin1;改变hive元数据库的字符集
|
||
---|---|---|---|
级别: 童生
![]() |
30# 发表于:2013-07-30 16:05:06 IP:14.177.*.*
--------------
E:\MySQL\MySQL6\bin\mysql.exe Ver 14.15 Distrib 6.0.11-alpha, for Win32 (ia32) Connection id: 130 Current database: Current user: root@localhost SSL: Not in use Using delimiter: ; Server version: 6.0.11-alpha-community MySQL Community Server (GPL) Protocol version: 10 Connection: localhost via TCP/IP Server characterset: utf8 Db characterset: utf8 Client characterset: utf8 Conn. characterset: utf8 TCP port: 3306 Uptime: 2 hours 1 min 20 sec Threads: 2 Questions: 9217 Slow queries: 0 Opens: 454 Flush tables: 1 Open tables: 0 Queries per second avg: 1.266 -------------- |
||
---|---|---|---|