After updating to 5.0 stable file icons are broken

[zac]

Hi there,

Thank you for your answer. This is the output from the server.log that apperead when I performed the Reset:

Code: Select all

2011-02-22 00:57:05,516 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: -95, SQLState: 22003
2011-02-22 00:57:05,516 ERROR [org.hibernate.util.JDBCExceptionReporter] Type Conversion not supported
2011-02-22 00:57:05,517 WARN  [com.openkm.core.Config] could not insert: [com.openkm.dao.bean.MimeType]
com.openkm.core.DatabaseException: could not insert: [com.openkm.dao.bean.MimeType]
        at com.openkm.dao.MimeTypeDAO.create(MimeTypeDAO.java:64)
        at com.openkm.core.Config.resetMimeTypes(Config.java:746)
        at com.openkm.servlet.admin.MimeTypeServlet.doGet(MimeTypeServlet.java:110)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
        at java.lang.Thread.run(Thread.java:636)
Caused by: org.hibernate.exception.DataException: could not insert: [com.openkm.dao.bean.MimeType]
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:77)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
        at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:40)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2158)
        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2638)
        at org.hibernate.action.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:48)
        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:248)
        at org.hibernate.event.def.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:298)
        at org.hibernate.event.def.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:181)
        at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:107)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:187)
        at org.hibernate.event.def.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:33)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:172)
        at org.hibernate.event.def.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:27)
        at org.hibernate.event.def.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:70)
        at org.hibernate.impl.SessionImpl.fireSave(SessionImpl.java:535)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:523)
        at org.hibernate.impl.SessionImpl.save(SessionImpl.java:519)
        at com.openkm.dao.MimeTypeDAO.create(MimeTypeDAO.java:52)
        ... 23 more
Caused by: java.sql.SQLException: Type Conversion not supported
        at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.setParameter(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.setCharacterStream(Unknown Source)
        at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.setCharacterStream(CachedPreparedStatement.java:226)
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setCharacterStream(WrappedPreparedStatement.java:745)
        at org.hibernate.type.TextType.set(TextType.java:22)
        at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136)
        at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:107)
        at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1997)
        at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:1974)
        at org.hibernate.persister.entity.AbstractEntityPersister$3.bindValues(AbstractEntityPersister.java:2152)
        at org.hibernate.id.insert.AbstractSelectingDelegate.performInsert(AbstractSelectingDelegate.java:32)
        ... 39 more

[jllort]

Can you try executing it:

Code: Select all

INSERT INTO OKM_MIME_TYPE (MT_ID, MT_NAME, MT_IMAGE_CONTENT, MT_IMAGE_MIME) VALUES (1, 'application/vnd.oasis.opendocument.text', 'R0lGODlhFwAQAOeeABUyQBkyPxc2Rhg5SRg6Sh84RR05Rxk7Sxk7TCE6SBk9Tho9Tho+Txo+UBtAUhtBUxxEVx1FWB5GWSVLXSZOYTVWZzpVYkJVYkNXYz5ZZj5aZ0VYYjpdb0Jeb0JfbUNgbklebEhfa0Bic0pfbUxicUZlc01jckpqeVFpeUtsfFNqelRreFhuflJxgFZvgFl0hVl0hlp1hl52hl55i155jF56jF97jWB7jWR6iGV9iGl/jmiAkG9/h2uAjWiElnWDjG+GlXaEjniIkHeOmHmNmnaPoHeQoYGSnHyUn32UoICUooWTnIaWoYyVmo+Xm4yZoI+Yn4qbp46bo4mdq4qeq5GcpI6eqo+gq5Kgpo2isI6ir5WhqZGlrpakrZeosaGlqJmos56nraGnqZ2or5ypsp6ttpyuuaWsr6CutqGwuqKyvaOzu6KzvqO0v6S0v6izvKe1vq20t6e2wai2wLK1tqi4w7K4u7W4urK7wba6vLe7vbe8vrPBy77Bw7nEy7/Dxb/ExbrGzMXHyMbJysPKzcLN1MfMzsPP1tDR0tHS087T1tHT09DV2NTV1tTW1tTb39Tc39fd4Nzi5tzj597k5+Lm6uHn6uPo6+fn5+Pp7Onq6/Dx8fv7+/3+/v///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////yH5BAEKAP8ALAAAAAAXABAAAAjlAP8J/HeCAgEATpwI+cHjR5OBECO+0ADAghM9mDh5MkTpzJ2IEV2EeORJo0InPyRx4uEE5EATK2QACMCDRxNHTlR64uFSoIUEAGZiKqmJxwoTX1b0/Oekk6ennpzQGRSpUZ8fP3pG8gToDI9OPJ6kqcNn0yYhPQcN+hm0hI8iRqZMycSp5VISEwAU2MRJI1RND3vGOJHXRKHDhfwaCuzyRokIAErIlZvpKZ2l/26IeADgTKfPoDt9wayZMxHEiDmNXppjc2QjsGFP2fRx6YwSnFmY3W12EGOXFIIGaFLli3HjxUEGBAA7', 'image/gif');
INSERT INTO OKM_MIME_TYPE_EXTENSION (MTE_ID, MTE_NAME) VALUES (1, 'ott');
INSERT INTO OKM_MIME_TYPE_EXTENSION (MTE_ID, MTE_NAME) VALUES (1, 'odt');

And tell me where's the error

[zac]

those are the errors I receive when running the 3 queries:

Code: Select all

Application error
Class: 	java.sql.SQLException
Message: 	Wrong data type: java.io.IOException: hexadecimal string contains non hex character
Date: 	Thu Feb 24 00:29:10 PST 2011

Class: 	java.sql.SQLException
Message: 	Integrity constraint violation - no parent FK198BAD77C645F9B7 table: OKM_MIME_TYPE
Date: 	Thu Feb 24 00:29:53 PST 2011


Class: 	java.sql.SQLException
Message: 	Integrity constraint violation - no parent FK198BAD77C645F9B7 table: OKM_MIME_TYPE
Date: 	Thu Feb 24 00:30:00 PST 2011

Best regards,
Silviu Vulcan

[jllort]

Change first query for it:

Code: Select all

INSERT INTO OKM_MIME_TYPE (MT_ID, MT_NAME, MT_IMAGE_CONTENT, MT_IMAGE_MIME) VALUES (1, 'application/vnd.oasis.opendocument.text', 'Strange error', 'image/gif');

And execute the others. I'm trying to understanding which part of query is wrong. After it delete all, because it'll not be a valid image.

[zac]

Your latest query produces this error:

Code: Select all

Application error
Class: 	java.sql.SQLException
Message: 	Wrong data type: java.io.IOException: hexadecimal string with odd number of characters
Date: 	Thu Feb 24 01:36:11 PST 2011

Maybe the database query window from the administrator interface is not working properly?

[jllort]

can you try removing / and . from query to see if it runs ?

[zac]

I tried running without . and / and I still get the same error. I tried even running

Code: Select all

INSERT INTO OKM_MIME_TYPE (MT_ID, MT_NAME, MT_IMAGE_CONTENT, MT_IMAGE_MIME) VALUES (1,'A','A','A');

and I still get the same errors.

Regards

[jllort]

Sincerally I don't know what's happening to you. Without connecting to that system and take some look on it ... I don't know what could be happen.

You could try with data studio and connect directly to database. The jboss must be stopped for doing it, the database is on /server/default/data/hypersonic

[zac]

Well, thank's a lot for your help. It's not a major nuisance. I'll try using data studio again and see what I come up with. Thanks a lot.

[pavila]

I made an migration from OpenKM-5.0-RC1 to OpenKM-5.0.2 and there was no problems.