Failed upgrade

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.
1/15/2010 10:18:44 AM
Magnetic_dud
Gravatar
Total Posts 251
View Posts

Failed upgrade

I upgraded my primary website installation and i got:

2010-01-15 17:15:46,859 ERROR mojoPortal.Web.Global - x.x.x.x-it-IT - /Default.aspx
MySql.Data.MySqlClient.MySqlException: Unknown column 'IsPublished' in 'where clause'
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId)
at MySql.Data.MySqlClient.MySqlDataReader.GetResultSet()
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(MySqlConnection connection, MySqlTransaction transaction, String commandText, MySqlParameter[] commandParameters, Boolean ExternalConn)
at MySql.Data.MySqlClient.MySqlHelper.ExecuteReader(String connectionString, String commandText, MySqlParameter[] commandParameters)
at mojoPortal.Data.DBBlog.GetDrafts(Int32 moduleId)
at mojoPortal.Business.Blog.CountOfDrafts(Int32 moduleId)
at mojoPortal.Web.BlogUI.BlogModule.LoadSettings()
at mojoPortal.Web.BlogUI.BlogModule.Page_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

what is the meaning? how to solve it? win2003+mysql, upgrading from mojoportal 2.3.0.8 (i think)

1/15/2010 10:29:23 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: Failed upgrade

We changed the upgrade process for MySql, you need to copy the contents of the Setup folder from the MySql data layer download into your /Setup folder and visit the setup page again. Previously we included the MySql scripts in the MS SQL download but we changed this to reduce the size of the MS SQL download.

That field "IsPublished", is added to the blog in the 0.0.1.3 script for the blog. You can see feature versions from Administration > System Info

Hope it helps,

Joe

1/15/2010 10:41:06 AM
Magnetic_dud
Gravatar
Total Posts 251
View Posts

Re: Failed upgrade

hi, for a reason that I ignore, \Setup\applications\blog\SchemaUpgradeScripts\mysql was missing, while \Setup\applications\blog\SchemaInstallScripts\mysql was there

i copied Setup from the mysql zip...

by the way, thanks for the hint :-)

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