Perch Shop - Free Shipping Over X Promotion Not Working

Hi Drew,

It looks as though the shipping method I've ticked hasn't been assigned an ID?

This is the preceding line:

SELECT * FROM perch2_shop_shippings WHERE shippingID= AND shippingDeleted IS NULL LIMIT 1

Hi Drew,

I'm able to edit the shipping methods that are in use without any issues.

Yep, just checked the debug on the Shipping screen and this method has a shippingID of 1.

Any ideas as to the problem here, then?

Hi Drew,

I'm trying to create an automatic "Free Shipping over £50" promotion in Perch Shop.

The error occurs when I create/edit the promotion, and select the Shipping Method that it applies to.

Here is the error I get, and the last query just before that:

SELECT * FROM perch2_shop_shippings WHERE shippingID= AND shippingDeleted IS NULL LIMIT 1

Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND shippingDeleted IS NULL LIMIT 1' at line 1

This is the debug message that appears after trying to save a promotion that applies to a selected shipping method.

Debug Message
[1] SELECT u.*, r.* FROM perch2_users u, perch2_user_roles r WHERE u.roleID=r.roleID AND u.userEnabled=1 AND u.userID=2 AND u.userHash='a7cba9d77d885533045951697cacacfe' LIMIT 1
UPDATE perch2_users SET userHash='acbe46bff58a035ebbe4267b2e63ca07' WHERE userID='2'
[41] SELECT p.privKey FROM perch2_user_privileges p
[32] SELECT * FROM (SELECT DISTINCT settingID, settingValue, userID FROM perch2_settings WHERE userID=2 OR userID=0 ORDER BY userID DESC) AS settings GROUP BY settingID, settingValue, userID
[nil] SELECT collectionID, collectionKey, collectionEditRoles FROM perch2_collections WHERE collectionInAppMenu=1 ORDER BY collectionOrder ASC
[1] SELECT * FROM perch2_shop_promotions WHERE promoID='8' LIMIT 1
Using template: /templates/shop/promotions/promotion.html
[2] SELECT * FROM perch2_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=47 DESC, currencyCode
[2] SELECT * FROM perch2_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=47 DESC, currencyCode
[2] SELECT * FROM perch2_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=47 DESC, currencyCode
UPDATE perch2_shop_promotions SET promoDynamicFields='{\"title\":\"FREE SHIPPING OVER FIFTY\",\"description\":{\"_flang\":\"markdown\",\"raw\":\"Free Shipping on all orders over \\u00a350!\",\"processed\":\"<p>Free Shipping on all orders over \\u00a350!<\\/p>\"},\"from\":\"2016-03-16 15:20:00\",\"to\":\"2018-03-16 15:20:00\",\"active\":\"1\",\"action\":\"free_ship\",\"discount_code\":\"FREEOVER50\",\"amount_percent\":null,\"amount\":{\"47\":\"\",\"142\":\"\"},\"trigger_value\":{\"47\":\"50\",\"142\":\"50\"},\"max_discount\":{\"47\":\"\",\"142\":\"\"},\"max_uses\":null,\"customer_uses\":null,\"terminating\":\"0\",\"persistent\":\"1\",\"priority\":\"1\",\"apply_to_shipping\":\"1\",\"shipping_methods\":[\"1\"]}', promoTitle='FREE SHIPPING OVER FIFTY', promoFrom='2016-03-16 15:20:00', promoTo='2018-03-16 15:20:00', promoUpdated='2017-03-21 08:53:54' WHERE promoID='8'
No ids to log.
DELETE FROM perch2_shop_index WHERE itemKey='promoID' AND itemID='8'
[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=142 LIMIT 1
[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=142 LIMIT 1
[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT * FROM perch2_shop_currencies WHERE currencyID=142 LIMIT 1
SELECT * FROM perch2_shop_shippings WHERE shippingID= AND shippingDeleted IS NULL LIMIT 1
Invalid query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND shippingDeleted IS NULL LIMIT 1' at line 1
INSERT INTO perch2_shop_index (itemKey, itemID, indexKey, indexValue) VALUES ('promoID',8,'title','FREE SHIPPING OVER FIFTY'),('promoID',8,'description','Free Shipping on all orders over £50!'),('promoID',8,'from','2016-03-16 15:20:00'),('promoID',8,'to','2018-03-16 15:20:00'),('promoID',8,'active','1'),('promoID',8,'action','free_ship'),('promoID',8,'discount_code','FREEOVER50'),('promoID',8,'amount_percent',''),('promoID',8,'amount',''),('promoID',8,'amount.gbp',''),('promoID',8,'amount.usd',''),('promoID',8,'trigger_value','50'),('promoID',8,'trigger_value.gbp','50'),('promoID',8,'trigger_value.usd','50'),('promoID',8,'max_discount',''),('promoID',8,'max_discount.gbp',''),('promoID',8,'max_discount.usd',''),('promoID',8,'max_uses',''),('promoID',8,'customer_uses',''),('promoID',8,'terminating','0'),('promoID',8,'persistent','1'),('promoID',8,'priority','1'),('promoID',8,'apply_to_shipping','1'),('promoID',8,'shipping_methods',''),('promoID',8,'promoID','8'),('promoID',8,'promoTitle','FREE SHIPPING OVER FIFTY'),('promoID',8,'promoFrom','2016-03-16 15:20:00'),('promoID',8,'promoTo','2018-03-16 15:20:00'),('promoID',8,'promoActive','1'),('promoID',8,'promoOrder','1'),('promoID',8,'promoCreated','2017-03-16 15:24:03'),('promoID',8,'promoUpdated','2017-03-21 08:53:54'),('promoID',8,'promoDeleted',''),('promoID',8,'itemID',''),('promoID',8,'itemRowID',''),('promoID',8,'_id',8)
[1] OPTIMIZE TABLE perch2_shop_index
[2] SELECT * FROM perch2_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=47 DESC, currencyCode
[2] SELECT * FROM perch2_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=47 DESC, currencyCode
[2] SELECT * FROM perch2_shop_currencies WHERE currencyActive=1 ORDER BY currencyID=47 DESC, currencyCode
[1] SELECT * FROM perch2_shop_shippings WHERE 1=1 AND shippingDeleted IS NULL ORDER BY shippingTitle ASC
Queries: 26
Memory: 3.7393
Array
(
    [type] => 2
    [message] => Cannot modify header information - headers already sent by (output started at /nfs/c11/h04/mnt/198028/domains/staging.flykartel.com/html/cms/addons/apps/perch_shop/fieldtypes.php:139)
    [file] => /nfs/c11/h04/mnt/198028/domains/staging.flykartel.com/html/cms/core/inc/top.php
    [line] => 17
)