<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16385"></HEAD>
<BODY style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 15px"
id=MailContainerBody leftMargin=0 topMargin=0 CanvasTabStop="true"
name="Compose message area">
<DIV><FONT color=#280b00 face=Cambria>I can't login to SerMyAdmin. I have
message "Invalid username or password".<BR>I have tried all defaults
options (username and password) but for nothing. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#280b00 face=Cambria>How do I add new user as "admin" in mysql
"subscriber" table, with witch I<BR>will be able to login on SerMyAdmin
?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#280b00 face=Cambria>Also, </FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#280b00 face=Cambria>when I try to register new user via
SerMyAdmin, get this error>>></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#280b00 size=4 face=Cambria><STRONG>Grails Runtime
Exception<BR>Error Details</STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#280b00 face=Cambria><STRONG>Message</STRONG>: could not
execute query; nested exception is org.hibernate.exception.SQLGrammarException:
could not execute query<BR><STRONG>Caused by</STRONG>:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
execute query; nested exception is org.hibernate.exception.SQLGrammarException:
could not execute query<BR><STRONG>Class</STRONG>: AuthController<BR><STRONG>At
Line</STRONG>: [112]<BR><STRONG>Code Snippet:</STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#280b00 size=4 face=Cambria><STRONG>Stack
Trace</STRONG></FONT></DIV>
<DIV> </DIV>
<DIV><FONT color=#280b00
face=Cambria>org.codehaus.groovy.runtime.InvokerInvocationException:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
execute query; nested exception is org.hibernate.exception.SQLGrammarException:
could not execute query<BR> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<BR> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at
org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)<BR> at
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)<BR> at
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)<BR> at
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)<BR> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at
org.jsecurity.web.servlet.JSecurityFilter.doFilterInternal(JSecurityFilter.java:384)<BR> at
org.jsecurity.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:183)<BR> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR> at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR> at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<BR> at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)<BR> at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)<BR> at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<BR> at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<BR> at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)<BR> at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)<BR> at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)<BR> at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)<BR> at
java.lang.Thread.run(Thread.java:619)<BR>Caused by:
org.springframework.dao.InvalidDataAccessResourceUsageException: could not
execute query; nested exception is org.hibernate.exception.SQLGrammarException:
could not execute query<BR> at
AuthController$_closure3.doCall(AuthController.groovy:112)<BR> at
AuthController$_closure3.doCall(AuthController.groovy)<BR> ... 28
more<BR>Caused by: org.hibernate.exception.SQLGrammarException: could not
execute query<BR> ... 30 more<BR>Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
'this_.areacode' in 'field list'<BR> at
com.mysql.jdbc.Util.handleNewInstance(Util.java:406)<BR> at
com.mysql.jdbc.Util.getInstance(Util.java:381)<BR> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)<BR> at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)<BR> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)<BR> at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)<BR> at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)<BR> at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)<BR> at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)<BR> at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)<BR> at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)<BR> at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)<BR> ...
30 more</FONT></DIV></BODY></HTML>