Tag not applying on purchase

Mxkert · Jan 5th 2020

Hello,

I added a tag to a product which has to be applied to a member after purchase. But the tag is not applied when the member purchases this product. I also tried logging the member out and back in, but without success. I also don't see anything about the tag in the debug after the purchase.

Am I missing something?

Mike

Mxkert · Jan 7th 2020

Anyone?

hus_hmd · Jan 7th 2020

Hi Mike,

Quote from Mxkert

I also don't see anything about the tag in the debug after the purchase.

Nonetheless, could you share the debug message you get after the purchase?

Mxkert · Jan 7th 2020

Hello Hussein,

Sure, here is my debug (split into two posts, because it is too long):

Code

Debug Message - Perch 3.1.5
[1]SELECT * FROM perch3_members_sessions WHERE sessionID='5c26c7cfb0ca4330ae13d0dd2282408b19de2337' AND sessionHttpFootprint='6998e5739945e0c073eec9f1b11d11fd464c7dbc' AND sessionExpires>'2020-01-07 08:57:21' LIMIT 1
User is logged in
[1]SELECT * FROM perch3_pages WHERE pagePath='/shop/resultaat.php' LIMIT 1
[1]SELECT * FROM perch3_shop_cart WHERE cartID=3329
[1]SELECT * FROM perch3_shop_cart WHERE cartID=3329
[61]SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1]SELECT * FROM perch3_shop_orders WHERE orderID=287 AND orderDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_orders WHERE orderID=287 AND orderDeleted IS NULL LIMIT 1
Setting order status to paid
UPDATE perch3_shop_orders SET orderDynamicFields='{\"status\":\"paid\",\"Mollie Transactie ID\":\"tr_5BsMzEw8mv\"}', orderStatus='paid', orderUpdated='2020-01-07 08:57:21' WHERE orderID='287'
No ids to log.
[1]SELECT * FROM perch3_shop_addresses WHERE addressID='1523' AND addressDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_tax_locations WHERE locationDeleted IS NULL AND ((countryID=155 AND regionID IS NULL) OR locationIsDefault=1) ORDER BY locationIsDefault ASC LIMIT 1
Looking up missing property address_1
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
Looking up missing property address_2
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
Looking up missing property city
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
Looking up missing property county
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
SELECT county FROM perch3_shop_addresses WHERE addressID='1523'
[0]Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'county' in 'field list'
Looking up missing property postcode
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
INSERT INTO perch3_shop_tax_exhibits(orderID,exhibitType,exhibitDetail,exhibitSource,locationID,countryID,exhibitDate) VALUES(287,'BILL_ADDRESS','Lisdodde, 17, 17, Naaldwijk, 2671WJ, Nederland','Customer','1','155','2020-01-07 08:57:21')
[1]SELECT * FROM perch3_shop_tax_exhibits WHERE exhibitID='1046' LIMIT 1
No ids to log.
UPDATE perch3_shop_tax_exhibits SET orderID=287, exhibitType='BILL_ADDRESS', exhibitDetail='Lisdodde, 17, 17, Naaldwijk, 2671WJ, Nederland', exhibitSource='Customer', locationID='1', countryID='155', exhibitDate='2020-01-07 08:57:21' WHERE exhibitID='1046'
No ids to log.
[1]SELECT * FROM perch3_shop_addresses WHERE addressID='1523' AND addressDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_tax_locations WHERE locationDeleted IS NULL AND ((countryID=155 AND regionID IS NULL) OR locationIsDefault=1) ORDER BY locationIsDefault ASC LIMIT 1
Looking up missing property address_1
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
Looking up missing property address_2
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
Looking up missing property city
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
Looking up missing property county
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
SELECT county FROM perch3_shop_addresses WHERE addressID='1523'
[0]Invalid query: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'county' in 'field list'
Looking up missing property postcode
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
INSERT INTO perch3_shop_tax_exhibits(orderID,exhibitType,exhibitDetail,exhibitSource,locationID,countryID,exhibitDate) VALUES(287,'SHIP_ADDRESS','Lisdodde, 17, 17, Naaldwijk, 2671WJ, Nederland','Customer','1','155','2020-01-07 08:57:21')
[1]SELECT * FROM perch3_shop_tax_exhibits WHERE exhibitID='1047' LIMIT 1
No ids to log.
UPDATE perch3_shop_tax_exhibits SET orderID=287, exhibitType='SHIP_ADDRESS', exhibitDetail='Lisdodde, 17, 17, Naaldwijk, 2671WJ, Nederland', exhibitSource='Customer', locationID='1', countryID='155', exhibitDate='2020-01-07 08:57:21' WHERE exhibitID='1047'
No ids to log.
[1]SELECT * FROM perch3_shop_order_statuses WHERE statusKey='paid' AND statusActive=1 AND statusDeleted IS NULL
[2]SELECT * FROM perch3_shop_emails WHERE emailStatus=3 AND emailActive=1
Sending customer email
[1]SELECT * FROM perch3_shop_customers WHERE customerID='129' AND customerDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_members WHERE memberID='141' LIMIT 1
Using email template: /home/kndrxwbst/domains/kendrix.website/public_html/bindle-reseller/perch/templates/shop/emails/order_paid.html (html)
[1]SELECT * FROM perch3_shop_order_statuses WHERE statusKey='paid' AND statusDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_addresses WHERE addressID=1523 AND addressDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
[1]SELECT * FROM perch3_shop_addresses WHERE addressID=1523 AND addressDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
[2]SELECT * FROM perch3_shop_order_items WHERE orderID='287' ORDER BY itemID ASC
[1]SELECT * FROM perch3_shop_order_statuses WHERE statusKey='paid' AND statusDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_currencies WHERE currencyID=44 LIMIT 1
[1]SELECT * FROM perch3_shop_shippings WHERE shippingID=2 AND shippingDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_products WHERE productID=11 AND productDeleted IS NULL LIMIT 1
[0]SELECT promoID FROM perch3_shop_order_promotions WHERE orderID=287
Looking up missing property sender_name
Looking up missing property sender_email
Building message with Perch template
[1]Using template: /templates/shop/emails/order_paid.html
Using sub-template: /templates/shop/emails/email.html
Using sub-template: /templates/shop/emails/_email_header.html
[1]Using sub-template: /templates/shop/emails/_email_footer.html
[61]SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
Sent email: "Bedankt voor het plaatsen van uw bestelling via Bindle!" to mike@kendrix.nl
Sending customer email
[1]SELECT * FROM perch3_shop_customers WHERE customerID='129' AND customerDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_members WHERE memberID='141' LIMIT 1
Using email template: /home/kndrxwbst/domains/kendrix.website/public_html/bindle-reseller/perch/templates/shop/emails/order_paid.html (html)
[1]SELECT * FROM perch3_shop_order_statuses WHERE statusKey='paid' AND statusDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_addresses WHERE addressID=1523 AND addressDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
[1]SELECT * FROM perch3_shop_addresses WHERE addressID=1523 AND addressDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1
[2]SELECT * FROM perch3_shop_order_items WHERE orderID='287' ORDER BY itemID ASC
[1]SELECT * FROM perch3_shop_order_statuses WHERE statusKey='paid' AND statusDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_currencies WHERE currencyID=44 LIMIT 1
[1]SELECT * FROM perch3_shop_shippings WHERE shippingID=2 AND shippingDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_products WHERE productID=11 AND productDeleted IS NULL LIMIT 1
[0]SELECT promoID FROM perch3_shop_order_promotions WHERE orderID=287
Looking up missing property sender_name
Looking up missing property sender_email
Building message with Perch template
[1]Using template: /templates/shop/emails/order_paid.html
Using sub-template: /templates/shop/emails/email.html
Using sub-template: /templates/shop/emails/_email_header.html
[1]Using sub-template: /templates/shop/emails/_email_footer.html
[61]SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
Sent email: "Er is een bestelling geplaatst via Bindle!" to mike@kendrix.nl
Is paid?
Using cart from cache.
[1]Using template: /templates/shop/cart/cart_sidebar_reseller.html

Display More

I added the tag as follows:

https://imgur.com/ME6mbn3

Mxkert · Jan 7th 2020

Debug part 2

Code

[3]SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' WHERE 1=1 AND ((idx.indexKey='meest_verkocht' AND idx.indexValue=1)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 3
[3]Using template: /templates/shop/products/listing/meest_verkocht.html
[3]SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_blog_index idx JOIN perch3_blog_posts main ON idx.itemID=main.postID AND idx.itemKey='postID' JOIN perch3_blog_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='postID' AND idx2.indexKey='postDateTime' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, postID ) as tbl WHERE (postStatus='Published' AND postDateTime<='2020-01-07 08:57:00' ) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 3
[1]SELECT FOUND_ROWS() AS `count`
[3]Using template: /templates/blog/nav_list.html
[2]SELECT * FROM perch3_blog_sections ORDER BY sectionTitle ASC
[1]SELECT * FROM perch3_blogs ORDER BY blogTitle ASC
[1]SELECT * FROM perch3_shop_orders WHERE orderID=287 AND orderDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_members WHERE memberID='141' LIMIT 1
[1]SELECT * FROM perch3_shop_orders WHERE orderID=287 AND orderDeleted IS NULL LIMIT 1
Is paid?
[1]SELECT * FROM perch3_shop_orders WHERE orderID=287 AND orderDeleted IS NULL LIMIT 1
[7]SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/shop/resultaat.php' OR regionPage='*' ORDER BY regionPage DESC
Using template: /templates/forms/opmerkingen.html
[1]SELECT * FROM perch3_members WHERE memberID='141' LIMIT 1
DELETE FROM perch3_shop_cart WHERE cartID='3329'
------------------------------ Calculating cart ------------------------------
[1]SELECT * FROM perch3_shop_cart WHERE cartID=0
[1]SELECT * FROM perch3_shop_cart WHERE cartID=0
[1]SELECT * FROM perch3_shop_tax_locations WHERE locationID=0 AND locationDeleted IS NULL LIMIT 1
[1]SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1]SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_currencies WHERE currencyID=0 LIMIT 1
[1]SELECT * FROM perch3_shop_currencies WHERE currencyActive=1 AND currencyID=44
[1]SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=0
Tax mode: inc
[nil]SELECT * FROM perch3_shop_cart_items WHERE cartID=0 ORDER BY itemID ASC
[1]SELECT * FROM perch3_shop_orders WHERE orderID=287 AND orderDeleted IS NULL LIMIT 1
Is paid?
[1]SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES('141','1',44,'standard','[]')
[1]SELECT * FROM perch3_shop_cart WHERE cartID=3331
[1]SELECT * FROM perch3_shop_customers WHERE memberID=141
[9]SELECT statusKey FROM perch3_shop_order_statuses WHERE statusDeleted IS NULL ORDER BY statusIndex ASC
[1]SELECT * FROM perch3_shop_orders WHERE customerID=129 AND orderID=287 AND orderStatus IN ('paid', 'processing', 'cancelled', 'dispatched', 'returned', 'partial_refund', 'refunded')
[2]SELECT * FROM perch3_shop_order_items WHERE orderID='287' ORDER BY itemID ASC
[1]SELECT * FROM perch3_shop_order_statuses WHERE statusKey='paid' AND statusDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_currencies WHERE currencyID=44 LIMIT 1
[1]SELECT * FROM perch3_shop_shippings WHERE shippingID=2 AND shippingDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_products WHERE productID=11 AND productDeleted IS NULL LIMIT 1
[0]SELECT promoID FROM perch3_shop_order_promotions WHERE orderID=287
[1]Using template: /templates/shop/orders/order_items.html
[1]SELECT * FROM perch3_shop_customers WHERE memberID=141
[1]SELECT * FROM perch3_shop_orders WHERE customerID=129 AND orderID=287 AND orderStatus IN ('paid', 'processing', 'cancelled', 'dispatched', 'returned', 'partial_refund', 'refunded')
[2]SELECT * FROM perch3_shop_order_items WHERE orderID='287' ORDER BY itemID ASC
[1]SELECT * FROM perch3_shop_order_statuses WHERE statusKey='paid' AND statusDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_currencies WHERE currencyID=44 LIMIT 1
[1]SELECT * FROM perch3_shop_shippings WHERE shippingID=2 AND shippingDeleted IS NULL LIMIT 1
[1]SELECT * FROM perch3_shop_products WHERE productID=11 AND productDeleted IS NULL LIMIT 1
[0]SELECT promoID FROM perch3_shop_order_promotions WHERE orderID=287
[1]Using template: /templates/shop/orders/order_side.html
[1]SELECT * FROM perch3_shop_customers WHERE memberID=141
[1]SELECT * FROM perch3_shop_addresses WHERE customerID='129' AND addressDeleted IS NULL AND orderID IS NULL
[1]Using template: /templates/shop/checkout/order_address_form_vue_vue.html
[1]SELECT * FROM perch3_shop_countries WHERE countryID='155' LIMIT 1

Display More

hus_hmd · Jan 9th 2020

It looks like you are using Mollie as your payment gateway. If you implemented the integration yourself, are you calling the finalize_as_paid() function on successful orders?

Mxkert · Jan 10th 2020

Hi Hussein,

Thanks for your response. You are right, it is because of my custom gateway integration, I did not think of that. I am not calling finalize_as_paid(). I guess my integration is not 100% how it should be. This weekend I will look into how I can call the finalize_as_paid() function in my app.

Thank you!