Data Transferring to mysql failed

[NathanG86]

Getting the below error on one of our system that we recently updated, unsure why it has zero dates shouldnt it be NULL


Full Error Message

Data Transferring to mysql failed due to the following reason: Failed to offload `public_recordings`: MySqlConnector.MySqlException (0x80004005): Incorrect datetime value: '0000-00-00 00:00:00.000000' for column 'end_time' at row 1 at MySqlConnector.Core.ServerSession.ReceiveReplyAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/ServerSession.cs:line 1081 at MySqlConnector.Core.ResultSet.ReadResultSetHeaderAsync(IOBehavior ioBehavior) in /_/src/MySqlConnector/Core/ResultSet.cs:line 37 at MySqlConnector.MySqlDataReader.ActivateResultSet(CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 131 at MySqlConnector.MySqlDataReader.InitAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, IDictionary`2 cachedProcedures, IMySqlCommand command, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlDataReader.cs:line 487 at MySqlConnector.Core.CommandExecutor.ExecuteReaderAsync(CommandListPosition commandListPosition, ICommandPayloadCreator payloadCreator, CommandBehavior behavior, Activity activity, IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/Core/CommandExecutor.cs:line 56 at MySqlConnector.MySqlCommand.ExecuteScalarAsync(IOBehavior ioBehavior, CancellationToken cancellationToken) in /_/src/MySqlConnector/MySqlCommand.cs:line 329 at _3CX.TableDataOffload.Uploader.MySQLUploader.ExecuteCopyRowsStatementAsync(String query, CancellationToken cancellationToken) at _3CX.TableDataOffload.Uploader.MySQLUploader.ExecuteCopyRowsStatementAsync(String query, CancellationToken cancellationToken) at _3CX.TableDataOffload.Uploader.BaseUploader.<>c__DisplayClass10_0.<<HandleItemAsync>b__3>d.MoveNext() --- End of stack trace from previous location --- at _3CX.TableDataOffload.Uploader.RetryPolicy.<>c__DisplayClass2_0.<<ExecuteAsync>b__0>d.MoveNext() --- End of stack trace from previous location --- at _3CX.TableDataOffload.Uploader.RetryPolicy.ExecuteAsync[T](Func`2 action, ILogger logger, CancellationToken cancellationToken) at _3CX.TableDataOffload.Uploader.RetryPolicy.ExecuteAsync(Func`2 action, ILogger logger, CancellationToken cancellationToken) at _3CX.TableDataOffload.Uploader.BaseUploader.HandleItemAsync(UploadItem item, CancellationToken cancellationToken) at _3CX.TableDataOffload.Uploader.BaseUploader.UploadAsync(UploadItem item, CancellationToken cancellationToken)

 

[KyriacosS_3CX]

Hello,

From what I see this was update to 8 Alpha? Was the synchronisation working correctly on U7?

 

[NathanG86]

Yes was working in U7 Now 8 Alpha its not

 

[Marcos Farias]

Estou usando a versão Versão 20.0 Update 8 (Build 1109 Release) e tenho o mesmo erro.

 

[KyriacosS_3CX]

Hello, can you provide a section from logs like above? Let's see exactly what error is shown and then we can try and figure out the why.