Jump to content

816 Cannot sort by Import Date


exterminador
 Share

Recommended Posts

Hi,

 

When trying to sort by More Tags -> System -> Import Date it seems to not find any files and it shows the "No items match your search criteria".

 

I've seen this issue before but I thought probably my catalog didn't get updated correctly at some point. But now I recreated the catalog with build 816 and it also happens.

 

The error in the postgreSQL logs:

 

2013-06-07 10:03:51 CEST ERROR: no existe la columna b_a01.id_mediaitem en carácter 339

2013-06-07 10:03:51 CEST SENTENCIA: select distinct m.ID, m.Name, m.MediaFormatUi, m.Deleted, m.HashCode, m.ID_ImportSession, m.ID_File, b_a01.ImportTime, m.ID_User as ID_User, m.ID_SystemFlag as ID_SystemFlag, m.ID_ColorLabel as ID_ColorLabel, m.ID_Rating as ID_Rating, image.ImageOrientation as ImageOrientation from MediaItems m

left join ImportSession b_a01 on m.ID = b_a01.ID_MediaItem

left join image image on m.ID = image.ID_MediaItem where not m.Deleted

and

m.Id in (select distinct ID_MediaItem from Synchronize)

order by b_a01.ImportTime Desc

 

 

Regards

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...