daniel.siljanovski wrote:Hi,
I'm not using MySQL with nopCommerce but your version of nopCommerce (4.3) should be (as i remember) the first version with MySQL support added to it. Its always a good approach to use the latest nopCommerce version if possible (4.5) in case if there were some improvements (or bug fixes).
SUGGESTION: Beside your MySQL server-side settings, can you also check if there is any character set specified (used to encode the queries sent to mysql) in your ConnectionString (App_Data\appsettings.json)?
- Please check out this link
https://www.connectionstrings.com/mysql-connector-net-mysqlconnection/specifying-character-set/Version of the nopCommerce is 4.30 and it's not built from source, I took the release version 4.30 from the github (linux_x64) and deployed that. Database used is MySql (Ver 8.0.29-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu)).
There were no server updates so I am trying to figure out what might 'cause this sudden fail.
Yes I found the very same SO article, but the thing is, and as far as I know, this mysql net/connector is "baked" as a dependency (probably MySql.Data.dll ?) with these release .dlls from the nopCommerce release, so I don't think I can do much there. I tried some configurations with the mysql server and these character encodings but without any luck.
Also here is the setup for system variables regarding character_set for nopCommerce db:
mysql> show variables like '%character_set%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8mb3 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
Hi,
No, I try with and without adding charset to the connection string without any success.
I tried creating new db with new user (same sql server), with nopCommerce 4.30 release, freshly downloaded, and I get the same error. Not sure if it is entirely same because I see the portion, and I cannot see the full one in service log or in the system log. So I guess something must be off with the db server and nopCommerce4.30. I will try with fresh install of 4.50 and see how that goes.
Setup failed: An exception was thrown while activating Nop.Data.Migrations.MigrationManager -> λ:FluentMigrator.Runner.IVersionLoader.