Hello Sir,
Need your help.
I'm got error when run this application after downloaded from this repository. I'm try to migrate the database to mySQL.
Below is the error i got.
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
Failed executing DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
ALTER TABLE Users ADD Created TEXT NOT NULL DEFAULT '0001-01-01 00:00:00.000000';
fail: DatingApp.API.Program[0]
An error occured during migration
MySql.Data.MySqlClient.MySqlException (0x80004005): BLOB, TEXT, GEOMETRY or JSON column 'Created' can't have a default value
---> MySql.Data.MySqlClient.MySqlException (0x80004005): BLOB, TEXT, GEOMETRY or JSON column 'Created' can't have a default value at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in C:\projects\mysqlconnector\src\MySqlConnector\Core\ResultSet.cs:line 49
Thanks in advanced
Hello Sir,
Need your help.
I'm got error when run this application after downloaded from this repository. I'm try to migrate the database to mySQL.
Below is the error i got.
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
Failed executing DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
ALTER TABLE
UsersADDCreatedTEXT NOT NULL DEFAULT '0001-01-01 00:00:00.000000';fail: DatingApp.API.Program[0]
An error occured during migration
MySql.Data.MySqlClient.MySqlException (0x80004005): BLOB, TEXT, GEOMETRY or JSON column 'Created' can't have a default value
---> MySql.Data.MySqlClient.MySqlException (0x80004005): BLOB, TEXT, GEOMETRY or JSON column 'Created' can't have a default value at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in C:\projects\mysqlconnector\src\MySqlConnector\Core\ResultSet.cs:line 49
Thanks in advanced