[Building Sakai] Assignment attachment issue

[Zhen Qian]

Hi, Kelly:

If you mouse-over the attachment title, and save the link, you will find
the link of this format:

http://
{Server_url}/access/content/attachment/{site_id}Assignments/{assignment_id}/toolOrder.xml

The attachment is added in as a resource item. So you should be able to
trace it down in the content_resource table instead:

Try this:

select * from content_resource where
in_collection='/attachment/{site_id}Assignments/{assignment_id}'

You need to swap in values for the above attributes in curly braces.

Thanks,

- Zhen

On Tue, Jul 31, 2012 at 2:03 PM, Geng, Kelly <gengx at muohio.edu> wrote:

> Hi Assignment developers,****
>
> ** **
>
> We got a professor attached a word doc to his assignment, but is unable to
> open OR remove it now. The Remove link doesn’t do anything and no errors
> found in catalina.out. Clicking on the doc name returns an HTTP 404.  I’m
> thinking it’s something funky about the doc name or content. ? I can’t seem
> to find where the location of this doc is stored in the database. Encoded
> in the xml?  Can you point a direction of how to solve this issue? I
> attached a screenshot and highlighted the problematic doc. Other files are
> fine.****
>
> ** **
>
> Thanks,****
>
> Kelly****
>
> ** **
>
> Miami University****
>
> ** **
>
> ** **
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120731/68a01e77/attachment.html