MySQL add a row with empty fields

#1

Hi
I am adding a row to my MySQL using the records provided by FlowXO about return path, channel, etc. when the user sends a message to the bot.

The problem is that sometimes the users send an imagen instead a message, or that their last name at Telegram is empty.
Therefore I get errors. The log say:

Column “UserHandle” can’t be blank, Column “UserLastName” can’t be blank, Column “Message” can’t be blank

Please, any help different than filtering any of these empty fields? You know, one never knows where the empty field will appear from different users or platforms of the bot.
Thank you.

(John Jackson) #2

I have a feeling that you get those error messages when your column is set to NOT NULL but the field is empty (it would actually be sending NULL to the action).

Could you give that a try?

#3

Yes!! my mistake. Thank you