Sergei-k wrote:Could you please clarify do you use a connection string to exists database with the already created scheme? If so, this isn't an issue. If you want to use an exists database, which created earlier, you can't use the installation function. You should manually configure App_Data/dataSettings.json file instead
Hello
When the installation failed having used the create a MySQL Database option first, I find that the MySQL database is there. I then tried installing again but then using a connection string instead of create a database
That still produces an error
Setup failed: FUNCTION Check_Exists_FullText_Index already exists
The original error on the first attempt when using the Option Create MySQL database was
The Install program for creating the database is showing the following error
Setup failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'recursive CategoryTree AS ( SELECT id, cast(concat(LPAD(DisplayOrder, @lengt' at line 1
I am using Visual Studio 2019 version 16.5, Net.Core 3.1 and MySQL 5.7.29
Regards
I think he has the exact same issue as me except that I'm using the latest MySQL version 8.0.19.
The installation process fails even when letting nopCommerce creating the database (and even with the MySQL
root user who is supposed to have all the rights).
After the fail (the installation page just refreshes without any error message), we can see the database is successfully created (using MySQL Workbench for example).
But if we try again, this time giving it the connection string of the newly created database, we get an error
Setup failed: FUNCTION Check_Exists_FullText_Index already existsBecause the database already exists, it was created during the 1st attempt when running the installation page...