Please make sure that you are not watching issues.

yes, I'm sure

So you have no issues another "My Watched Issues"? What alerts are you receiving?

1) no issue on watched

2) assigned resource

Is it you who is the assigned resource? do you have auto alert for issue resource on?

1) no

2) yes

Ok, thanks got it now.

Please run the following sql to update a strored procedure to fix the issue:

/*******************

* geminigetusersforissuealert

IF EXISTS(SELECT name FROM sysobjects WHERE name='geminigetusersforissuealert')

DROP PROCEDURE geminigetusersforissuealert

CREATE PROCEDURE geminigetusersforissuealert

@projectid NUMERIC(10,0),

@issueid NUMERIC(10,0)

as

begin

-- issue watchers

SELECT userid,1024 AS watchcode

into #temp1

FROM geminiwatchissues WHERE projectid=@projectid AND issueid=@issueid

AND userid not in (SELECT userid FROM geminiusersettings WHERE sname=N'ReceiveEmailAlerts' AND svalue=N'N')

-- project watchers

SELECT userid,watchcode

into #temp2

FROM geminiwatchproject WHERE projectid=@projectid AND userid not in (SELECT userid FROM #temp1)

AND userid not in (SELECT userid FROM geminiusersettings WHERE sname=N'ReceiveEmailAlerts' AND svalue=N'N')

SELECT a.userid,a.watchcode,b.emailaddress

into #temp3

FROM #temp1 a, geminiusers b WHERE a.userid=b.userid

SELECT a.userid,a.watchcode,b.emailaddress FROM #temp2 a, geminiusers b WHERE a.userid=b.userid

SELECT a.userid,a.watchcode,a.emailaddress,ISNULL(b.svalue,N'H') AS emailformat,ISNULL(c.svalue,N'Y') AS emailmyself

FROM #temp3 a

LEFT OUTER JOIN (SELECT userid,svalue FROM geminiusersettings WHERE sname=N'EmailFormat') b on b.userid=a.userid

LEFT OUTER JOIN (SELECT userid,svalue FROM geminiusersettings WHERE sname=N'EmailMyChanges') c on c.userid=a.userid

end

go