InnoDB error on 2.2.5.4 Update using MySQL

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.
5/14/2008 5:15:01 PM
Gravatar
Total Posts 20

InnoDB error on 2.2.5.4 Update using MySQL

I updated the files as stated and then made the changes to the dlls in /bin and updated the web.config as well.

Setup runs and I get this error:

Probing system...
File system permissions ok.
MySQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
Running script mojoportal-core - 2.2.4.8 - 00:00:00.2187542
MySql.Data.MySqlClient.MySqlException: The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working at MySql.Data.MySqlClient.MySqlStream.OpenPacket() 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.MySqlCommand.ExecuteNonQuery() at MySql.Data.MySqlClient.MySqlHelper.ExecuteNonQuery(MySqlConnection connection, String commandText, MySqlParameter[] 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.2812554

5/15/2008 5:59:32 AM
Gravatar
Total Posts 18439

Re: InnoDB error on 2.2.5.4 Update using MySQL

Hi,

The problem seems to be that the setup routine thinks it needs to do a clean install rather than an upgrade as indicated by the "database schema needs to be created" part of the output. The setup routine makes the determination of whether it is an upgrade or a new install by detecting if the mp_Sites table exists or not. So in this case its either getting an error trying to detect it or it can't detect it so it is trying to run all the scripts needed for a clean install.

I'm wondering what version of MySql you are running, my guess is you are running the very newest version 5.1 which I have not yet tested myself. Perhaps something has changed and tables need to be detected a different way or something. There was a report of strange issues with the rc of 5.1 before it was released.

What I would suggest is. Look in the mp_SchemaVersion table and see what current version of mojoPortal you have. Then manually run the scripts in sequence from the /Setup/applications/mojoportal-core/SchemaUpgradeScripts/mysql folder starting with the script version higher than your current version and ending with 2.2.5.4.config. You can skip any empty ones. After you run all the scripts set your version manually to 2.2.5.4 in the mp_SchemVersion table.

Please do confirm whether it works and what version of MySql you are using.

Hope it helps,

Joe

5/15/2008 12:50:56 PM
Gravatar
Total Posts 20

Re: InnoDB error on 2.2.5.4 Update using MySQL

Joe -

Version of MySQL - 5.0

I tried updating the scripts as you suggested, still get the same error.

 

5/15/2008 3:39:28 PM
Gravatar
Total Posts 18439

Re: InnoDB error on 2.2.5.4 Update using MySQL

I'm not sure what the problem is. I've upgraded this site and several others MySql sites with no troubles so I suspect its something about your particular environment that the setup routine isn't able to handle correctly. Without knowing what the problem is I don't know what I can do to handle it better.

If you google for "The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB'" maybe you can find something to help you.

mojoPortal does use InnoDB tables.

Wish I could be more help on this, but thats all I got.

Joe

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