I shared this with Ms. VanAuken earlier, but I should have
responded to the listserv. This script was what I received from TMS support to
fix the problem.
Delete from MediaXrefs
where MediaMasterID not in (select MediaMasterID
from MediaMaster)
and TableID = 108
Maury Ford
Collections Manager
Paradise Valley, Arizona
From: The Museum System
(TMS) Users [mailto:[log in to unmask]] On Behalf Of Vanessa
Caldas
Sent: Tuesday, April 06, 2010 9:37 AM
To: [log in to unmask]
Subject: Re: Thumbnails in light box
I also had the same problem. I tried redoing the thumbnail,
deleting that and the main image file and redoing both, reattaching to the
object file and none of those worked. The only way I got it to work was
to actually delete the object file itself and reenter it. By NO means the
best way to do this, but it was the only solution I was able to find. I
would love to hear if anyone else has solved this issue in any other way.
Vanessa
-------------------------------------------
Vanessa Caldas
Assistant Registrar
The Heckscher
Museum of Art
2 Prime Avenue • Huntington NY 11732
Tel 631.845.5011 • Fax 631.845.5077
P Please be kind
to the environment and think before you print.
-----Original Message-----
From: The Museum System (TMS) Users [mailto:[log in to unmask]]On Behalf Of Michelle VanAuken
Sent: Tuesday, April 06, 2010 11:18 AM
To: [log in to unmask]
Subject: Thumbnails in light boxGood day TMS experts.
I'm experiencing a peculiar situation, and wonder if anyone has encountered the same...
We have thumbnails that do not appear in the light box, but the same thumbnail appears in all other views (list view, list with images, data entry, label copy).
I've tried everything from updating the thumbnail in the media module, to completely recreating a new media file and thumbnail. There seems nothing different/incorrect in the media file or thumbnail, but I must be overlooking something. This seems like such an elementary issue, but I'm stumped. Can anyone offer a suggestion?
My thanks, in advance.
Michelle VanAuken
Picker Art Gallery, Colgate University
13 Oak Drive, Hamilton, NY 13346
315.228.7692
[log in to unmask]