Jivespace: Message List - Can only see attachments when editing

Re: Can only see attachments when editing

communities@jivesoftware.com — Tue, 23 Jun 2009 12:53:02 GMT

Excellent, let me know if you need anything else. Thanks!

-Todd

Re: Can only see attachments when editing

communities@jivesoftware.com — Tue, 23 Jun 2009 01:11:29 GMT

We had to also scrub the references to the corrupted attachments from jiveAttachVersion in addtion to jiveAttachment. After clearing the cache, the problem finally went away in our testing server.

We cleaned out the production database and now waiting to see if the user is able to re-attach the files succesfully.

Otherwise, I think we are good now with the procedure.

Re: Can only see attachments when editing

communities@jivesoftware.com — Mon, 22 Jun 2009 17:52:39 GMT

You will definitely want to restart after making a database change like this. A cache clear might be enough but I would suggest a restart. Thanks.

-Todd

Re: Can only see attachments when editing

communities@jivesoftware.com — Mon, 22 Jun 2009 17:50:51 GMT

After scrubbing jiveAttachment and jiveAttachData, here is what we see now...

1. Indication that something is still wrong when viewing the document

2. When you edit, however, you can see we successfully removed the attachments successfully from the database via SQL

Are we suppose to clear the cache or restart the application?

Re: Can only see attachments when editing

communities@jivesoftware.com — Mon, 22 Jun 2009 13:32:21 GMT

Would you pelase show me a screenshot of what you are seeing here?

Also, it is a little odd that they had a corresponding entry in jiveAttachData. You should be able to confirm that this is the same bug by doing the following:

1. Create a new document with attachments and don't save as a Draft. They should work

2. Create a new document with attachments and save as draft then publish, they should be broken.

-Todd

Re: Can only see attachments when editing

communities@jivesoftware.com — Sat, 20 Jun 2009 05:18:33 GMT

Hi Todd.

Removing the entries from jiveAttachment did remove the attachments and in fact they each had a corresponding entry in jiveAttachData.

However, the Attachments header is still visible when viewing the document. Is this a normal result before re-attaching the files?

Re: Can only see attachments when editing

communities@jivesoftware.com — Fri, 19 Jun 2009 18:50:52 GMT

No problem! Please let me know if you need anything else.

-Todd

Re: Can only see attachments when editing

communities@jivesoftware.com — Fri, 19 Jun 2009 18:49:28 GMT

Thanks for the useful information.

Re: Can only see attachments when editing

communities@jivesoftware.com — Fri, 19 Jun 2009 18:29:18 GMT

Hi Mel,

Just to be certain, the attachments do become corrupted so they need to be removed from the database? We cannot add the missing entries in jiveAttachData as an alternate solution?

You might be able to do this. It seems just as easy to remove the entries from the jiveAttachment table and then use the UI to add them back. Each entry in jiveAttachment should have a corresponding entry in jiveAttachData which holds the actual data of the uploaded attachment. If either one is missing it is considered orphaned data. Thanks.

-Todd

Re: Can only see attachments when editing

communities@jivesoftware.com — Fri, 19 Jun 2009 18:21:40 GMT

Just to be certain, the attachments do become corrupted so they need to be removed from the database? We cannot add the missing entries in jiveAttachData as an alternate solution?

Sorry, haven't had the time yet to review the jiveAttachData table's relationship with attachments.