Problem updating 2.3.1.9 to 2.3.2.2

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
10/20/2009 2:47:10 AM
lgauton
Gravatar
Total Posts 26
View Posts

Problem updating 2.3.1.9 to 2.3.2.2

Hi

updating 2.3.1.9 to SVN release 2.3.2.2 pgsql

Just tkane SVN release to fix previous problem with modules and get following when updating database

Running script mojoportal-core - 2.3.2.0 - 00:00:00.4062500
An Error Occurred:ERROR: 23505: duplicate key value violates unique constraint "pk_schemascripthistory" Source:Npgsql Stack Trace at Npgsql.NpgsqlState.d__a.MoveNext() in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 831 at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1118 at Npgsql.ForwardsOnlyDataReader.GetNextRow(Boolean clearPending) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1208 at Npgsql.ForwardsOnlyDataReader.Read() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1331 at Npgsql.NpgsqlCommand.ExecuteScalar() in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 648 at mojoPortal.Data.NpgsqlHelper.ExecuteScalar(NpgsqlConnection connection, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) in C:\mojo-escape\mojoPortal.Data.pgsql\NpgsqlHelper.cs:line 1263 at mojoPortal.Data.NpgsqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) in C:\mojo-escape\mojoPortal.Data.pgsql\NpgsqlHelper.cs:line 1179 at mojoPortal.Data.DBPortal.SchemaScriptHistoryAddSchemaScriptHistory(Guid applicationId, String scriptFile, DateTime runTime, Boolean errorOccurred, String errorMessage, String scriptBody) in C:\mojo-escape\mojoPortal.Data.pgsql\dbPortal.cs:line 244 at mojoPortal.Business.DatabaseHelper.AddSchemaScriptHistory(Guid applicationId, String scriptFile, DateTime runTime, Boolean errorOccurred, String errorMessage, String scriptBody) in C:\mojo-escape\mojoPortal.Business\DatabaseHelper.cs:line 190 at mojoPortal.Web.UI.Pages.SetupHome.RunUpgradeScripts(Guid applicationId, String applicationName, String pathToScriptFolder, Version versionToStopAt) in C:\mojo-escape\Web\Setup\Default.aspx.cs:line 545 at mojoPortal.Web.UI.Pages.SetupHome.UpgradeSchema(String applicationName) in C:\mojo-escape\Web\Setup\Default.aspx.cs:line 437 at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() in C:\mojo-escape\Web\Setup\Default.aspx.cs:line 137 at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) in C:\mojo-escape\Web\Setup\Default.aspx.cs:line 81 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

10/20/2009 3:38:58 AM
lgauton
Gravatar
Total Posts 26
View Posts

Re: Problem updating 2.3.1.9 to 2.3.2.2

Hi

To try and bypass this error I have run the scripts manually and updated the schemahistory and version tables and all seems to work correctly, then went back to test the original problem adding modules to the features list - now this returns an error

ERROR: 42703: column "siteiid" of relation "mp_sitemoduledefinitions" does not exist

in Npgsqlhelper.cs

10/20/2009 7:18:41 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Problem updating 2.3.1.9 to 2.3.2.2

Hi,

I was unable to produce the script error on my db or a new db.

However I was able to produce the error when installing a custom feature. I have fixed this and committed it to svn, so get latest and rebuild. You will need to delete any row in mp_moduledefinitions for features that errored and then you should be able to install them without error.

Thanks,

Joe

You must sign in to post in the forums. This thread is closed to new posts.