Jump to content
TNG Community
annvwuelfing

Timeout - Unlinked media

Recommended Posts

annvwuelfing

Has anyone noticed a problem lately with the "Unlinked only" checkbox on the TNG Admin Media screen? I have used this for several years to keep track of media that still needs to be linked but suddenly within the last month or so it has started to time out. I tried running what I thought would be the underlying query (see below) but got the same result. I am wondering if there is a missing index on the tng_medialinks table??? I don't see one that is on just the mediaID field. Any ideas?

Select * from tng_media

where mediaID not in (select distinct mediaID from tng_medialinks)

Share this post


Link to post
Share on other sites
stores

I am using version 10.1 and it ran just fine for me, showing the only two documents I have unlinked, and it only took 15 or 20 seconds to run...

Share this post


Link to post
Share on other sites
Barry Ennever

It's been a while but....I am seeing this same problem running Admin >> Places & searching for places 'With 'no associated events'.

Did you, or anyone, find a fix by any chance?  I'm running V12.1

Many tks

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×