MySQL upgrade to 2.3.7.9 versuion failed

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/17/2012 1:39:02 AM
Gravatar
Total Posts 22

MySQL upgrade to 2.3.7.9 versuion failed

Running script mojoportal-core - 2.3.7.9 - 00:00:00.1718750

MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'mp_PaymentLog' already exists at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() at MySql.Data.MySqlClient.MySqlScript.Execute() at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:00.1875000
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.

 

Dear Joe, the problem with upgrade (MySQL version) was that the previous sql script did not consider the case tables (again same error). Please remember that in mySql (UX versions) the name of the tables is case sensitive.

previous script failed because mp_AuthorizeNetLog was created before with mp_AuthorizeNetlog lower case L

In my case I just fixed this issue changing the name of table to uppercase, it must be "mp_AuthorizeNetLog"

Best regards, very good job!

 

10/17/2012 9:19:20 AM
Gravatar
Total Posts 18439

Re: MySQL upgrade to 2.3.7.9 versuion failed

Errors like this usually are a result of moving a mysql database from one server to another. MySql table names are really only case sensitive on linux not on windows but often windows installations of mysql are configured to force all lower case table names. If  a database is moved from an installation configured one way to an installation configured the other way it can result in errors like this.

I'm not seeing any errors in my scripts

/Setup/applications/mojoportal-core/SchemaInstallScripts/mysql/2.2.7.8.config create the table like this:

CREATE TABLE `mp_AuthorizeNetLog`

So the upgrade script 2.3.7.9 is correct and uses the same case that the table was created with. On linux it should match the case correctly, on windows it is not case senstive

Best,

Joe

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