[Bodington-developers] Wtd: Expertise on uploaded_files table structure

[Peter C. <Pet...@me...>]

This is probably one for Matthew.

In summary: Is there one uploaded_files root (ie with a null parent) per
resource, or is there one total?  Did something change with the
uploaded_files rewrite?

In detail: I'm trying to upload files from multiple resources (two
pigeonholes and one logbook).  All works well while I am only uploading
from the first resource.  As soon as I try to upload anything from a
second, the code tries to create a root folder for that resource with a
null parent ID and a blank name.  It then fails because "Cannot insert
duplicate key row in object 'uploaded_files' with unique index
'uploaded_files_unq_name'".

I've not changed the logbook code for a couple of years; it's used in
production, yet it also exhibits this behaviour.  What am I missing?

		- Peter