Error count is different

[GoogleCodeExporter]

What steps will reproduce the problem?
1.Execute query like this: "select host, count(*) from Elmah_Error
group by host" and see error count by host (xServer 1606)
2.Opening xsite/Elmah.axd and see error count on page (Errors 1 to 15 of total 
1.461)
3.They are different

What is the expected output? What do you see instead?
Query result and elmah.axd page result different. They should be same.

What version of the product are you using? On what operating system?
Last version 1.1 Win 2003, .net 2.0

Please provide any additional information below.
Are there any tricks to see differensies ?

Original issue reported on code.google.com by ilker.m...@gmail.com on 8 Oct 2010 at 9:14

[GoogleCodeExporter]

Hi,

Would I be right in assuming this is using Sql Server?

Thanks,

James

Original comment by jamesdriscoll71 on 8 Oct 2010 at 9:31

[GoogleCodeExporter]

yes Sql server 2005, sorry for not told about sql server. 

Original comment by ilker.m...@gmail.com on 8 Oct 2010 at 11:50

[GoogleCodeExporter]

> select host, count(*) from Elmah_Error
> group by host

ELMAH distinguishes logs by application and not by host so you really need to 
count grouping by application and that should tally. I am marking this issue as 
invalid for now but if you find that the count does not tally when grouping by 
application then we can re-open this issue and investigate further.

Original comment by azizatif on 8 Oct 2010 at 11:55

• Changed state: Invalid