[opencms-dev] login problem

[Thomas.Zirnsack at gfk.de]

Hi,

that reminds me to an issue someone already posted to
this list: Do you have some kind of document that shows
the changes to the database design (by version)?

OpenCMS developers will need this for two reasons:

A) If you have a running OpenCMS system, you will have
to check if your database needs to be changed  when
you upgrade to a more recent version. (And then you will
have to import your old database content in some way).

B) I have ported OpenCMS to use a Sybase DB. The
original code used some features of mySQL/Oracle that
was not supported by Sybase. Hence, before I switch
to a new version of OpenCMS I need the information
to check and rewrite parts of the code concerning the
database.

Kind regards,
tom




                                                                                                                             
                    Andreas Schouten                                                                                         
                    <Andreas.Schouten at framf        An:     "'opencms-dev at www.opencms.com'" <opencms-dev at www.opencms.com>     
                    ab.de>                         Kopie:                                                                    
                    Gesendet von:                  Blindkopie:                                                               
                    owner-opencms-dev at www.o        Thema:  Re: [opencms-dev] login problem                                   
                    pencms.com                                                                                               
                                                                                                                             
                                                                                                                             
                    07.08.01 18:24                                                                                           
                    Bitte antworten an                                                                                       
                    opencms-dev                                                                                              
                                                                                                                             
                                                                                                                             




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