Setup failed: Fatal error encountered during command execution. [Mysql]

[kingsjakal]

nopCommerce version: 4.30

Steps to reproduce the problem:
Fresh installation
-> Added mysql connection string "Server=localhost;Port=3308;Database=nopcommerce;Uid=xxxxx;Pwd=xxxxxx;"
-> It says intalling
-> I able to see the tables that are created in mysql server

In console

-> After the above log i am getting the following fatal error, it is happening only for mysql based installation, for mssql it is working fine

[kingsjakal]

HI Found the root cause of the issue,

From the following path
nopcommerce\src\Libraries\Nop.Data\MySqlDataProvider.cs
attached snippet line number trying to create the store procedure in MySql

from the list of stored procedure, the below is the one of the store procedure throwing the error in mysql 8.0

CREATE PROCEDURECreate_FullText_Index( TableName varchar(200), ColumnNames varchar(600), IndexName varchar(200), outResult bool ) MODIFIES SQL DATA sql security invoker BEGIN setResult= true; select if ( Check_Exists_FullText_Index(TableName, IndexName) ,'select false into @stmt_result' , concat('CREATE FULLTEXT INDEX ', IndexName, ' ON ', TableName, '(', ColumnNames, ');')) into @a; PREPARE stmt1 FROM @a; EXECUTE stmt1; DEALLOCATE PREPARE stmt1; Set Result = @stmt_result; END

I have manually installed the script from
nopcommerce\src\Presentation\Nop.Web\App_Data\Install\MySQL.StoredProcedures.sql
after the table creation and it started to work.

If the person is not a developer who is installing the nopcommerce using mysql then he cant use the application, it is bug please review the code

[exileDev]

@kingsjakal The fact is that you didn't specify the Allow User Variables = True parameter in your RAW connection string. These stored procedures use User Defined Variables in SQL statements.

[exileDev]

Closed #4691