BugNET

Hi Davin,

I'd love to get my hands dirty with 08. But the upgrade of my existing data won't work. At one point you rename the tables, but I haven't found the bit of script that does that. So in a plain vanilla 07.921 the tables are not prefixed yet!

The RC 1 Schema.SqlDataProvider script starts with ALTER TABLE [dbo].[BugNet_IssueAttachments] DROP CONSTRAINT ... etc. This is the first script that is run and throws errors all over the place of course. I'm used to DNN style script distribution where you always stick to increments, but I figure you've taken an alternative route with this schema script which is supposed to fix all pre 0.8 dbs. I'm not sure how that works (because you need to account for all previous versions of BugNET), but I'll assume it's possible that way.

Where is the renaming happening? Which script should I run for the schema script to run correctly? Did I miss a post somewhere? I didn't spot it in the blog posts surrounding this, sorry.

Thanks,

Peter

Hey Davin,

Thanks. I got it. You're doing a migration by creating the new tables and filling them with the old data, after which you destroy the old data. OK, fair enough.

The next obstacle that has presented itself is the authentication. It turns out I've lost super user abilities. Retracing the code I see the standard roles are hard coded. So I've verified the existence of "Super Users" in BugNet_Roles and my userid guid bound to the role id in BugNet_UserRoles. Isn't that all there is to it? If so I'll dig deeper there to see if I can find the cause why IsInRole("Super Users") is not working.

Thanks,

Peter

BTW. I forgot to mention I'm a big fan of the project and love what you've built. I convinced multiple friends to adopt this. Cheers