when I try to login,the following exception occur:
java.sql.SQLException: Unknown column 'userenabled' in 'where clause'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2251)
at com.mysql.jdbc.PreparedStatement.executeQuery(
PreparedStatement.java:1586)
at com.caucho.sql.UserPreparedStatement.executeQuery(
UserPreparedStatement.java:108)
at com.caucho.sql.UserPreparedStatement.executeQuery(
UserPreparedStatement.java:108)
at com.caucho.server.security.JdbcAuthenticator.loginImpl(
JdbcAuthenticator.java:394)
at com.caucho.server.security.JdbcAuthenticator.loginImpl(
JdbcAuthenticator.java:322)
at com.caucho.server.security.AbstractAuthenticator.login(
AbstractAuthenticator.java:212)
at com.caucho.server.security.FormLoginServlet.service(
FormLoginServlet.java:76)
at com.caucho.server.dispatch.ServletFilterChain.doFilter(
ServletFilterChain.java:106)
at com.caucho.server.webapp.NamedDispatcherImpl.forward(
NamedDispatcherImpl.java:119)
at com.caucho.server.dispatch.ForwardFilterChain.doFilter(
ForwardFilterChain.java:74)
at com.caucho.server.cache.CacheFilterChain.doFilter(
CacheFilterChain.java:188)
at com.caucho.server.webapp.WebAppFilterChain.doFilter(
WebAppFilterChain.java:178)
at com.caucho.server.dispatch.ServletInvocation.service(
ServletInvocation.java:229)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java
:268)
at com.caucho.server.port.TcpConnection.run(TcpConnection.java:389)
at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
at java.lang.Thread.run(Thread.java:595)
[12:38:52.375] Closing dangling connections. All connections must have a
close() in a finally block.
[12:38:52.375] java.lang.IllegalStateException: Connection UserConnection[
[EMAIL PROTECTED] was not clo
sed. Connections must have a close() in a finally block.
[12:38:52.375] at com.caucho.jca.UserTransactionImpl.abortTransaction(
UserTransactionImpl.java:466)
[12:38:52.375] at com.caucho.jca.UserTransactionProxy.abortTransaction(
UserTransactionProxy.java:174)
[12:38:52.375] at com.caucho.server.webapp.WebAppFilterChain.doFilter(
WebAppFilterChain.java:198)
[12:38:52.375] at com.caucho.server.dispatch.ServletInvocation.service(
ServletInvocation.java:229)
[12:38:52.375] at com.caucho.server.http.HttpRequest.handleRequest(
HttpRequest.java:268)
[12:38:52.375] at com.caucho.server.port.TcpConnection.run(
TcpConnection.java:389)
[12:38:52.375] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:492)
[12:38:52.375] at com.caucho.util.ThreadPool.run(ThreadPool.java:425)
[12:38:52.375] at java.lang.Thread.run(Thread.java:595)
--
kevin
