About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

MySQL to Facebook offline conversion isn't working after publishing

  • 28 August 2023
  • 9 replies
  • 35 views
Wassef

Hello , Im trying to send offline conversion From Mysql to facebook 
when im testing in zapier its working but after when im publish it nothing trigger 
-i checked the data base its working 
-i did all the integrations between zapier and facebook 
Also i tried from Mysql to googlesheet its not working also
can any one help me here to fix it 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

9 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Wassef 

Good question.

We would need to see detailed screenshots with how your Zap steps are configured.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Wassef

From Mysql to google sheet : 
 

 

Troy Tessalone
Userlevel 7
Badge +14

@Wassef 

What about screenshots for Step 2 and Step 3?

What issue/error are you having?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Wassef

i don`t have any error there 

ken.a
Userlevel 7
Badge +6

Hi there @Wassef,

I’m jumping in to see if I can help!

I did some digging on our notes, and it seems like you should double check your Zap's filters to make sure you have selected an “Order By” field. You can find this when you go to the “Trigger” section of the MySQL trigger.

It is very important that you select a field here. When we query your database we'll only pull a set number of records at a time (since we cannot pull all of them) and with no field to order by we'll most likely get the default ordering.

Your primary key would be an excellent choice here if it is auto incremented. Creation dates are also good candidates as well. But leaving this field empty could lead your Zap to stop triggering on new rows because it can't see them anymore.

Hopefully, this helps!

Wassef

Hello @ken.a 
Thanks for you collaboration 
Regarding the first point i already did order by and its not working 
Also the filter that i used the same Value of the order by
 

 

ken.a
Userlevel 7
Badge +6

Thanks for the update @Wassef,

Have you tried reconnecting your MySQL account? If not, could you please try these for me:

  1. Turn off your Zap.
  2. Reconnect your MySQL account here: https://zapier.com/app/connections/mysql
  3. Publish the Zap again.
  4. Try triggering the Zap while the Zap is published.

Please give that a try, and let me know how it goes.

Wassef

Hello @ken.a  thanks for your support 
yes i did that and still not working

ken.a
Userlevel 7
Badge +6

Hi @Wassef,

Thanks for trying that out.

If that’s the case, it would be best to contact our Support Team about this issue. They are equipped with the right tools to closely examine the Zap and its logs to identify the problem.

You may contact our Support Team through this link: https://zapier.com/app/get-help

 

I appreciate your patience and understanding.

Terms & Conditions