[ome-devel] Issue after upgrading from 4.4.5 to 4.4.9

[Niko Ehrenfeuchter]

Hey Josh,

On 14.11.2013 11:38, Josh Moore wrote:
[...]
>
> The most likely cause I can think of would be mis-linked data. Were these images (or the dataset they're in) moved between groups recently? Just before the upgrade? You might try running the following SQL query:
>
>    select distinct p.group_id, pdl.group_id, d.group_id, dil.group_id, i.group_id
>      from project p, projectdatasetlink pdl, dataset d, datasetimagelink dil, image i
>     where p.id = pdl.parent and pdl.child = d.id and d.id = dil.parent and dil.child = i.id and i.owner_id = YOURUSERID;

according to the user, he just imported his data plainly into OMERO. 
Currently, he's also the only user in his group. The DB reports this:

>> omero=> select distinct p.group_id, pdl.group_id, d.group_id, dil.group_id, i.group_id
>> omero->     from project p, projectdatasetlink pdl, dataset d, datasetimagelink dil, image i
>> omero->    where p.id = pdl.parent and pdl.child = d.id and d.id = dil.parent and dil.child = i.id and i.owner_id = '552';
>>  group_id | group_id | group_id | group_id | group_id
>> ----------+----------+----------+----------+----------
>>         3 |        3 |        3 |        3 |        3
>> (1 row)

> where any row that doesn't have equal values would be a "Bad Thing".

so that can be ruled out...

Cheers
~Niko