Import Update!

We are currently in transition and have moved our discussions to CodePlex. These forums will remain as reference until we launch of our new site in the upcoming weeks. After that they will be removed.

Thank you for your patience during our transition.

Forums

Search Home All Forums

11/18/2011 11:53 AM

Mauricio Cirelli

Joined: 11/18/2011

Posts: 5

Installation errors

Hello BugNET users/staff,

I have just downloaded latest BugNET version and Im trying to install it on a remote server.
I would like to install using default configuration, and uncompressed everything from the BugNET install package - except for BugNET.SubversionHooks folder- into a new Virtual Directory on my Web Server.

Then, I went to http://myserver.com/bugnet/Install/Install.aspx and I've got the famous Network-related error, asking me to allow remote connections.
I would like to know how can I allow remote connections on a Database.mdf file. as I couldnt find answer for this, I created a blank Database in my WebServer (I dont like this approach, because I have limited database instances). I created a new user and put the following connection string into my Web.Config file:

<add name="BugNET" connectionstring="server=MyServer;database=BugNet;uid=BugNet;pwd=BugNet" providername=""

/>

Then, I went to the install url and I've got the following errors:

Installing BugNET

Version: 0.8.304.0

Installation Status Report

00:00:00 - Installing Version: 0.8.304.0
00:00:00 - Installing Membership Provider:
00:00:00 - Executing Script: InstallCommon.sql Error!

Error Details

File	InstallCommon.sql
Error	String or binary data would be truncated.

00:00:00.2496016 - Executing Script: InstallMembership.sql Error!

Error Details

File

InstallMembership.sql

Error

The table 'aspnet_Applications' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The table 'aspnet_Users' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The stored procedure 'aspnet_Applications_CreateApplication' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The stored procedure 'aspnet_Users_CreateUser' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The stored procedure 'aspnet_Users_DeleteUser' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. Foreign key 'FK__aspnet_Me__Appli__2F10007B' references invalid table 'dbo.aspnet_Applications'. Could not create constraint. See previous errors. Creating the aspnet_Membership table...

00:00:00.2808018 - Executing Script: InstallProfile.sql Error!

Error Details

File

InstallProfile.sql

Error

The table 'aspnet_Applications' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The table 'aspnet_Users' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The stored procedure 'aspnet_Applications_CreateApplication' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The stored procedure 'aspnet_Users_CreateUser' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The stored procedure 'aspnet_Users_DeleteUser' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. Foreign key 'FK__aspnet_Pr__UserI__31EC6D26' references invalid table 'dbo.aspnet_Users'. Could not create constraint. See previous errors. Creating the aspnet_Profile table...

00:00:00.3120020 - Executing Script: InstallRoles.sql Error!

Error Details

File

InstallRoles.sql

Error

The table 'aspnet_Applications' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The table 'aspnet_Users' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The stored procedure 'aspnet_Applications_CreateApplication' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The stored procedure 'aspnet_Users_CreateUser' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. The stored procedure 'aspnet_Users_DeleteUser' cannot be found. Please use aspnet_regsql.exe for installing ASP.NET application services. Foreign key 'FK__aspnet_Ro__Appli__34C8D9D1' references invalid table 'dbo.aspnet_Applications'. Could not create constraint. See previous errors. Creating the aspnet_Roles table...

00:00:00.3432022 - Installing BugNET Database:
00:00:00.3432022 - Executing Script: BugNET.Schema.SqlDataProvider.sql Error!

Error Details

File	BugNET.Schema.SqlDataProvider.sql
Error	Invalid object name 'dbo.aspnet_Users'.

00:00:00.4056026 - Installing BugNET Default Data:
00:00:00.4056026 - Executing Script: BugNET.Data.SqlDataProvider.sql Error!

Error Details

File	BugNET.Data.SqlDataProvider.sql
Error	Invalid object name 'BugNet_Permissions'.

00:00:00.4056026 - Creating Administrator Account

Error: Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'.

Installation Failed!

Please, help me solving this problem. Im not sure, but have a clue that the first error is causing the other ones. Is it right? If yes, how can I fix it?

Thanks in advance,

Mauricio

11/19/2011 5:47 AM

William Highfield

Joined: 10/23/2010

Posts: 54

Re: Installation errors

What version of SQL Server are you trying to install the BugNET DB on?
What version of Windows does your webserver run under?
You say you are trying to install remotely, are you hosting your site and database with a asp.net hosting provider? And if so which one?

I ask these as it might help with troubleshooting as well if someone has already installed BugNET on your hosting service maybe they can help out too.

Thanks,

- William

Twitter: will_highfield : : Blog: thefrozencoder.ca : : I need more space: DropBox Referral

11/20/2011 2:12 AM

Mauricio Cirelli

Joined: 11/18/2011

Posts: 5

Re: Installation errors

Hello,

I have checked with my Web Server support. We are using:
Windows Server 2008
MS SQL Server 2005
ASP.NET 1.1, 2.0, 3.5 and 4.0 are available.

I have made another attempt to install.. My IIS was configured to use ASP.NET 2.0. I have changed it to 4.0. But the error persists.

Im pretty convinced its an SQL Server Error.. A SQL Query from that install script failed because its using a smaller char/varchar/nchar field than data is being stored into this field.

I have tried to read the script, but its hard to find out something as the error log does not tell us which line caused the error.

11/21/2011 4:17 AM

Mauricio Cirelli

Joined: 11/18/2011

Posts: 5

Re: Installation errors Modified By Mauricio Cirelli on 11/21/2011 10:28:23 AM

I have just seen BugNET team has released a new version and it seems to fix the problem Im having!
Take a look at this Bug which has been fixed in this new release:
1) http://support.bugnetproject.com/Issu...
I will test it in a few hours (when I get home) and report if I have succeded.

This is another issue related to this problem which is marked as closed and available in this recently release (0.9):
2) http://support.bugnetproject.com/Issu...

EDIT:

I have just downloaded the new release and tried to install it out of the box, just fixing the web.config to point to my database instance.
I have got a 500 Internal Server error from the application.

Then I tried to change the InstallCommon.sql script accordingly to issue 1) I have mentioned above.. I have replaced all sysname variables to nvarchar(128). The String or binary data would be truncated error happened again.
I think I have the asp.net membership structure installed into my web server database.. I will follow the instructions from issue 2) and try to install 0.8 version again and report back soon.

Does anybody knows why Im getting 500 - Internal Server when I tried to install v0.9?

11/21/2011 5:43 PM

Davin Dubeau

bugnetproject.com
Joined: 3/2/2006

Posts: 1428

Re: Installation errors

Double check you have changed the framework to .net 4.0.

Davin Dubeau

Page 1 of 2

Forum Policy

These Discussion Forums are dedicated to the discussion of the BugNET issue tracker.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:
1. No Advertising.
2. No Flaming or Trolling.
3. No Profanity, Racism, or Prejudice.
4. Site Moderators have the final word on approving/removing a thread or post or comment.
5. English language posting only, please.