Need your help - MySQL Rows are deleting
Status: Closed · Asked by Václav Petr on · 0 views
Hi guys,
I have a big request, I need advice.
I have created a Workflow in Pabbly Connect that sending information from Facebook Lead Ads campaigns to MySQL database.
When i do final test request and save, everything is ok. But otherwise the following happens:
Data (rows) that are added to MySQL are deleted in the database. Despite the fact that I am not sending the "deleted" column from Pabbly.
I am attaching few screenshots to show it better.
The right green square, in which, are the dates of creation of the row.
And the left green square in which are the deletion dates.
But why are records being deleted? I am dont have it mapped in Pabbly so i dont send any dates in this column...
Only test request rows are not deleted.
Thank you for help!
Attachments

Could you please share the Workflow URL or task history ID of the concerned data?
I just checked your account and didn't find any MySQL integration there in any workflow.
Workflow URL:
https://connect.pabbly.com/workflow/mapping/IjQzOTI5NyI_3D
Its created in another account (Client acc)
I have checked the workflow and its history, I can confirm that, the correct API is executing for inserting the records in MySQL.
Pabbly Connect do not perform any delete operation internally, Also, we haven't heard such issue from any of the other users. Possibly you have any script on your server which deletes the record or may be something else. There could be any cron job running on your server which may leads to this.
I would recommend you connecting a different database once and monitor the data entries for some time.