feliperochadev / elmah

Automatically exported from code.google.com/p/elmah
Apache License 2.0
0 stars 0 forks source link

SQL Server script fails on a case-sensitive database #76

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?

1. Download ELMAH 1.0 BETA 2
2. Create a SQL Server database using a case-sensitive collation (e.g. 
Latin1_General_CS_AS)
3. Run the Database.sql script from the download

What is the expected output? What do you see instead?

The expected output is that the script runs without any errors. Instead, 
one receives the following errors:

Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 35
Invalid column name 'TimeUTC'.
Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 73
Invalid column name 'TimeUTC'.
Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 59
Invalid column name 'errorId'.
Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 60
Invalid column name 'application'.
Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 61
Invalid column name 'host'.
Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 62
Invalid column name 'type'.
Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 63
Invalid column name 'source'.
Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 64
Invalid column name 'message'.
Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 65
Invalid column name 'user'.
Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 66
Invalid column name 'statusCode'.
Msg 207, Level 16, State 1, Procedure ELMAH_GetErrorsXml, Line 77
Invalid column name 'TimeUTC'.

What version of the product are you using? On what operating system?

ELMAH 1.0 BETA 2
Windows Vista Ultimate Edition with SP 1

Please provide any additional information below.

This issues was originally reported by Timo Jokinen in the following 
thread over at the discussion group:

http://groups.google.com/group/elmah/msg/21427f12d08754f8

Original issue reported on code.google.com by azizatif on 13 Nov 2008 at 5:53

GoogleCodeExporter commented 9 years ago

Original comment by azizatif on 13 Nov 2008 at 5:53

GoogleCodeExporter commented 9 years ago
Fixed in r476.

Original comment by azizatif on 13 Nov 2008 at 7:59