BugNET

I'm trying to install and run BugNET for the first time and have run into a small snag.  The nant scripts don't work with Visual Web Devloper 2005 Express Edition and I don't have the full-fledged Visual Studio.  So instead of using nant, I've done all the install and setup manually.

The one piece that I had issues with was the creation of all the DB tables, stored procedures, etc.  I ran all the SQL scripts that came in the Zip package but could never get them to run cleanly.  At this point I don't think I've got all the right versions in sync.  I think this is mostly due to the scripts wanting to build upon tables and stored procedures that are already there instead of building them from scratch.

Does anyone have a complete backup or set of SQL statements to create a blank DB from scratch?  Would someone mind doing a Tasks -> Generate Scripts  for me to create the SQL statements?  or point me in the right direction with what I've done wrong...

Any help is greatly appreciated.

Michael

I'm seeing things similar to what Michael is describing and some problems which are related to Tables not being populated by the install (using the new install option) for 0.7.0.  At first it was the CustomFieldType table which I corrected manually, but I'm also getting FK constraint errors elsewhere.  I also experienced the issue above and there seems to be an issue with populating the permissions table.  Also if the default roles require permissions they are also don't seem to be populated by the install.  Is it possible to post a backup of a new database known to function with 0.7.0? 

Please forgive a bugnet newbie if this is a known issue...

As always help is appreciated,

Red

I haven't observed that specific tables are absent, but the application seems to require data in certain tables in order to function.  Specifically I've observed this in ProjectCustomFieldType where after the install there are no records present and the application will crash without data in these tables when creating a custom field.  I'm also getting some other FK constraint violations such as on "FK_Bug_Resolution"  which happens when "BugNet_Bug_CreateNewBug" is executed.  This leads me to believe there are other tables which may have a similar issue.  I can wipe my DB clean and start over if I'm the only one exhibiting the behavior, but the first issue seems like it will manifest itself regardless of how the scripts in the install folder are executed.  I've reviewed the scripts and code and can't find any hint of an insert statement which would populate ProjectCustomFieldType.