Update to 2.3.3.2

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

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.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
12/21/2009 12:50:04 PM
Juliano Barbosa
Gravatar
Total Posts 49
View Posts
Juliano Morais Barbosa

Update to 2.3.3.2

Hi for all

When I update my site, I Get this message.

 

Probing system...
File system permissions ok.
pgsql database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema needs upgrade.
1 site(s) found.
Running script mojoportal-core - 2.3.2.0 - 00:00:00.7812600
Npgsql.NpgsqlException: relation "mp_lettersubscribe" already exists Severity: ERROR Code: 42P07 at Npgsql.NpgsqlState.d__a.MoveNext() at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() at Npgsql.ForwardsOnlyDataReader.NextResult() at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) at Npgsql.NpgsqlCommand.ExecuteNonQuery() at mojoPortal.Data.NpgsqlHelper.ExecuteNonQuery(NpgsqlTransaction transaction, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:00.9218868
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

12/21/2009 12:59:45 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Update to 2.3.3.2

Hi Juliano,

That is the first script where this table is created so I don't see how it can say it already exists unless you somehow ran that script previously. Only way I could see that happening is you were working from my svn sandbox. When I tested pgsql upgrade no error occurred.

I recommend if the tables mp_lettersubscribe and mp_lettersubscribehx already exist then drop them and visit setup again.

Hope it helps,

Joe

12/21/2009 1:23:53 PM
Juliano Barbosa
Gravatar
Total Posts 49
View Posts
Juliano Morais Barbosa

Re: Update to 2.3.3.2

Hi Joe.

 

I delete, but I get this message:

Probing system...
File system permissions ok.
pgsql database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema needs upgrade.
1 site(s) found.
Running script mojoportal-core - 2.3.2.0 - 00:00:00.7550312
Npgsql.NpgsqlException: relation "mp_lettersendlog" does not exist Severity: ERROR Code: 42P01 at Npgsql.NpgsqlState.d__a.MoveNext() at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() at Npgsql.ForwardsOnlyDataReader.NextResult() at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) at Npgsql.NpgsqlCommand.ExecuteNonQuery() at mojoPortal.Data.NpgsqlHelper.ExecuteNonQuery(NpgsqlTransaction transaction, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:00.8320752

12/21/2009 1:39:31 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Update to 2.3.3.2

mp_lettersendlog should have been created in version 2.2.4.6, did you delete the table?

12/21/2009 2:22:49 PM
Juliano Barbosa
Gravatar
Total Posts 49
View Posts
Juliano Morais Barbosa

Re: Update to 2.3.3.2

Hi Joe.

 

Yes, this table is deleted.

12/21/2009 2:25:49 PM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Update to 2.3.3.2

you should not have deleted that one, only the ones I mentioned after your first error. I would find it in the 2.2.4.6 script and re-create that table and then hope it can proceed from setup.

Hope it helps,

Joe

12/22/2009 5:42:35 AM
Juliano Barbosa
Gravatar
Total Posts 49
View Posts
Juliano Morais Barbosa

Re: Update to 2.3.3.2

Hi Joe.

 

I Created the "mp_lettersendlog"

And now I get this message:

 

Probing system...
File system permissions ok.
pgsql database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema needs upgrade.
1 site(s) found.
Running script mojoportal-core - 2.3.2.0 - 00:00:00.8124896

An Error Occurred:ERROR: 42P01: relation "mp_lettersubscriber" does not exist
Source:Npgsql
Stack Trace at Npgsql.NpgsqlState.d__a.MoveNext() at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() at Npgsql.ForwardsOnlyDataReader.NextResult() at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at mojoPortal.Data.NpgsqlHelper.ExecuteDataset(NpgsqlConnection connection, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) at mojoPortal.Data.NpgsqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperDoVersion2320PostUpgradeTasks(String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.DoVersion2320PostUpgradeTasks(String overrideConnectionInfo) at mojoPortal.Web.mojoSetup.DoPostScriptTasks(Version scriptVersion, String overrideConnectionInfo) at mojoPortal.Web.UI.Pages.SetupHome.RunUpgradeScripts(Guid applicationId, String applicationName, String pathToScriptFolder, Version versionToStopAt) at mojoPortal.Web.UI.Pages.SetupHome.UpgradeSchema(String applicationName) at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

12/22/2009 5:48:46 AM
Juliano Barbosa
Gravatar
Total Posts 49
View Posts
Juliano Morais Barbosa

Re: Update to 2.3.3.2

When I deleted the mp_lettersubscribe

 

I Get this message:

 

Probing system...
File system permissions ok.
pgsql database connection ok.
database permissions are sufficient to alter schema.
database initial schema already exists.
database core schema needs upgrade.
1 site(s) found.
Running script mojoportal-core - 2.3.2.0 - 00:00:00.8124896

An Error Occurred:ERROR: 42P01: relation "mp_lettersubscriber" does not exist
Source:Npgsql
Stack Trace at Npgsql.NpgsqlState.d__a.MoveNext() at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() at Npgsql.ForwardsOnlyDataReader.NextResult() at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at mojoPortal.Data.NpgsqlHelper.ExecuteDataset(NpgsqlConnection connection, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) at mojoPortal.Data.NpgsqlHelper.ExecuteDataset(String connectionString, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) at mojoPortal.Data.DBPortal.DatabaseHelperDoVersion2320PostUpgradeTasks(String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.DoVersion2320PostUpgradeTasks(String overrideConnectionInfo) at mojoPortal.Web.mojoSetup.DoPostScriptTasks(Version scriptVersion, String overrideConnectionInfo) at mojoPortal.Web.UI.Pages.SetupHome.RunUpgradeScripts(Guid applicationId, String applicationName, String pathToScriptFolder, Version versionToStopAt) at mojoPortal.Web.UI.Pages.SetupHome.UpgradeSchema(String applicationName) at mojoPortal.Web.UI.Pages.SetupHome.RunSetup() at mojoPortal.Web.UI.Pages.SetupHome.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

12/22/2009 9:23:54 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Update to 2.3.3.2

Hi Juliano,

Please try this:

  1. Edit the data in the mp_SchemaVersion table, set mojoportal-core to version 2.3.2.0
  2. touch web.config to recycle the app
  3. Visit Setup page gain.

Hope it helps,

Joe

12/22/2009 12:45:37 PM
Juliano Barbosa
Gravatar
Total Posts 49
View Posts
Juliano Morais Barbosa

Re: Update to 2.3.3.2

Hi Joe.

 

I Recover my database.

Changed Version.

and now my version is 2.3.3.2

 

Thanxxxxxxxxxxxxxxxx for you attention.

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