BugNET

Open source issue tracking & project management

Forums

HomeHomeSupportSupportUpgrading BugNE...Upgrading BugNE...0.7 -> 0.8.188 fails to upgrade database0.7 -> 0.8.188 fails to upgrade database
Previous
 
Next
New Post
5/6/2010 1:45 AM
 

When executing Install.aspx:


unable to find BugNet_HostSetting_GetHostSettings ( current database has a store procedure BugNet_HostSettings_GetHostSettings.... !! hostsetting in plural)

Created a copy and named it BugNet_HostSettings.GetHostSettings... rerun installation script

now get an error : Invalid object name 'BugNet_StringResources'.

Checked the database, there is no table BugNet_StringResources, it seems the upgrade script has not run... several other tables seem to be missing as well...

 
New Post
5/6/2010 4:59 AM
 

Same error here.

I found this post

Maybe the installation script is not the last version in the release?

 
New Post
5/6/2010 9:27 AM
 

The lastest version was released 5/5/2010. It is still 0.8.188.0 with a few minor adjustments to the sql scripts. Please give that a try.


Follow me on twitter: @stewartmoss http://www.twitter.com/stewartmoss
Follow BugNETProject on twitter: @bugnetproject http://www.twitter.com/bugnetproject
 
New Post
5/6/2010 11:38 PM
 
Still same error Could not find stored procedure 'BugNet_HostSetting_GetHostSettings'.

Binary files of the first one I tried and the one I just tried are exactly the same...

Please do not release newer version with the same version number... this is extremely confusing and error prone (also if download links are the same, caching of browser or proxies can prevent from downloading the correct file) !!!

What ever I do, i get MD5 hash d4d7929b4dd479241ebfd74740eca9be, which is different from the hash mentioned on the download page...
 
New Post
5/10/2010 12:12 AM
 
version 193... still problem

immediately, when I start the install.Aspx I get the error : (the store procedure in the database is BugNet_HostSettings_GetHostSettings)

From what I see from the stack trace, it seems to me, this error occurs even before the install script begins. Could it be you rename this stored procedure inside the Install script, but your website startup already relies on it being renamed ?

Could not find stored procedure 'BugNet_HostSetting_GetHostSettings'.
Beschrijving: Er is een onverwerkte uitzondering opgetreden tijdens het uitvoeren van de huidige webaanvraag. Raadpleeg de stacktracering voor meer informatie over deze fout en de oorsprong ervan in de code.

Details van uitzondering: System.Data.SqlClient.SqlException: Could not find stored procedure 'BugNet_HostSetting_GetHostSettings'.

Fout in bron:

Er is een onverwerkte uitzondering gegenereerd tijdens het uitvoeren van de huidige webaanvraag. Aan de hand van de onderstaande tracering van de uitzonderingsstack kunt u meer informatie verkrijgen over de oorsprong en de locatie van de uitzondering.

Stacktracering:

[SqlException (0x80131904): Could not find stored procedure 'BugNet_HostSetting_GetHostSettings'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1953274
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849707
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +96
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteReader() +89
BugNET.DataAccessLayer.SqlDataProvider.TExecuteReaderCmd(SqlCommand sqlCmd, TGenerateListFromReader`1 gcfr, List`1& List) +120
BugNET.DataAccessLayer.SqlDataProvider.GetHostSettings() +126
BugNET.BusinessLogicLayer.HostSetting.GetHostSettings() +129
BugNET.Initialization.Init(HttpContext context) +215
BugNET.Global.Application_BeginRequest(Object sender, EventArgs e) +77
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
 
Previous
 
Next
HomeHomeSupportSupportUpgrading BugNE...Upgrading BugNE...0.7 -> 0.8.188 fails to upgrade database0.7 -> 0.8.188 fails to upgrade database


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.