BugNET

I am new to bugnet so forgive me if this has already been fixed.  I have been trying to get bugnet working on a dev server for a day or so and I wanted to share what i found was the problem.  I tried both the 0.7.891.0 install and source but was getting an error during the install stating that it couldn't find one of the tables and various syntax errors in bugnet.schema.sqldataprovider.sql.  I tried the suggestion on the blog page to fix this release but the suggested update query references a table that wasn't there.  Just the aspnet user tables were created during the error out.

After opening bugnet.schema.sqldataprovider.sql from the install/config folder in sql managment studio i noticed that there were formating characters in the script.

I opened it in wordpad, copied and pasted it into notepad and saved it with the same name.

installed completely on the first try after that. 

I think that someone must have opened and saved the script in an editor that left formatting tags.  They look like different sized boxes when viewed in my sql server admin.

CDex wrote I'm having the same problem, and your solution isn't solving it for me, unfortunately. I'm getting: Error in file:C:\Inetpub\wwwroot\BugNET\Install\dbscripts\BugNET.Schema.SqlDataProvider.sql Message:An invalid parameter or option was specified for procedure 'sp_addextendedproperty'. ...and that's all she wrote for my install.  If I remove the calls to 'sp_addextendedproperty' I can get the app working, but I won't use it for our dev shop without the entire script running properly.  The server is MS SQL Server 2000 SP3.  I've even tried temporarily adding the database user to the sysadmin role, so it's not a security issue. Anyone have any ideas?  It doesn't look like the calls to sp_addextendedproperty are doing anything terribly important...

These calls shouldn't be in the script, its for the database diagram. I will have to remove them so its fine if you take them out.

Davin Dubeau
BugNET - Core Developer