Report insert error Warning: 1265 Data truncated for column 'email_sending_time'

[serefkoca]

hi
I m insert new any report no proplem
but I m edit email sending interval daily or weekly

I can't update interval report

error : server side error 200: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'email_sending_time' at row 1

how can I solve the problem ?

[tanya]

Hello,
what EspoCRM version do you use?
what Advanced Pack version do you use?
mySql version as well

and, if you have access to the database, check report table structure, email_sending_time column

[serefkoca]

Hi
crm ver. 5.0.3
admanced ver : 1.31.3 but I tested (1.28...1.31.4)
PHP version: 5.6.31
mysql Server version: 5.7.19


I checked report table
cloumn : email_sending_time

typ : int(11)

[tanya]

And what about the last "and, if you have access to the database, check report table structure, email_sending_time column" ?
And attach please the screenshot with filled Email Sending panel.

[serefkoca]

I m checked reporttable email_sending_time column
column type typ : int(11)

[tanya]

weird, it has to be time
Could you try to change it manually (create a backup before)?

I have the similar server configuration and it has time type in database. And your request is the first for few years...