MYSQL ERROR : Variable 'time_zone' can't be set to the value of 'NULL'
Query : SET time_zone = ( SELECT timeZoneDiff FROM dp_timezones WHERE timeZoneID='' )


MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT staBlo.blockID ,blockTitle,blockContent FROM dp_static_blocks AS staBlo LEFT JOIN dp_static_blocks_details AS staBloDet ON ( staBlo.blockID = staBloDet.blockID ) WHERE 1 AND staBloDet.languageID = 1 AND staBlo.status <> 'Deleted' AND staBlo.status ='Active' AND (dateTo > NOW() OR dateTo =0) AND (dateFrom < NOW() OR dateFrom =0) AND (dateTo > NOW() OR dateTo =0) GROUP BY staBlo.blockID ORDER BY blockTitle ASC


MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT deal.dealID, deal.refdealID, deal.dealProximity, deal.dealStartTime, deal.dealEndTime, deal.multiOptionsAvailable, deal.dealImage, deal.dealOnlineRedemption, deal.dealCreatedDate, deal.dealStatus, deal.dealExclusiveDeal, dealDet.dealExclusiveText, deal.InventoryTrackLevel, deal.dealCreatedDate, deal.dealDefaultCurrency, deal.dealTippedDate, deal.dealMinQntyReqToTipp, deal.dealTypeID, urlRew.requestPath, deal.dealSoldCountManipulate, ( CASE WHEN deal.InventoryTrackLevel='Deal' THEN (SELECT COALESCE(sum(`dealOptionQuantity`)+sum(CAST(dealQuantityUnlimited AS BINARY)),0) FROM `dp_deal_options` WHERE dealID=deal.dealID AND dealOptionStatus='Active') WHEN deal.InventoryTrackLevel='Options' THEN (SELECT COALESCE(sum(`combinationQty`),0) FROM `dp_product_combination` Combo INNER JOIN dp_deal_options OPT ON (OPT.dealOptionID=Combo.dealOptionID) WHERE OPT.dealID=deal.dealID AND Combo.status='A') ELSE 1 END )as dealSoldOut, dealDet.dealTitle, dealTyp.dealTypeKey, busDet.businessName, dealOpt.dealOptionRegularPrice, dealOpt.dealOptionDealPrice, dealOpt.optionSKU, timez.timeZoneName, timez.timeZoneAbbreviation, (SELECT SUM(soldQuantity) FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealOrdersCount , (SELECT GROUP_CONCAT(dealOptionID SEPARATOR ',') FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealoptionIDs , ( SELECT GROUP_CONCAT( DISTINCT (city_details.cityName) ORDER BY city_details.cityName ASC SEPARATOR ', ' ) AS cityName FROM dp_deal_locations AS dealLoc, dp_cities AS cit INNER JOIN dp_city_details AS city_details ON (city_details.cityID=cit.cityID) WHERE dealLoc.cityID=cit.cityID AND cit.cityStatus = 'Active' AND dealLoc.dealID=deal.dealID AND city_details.languageID='1' ) AS cityNames FROM dp_timezones AS timez LEFT JOIN dp_deals AS deal ON (timez.timeZoneID=deal.dealTimeZone) LEFT JOIN dp_deal_details AS dealDet ON ( deal.dealID=dealDet.dealID AND dealDet.languageID='1' ) LEFT JOIN dp_deal_types AS dealTyp ON (deal.dealTypeID = dealTyp.dealTypeID) LEFT JOIN dp_business_details AS busDet ON ( deal.businessID = busDet.businessID AND busDet.languageID='1' ) LEFT JOIN dp_deal_options AS dealOpt ON ( dealOpt.dealID = deal.dealID AND dealOpt.dealOptionDefault='Yes' ) LEFT JOIN dp_url_rewrite AS urlRew ON ( urlRew.objectID = deal.dealID AND urlRew.type = IF(dealTyp.dealTypeKey='getaway_deal','getaways',IF(dealTyp.dealTypeKey='product_deal','products','deal')) AND parentID=0 AND isSystem=1 AND urlRew.languageID = '1' ) WHERE 1 AND (deal.dealID IN ( SELECT DISTINCT dealLoc.dealID FROM dp_deal_locations AS dealLoc INNER JOIN dp_cities AS cit ON dealLoc.cityID = cit.cityID WHERE dealLoc.dealID = deal.dealID AND cit.cityStatus = 'Active' AND dealLoc.cityID IN ('1') ) OR EXISTS( SELECT 1 FROM dp_deal_to_country AS dealTC WHERE dealTC.dealID = deal.dealID AND dealTC.countryID IN (161) )) AND dealTyp.dealTypeStatus='Active' AND deal.dealStatus IN ('Active') AND dealTyp.dealTypeKey = 'deal' AND deal.businessID = '20' AND CONVERT_TZ('2021-06-16 00:51:58',@@session.time_zone,timez.timeZoneDiff) BETWEEN deal.dealStartTime AND deal.dealEndTime AND deal.businessID IN ( SELECT businessID FROM dp_business WHERE businessID = deal.businessID AND businessStatus='Active' ) AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY deal.dealID ORDER BY dealTyp.isFeatured, dealTyp.dealTypePosition, deal.dealEndTime DESC


MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT deal.dealID, deal.refdealID, deal.dealProximity, deal.dealStartTime, deal.dealEndTime, deal.multiOptionsAvailable, deal.dealImage, deal.dealOnlineRedemption, deal.dealCreatedDate, deal.dealStatus, deal.dealExclusiveDeal, dealDet.dealExclusiveText, deal.InventoryTrackLevel, deal.dealCreatedDate, deal.dealDefaultCurrency, deal.dealTippedDate, deal.dealMinQntyReqToTipp, deal.dealTypeID, urlRew.requestPath, deal.dealSoldCountManipulate, ( CASE WHEN deal.InventoryTrackLevel='Deal' THEN (SELECT COALESCE(sum(`dealOptionQuantity`)+sum(CAST(dealQuantityUnlimited AS BINARY)),0) FROM `dp_deal_options` WHERE dealID=deal.dealID AND dealOptionStatus='Active') WHEN deal.InventoryTrackLevel='Options' THEN (SELECT COALESCE(sum(`combinationQty`),0) FROM `dp_product_combination` Combo INNER JOIN dp_deal_options OPT ON (OPT.dealOptionID=Combo.dealOptionID) WHERE OPT.dealID=deal.dealID AND Combo.status='A') ELSE 1 END )as dealSoldOut, dealDet.dealTitle, dealTyp.dealTypeKey, busDet.businessName, dealOpt.dealOptionRegularPrice, dealOpt.dealOptionDealPrice, dealOpt.optionSKU, timez.timeZoneName, timez.timeZoneAbbreviation, (SELECT SUM(soldQuantity) FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealOrdersCount , (SELECT GROUP_CONCAT(dealOptionID SEPARATOR ',') FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealoptionIDs , ( SELECT GROUP_CONCAT( DISTINCT (city_details.cityName) ORDER BY city_details.cityName ASC SEPARATOR ', ' ) AS cityName FROM dp_deal_locations AS dealLoc, dp_cities AS cit INNER JOIN dp_city_details AS city_details ON (city_details.cityID=cit.cityID) WHERE dealLoc.cityID=cit.cityID AND cit.cityStatus = 'Active' AND dealLoc.dealID=deal.dealID AND city_details.languageID='1' ) AS cityNames FROM dp_timezones AS timez LEFT JOIN dp_deals AS deal ON (timez.timeZoneID=deal.dealTimeZone) LEFT JOIN dp_deal_details AS dealDet ON ( deal.dealID=dealDet.dealID AND dealDet.languageID='1' ) LEFT JOIN dp_deal_types AS dealTyp ON (deal.dealTypeID = dealTyp.dealTypeID) LEFT JOIN dp_business_details AS busDet ON ( deal.businessID = busDet.businessID AND busDet.languageID='1' ) LEFT JOIN dp_deal_options AS dealOpt ON ( dealOpt.dealID = deal.dealID AND dealOpt.dealOptionDefault='Yes' ) LEFT JOIN dp_url_rewrite AS urlRew ON ( urlRew.objectID = deal.dealID AND urlRew.type = IF(dealTyp.dealTypeKey='getaway_deal','getaways',IF(dealTyp.dealTypeKey='product_deal','products','deal')) AND parentID=0 AND isSystem=1 AND urlRew.languageID = '1' ) WHERE 1 AND (deal.dealID IN ( SELECT DISTINCT dealLoc.dealID FROM dp_deal_locations AS dealLoc INNER JOIN dp_cities AS cit ON dealLoc.cityID = cit.cityID WHERE dealLoc.dealID = deal.dealID AND cit.cityStatus = 'Active' AND dealLoc.cityID IN ('1') ) OR EXISTS( SELECT 1 FROM dp_deal_to_country AS dealTC WHERE dealTC.dealID = deal.dealID AND dealTC.countryID IN (161) )) AND dealTyp.dealTypeStatus='Active' AND deal.dealStatus IN ('Active') AND dealTyp.dealTypeKey = 'getaway_deal' AND deal.businessID = '20' AND CONVERT_TZ('2021-06-16 00:51:58',@@session.time_zone,timez.timeZoneDiff) BETWEEN deal.dealStartTime AND deal.dealEndTime AND deal.businessID IN ( SELECT businessID FROM dp_business WHERE businessID = deal.businessID AND businessStatus='Active' ) AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY deal.dealID ORDER BY dealTyp.isFeatured, dealTyp.dealTypePosition, deal.dealEndTime DESC


MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT deal.dealID, deal.refdealID, deal.dealProximity, deal.dealStartTime, deal.dealEndTime, deal.multiOptionsAvailable, deal.dealImage, deal.dealOnlineRedemption, deal.dealCreatedDate, deal.dealStatus, deal.dealExclusiveDeal, dealDet.dealExclusiveText, deal.InventoryTrackLevel, deal.dealCreatedDate, deal.dealDefaultCurrency, deal.dealTippedDate, deal.dealMinQntyReqToTipp, deal.dealTypeID, urlRew.requestPath, deal.dealSoldCountManipulate, ( CASE WHEN deal.InventoryTrackLevel='Deal' THEN (SELECT COALESCE(sum(`dealOptionQuantity`)+sum(CAST(dealQuantityUnlimited AS BINARY)),0) FROM `dp_deal_options` WHERE dealID=deal.dealID AND dealOptionStatus='Active') WHEN deal.InventoryTrackLevel='Options' THEN (SELECT COALESCE(sum(`combinationQty`),0) FROM `dp_product_combination` Combo INNER JOIN dp_deal_options OPT ON (OPT.dealOptionID=Combo.dealOptionID) WHERE OPT.dealID=deal.dealID AND Combo.status='A') ELSE 1 END )as dealSoldOut, dealDet.dealTitle, dealTyp.dealTypeKey, busDet.businessName, dealOpt.dealOptionRegularPrice, dealOpt.dealOptionDealPrice, dealOpt.optionSKU, timez.timeZoneName, timez.timeZoneAbbreviation, (SELECT SUM(soldQuantity) FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealOrdersCount , (SELECT GROUP_CONCAT(dealOptionID SEPARATOR ',') FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealoptionIDs , ( SELECT GROUP_CONCAT( DISTINCT (city_details.cityName) ORDER BY city_details.cityName ASC SEPARATOR ', ' ) AS cityName FROM dp_deal_locations AS dealLoc, dp_cities AS cit INNER JOIN dp_city_details AS city_details ON (city_details.cityID=cit.cityID) WHERE dealLoc.cityID=cit.cityID AND cit.cityStatus = 'Active' AND dealLoc.dealID=deal.dealID AND city_details.languageID='1' ) AS cityNames FROM dp_timezones AS timez LEFT JOIN dp_deals AS deal ON (timez.timeZoneID=deal.dealTimeZone) LEFT JOIN dp_deal_details AS dealDet ON ( deal.dealID=dealDet.dealID AND dealDet.languageID='1' ) LEFT JOIN dp_deal_types AS dealTyp ON (deal.dealTypeID = dealTyp.dealTypeID) LEFT JOIN dp_business_details AS busDet ON ( deal.businessID = busDet.businessID AND busDet.languageID='1' ) LEFT JOIN dp_deal_options AS dealOpt ON ( dealOpt.dealID = deal.dealID AND dealOpt.dealOptionDefault='Yes' ) LEFT JOIN dp_url_rewrite AS urlRew ON ( urlRew.objectID = deal.dealID AND urlRew.type = IF(dealTyp.dealTypeKey='getaway_deal','getaways',IF(dealTyp.dealTypeKey='product_deal','products','deal')) AND parentID=0 AND isSystem=1 AND urlRew.languageID = '1' ) WHERE 1 AND (deal.dealID IN ( SELECT DISTINCT dealLoc.dealID FROM dp_deal_locations AS dealLoc INNER JOIN dp_cities AS cit ON dealLoc.cityID = cit.cityID WHERE dealLoc.dealID = deal.dealID AND cit.cityStatus = 'Active' AND dealLoc.cityID IN ('1') ) OR EXISTS( SELECT 1 FROM dp_deal_to_country AS dealTC WHERE dealTC.dealID = deal.dealID AND dealTC.countryID IN (161) )) AND dealTyp.dealTypeStatus='Active' AND deal.dealEndTime < IF ( (CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff)>0), CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff), NOW() ) AND deal.dealTippedDate IS NOT NULL AND deal.dealStatus IN ('Active') AND dealTyp.dealTypeKey = 'getaway_deal' AND deal.businessID = '20' AND deal.businessID IN ( SELECT businessID FROM dp_business WHERE businessID = deal.businessID AND businessStatus='Active' ) AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY deal.dealID HAVING (dealOrdersCount >= deal.dealMinQntyReqToTipp) ORDER BY deal.dealID DESC


MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT deal.dealID, deal.refdealID, deal.dealProximity, deal.dealStartTime, deal.dealEndTime, deal.multiOptionsAvailable, deal.dealImage, deal.dealOnlineRedemption, deal.dealCreatedDate, deal.dealStatus, deal.dealExclusiveDeal, dealDet.dealExclusiveText, deal.InventoryTrackLevel, deal.dealCreatedDate, deal.dealDefaultCurrency, deal.dealTippedDate, deal.dealMinQntyReqToTipp, deal.dealTypeID, urlRew.requestPath, deal.dealSoldCountManipulate, ( CASE WHEN deal.InventoryTrackLevel='Deal' THEN (SELECT COALESCE(sum(`dealOptionQuantity`)+sum(CAST(dealQuantityUnlimited AS BINARY)),0) FROM `dp_deal_options` WHERE dealID=deal.dealID AND dealOptionStatus='Active') WHEN deal.InventoryTrackLevel='Options' THEN (SELECT COALESCE(sum(`combinationQty`),0) FROM `dp_product_combination` Combo INNER JOIN dp_deal_options OPT ON (OPT.dealOptionID=Combo.dealOptionID) WHERE OPT.dealID=deal.dealID AND Combo.status='A') ELSE 1 END )as dealSoldOut, dealDet.dealTitle, dealTyp.dealTypeKey, busDet.businessName, dealOpt.dealOptionRegularPrice, dealOpt.dealOptionDealPrice, dealOpt.optionSKU, timez.timeZoneName, timez.timeZoneAbbreviation, (SELECT SUM(soldQuantity) FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealOrdersCount , (SELECT GROUP_CONCAT(dealOptionID SEPARATOR ',') FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealoptionIDs , ( SELECT GROUP_CONCAT( DISTINCT (city_details.cityName) ORDER BY city_details.cityName ASC SEPARATOR ', ' ) AS cityName FROM dp_deal_locations AS dealLoc, dp_cities AS cit INNER JOIN dp_city_details AS city_details ON (city_details.cityID=cit.cityID) WHERE dealLoc.cityID=cit.cityID AND cit.cityStatus = 'Active' AND dealLoc.dealID=deal.dealID AND city_details.languageID='1' ) AS cityNames FROM dp_timezones AS timez LEFT JOIN dp_deals AS deal ON (timez.timeZoneID=deal.dealTimeZone) LEFT JOIN dp_deal_details AS dealDet ON ( deal.dealID=dealDet.dealID AND dealDet.languageID='1' ) LEFT JOIN dp_deal_types AS dealTyp ON (deal.dealTypeID = dealTyp.dealTypeID) LEFT JOIN dp_business_details AS busDet ON ( deal.businessID = busDet.businessID AND busDet.languageID='1' ) LEFT JOIN dp_deal_options AS dealOpt ON ( dealOpt.dealID = deal.dealID AND dealOpt.dealOptionDefault='Yes' ) LEFT JOIN dp_url_rewrite AS urlRew ON ( urlRew.objectID = deal.dealID AND urlRew.type = IF(dealTyp.dealTypeKey='getaway_deal','getaways',IF(dealTyp.dealTypeKey='product_deal','products','deal')) AND parentID=0 AND isSystem=1 AND urlRew.languageID = '1' ) WHERE 1 AND dealTyp.dealTypeStatus='Active' AND deal.dealStatus IN ('Active') AND dealTyp.dealTypeKey = 'product_deal' AND deal.businessID = '20' AND CONVERT_TZ('2021-06-16 00:51:58',@@session.time_zone,timez.timeZoneDiff) BETWEEN deal.dealStartTime AND deal.dealEndTime AND deal.businessID IN ( SELECT businessID FROM dp_business WHERE businessID = deal.businessID AND businessStatus='Active' ) AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY deal.dealID ORDER BY dealTyp.isFeatured, dealTyp.dealTypePosition, deal.dealEndTime DESC


MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT deal.dealID, deal.refdealID, deal.dealProximity, deal.dealStartTime, deal.dealEndTime, deal.multiOptionsAvailable, deal.dealImage, deal.dealOnlineRedemption, deal.dealCreatedDate, deal.dealStatus, deal.dealExclusiveDeal, dealDet.dealExclusiveText, deal.InventoryTrackLevel, deal.dealCreatedDate, deal.dealDefaultCurrency, deal.dealTippedDate, deal.dealMinQntyReqToTipp, deal.dealTypeID, urlRew.requestPath, deal.dealSoldCountManipulate, ( CASE WHEN deal.InventoryTrackLevel='Deal' THEN (SELECT COALESCE(sum(`dealOptionQuantity`)+sum(CAST(dealQuantityUnlimited AS BINARY)),0) FROM `dp_deal_options` WHERE dealID=deal.dealID AND dealOptionStatus='Active') WHEN deal.InventoryTrackLevel='Options' THEN (SELECT COALESCE(sum(`combinationQty`),0) FROM `dp_product_combination` Combo INNER JOIN dp_deal_options OPT ON (OPT.dealOptionID=Combo.dealOptionID) WHERE OPT.dealID=deal.dealID AND Combo.status='A') ELSE 1 END )as dealSoldOut, dealDet.dealTitle, dealTyp.dealTypeKey, busDet.businessName, dealOpt.dealOptionRegularPrice, dealOpt.dealOptionDealPrice, dealOpt.optionSKU, timez.timeZoneName, timez.timeZoneAbbreviation, (SELECT SUM(soldQuantity) FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealOrdersCount , (SELECT GROUP_CONCAT(dealOptionID SEPARATOR ',') FROM dp_deal_options WHERE dealID = deal.dealID ) AS dealoptionIDs , ( SELECT GROUP_CONCAT( DISTINCT (city_details.cityName) ORDER BY city_details.cityName ASC SEPARATOR ', ' ) AS cityName FROM dp_deal_locations AS dealLoc, dp_cities AS cit INNER JOIN dp_city_details AS city_details ON (city_details.cityID=cit.cityID) WHERE dealLoc.cityID=cit.cityID AND cit.cityStatus = 'Active' AND dealLoc.dealID=deal.dealID AND city_details.languageID='1' ) AS cityNames FROM dp_timezones AS timez LEFT JOIN dp_deals AS deal ON (timez.timeZoneID=deal.dealTimeZone) LEFT JOIN dp_deal_details AS dealDet ON ( deal.dealID=dealDet.dealID AND dealDet.languageID='1' ) LEFT JOIN dp_deal_types AS dealTyp ON (deal.dealTypeID = dealTyp.dealTypeID) LEFT JOIN dp_business_details AS busDet ON ( deal.businessID = busDet.businessID AND busDet.languageID='1' ) LEFT JOIN dp_deal_options AS dealOpt ON ( dealOpt.dealID = deal.dealID AND dealOpt.dealOptionDefault='Yes' ) LEFT JOIN dp_url_rewrite AS urlRew ON ( urlRew.objectID = deal.dealID AND urlRew.type = IF(dealTyp.dealTypeKey='getaway_deal','getaways',IF(dealTyp.dealTypeKey='product_deal','products','deal')) AND parentID=0 AND isSystem=1 AND urlRew.languageID = '1' ) WHERE 1 AND dealTyp.dealTypeStatus='Active' AND deal.dealEndTime < IF ( (CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff)>0), CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff), NOW() ) AND deal.dealTippedDate IS NOT NULL AND deal.dealStatus IN ('Active') AND dealTyp.dealTypeKey = 'product_deal' AND deal.businessID = '20' AND deal.businessID IN ( SELECT businessID FROM dp_business WHERE businessID = deal.businessID AND businessStatus='Active' ) AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='') GROUP BY deal.dealID HAVING (dealOrdersCount >= deal.dealMinQntyReqToTipp) ORDER BY deal.dealID DESC