CODEWITHSUNDEEP
asp.net-mvcelmah
arame3333
arame3333

Reputation: 10203

MVC app deployment; System.Data.SqlClient.SqlException: Could not find stored procedure 'ELMAH_GetErrorsXml'

I have deployed my MVC app but the error handling does not work. I use a SQLite database and when I try to navigate to the error messages in Elmah i get this exception;

System.Data.SqlClient.SqlException: Could not find stored procedure 'ELMAH_GetErrorsXml'.

Of course I need to deploy the SQLite database, defined in my web.config as;

add name="ELMAH.SQLite" connectionString="Data Source=|DataDirectory|errors.s3db" />

I am thinking that I did not deploy a SQLite database when I deployed my application. Yet I cannot locate the errors.s3db on my local file system, so I am not sure how I set one up on my live environment.

Upvotes: 12

Views: 6041

Answers (1)

aWrongun
aWrongun

Reputation: 276

You'll need to run the SQL script to create the ELMAH objects. It can be found in the 'db' folder of the download ( http://code.google.com/p/elmah/downloads/list )

Upvotes: 26

Related Questions