Question

New MYSQL Row not showing up

  • 7 April 2021
  • 3 replies
  • 11 views

Hello,

I am trying to figure out why anew row didn’t trigger the ZAP.  I have it set to New ROW(Custom Query).  It test’s out just fine.

This is the code:

SELECT order_id, order_extra_val_1, order_extra_val_2, order_extra_val_3, order_extra_val_4, order_extra_val_5, order_notes, order_total FROM ms_orders 
LEFT OUTER JOIN ms_cart
ON ms_orders.order_id = ms_cart.cart_order
WHERE ms_cart.cart_pic_date_org = '2021 Level 3-4-5 State Meet' AND ms_orders.order_extra_val_4 = 'Friday Session 1: Level 5 Junior A & B Senior A'


3 replies

I am having the same issue. 

It has been about 30 minutes. 

If the actual updating takes 15 minutes, what is happening when I hit “run” on the zap? It seems like it is checking realtime and saying “no new rows”, although one was just added. 

 

thx, 

rbv

Userlevel 7
Badge +10

Hi @jfreeman1412 

FYI: The MYSQL triggers are NOT instant, so depending on your Zapier plan the trigger can take from 1-15 minutes to fire.

 

It did end up working, but took about 10 minutes.  Is that pretty normal?  Thanks!

Reply