[opencms-dev] login problem
Andreas Schouten
Andreas.Schouten at framfab.de
Tue Aug 7 18:24:04 CEST 2001
Hello,
please try to update your mysql-database. You should use the latest release
of mysql.
Regards,
Andreas
-----Ursprüngliche Nachricht-----
Von: Andreas Linde [mailto:andreas.linde at os2.org]
Gesendet: Dienstag, 7. August 2001 19:06
An: opencms-dev at www.opencms.com
Betreff: [opencms-dev] login problem
hello everybody,
I have troubles getting opencms work.
setup worked just fine, and now I want to login, but I get the following
"Systemfehler":
--snip--
[CmsException]: 4 Sql exception. Detailed Error:
[com.opencms.file.mySql.CmsDbAccess] Syntax error or access
violation: You have an error in your SQL syntax near 'LOCKED_IN_PROJECT FROM
CMS_ONLINE_RESOURCES,CMS_ONLINE_FILES
WHERE CMS_ONLINE_RE' at line 1. Caught Exception: >java.sql.SQLException:
Syntax error or access violation: You
have an error in your SQL syntax near 'LOCKED_IN_PROJECT FROM
CMS_ONLINE_RESOURCES,CMS_ONLINE_FILES WHERE
CMS_ONLINE_RE' at line 1<
at
com.opencms.file.mySql.CmsDbAccess.readFile(CmsDbAccess.java:1082)
at
com.opencms.file.genericSql.CmsResourceBroker.readFile(CmsResourceBroker.jav
a:4609)
at com.opencms.file.CmsObject.readFile(CmsObject.java:2502)
at com.opencms.core.OpenCms.initResource(OpenCms.java:240)
at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:461)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
at com.opencms.boot.OpenCmsServlet.service(OpenCmsServlet.java:106)
at
com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:8
2)
at com.caucho.server.http.Invocation.service(Invocation.java:272)
at
com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:128)
at
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216)
at
com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:158)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:498)
>java.sql.SQLException: Syntax error or access violation: You have an error
in your SQL syntax near
'LOCKED_IN_PROJECT FROM CMS_ONLINE_RESOURCES,CMS_ONLINE_FILES WHERE
CMS_ONLINE_RE' at line 1
> at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
> at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
> at org.gjt.mm.mysql.Connection.execSQL(Connection.java:885)
> at
org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java:288)
> at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatement.ja
va:166)
> at
com.opencms.file.mySql.CmsDbAccess.readFile(CmsDbAccess.java:1054)
> at
com.opencms.file.genericSql.CmsResourceBroker.readFile(CmsResourceBroker.jav
a:4609)
> at com.opencms.file.CmsObject.readFile(CmsObject.java:2502)
> at com.opencms.core.OpenCms.initResource(OpenCms.java:240)
> at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:461)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
> at com.opencms.boot.OpenCmsServlet.service(OpenCmsServlet.java:106)
> at
com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:8
2)
> at com.caucho.server.http.Invocation.service(Invocation.java:272)
> at
com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:128)
> at
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216)
> at
com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:158)
> at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
> at java.lang.Thread.run(Thread.java:498)
java.sql.SQLException: Syntax error or access violation: You have an error
in your SQL syntax near
'LOCKED_IN_PROJECT FROM CMS_ONLINE_RESOURCES,CMS_ONLINE_FILES WHERE
CMS_ONLINE_RE' at line 1
at org.gjt.mm.mysql.MysqlIO.sendCommand(MysqlIO.java:497)
at org.gjt.mm.mysql.MysqlIO.sqlQueryDirect(MysqlIO.java:550)
at org.gjt.mm.mysql.Connection.execSQL(Connection.java:885)
at
org.gjt.mm.mysql.PreparedStatement.executeQuery(PreparedStatement.java:288)
at
com.opencms.dbpool.CmsPreparedStatement.executeQuery(CmsPreparedStatement.ja
va:166)
at
com.opencms.file.mySql.CmsDbAccess.readFile(CmsDbAccess.java:1054)
at
com.opencms.file.genericSql.CmsResourceBroker.readFile(CmsResourceBroker.jav
a:4609)
at com.opencms.file.CmsObject.readFile(CmsObject.java:2502)
at com.opencms.core.OpenCms.initResource(OpenCms.java:240)
at
com.opencms.core.OpenCmsHttpServlet.doGet(OpenCmsHttpServlet.java:461)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:126)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:103)
at com.opencms.boot.OpenCmsServlet.service(OpenCmsServlet.java:106)
at
com.caucho.server.http.FilterChainServlet.doFilter(FilterChainServlet.java:8
2)
at com.caucho.server.http.Invocation.service(Invocation.java:272)
at
com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:128)
at
com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:216)
at
com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:158)
at com.caucho.server.TcpConnection.run(TcpConnection.java:140)
at java.lang.Thread.run(Thread.java:498)
--snip--
any hints ? do I need another (newer) mysql version ?
ciao
andy
+---------------------+
OS2.org
Online Producer
Andreas Linde
email: andreas.linde at os2.org
irc-nick: kerni
+---------------------+
More information about the opencms-dev
mailing list