search

mediabeastnz / craft-commerce-abandoned-cart

Abandoned Cart plugin for Craft Commerce 2
Other
1 stars 15 forks source link

Column not found: 1054 Unknown column '' in 'where clause' #61

Closed mythdigital closed 1 year ago

mythdigital commented 2 years ago

We're experiencing an issue with the plugin. It does sound data related, but we're struggling to pinpoint a fix. Running the find abandoned carts command is giving the following exception. We can't find the issue with the SQL query.

Next yii\db\Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'where clause'
The SQL being executed was: SELECT `elements`.`id`, `elements`.`fieldLayoutId`, `elements`.`uid`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_sites`.`id` AS `siteSettingsId`, `elements_sites`.`slug`, `elements_sites`.`siteId`, `elements_sites`.`uri`, `elements_sites`.`enabled` AS `enabledForSite`, `elements`.`canonicalId`, `elements`.`dateLastMerged`, `commerce_orders`.`id`, `commerce_orders`.`number`, `commerce_orders`.`reference`, `commerce_orders`.`couponCode`, `commerce_orders`.`orderStatusId`, `commerce_orders`.`dateOrdered`, `commerce_orders`.`email`, `commerce_orders`.`isCompleted`, `commerce_orders`.`datePaid`, `commerce_orders`.`currency`, `commerce_orders`.`paymentCurrency`, `commerce_orders`.`lastIp`, `commerce_orders`.`orderLanguage`, `commerce_orders`.`message`, `commerce_orders`.`returnUrl`, `commerce_orders`.`cancelUrl`, `commerce_orders`.`billingAddressId`, `commerce_orders`.`shippingAddressId`, `commerce_orders`.`estimatedBillingAddressId`, `commerce_orders`.`estimatedShippingAddressId`, `commerce_orders`.`shippingMethodHandle`, `commerce_orders`.`gatewayId`, `commerce_orders`.`paymentSourceId`, `commerce_orders`.`customerId`, `commerce_orders`.`dateUpdated`, `commerce_orders`.`registerUserOnOrderComplete`, `commerce_orders`.`recalculationMode`, `commerce_orders`.`origin`, `commerce_orders`.`dateAuthorized`, `commerce_orders`.`totalPrice` AS `storedTotalPrice`, `commerce_orders`.`totalPaid` AS `storedTotalPaid`, `commerce_orders`.`itemTotal` AS `storedItemTotal`, `commerce_orders`.`totalDiscount` AS `storedTotalDiscount`, `commerce_orders`.`totalShippingCost` AS `storedTotalShippingCost`, `commerce_orders`.`totalTax` AS `storedTotalTax`, `commerce_orders`.`totalTaxIncluded` AS `storedTotalTaxIncluded`, `commerce_orders`.`shippingMethodName`, `commerce_orders`.`itemSubtotal` AS `storedItemSubtotal`, `commerce_orders`.`orderSiteId`, `content`.`id` AS `contentId`, `content`.`field_copy`, `content`.`field_description`, `content`.`field_productFeatured`, `content`.`field_navLabel`, `content`.`field_productDescription`, `content`.`field_productGtin`, `content`.`field_productItemisr`
FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId`
FROM `elements` `elements`
INNER JOIN `commerce_orders` `commerce_orders` ON `commerce_orders`.`id` = `elements`.`id`
LEFT JOIN `commerce_addresses` `billing_address` ON `billing_address`.`id` = `commerce_orders`.`billingAddressId`
LEFT JOIN `commerce_addresses` `shipping_address` ON `shipping_address`.`id` = `commerce_orders`.`shippingAddressId`
INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `elements`.`id`
INNER JOIN `content` `content` ON `content`.`elementId` = `elements`.`id`
WHERE (`commerce_orders`.`dateUpdated` <= '2022-04-12 15:33:46') AND (`commerce_orders`.`dateUpdated` >= '2022-04-12 04:33:46') AND (totalPrice > 0) AND (isCompleted = 0) AND (email != "") AND (`email`<>'false') AND (`elements`.`archived`=FALSE) AND (`elements`.`dateDeleted` IS NULL) AND (`elements`.`draftId` IS NULL) AND (`elements`.`revisionId` IS NULL)
ORDER BY `commerce_orders`.`dateUpdated` DESC) `subquery`
INNER JOIN `commerce_orders` `commerce_orders` ON `commerce_orders`.`id` = `subquery`.`elementsId`
LEFT JOIN `commerce_addresses` `billing_address` ON `billing_address`.`id` = `commerce_orders`.`billingAddressId`
LEFT JOIN `commerce_addresses` `shipping_address` ON `shipping_address`.`id` = `commerce_orders`.`shippingAddressId`
INNER JOIN `elements` `elements` ON `elements`.`id` = `subquery`.`elementsId`
INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`id` = `subquery`.`elementsSitesId`
INNER JOIN `content` `content` ON `content`.`id` = `subquery`.`contentId`
ORDER BY `commerce_orders`.`dateUpdated` DESC in /home/forge/<our-site>/vendor/yiisoft/yii2/db/Schema.php:676
mediabeastnz commented 2 years ago

Sorry for the slow response, did you find a fix for this in the data? Or does it still happen?