[opencms-dev] Strange errors on startup

[Michael Moossen]

Hi Fabian!

you can not just update from MySql version < 4.1 to version >= 4.1 since 
OpenCms uses different db drivers (ie. SQL queries, DDL queries. see 
/setup/database/mysql(mysql41)/create_db.sql and create_tables.sql)
the easiest way to update, is to dump the old db, install OpenCms on the 
new db and import the dump. but here you have to ensure you are using 
the right parameters to create the dump and to import it to maintain the 
right encoding of the data (since mysql < 4.1 does not support utf8).
i am not sure but you may need to update your jdbc driver as well.

Kind regards,
Michael

-------------------

Alkacon Software GmbH - The OpenCms Experts

http://www.alkacon.com
http://www.opencms.org



Fabian Huschka wrote:
> Hello List,
> 
> we had OpenCms running perfectly on our test system. However after a
> MySql update we receive strange error messages like the one below and
> the system is no longer accessible.
> 
> Any ideas what might be wrong and/or how to fix the issue?
> 
> Short system overview:
> 
> OpenCms 6.2.3
> MySql Ver 14.7 Distrib 4.1.10a
> Tomcat 5.5.20
> 
> Help is appreciated!
> 
> 
> \Fabian
> 
> 06 Feb 2007 20:08:40,104 ERROR [.workplace.CmsWorkplaceManager:1323]
> Error reading view folder: [B at 1041876/
> org.opencms.file.CmsVfsResourceNotFoundException: Error reading resource
> from path "/[B at 1041876/".
>         at
> org.opencms.file.CmsVfsResourceNotFoundException.createException(CmsVfsResourceNotFoundException.java:78)
>         at org.opencms.db.CmsDbContext.throwException(CmsDbContext.java:213)
>         at org.opencms.db.CmsDbContext.report(CmsDbContext.java:197)
>         at
> org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:3830)
>         at org.opencms.file.CmsObject.readResource(CmsObject.java:2711)
>         at
> org.opencms.file.CmsObject.readPropertyObject(CmsObject.java:2577)
>         at
> org.opencms.workplace.CmsWorkplaceManager.initWorkplaceViews(CmsWorkplaceManager.java:1286)
>         at
> org.opencms.workplace.CmsWorkplaceManager.initialize(CmsWorkplaceManager.java:799)
>         at
> org.opencms.main.OpenCmsCore.initConfiguration(OpenCmsCore.java:1001)
>         at org.opencms.main.OpenCmsCore.initContext(OpenCmsCore.java:1111)
>         at
> org.opencms.main.OpenCmsCore.upgradeRunlevel(OpenCmsCore.java:1527)
>         at
> org.opencms.main.OpenCmsListener.contextInitialized(OpenCmsListener.java:87)
>         at
> org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3763)
>         at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4211)
>         at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
>         at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
>         at
> org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
>         at
> org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:904)
>         at
> org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:867)
>         at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:474)
>         at
> org.apache.catalina.startup.HostConfig.start(HostConfig.java:1122)
>         at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:310)
>         at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
>         at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1021)
>         at
> org.apache.catalina.core.StandardHost.start(StandardHost.java:718)
>         at
> org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1013)
>         at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:442)
>         at
> org.apache.catalina.core.StandardService.start(StandardService.java:450)
>         at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:709)
>         at org.apache.catalina.startup.Catalina.start(Catalina.java:551)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
>         at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
>         at java.lang.reflect.Method.invoke(Method.java:585)
>         at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:294)
>         at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:432)
> Caused by: org.opencms.file.CmsVfsResourceNotFoundException: Unable to
> read resource "/[B at 1041876".
>         at
> org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1434)
>         at
> org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:5590)
>         at
> org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5595)
>         at
> org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:3828)
>         ... 32 more
> 
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev