search

bishop335 / subtext

Automatically exported from code.google.com/p/subtext
0 stars 0 forks source link

HTTP 500 when entering admin area #234

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Blog displays correctly, but when I go to admin get a 500 error.

Just upgraded from 2.1, no errors from the database upgrade bit

Running on Windows 2008 against SQL Express

Original issue reported on code.google.com by pa...@grassoc.co.uk on 26 Jun 2010 at 1:37

GoogleCodeExporter commented 8 years ago 
Some more info, appears that the Dashboard is the only one crashing, I can get 
into the other admin pages

Original comment by pa...@grassoc.co.uk on 27 Jun 2010 at 2:11

GoogleCodeExporter commented 8 years ago 
Can you post a full stack trace? Check your EventViewer or the Errors page in 
Subtext.

Original comment by haac...@gmail.com on 27 Jun 2010 at 4:20

GoogleCodeExporter commented 8 years ago 
Basically it's a database error, for example the error log says...

System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the 
object 'subtext_GetPopularPosts', database 'subtext', schema 'dbo'. at 
System.Data.SqlClient.SqlConnection.OnError

even though there is execute permission given to public.

I managed to make it go away by re-granting dbo permission, running the admin 
page, and then removing dbo permission!

I think we can close this, but I'm not sure if it's a SQL Server bug or not - 
I'd restarted both SQL Server and the web server between each step, so it's not 
a caching question

Original comment by pa...@grassoc.co.uk on 28 Jun 2010 at 10:15

GoogleCodeExporter commented 8 years ago 
We will check the SQL script to verify if we are granting permission to that 
object correctly

Original comment by simone.chiaretta on 29 Jun 2010 at 7:11

GoogleCodeExporter commented 8 years ago 
The SQL script contains this:
GRANT EXECUTE ON [<dbUser,varchar,dbo>].[subtext_GetPopularPosts] TO [public]
GO

Not sure what it is, probably some SQL Server bug or similar

Original comment by simone.chiaretta on 29 Jun 2010 at 7:15