Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

Files uploaded not visible.
Last Post 09/06/2011 7:34 PM by Synoptek Web Team. 4 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Synoptek Web Team
New Member
New Member
Posts:10


--
08/15/2011 10:46 PM
I am having an issue where once files are uploaded and approved they are not visible in the UI. The files are visible if looking at the folder path via windows explorer and can be found in the db. I have found that they are uploading with the LastVersionId=null, which seems to be the issue. I discovered this from going through the scripts and seeing that the RepairPortalStructure script fixed the issue.

If I modify a freshly uploaded file to only add its own ID to the LastVersionId, it shows up just fine.

How can I fix this issue so that the files automatically have their LastVersionId automatically set to their own EntryId?
Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
08/24/2011 1:44 PM
Sounds like this is an older version of DMX. I faintly remember having seen that once but that was resolved a long time ago. What version are you using?
Synoptek Web Team
New Member
New Member
Posts:10


--
08/25/2011 7:24 PM
We are using version 5.3.8 of DMX.
Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
08/30/2011 2:30 PM
There is a trigger on the DMX_Entries table which ensures that the LastVersionId gets set. Either the trigger is not there or it is not firing. If it isn't there then one of the updates/sql scripts must have failed on your installation. Did you see anything unusual during the installation process?

Peter
Synoptek Web Team
New Member
New Member
Posts:10


--
09/06/2011 7:34 PM
Peter, thanks for the tip. I investigated the triggers on the DMX_Entries table and sure enough, when the site was moved from one server to another, the triggers were left off the table. I have added the triggers back to that table and it is working correctly again.

Thank you for your help. Cheers!
You are not authorized to post a reply.