Error deleting attachment

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

Error deleting attachment

Marc Lijour
I looked around and I found other similar problems but no solutions.
Does somebody know about a fix for that?

Manual fix is good enough. I tried to add/remove values from the database but
I am not sure which one is the right one.

I try to remove an attachment and I get this error message:


------
Un problème est apparu en essayant de réaliser cette action. Veuillez
contacter le support si cela se reproduit

 Information détaillée:
 
Error number 3233 in 3: Exception while deleting attachment josephos.doc of
document Perso.OsnerJoseph.WebHome
Wrapped Exception: Error number 3231 in 3: Exception while loading attachment
josephos.doc of document Perso.OsnerJoseph.WebHome
Wrapped Exception: No row with the given identifier exists:
[com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
com.xpn.xwiki.XWikiException: Error number 3233 in 3: Exception while deleting
attachment josephos.doc of document Perso.OsnerJoseph.WebHome
Wrapped Exception: Error number 3231 in 3: Exception while loading attachment
josephos.doc of document Perso.OsnerJoseph.WebHome
Wrapped Exception: No row with the given identifier exists:
[com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
        at
com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1647)
        at
com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1525)
        at
com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514)
        at
com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105)
        at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
        at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
        at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
        at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)


Wrapped Exception:

com.xpn.xwiki.XWikiException: Error number 3231 in 3: Exception while loading
attachment josephos.doc of document Perso.OsnerJoseph.WebHome
Wrapped Exception: No row with the given identifier exists:
[com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
        at
com.xpn.xwiki.store.XWikiHibernateStore.loadAttachmentContent(XWikiHibernateStore.java:1484)
        at
com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1624)
        at
com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1525)
        at
com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514)
        at
com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105)
        at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
        at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
        at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
        at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)


Wrapped Exception:

org.hibernate.ObjectNotFoundException: No row with the given identifier
exists: [com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
        at
org.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:27)
        at
org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:118)
        at
org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:167)
        at
org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:79)
        at org.hibernate.impl.SessionImpl.load(SessionImpl.java:588)
        at
com.xpn.xwiki.store.XWikiHibernateStore.loadAttachmentContent(XWikiHibernateStore.java:1477)
        at
com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1624)
        at
com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1525)
        at
com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514)
        at
com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105)
        at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198)
        at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
        at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
        at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
        at
org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
        at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at
org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
        at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
        at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
        at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
        at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
        at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
        at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
        at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
        at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error deleting attachment

Marc Lijour
also I don't find the document in the attachment table:

mysql> select * from xwikiattachment where XWA_AUTHOR = 'XWiki.OsnerJoseph';
+-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
| XWA_ID      | XWA_DOC_ID | XWA_FILENAME   | XWA_SIZE | XWA_DATE            |
XWA_AUTHOR        | XWA_VERSION | XWA_COMMENT |
+-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
|   493824533 | 1329616320 | 132795189.img  |    81721 | 2006-02-10 09:45:26 |
XWiki.OsnerJoseph | 1.1         |             |
| -1859509744 |  337185142 | nicky.jpg      |    23505 | 2006-02-10 10:01:51 |
XWiki.OsnerJoseph | 1.3         |             |
|  1870603601 |  337185142 | osner.jpg      |    31151 | 2006-02-10 11:34:43 |
XWiki.OsnerJoseph | 1.3         |             |
|  -427375445 |  337185142 | hotel3.jpg     |    91538 | 2006-02-10 10:18:25 |
XWiki.OsnerJoseph | 1.1         |             |
|  1895209951 |  337185142 | joseph.bmp     |   800754 | 2006-02-10 11:23:08 |
XWiki.OsnerJoseph | 1.1         |             |
|  1612673344 | -593433723 | HatPicture.jpg |   104435 | 2006-02-11 15:23:30 |
XWiki.OsnerJoseph | 1.1         |             |
|   444268704 | -593433723 | osner.jpg      |    31151 | 2006-02-14 10:03:38 |
XWiki.OsnerJoseph | 1.1         |             |
|   652278503 | 1329616320 | jo.jpg         |    91538 | 2006-02-14 09:55:37 |
XWiki.OsnerJoseph | 1.1         |             |
|  -857322110 | -593433723 | jo.jpg         |    91538 | 2006-02-14 09:58:20 |
XWiki.OsnerJoseph | 1.1         |             |
+-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
9 rows in set (0.00 sec)

The problematic files are not there.
How is that possible?

I also tried $xwiki.flushCache() in the page where the files are attached
without success.



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error deleting attachment

jeremi joslin
In reply to this post by Marc Lijour
Hi,
maybe it's a problem with your document name :
Perso.OsnerJoseph.WebHome
I think it doesn't work because you have two points on the document name.


Jérémi
On 2/16/06, Marc Lijour <[hidden email]> wrote:

> I looked around and I found other similar problems but no solutions.
> Does somebody know about a fix for that?
>
> Manual fix is good enough. I tried to add/remove values from the database but
> I am not sure which one is the right one.
>
> I try to remove an attachment and I get this error message:
>
>
> ------
> Un problème est apparu en essayant de réaliser cette action. Veuillez
> contacter le support si cela se reproduit
>
>  Information détaillée:
>
> Error number 3233 in 3: Exception while deleting attachment josephos.doc of
> document Perso.OsnerJoseph.WebHome
> Wrapped Exception: Error number 3231 in 3: Exception while loading attachment
> josephos.doc of document Perso.OsnerJoseph.WebHome
> Wrapped Exception: No row with the given identifier exists:
> [com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
> com.xpn.xwiki.XWikiException: Error number 3233 in 3: Exception while deleting
> attachment josephos.doc of document Perso.OsnerJoseph.WebHome
> Wrapped Exception: Error number 3231 in 3: Exception while loading attachment
> josephos.doc of document Perso.OsnerJoseph.WebHome
> Wrapped Exception: No row with the given identifier exists:
> [com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
>         at
> com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1647)
>         at
> com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1525)
>         at
> com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514)
>         at
> com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105)
>         at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198)
>         at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
>         at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
>         at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
>         at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>         at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>         at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
>         at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
>         at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>         at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>         at
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
>         at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
>         at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
>         at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
>         at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
>         at java.lang.Thread.run(Thread.java:595)
>
>
> Wrapped Exception:
>
> com.xpn.xwiki.XWikiException: Error number 3231 in 3: Exception while loading
> attachment josephos.doc of document Perso.OsnerJoseph.WebHome
> Wrapped Exception: No row with the given identifier exists:
> [com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
>         at
> com.xpn.xwiki.store.XWikiHibernateStore.loadAttachmentContent(XWikiHibernateStore.java:1484)
>         at
> com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1624)
>         at
> com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1525)
>         at
> com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514)
>         at
> com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105)
>         at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198)
>         at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
>         at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
>         at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
>         at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>         at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>         at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
>         at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
>         at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>         at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>         at
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
>         at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
>         at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
>         at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
>         at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
>         at java.lang.Thread.run(Thread.java:595)
>
>
> Wrapped Exception:
>
> org.hibernate.ObjectNotFoundException: No row with the given identifier
> exists: [com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
>         at
> org.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException.java:27)
>         at
> org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventListener.java:118)
>         at
> org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:167)
>         at
> org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:79)
>         at org.hibernate.impl.SessionImpl.load(SessionImpl.java:588)
>         at
> com.xpn.xwiki.store.XWikiHibernateStore.loadAttachmentContent(XWikiHibernateStore.java:1477)
>         at
> com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1624)
>         at
> com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibernateStore.java:1525)
>         at
> com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514)
>         at
> com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105)
>         at com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198)
>         at
> org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421)
>         at
> org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226)
>         at
> org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
>         at
> org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at
> com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:127)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at
> org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
>         at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
>         at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
>         at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
>         at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
>         at
> org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
>         at
> org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
>         at
> org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
>         at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
>         at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
>         at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
>         at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
>         at
> org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
>         at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385)
>         at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748)
>         at
> org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678)
>         at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
>         at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
>         at java.lang.Thread.run(Thread.java:595)
>
>
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
>
>

--
Blog: http://www.jeremi.info
LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724
http://www.xwiki.org
skype: jeremi23 -- msn et gtalk : [hidden email]


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error deleting attachment

Marc Lijour
On February 15, 2006 09:02 pm, jeremi joslin wrote:
> Hi,
> maybe it's a problem with your document name :
> Perso.OsnerJoseph.WebHome
> I think it doesn't work because you have two points on the document name.

Interesting remark. I had understood that it was correct to divide a namespace
by a dot like that: a.b.c , where a.b is the namespace and c the page.
It works fine with the other pages but I may be just lucky? Is that the
problem?

>
> Jérémi
>
> On 2/16/06, Marc Lijour <[hidden email]> wrote:
> > I looked around and I found other similar problems but no solutions.
> > Does somebody know about a fix for that?
> >
> > Manual fix is good enough. I tried to add/remove values from the database
> > but I am not sure which one is the right one.
> >
> > I try to remove an attachment and I get this error message:
> >
> >
> > ------
> > Un problème est apparu en essayant de réaliser cette action. Veuillez
> > contacter le support si cela se reproduit
> >
> >  Information détaillée:
> >
> > Error number 3233 in 3: Exception while deleting attachment josephos.doc
> > of document Perso.OsnerJoseph.WebHome
> > Wrapped Exception: Error number 3231 in 3: Exception while loading
> > attachment josephos.doc of document Perso.OsnerJoseph.WebHome
> > Wrapped Exception: No row with the given identifier exists:
> > [com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
> > com.xpn.xwiki.XWikiException: Error number 3233 in 3: Exception while
> > deleting attachment josephos.doc of document Perso.OsnerJoseph.WebHome
> > Wrapped Exception: Error number 3231 in 3: Exception while loading
> > attachment josephos.doc of document Perso.OsnerJoseph.WebHome
> > Wrapped Exception: No row with the given identifier exists:
> > [com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
> >         at
> > com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibern
> >ateStore.java:1647) at
> > com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibern
> >ateStore.java:1525) at
> > com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514)
> >         at
> > com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105)
> >         at
> > com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198) at
> > org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro
> >cessor.java:421) at
> > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:2
> >26) at
> > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
> >         at
> > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> >         at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat
> >ionFilterChain.java:252) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte
> >rChain.java:173) at
> > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodin
> >gFilter.java:127) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat
> >ionFilterChain.java:202) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte
> >rChain.java:173) at
> > org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter
> >.java:81) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat
> >ionFilterChain.java:202) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte
> >rChain.java:173) at
> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve
> >.java:213) at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve
> >.java:178) at
> > org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipal
> >Valve.java:39) at
> > org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAss
> >ociationValve.java:159) at
> > org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.ja
> >va:59) at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
> >126) at
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
> >105) at
> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j
> >ava:107) at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14
> >8) at
> > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
> >         at
> > org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) at
> > org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) at
> > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:6
> >78) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
> > at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.
> >java:684) at java.lang.Thread.run(Thread.java:595)
> >
> >
> > Wrapped Exception:
> >
> > com.xpn.xwiki.XWikiException: Error number 3231 in 3: Exception while
> > loading attachment josephos.doc of document Perso.OsnerJoseph.WebHome
> > Wrapped Exception: No row with the given identifier exists:
> > [com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
> >         at
> > com.xpn.xwiki.store.XWikiHibernateStore.loadAttachmentContent(XWikiHibern
> >ateStore.java:1484) at
> > com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibern
> >ateStore.java:1624) at
> > com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibern
> >ateStore.java:1525) at
> > com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514)
> >         at
> > com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105)
> >         at
> > com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198) at
> > org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro
> >cessor.java:421) at
> > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:2
> >26) at
> > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
> >         at
> > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> >         at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat
> >ionFilterChain.java:252) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte
> >rChain.java:173) at
> > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodin
> >gFilter.java:127) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat
> >ionFilterChain.java:202) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte
> >rChain.java:173) at
> > org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter
> >.java:81) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat
> >ionFilterChain.java:202) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte
> >rChain.java:173) at
> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve
> >.java:213) at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve
> >.java:178) at
> > org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipal
> >Valve.java:39) at
> > org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAss
> >ociationValve.java:159) at
> > org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.ja
> >va:59) at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
> >126) at
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
> >105) at
> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j
> >ava:107) at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14
> >8) at
> > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
> >         at
> > org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) at
> > org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) at
> > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:6
> >78) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
> > at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.
> >java:684) at java.lang.Thread.run(Thread.java:595)
> >
> >
> > Wrapped Exception:
> >
> > org.hibernate.ObjectNotFoundException: No row with the given identifier
> > exists: [com.xpn.xwiki.doc.XWikiAttachmentContent#2105339254]
> >         at
> > org.hibernate.ObjectNotFoundException.throwIfNull(ObjectNotFoundException
> >.java:27) at
> > org.hibernate.event.def.DefaultLoadEventListener.load(DefaultLoadEventLis
> >tener.java:118) at
> > org.hibernate.event.def.DefaultLoadEventListener.proxyOrLoad(DefaultLoadE
> >ventListener.java:167) at
> > org.hibernate.event.def.DefaultLoadEventListener.onLoad(DefaultLoadEventL
> >istener.java:79) at
> > org.hibernate.impl.SessionImpl.load(SessionImpl.java:588) at
> > com.xpn.xwiki.store.XWikiHibernateStore.loadAttachmentContent(XWikiHibern
> >ateStore.java:1477) at
> > com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibern
> >ateStore.java:1624) at
> > com.xpn.xwiki.store.XWikiHibernateStore.deleteXWikiAttachment(XWikiHibern
> >ateStore.java:1525) at
> > com.xpn.xwiki.doc.XWikiDocument.deleteAttachment(XWikiDocument.java:1514)
> >         at
> > com.xpn.xwiki.XWikiService.actionDelattachment(XWikiService.java:105)
> >         at
> > com.xpn.xwiki.web.ViewEditAction.execute(ViewEditAction.java:198) at
> > org.apache.struts.action.RequestProcessor.processActionPerform(RequestPro
> >cessor.java:421) at
> > org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:2
> >26) at
> > org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164)
> >         at
> > org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:397)
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
> >         at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
> >         at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat
> >ionFilterChain.java:252) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte
> >rChain.java:173) at
> > com.xpn.xwiki.web.SetCharacterEncodingFilter.doFilter(SetCharacterEncodin
> >gFilter.java:127) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat
> >ionFilterChain.java:202) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte
> >rChain.java:173) at
> > org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter
> >.java:81) at
> > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applicat
> >ionFilterChain.java:202) at
> > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilte
> >rChain.java:173) at
> > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve
> >.java:213) at
> > org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve
> >.java:178) at
> > org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipal
> >Valve.java:39) at
> > org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAss
> >ociationValve.java:159) at
> > org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.ja
> >va:59) at
> > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
> >126) at
> > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
> >105) at
> > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.j
> >ava:107) at
> > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:14
> >8) at
> > org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307)
> >         at
> > org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) at
> > org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) at
> > org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:6
> >78) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871)
> > at
> > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.
> >java:684) at java.lang.Thread.run(Thread.java:595)
> >
> >
> >
> >
> > --
> > You receive this message as a subscriber of the [hidden email]
> > mailing list. To unsubscribe:
> > mailto:[hidden email]
> > For general help: mailto:[hidden email]?subject=help
> > ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
>
> --
> Blog: http://www.jeremi.info
> LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724
> http://www.xwiki.org
> skype: jeremi23 -- msn et gtalk : [hidden email]


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error deleting attachment

jeremi joslin
On 2/16/06, Marc Lijour <[hidden email]> wrote:

> On February 15, 2006 09:02 pm, jeremi joslin wrote:
> > Hi,
> > maybe it's a problem with your document name :
> > Perso.OsnerJoseph.WebHome
> > I think it doesn't work because you have two points on the document name.
>
> Interesting remark. I had understood that it was correct to divide a namespace
> by a dot like that: a.b.c , where a.b is the namespace and c the page.
> It works fine with the other pages but I may be just lucky? Is that the
> problem?
I'm not sure, it can be this.
Have you restart your tomcat?

jeremi
--
Blog: http://www.jeremi.info
LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724
http://www.xwiki.org
skype: jeremi23 -- msn et gtalk : [hidden email]


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error deleting attachment

Marc Lijour

> I'm not sure, it can be this.
> Have you restart your tomcat?

I just tried and nothing changed.

I wonder how it can display an attachment which is not (visible to me) in the
database?



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error deleting attachment

jeremi joslin
On 2/16/06, Marc Lijour <[hidden email]> wrote:
>
> > I'm not sure, it can be this.
> > Have you restart your tomcat?
>
> I just tried and nothing changed.
>
> I wonder how it can display an attachment which is not (visible to me) in the
> database?

can you just do an
select * from xwikiattachment;

jeremi

--
Blog: http://www.jeremi.info
LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724
http://www.xwiki.org
skype: jeremi23 -- msn et gtalk : [hidden email]


--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error deleting attachment

Marc Lijour
On February 16, 2006 01:21 am, jeremi joslin wrote:

> On 2/16/06, Marc Lijour <[hidden email]> wrote:
> > > I'm not sure, it can be this.
> > > Have you restart your tomcat?
> >
> > I just tried and nothing changed.
> >
> > I wonder how it can display an attachment which is not (visible to me) in
> > the database?
>
> can you just do an
> select * from xwikiattachment;
I did this one:

mysql> select * from xwikiattachment where XWA_AUTHOR = 'XWiki.OsnerJoseph';

and the document was not there (see 2nd email in the thread). This was last
time.

After restarting xwiki, here is what I get:
mysql> select * from xwikiattachment where XWA_AUTHOR = 'XWiki.OsnerJoseph';
+-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
| XWA_ID      | XWA_DOC_ID | XWA_FILENAME   | XWA_SIZE | XWA_DATE            |
XWA_AUTHOR        | XWA_VERSION | XWA_COMMENT |
+-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
|   493824533 | 1329616320 | 132795189.img  |    81721 | 2006-02-10 09:45:26 |
XWiki.OsnerJoseph | 1.1         |             |
| -1859509744 |  337185142 | nicky.jpg      |    23505 | 2006-02-10 10:01:51 |
XWiki.OsnerJoseph | 1.3         |             |
|  1870603601 |  337185142 | osner.jpg      |    31151 | 2006-02-10 11:34:43 |
XWiki.OsnerJoseph | 1.3         |             |
|  -427375445 |  337185142 | hotel3.jpg     |    91538 | 2006-02-10 10:18:25 |
XWiki.OsnerJoseph | 1.1         |             |
|  1895209951 |  337185142 | joseph.bmp     |   800754 | 2006-02-10 11:23:08 |
XWiki.OsnerJoseph | 1.1         |             |
|  1612673344 | -593433723 | HatPicture.jpg |   104435 | 2006-02-11 15:23:30 |
XWiki.OsnerJoseph | 1.1         |             |
|   444268704 | -593433723 | osner.jpg      |    31151 | 2006-02-14 10:03:38 |
XWiki.OsnerJoseph | 1.1         |             |
|   652278503 | 1329616320 | jo.jpg         |    91538 | 2006-02-14 09:55:37 |
XWiki.OsnerJoseph | 1.1         |             |
|  -857322110 | -593433723 | jo.jpg         |    91538 | 2006-02-14 09:58:20 |
XWiki.OsnerJoseph | 1.1         |             |
|  2105339254 |  337185142 | josephos.doc   |        0 | 2006-02-15 09:20:14 |
XWiki.OsnerJoseph | 1.1         |             |
|  1134896447 |  337185142 | soj.doc        |        0 | 2006-02-15 09:16:51 |
XWiki.OsnerJoseph | 1.1         |             |
+-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
11 rows in set (0.00 sec)

My 2 rogue documents are back! I still can't delete them, the same error
appears.

I also have a jo.jpg in 2 places with the same version number, humm, is that
correct?

Can I just delete them from this table then? What about the jo.jpg, do I
remove one version?

> jeremi
>
> --
> Blog: http://www.jeremi.info
> LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724
> http://www.xwiki.org
> skype: jeremi23 -- msn et gtalk : [hidden email]



--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
Reply | Threaded
Open this post in threaded view
|

Re: Error deleting attachment

Mark Robinson-6
Hi Marc.

I had exactly this problem when I was duplicating some pages with
attachments via the copyDocument() method and the attachment was not
transferring.

I ended up with a reference to the attachment in the xwikiattachment
table but no corresponding record in xwikiattachment_content.  This lack
of content was preventing me from using the normal delete.

So I located the content of the attachment that was to be copied (eg "id
= 66666") and inserted the content from that using the missing reference
number as the id.

Then the page could display correctly and the usual delete method
worked.

Example SQL (55555 is the missing content id):

INSERT INTO xwikiattachment_content SELECT '55555', XWA_CONTENT from
xwikiattachment_content where XWA_ID = '66666';

A rbit messy, but it worked.

Good luck.

Cheers,

Mark

On Thu, 2006-02-16 at 01:29 -0500, Marc Lijour wrote:

> On February 16, 2006 01:21 am, jeremi joslin wrote:
> > On 2/16/06, Marc Lijour <[hidden email]> wrote:
> > > > I'm not sure, it can be this.
> > > > Have you restart your tomcat?
> > >
> > > I just tried and nothing changed.
> > >
> > > I wonder how it can display an attachment which is not (visible to me) in
> > > the database?
> >
> > can you just do an
> > select * from xwikiattachment;
>
> I did this one:
>
> mysql> select * from xwikiattachment where XWA_AUTHOR = 'XWiki.OsnerJoseph';
>
> and the document was not there (see 2nd email in the thread). This was last
> time.
>
> After restarting xwiki, here is what I get:
> mysql> select * from xwikiattachment where XWA_AUTHOR = 'XWiki.OsnerJoseph';
> +-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
> | XWA_ID      | XWA_DOC_ID | XWA_FILENAME   | XWA_SIZE | XWA_DATE            |
> XWA_AUTHOR        | XWA_VERSION | XWA_COMMENT |
> +-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
> |   493824533 | 1329616320 | 132795189.img  |    81721 | 2006-02-10 09:45:26 |
> XWiki.OsnerJoseph | 1.1         |             |
> | -1859509744 |  337185142 | nicky.jpg      |    23505 | 2006-02-10 10:01:51 |
> XWiki.OsnerJoseph | 1.3         |             |
> |  1870603601 |  337185142 | osner.jpg      |    31151 | 2006-02-10 11:34:43 |
> XWiki.OsnerJoseph | 1.3         |             |
> |  -427375445 |  337185142 | hotel3.jpg     |    91538 | 2006-02-10 10:18:25 |
> XWiki.OsnerJoseph | 1.1         |             |
> |  1895209951 |  337185142 | joseph.bmp     |   800754 | 2006-02-10 11:23:08 |
> XWiki.OsnerJoseph | 1.1         |             |
> |  1612673344 | -593433723 | HatPicture.jpg |   104435 | 2006-02-11 15:23:30 |
> XWiki.OsnerJoseph | 1.1         |             |
> |   444268704 | -593433723 | osner.jpg      |    31151 | 2006-02-14 10:03:38 |
> XWiki.OsnerJoseph | 1.1         |             |
> |   652278503 | 1329616320 | jo.jpg         |    91538 | 2006-02-14 09:55:37 |
> XWiki.OsnerJoseph | 1.1         |             |
> |  -857322110 | -593433723 | jo.jpg         |    91538 | 2006-02-14 09:58:20 |
> XWiki.OsnerJoseph | 1.1         |             |
> |  2105339254 |  337185142 | josephos.doc   |        0 | 2006-02-15 09:20:14 |
> XWiki.OsnerJoseph | 1.1         |             |
> |  1134896447 |  337185142 | soj.doc        |        0 | 2006-02-15 09:16:51 |
> XWiki.OsnerJoseph | 1.1         |             |
> +-------------+------------+----------------+----------+---------------------+-------------------+-------------+-------------+
> 11 rows in set (0.00 sec)
>
> My 2 rogue documents are back! I still can't delete them, the same error
> appears.
>
> I also have a jo.jpg in 2 places with the same version number, humm, is that
> correct?
>
> Can I just delete them from this table then? What about the jo.jpg, do I
> remove one version?
>
> > jeremi
> >
> > --
> > Blog: http://www.jeremi.info
> > LinkedIn: https://www.linkedin.com/profile?viewProfile=&key=1437724
> > http://www.xwiki.org
> > skype: jeremi23 -- msn et gtalk : [hidden email]
>
> plain text document attachment (message-footer.txt)
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws
--
Mark Robinson
Regional Clarity Project Manager (HK & AU)

TNT Freight Managment (Australia) Limited
TNT Freight Managment (Hong Kong) Limited

3rd floor, Two Harbourfront, 18-22 Tak Fung Street,
Hung Hom, Kowloon, Hong Kong
Tel: +852 26213688 (ext. 374)
Mob: +852 90335711

Em : [hidden email]
Web: http://www.tntfreight.com





--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
ObjectWeb mailing lists service home page: http://www.objectweb.org/wws