MySQL installation problem 2600

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.

10/31/2017 2:47:18 PM
Gravatar
Total Posts 2

MySQL installation problem 2600

Installation log:

 

Welcome to mojoPortal Setup

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.7.8 - 00:00:00.9619140
Running script mojoportal-core - 2.2.7.9 - 00:00:09.4795938
Running script mojoportal-core - 2.2.8.0 - 00:00:09.5108438
Running script mojoportal-core - 2.2.8.1 - 00:00:09.7432656
Running script mojoportal-core - 2.2.8.2 - 00:00:09.7969766
Running script mojoportal-core - 2.2.8.3 - 00:00:10.0684609
Running script mojoportal-core - 2.2.8.4 - 00:00:10.1954141
Running script mojoportal-core - 2.2.8.5 - 00:00:10.2920938
Running script mojoportal-core - 2.2.8.6 - 00:00:10.7247109
Running script mojoportal-core - 2.2.8.7 - 00:00:10.8877969
Running script mojoportal-core - 2.2.8.8 - 00:00:10.9659219
Running script mojoportal-core - 2.2.8.9 - 00:00:11.1133828
Running script mojoportal-core - 2.2.9.0 - 00:00:11.3877969
Running script mojoportal-core - 2.2.9.1 - 00:00:11.7383828
Running script mojoportal-core - 2.2.9.2 - 00:00:12.0088906
Running script mojoportal-core - 2.2.9.3 - 00:00:12.4180703
Running script mojoportal-core - 2.2.9.4 - 00:00:12.4512734
Running script mojoportal-core - 2.2.9.5 - 00:00:12.6182656
Running script mojoportal-core - 2.2.9.6 - 00:00:13.0577188
Running script mojoportal-core - 2.2.9.7 - 00:00:13.3702188
Running script mojoportal-core - 2.2.9.8 - 00:00:13.4444375
Running script mojoportal-core - 2.2.9.9 - 00:00:13.4825234
Running script mojoportal-core - 2.3.0.0 - 00:00:13.7110391
Running script mojoportal-core - 2.3.0.1 - 00:00:13.9024453
Running script mojoportal-core - 2.3.0.2 - 00:00:14.2588906
Running script mojoportal-core - 2.3.0.3 - 00:00:14.3047891
Running script mojoportal-core - 2.3.0.4 - 00:00:14.5235391
Running script mojoportal-core - 2.3.0.5 - 00:00:14.7471719
Running script mojoportal-core - 2.3.0.6 - 00:00:15.1358438
Running script mojoportal-core - 2.3.0.7 - 00:00:15.2188516
Running script mojoportal-core - 2.3.0.8 - 00:00:15.3282266
Running script mojoportal-core - 2.3.0.9 - 00:00:15.5010781
Running script mojoportal-core - 2.3.1.0 - 00:00:15.6924844
Running script mojoportal-core - 2.3.1.1 - 00:00:15.7295938
Running script mojoportal-core - 2.3.1.2 - 00:00:16.3985391
Running script mojoportal-core - 2.3.1.3 - 00:00:16.4756875
Running script mojoportal-core - 2.3.1.4 - 00:00:16.7618203
Running script mojoportal-core - 2.3.1.5 - 00:00:16.9258828
Running script mojoportal-core - 2.3.1.6 - 00:00:17.4083047
Running script mojoportal-core - 2.3.1.7 - 00:00:17.4551797
Running script mojoportal-core - 2.3.1.8 - 00:00:17.5635781
Running script mojoportal-core - 2.3.1.9 - 00:00:17.7833047
Running script mojoportal-core - 2.3.2.0 - 00:00:17.9883828
Running script mojoportal-core - 2.3.2.1 - 00:00:18.8145547
Running script mojoportal-core - 2.3.2.2 - 00:00:19.1592813
Running script mojoportal-core - 2.3.2.3 - 00:00:19.4854531
Running script mojoportal-core - 2.3.2.4 - 00:00:19.8565469
Running script mojoportal-core - 2.3.2.5 - 00:00:19.8995156
Running script mojoportal-core - 2.3.2.6 - 00:00:20.4288125
Running script mojoportal-core - 2.3.2.7 - 00:00:20.5460000
Running script mojoportal-core - 2.3.2.8 - 00:00:20.7081094
Running script mojoportal-core - 2.3.2.9 - 00:00:20.8536172
Running script mojoportal-core - 2.3.3.0 - 00:00:21.0723672
Running script mojoportal-core - 2.3.3.1 - 00:00:21.2237344
Running script mojoportal-core - 2.3.3.2 - 00:00:21.7198281
Running script mojoportal-core - 2.3.3.3 - 00:00:22.1612344
Running script mojoportal-core - 2.3.3.4 - 00:00:22.2647500
Running script mojoportal-core - 2.3.3.5 - 00:00:22.2911172
Running script mojoportal-core - 2.3.3.6 - 00:00:22.4561563
Running script mojoportal-core - 2.3.3.7 - 00:00:22.6719766
Running script mojoportal-core - 2.3.3.8 - 00:00:23.1573281
Running script mojoportal-core - 2.3.3.9 - 00:00:23.1768594
Running script mojoportal-core - 2.3.4.0 - 00:00:23.3467813
Running script mojoportal-core - 2.3.4.1 - 00:00:23.4756875
Running script mojoportal-core - 2.3.4.2 - 00:00:23.6026406
Running script mojoportal-core - 2.3.4.3 - 00:00:23.6631875
Running script mojoportal-core - 2.3.4.4 - 00:00:23.6934609
Running script mojoportal-core - 2.3.4.5 - 00:00:23.7442422
Running script mojoportal-core - 2.3.4.6 - 00:00:23.7920938
Running script mojoportal-core - 2.3.4.7 - 00:00:23.8360391
Running script mojoportal-core - 2.3.4.8 - 00:00:23.9034219
Running script mojoportal-core - 2.3.4.9 - 00:00:23.9219766
Running script mojoportal-core - 2.3.5.0 - 00:00:24.3487344
Running script mojoportal-core - 2.3.5.1 - 00:00:24.6641641
Running script mojoportal-core - 2.3.5.2 - 00:00:24.7178750
Running script mojoportal-core - 2.3.5.3 - 00:00:24.7549844
Running script mojoportal-core - 2.3.5.4 - 00:00:24.7979531
Running script mojoportal-core - 2.3.5.5 - 00:00:24.8790078
Running script mojoportal-core - 2.3.5.6 - 00:00:24.9219766
Running script mojoportal-core - 2.3.5.7 - 00:00:24.9747109
Running script mojoportal-core - 2.3.5.8 - 00:00:25.0284219
Running script mojoportal-core - 2.3.5.9 - 00:00:25.6016641
Running script mojoportal-core - 2.3.6.0 - 00:00:25.7383828
Running script mojoportal-core - 2.3.6.1 - 00:00:26.1319375
Running script mojoportal-core - 2.3.6.2 - 00:00:26.2061563
Running script mojoportal-core - 2.3.6.3 - 00:00:26.2588906
Running script mojoportal-core - 2.3.6.4 - 00:00:26.6055703
Running script mojoportal-core - 2.3.6.5 - 00:00:26.8389688
Running script mojoportal-core - 2.3.6.6 - 00:00:27.0167031
Running script mojoportal-core - 2.3.6.7 - 00:00:27.2637734
Running script mojoportal-core - 2.3.6.8 - 00:00:27.3907266
Running script mojoportal-core - 2.3.6.9 - 00:00:27.6924844
Running script mojoportal-core - 2.3.7.0 - 00:00:27.7803750
Running script mojoportal-core - 2.3.7.1 - 00:00:27.8809609
Running script mojoportal-core - 2.3.7.2 - 00:00:28.1622109
Running script mojoportal-core - 2.3.7.3 - 00:00:29.3995156
Running script mojoportal-core - 2.3.7.4 - 00:00:29.4571328
Running script mojoportal-core - 2.3.7.5 - 00:00:29.4668984
Running script mojoportal-core - 2.3.7.6 - 00:00:29.5440469
Running script mojoportal-core - 2.3.7.7 - 00:00:29.5723672
Running script mojoportal-core - 2.3.7.8 - 00:00:29.7833047
Running script mojoportal-core - 2.3.7.9 - 00:00:29.8516641
Running script mojoportal-core - 2.3.8.0 - 00:00:30.1251016
Running script mojoportal-core - 2.3.8.1 - 00:00:30.1397500
Running script mojoportal-core - 2.3.8.2 - 00:00:30.1983438
Running script mojoportal-core - 2.3.8.3 - 00:00:30.2002969
Running script mojoportal-core - 2.3.8.4 - 00:00:30.2012734
Running script mojoportal-core - 2.3.8.5 - 00:00:30.3389688
Running script mojoportal-core - 2.3.8.6 - 00:00:30.3985391
Running script mojoportal-core - 2.3.8.7 - 00:00:30.8360391
Running script mojoportal-core - 2.3.8.8 - 00:00:30.9522500
Running script mojoportal-core - 2.3.8.9 - 00:00:31.0801797
Running script mojoportal-core - 2.3.9.0 - 00:00:31.1758828
Running script mojoportal-core - 2.3.9.1 - 00:00:31.2774453
Running script mojoportal-core - 2.3.9.2 - 00:00:31.4014688
Running script mojoportal-core - 2.3.9.3 - 00:00:31.6475625
Running script mojoportal-core - 2.3.9.4 - 00:00:31.8096719
Running script mojoportal-core - 2.3.9.5 - 00:00:32.1973672
Running script mojoportal-core - 2.3.9.6 - 00:00:32.6172891
Running script mojoportal-core - 2.3.9.7 - 00:00:32.8370156
Running script mojoportal-core - 2.3.9.8 - 00:00:33.2090859
Running script mojoportal-core - 2.3.9.9 - 00:00:33.2530313
Running script mojoportal-core - 2.4.0.0 - 00:00:33.4249063
Running script mojoportal-core - 2.4.0.1 - 00:00:33.5176797
Running script mojoportal-core - 2.4.0.2 - 00:00:34.2501016
Running script mojoportal-core - 2.4.0.3 - 00:00:34.3780313
Running script mojoportal-core - 2.4.0.4 - 00:00:34.6612344
Running script mojoportal-core - 2.4.0.5 - 00:00:34.7374063
Running script mojoportal-core - 2.4.0.6 - 00:00:35.7774453
Running script mojoportal-core - 2.4.0.7 - 00:00:36.2920938
Running script mojoportal-core - 2.4.0.8 - 00:00:36.3614297
Running script mojoportal-core - 2.4.0.9 - 00:00:36.4249063
Running script mojoportal-core - 2.4.1.0 - 00:00:36.4854531
Running script mojoportal-core - 2.5.0.0 - 00:00:36.4854531
Running script mojoportal-core - 2.6.0.0 - 00:00:36.4864297
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'gb_m2017.mp_modulesettings' doesn't exist в MySql.Data.MySqlClient.MySqlStream.ReadPacket() в MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId) в MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId) в MySql.Data.MySqlClient.MySqlDataReader.NextResult() в MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) в MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery() в MySql.Data.MySqlClient.MySqlScript.Execute() в mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) в mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) - 00:00:36.5440469
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.

10/31/2017 4:37:59 PM
Gravatar
Total Posts 1981

Re: MySQL installation problem 2600

Hello,

We're going to release a patch release with a fix for this in the next couple of days.

Until then, replace the contents of the /setup/application/mojoPortal-core/SchemaUpgradesScripts/MySQL/2.6.0.0.config file with this:

ALTER TABLE `mp_ModuleSettings` 
CHANGE COLUMN `SettingValue` `SettingValue` MEDIUMTEXT NULL DEFAULT NULL ;
 
alter table `mp_ContentMeta` 
11/1/2017 3:52:19 AM
Gravatar
Total Posts 2

Re: MySQL installation problem 2600

also this file needs to be fixed:

 

Running script blog - 2.6.1.9 - 00:00:23.7713750
MySql.Data.MySqlClient.MySqlException (0x80004005): Table 'gb_m2017.mp_moduledefinitionsettings' doesn't exist 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:23.7870000
Configuring feature Blog - 00:00:23.7870000
Configuring feature Blog Post List - 00:00:25.8026250

 

but it was not fatal error, site started after the installation, thank you! yessmiley