v9版本安装报错 - JEECMS官方论坛|开源java cms,jsp cms,jsp bbs

zbsxlsf

级别: 解元

UID: 1466
积分:279 加为好友
威望: 0 精华: 0
主题:13 回复:148
注册时间:2009-12-26
在线时长:0

1# 发表于:2017-12-27 14:10:48 IP:120.79.*.*

v9版本安装报错，报错信息为
HTTP Status 500 - install failed!
type Exception report

message install failed!

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:646)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause

java.sql.SQLException: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2483)
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2441)
com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:845)
com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:745)
com.jeecms.cms.Install.createTable(Install.java:102)
com.jeecms.cms.InstallServlet.doPost(InstallServlet.java:48)
javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.57 logs.