• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

MySQL: New Row in a table: missing new data

Lucas.

Member
Your Task History ID
IjU3NjUwNTZk...
Hi!
I'm having sudden trouble fetching data from my Mysql db. (workflow map: IjU3NjUwNTY4MDYzNDA0MzQ1MjZjNTUzMjUxM2Ii_pc)
As you can see I have rows until ID 1607

1727717416938.png


When I look in Pabbly the last item is 1597 and not 1607. I tried refreshing multiple times; this did not work.
I noticed a lot of weird things to on 26th of september. Many tasks suddenly got triggerred:

1727717774904.png
 

Lucas.

Member
OK, somehow new data seem to be coming trough.
I think pabbly somehow reset the counter or did not remember where the last row was.
 

Preeti Paryani

Well-known member
Hello @Lucas.

Can you please share the row details that are been added to the table, but not captured in the workflow? Also, please mention the "Reference" field details, refer to the attached image for more info on the same.

image-10-03-2024_11_12_AM.png
 

Lucas.

Member
Hi, the problem is there is nothing triggered.
So, no data available in Pabbly but it is in mysql.
I saw on Facebook you improved somethings that could have an impact on this.
1728325037171.png
 

Lucas.

Member
So, I have noticed you changed your polling service to another server.
They still don't seem to work for me.
I noticed that: manually refreshing the fields does get the latest rows in. But this does not seem to work automatically:
 

Attachments

  • 1728326030478.png
    1728326030478.png
    87.3 KB · Views: 7

Lucas.

Member
I have added a new row in the database table.
The unique column id is 1617.
You will probably see in +1 h (what is the trigger timer) this is not triggered.
When you try and fetch data manually it will show.
 

Lucas.

Member
It also seems all rows are triggered again instaid of new ones once I manually refresh the fields:
1728327664202.png

I hope you can find the issue soon. It's making everything very hard now.
Thanks! Let me know if I can provide more information
 

Luv

Member
Staff member
Hey @Lucas.

The issue has been fixed and it should work now. Please try again on your end and let us know if you face any issues.
 
Top