[opencms-dev] login problem

[Andreas Schouten]

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
+---------------------+