Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- You deleted your Meetings but you're still getting Meeting Reminders?
- -- also applies to Calls, maybe Tasks.
- -- First clear browser cache. That's the more likely cause. If that fails, check these out:
- select * from dbo.meetings where deleted = 0 ;
- --
- select * from dbo.meetings_contacts
- join meetings on meeting_id = meetings.id
- where meetings_contacts.deleted = 0 and meetings.deleted = 1;
- select * from dbo.meetings_leads
- join meetings on meeting_id = meetings.id
- where meetings_leads.deleted = 0 and meetings.deleted = 1;
- select * from dbo.meetings_users
- join meetings on meeting_id = meetings.id
- where meetings_users.deleted = 0 and meetings.deleted = 1;
- --
- update dbo.meetings_users set meetings_users.deleted = 1
- from dbo.meetings_users
- join meetings on meeting_id = meetings.id
- where meetings_users.deleted = 0 and meetings.deleted = 1;
- update dbo.meetings_leads set meetings_leads.deleted = 1
- from dbo.meetings_leads
- join meetings on meeting_id = meetings.id
- where meetings_leads.deleted = 0 and meetings.deleted = 1;
- update dbo.meetings_contacts set meetings_contacts.deleted = 1
- from dbo.meetings_contacts
- join meetings on meeting_id = meetings.id
- where meetings_contacts.deleted = 0 and meetings.deleted = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement