deploying version 2.2.3.3

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.
8/7/2007 3:21:28 AM
metafedora
Gravatar
Total Posts 2
View Posts

deploying version 2.2.3.3

hello--

i'm deploying mojoportal to a windows server with mysql version 4.1.

after getting my isp to setup my website root in iis, and uploading the files from the mssqlreleasefiles (with the sharpziplib.dll, mojoPortal.Data.dll and MySQL.Data.dll from mysqldatalayer in the bin), i browse to the root and click 'Create Initial Data',  I get the following error.

After performing a search, it looks like the m_Sites table is supposed to have an EditorProvider column, but its missing.

Should I rebuild the database with different script?  or any other advice?

Thanks,

/.ndrew

 

#42S22Unknown column 'EditorProvider' in 'field list' at MySql.Data.MySqlClient.PacketReader.CheckForError() at MySql.Data.MySqlClient.PacketReader.ReadHeader() at MySql.Data.MySqlClient.PacketReader.OpenPacket() at MySql.Data.MySqlClient.NativeDriver.ReadResult(Int64& affectedRows, Int64& lastInsertId) at MySql.Data.MySqlClient.CommandResult.ReadNextResult(Boolean isFirst) at MySql.Data.MySqlClient.NativeDriver.SendQuery(Byte[] bytes, Int32 length, Boolean consume) at MySql.Data.MySqlClient.MySqlCommand.GetNextResultSet(MySqlDataReader reader) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteScalar() at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(MySqlConnection connection, String commandText, MySqlParameter[] commandParameters) at MySql.Data.MySqlClient.MySqlHelper.ExecuteScalar(String connectionString, String commandText, MySqlParameter[] commandParameters) at mojoPortal.Data.dbPortal.SiteSettings_Create(Guid siteGuid, String siteName, String skin, String logo, String icon, Boolean allowNewRegistration, Boolean allowUserSkins, Boolean allowPageSkins, Boolean allowHideMenuOnPages, Boolean useSecureRegistration, Boolean useSSLOnAllPages, String defaultPageKeywords, String defaultPageDescription, String defaultPageEncoding, String defaultAdditionalMetaTags, Boolean isServerAdminSite, Boolean useLdapAuth, Boolean autoCreateLDAPUserOnFirstLogin, String ldapServer, Int32 ldapPort, String ldapDomain, String ldapRootDN, String ldapUserDNKey, Boolean allowUserFullNameChange, Boolean useEmailForLogin, Boolean reallyDeleteUsers, String editorSkin, String defaultFriendlyUrlPattern, Boolean enableMyPageFeature, String editorProvider) at mojoPortal.Business.SiteSettings.Create() at mojoPortal.Business.SiteSettings.Save() at mojoPortal.Business.WebHelpers.mojoSetup.CreateInitialData() at mojoPortal.Web.UI.Pages.SetupHome.btnCreateInitialData_Click(Object sender, EventArgs e)
8/7/2007 6:19:37 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: deploying version 2.2.3.3

Hi,

The upgrade scripts should have added that column. If you navigate to siterrot/Setup/Upgrade.aspx does it say you are up to date?

Can you look in the mp_SchemaScriptHistory table and see if any rows in there have error messages, if so tell me the error. If the error can be resolved then delete the rows from the table that have errors and navigate to siteroot/Setup/Upgrade.aspx again and it should try to re-run the scripts.

If you want to run the scripts manually you can find them under siteroot/Setup/SchemaUpgradeScripts. Afer running them you would have to manually set your version to 2.2.3.3 in the mp_SchemaVersion table.

However its all supposed to be automatic so if errors are happening I would like to know what they are.

Hope it helps,

Joe

8/7/2007 3:15:35 PM
metafedora
Gravatar
Total Posts 2
View Posts

Re: deploying version 2.2.3.3

Thanks for replying.

When I navigate to Upgrade.aspx, it states 'No Sites have been created yet, click the button to create initial site data.'  Clicking the 'Create Initial Data' button causes the same error.

I do see error messages in the mp_SchemaScriptHistory -- looks like they're all similar (Full Stack trace omited):

ScriptFile: 2.2.2.5.config

MySql.Data.MySqlClient.MySqlException: #HY000Error on rename of './metafed_mojoportal/mp_Users' to './metafed_mojoportal/#sql2-8a47-e993bb' (errno: -1) 

ScriptFile: 2.2.2.5.config

MySql.Data.MySqlClient.MySqlException: #HY000Error on rename of './metafed_mojoportal/mp_Sites' to './metafed_mojoportal/#sql2-8a47-e993bb' (errno: -1)

ScriptFile: 2.2.3.0.config

MySql.Data.MySqlClient.MySqlException: #HY000Error on rename of './metafed_mojoportal/mp_ModuleDefinitions' to './metafed_mojoportal/#sql2-8a47-e993bb' (errno: -1)

I just dropped the db and re-created it using the scripts to be sure, and got the same error.  Strange thing is when I try to manually update the tables in phpMyAdmin, it fails with the same errors.  Looks like a problem with mysql at my isp -- I will have to figure this issue out, or create the db locally and upload it...

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