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

Bring2mind Forums

DMX_EntryTriggerInsert issue...
Last Post 02/05/2013 6:51 PM by Mitchell Gray. 1 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Mitchell Gray
New Member
New Member
Posts:2


--
02/04/2013 5:40 PM
According to Peter I am having issues with a malfunctioning trigger that is causing added files/folders not to show up in a timely fashion (hours of delay) in the DMX exchange. I believe it might be something related to this forum post:

http://www.bring2mind.net...v/topic/Default.aspx

However, I have no idea how to see how this trigger is working or how to implement the fix listed. Anyone give me a lead on where I might find how to fix this?

Thanks,
-Alex-
Mitchell Gray
New Member
New Member
Posts:2


--
02/05/2013 6:51 PM
I was able to recreate the triggers which solved the issue. Still looking into how triggers were deleted or not installed.

I recreated the triggers:
-Find a working installation of DNN with DMX.
-In SSMS open the db that has the working DMX install
-Find the DMX_Entries table
-Find the triggers folder.
-Copy each of the 3 triggers SQL statements (DMX_EntryTriggerDelete, DMX_EntryTriggerInsert, DMX_EntryTriggerUpdate) to a separate text file.
-Using SSMS open the db with the Missing DMX triggers
-Find the DMX_Entries table
-Find the trigger folder and open
-Create new triggers under the folder for each of the missing triggers (DMX_EntryTriggerDelete, DMX_EntryTriggerInsert, DMX_EntryTriggerUpdate)using the template
-Execute the template to create the triggers.
-Paste the corresponding sql into each of the triggers from the text files you saved.
-Execute the sql.

Probably a much easier way to do this but this is how I solved.
Thanks,
-Alex-
You are not authorized to post a reply.