Advertisement
matthewpoer

SugarCRM Ghost Meeting Remindrs

Oct 5th, 2012
49
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.23 KB | None | 0 0
  1. -- You deleted your Meetings but you're still getting Meeting Reminders?
  2. -- also applies to Calls, maybe Tasks.
  3. -- First clear browser cache. That's the more likely cause. If that fails, check these out:
  4.  
  5. select * from dbo.meetings where deleted = 0 ;
  6. --
  7. select * from dbo.meetings_contacts
  8. join meetings on meeting_id = meetings.id
  9. where meetings_contacts.deleted = 0 and meetings.deleted = 1;
  10.  
  11. select * from dbo.meetings_leads
  12. join meetings on meeting_id = meetings.id
  13. where meetings_leads.deleted = 0 and meetings.deleted = 1;
  14.  
  15. select * from dbo.meetings_users
  16. join meetings on meeting_id = meetings.id
  17. where meetings_users.deleted = 0 and meetings.deleted = 1;
  18. --
  19. update dbo.meetings_users set meetings_users.deleted = 1
  20. from dbo.meetings_users
  21. join meetings on meeting_id = meetings.id
  22. where meetings_users.deleted = 0 and meetings.deleted = 1;
  23.  
  24. update dbo.meetings_leads set meetings_leads.deleted = 1
  25. from dbo.meetings_leads
  26. join meetings on meeting_id = meetings.id
  27. where meetings_leads.deleted = 0 and meetings.deleted = 1;
  28.  
  29. update dbo.meetings_contacts set meetings_contacts.deleted = 1
  30. from dbo.meetings_contacts
  31. join meetings on meeting_id = meetings.id
  32. where meetings_contacts.deleted = 0 and meetings.deleted = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement