I know but don’t know why.
I installed SuiteCRM 7.14.3 using SQL Server and it works well.
When I try to migrate, my error was that.
I used this config for migrate:
Public folder: web.config
<?xml version="1.0" encoding="UTF-8"?>
<configuration>
<system.webServer>
<rewrite>
<rules>
<clear />
<rule name="public/index.php" enabled="true" stopProcessing="false">
<match url="^(.*)$" ignoreCase="false" />
<conditions logicalGrouping="MatchAll" trackAllCaptures="false">
<add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
<add input="{REQUEST_URI}" matchType="Pattern" pattern="^/legacy" ignoreCase="true" negate="true" />
</conditions>
<action type="Rewrite" url="index.php/{R:1}" appendQueryString="true" />
</rule>
</rules>
</rewrite>
<defaultDocument enabled="false" />
<staticContent>
<remove fileExtension=".webmanifest" />
<mimeMap fileExtension=".webmanifest" mimeType="application/json" />
</staticContent>
</system.webServer>
</configuration>
legacy folder(based on installed suitecrm 7.14.3):
add this config to web.config:
<rule name="legacy/index.php" enabled="true" stopProcessing="false">
<match url="^(.*)$" ignoreCase="false" />
<conditions logicalGrouping="MatchAll" trackAllCaptures="false">
<add input="{REQUEST_FILENAME}" matchType="IsFile" negate="true" />
</conditions>
<action type="Rewrite" url="index.php/{R:1}" appendQueryString="true" />
</rule>
</rules>
config_override.php:
<?php
/***CONFIGURATOR***/
/***CONFIGURATOR***/
$sugar_config['dbconfig']['db_host_name'] = 'WIN-GKDBNR7SK5M';
$sugar_config['dbconfig']['db_user_name'] = 'sa';
$sugar_config['dbconfig']['db_password'] = '*******';
$sugar_config['dbconfig']['db_host_instance'] = 'web';
$sugar_config['dbconfig']['db_name'] = 'crm7';
$sugar_config['dbconfig']['db_type'] = 'mssql';
$sugar_config['dbconfig']['db_port'] = '1433';
$sugar_config['dbconfig']['db_manager'] = 'SqlsrvManager';
and this for database in config.php:
'dbconfig' =>
array (
'db_host_name' => 'WIN-GKDBNR7SK5M',
'db_host_instance' => 'web',
'db_user_name' => 'sa',
'db_password' => '*******',
'db_name' => 'crm7',
'db_type' => 'mssql',
'db_port' => '1433',
'db_manager' => 'SqlsrvManager',
'collation' => 'utf8mb4_general_ci',
'charset' => 'utf8mb4',
),
'dbconfigoption' =>
array (
'persistent' => true,
'autofree' => false,
'debug' => 0,
'ssl' => false,
'collation' => 'utf8mb4_general_ci',
'charset' => 'utf8mb4',
),
then I ran this:
PS C:\Windows\system32> php C:\Sources\CRM8m\bin\console suitecrm:app:setup-legacy-migration
I don’t know why my error is about MySQL!!!