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
SQL_CALC_FOUND_ROWS
'product_deal' AS dealTypeKey,
'product_deal' AS dealType,
'' AS dealTypeUrlKey,
'Products' AS dealTypeName, deal.dealID,
deal.dealTypeID,
deal.InventoryTrackLevel,
deal.dealOnlineRedemption,
deal.dealStartTime,
deal.dealCreatedDate,
deal.dealEndTime,
deal.dealNoEndDate,
deal.dealExpiryDate,
deal.dealDefaultCurrency,
deal.dealMinBuyLimit,
deal.dealMaxBuyLimit,
deal.dealMaxGiftBuy,
IF((dealMaxGiftBuy>0),'No','Yes') AS giftUnlimited,
deal.dealMinQntyReqToTipp,
deal.dealImage,
deal.dealVideo,
deal.dealShowVideo,
deal.dealShowDealTipped,
deal.dealShowNosBought,
deal.dealProximity,
deal.dealTippedDate,
deal.dealExclusiveDeal,
deal.dealHideDiscount,
deal.productCollectFromStore,
deal.dealSlotAvailable,
deal.dealFlightAvailable,
deal.dealRoomAvailable,
deal.multipleDestination,
deal.dealReturnableDays,
deal.dealShowReturnable,
DATEDIFF(NOW(),deal.dealTippedDate) AS dealTippedDateDifference,
dealDet.dealTitle,
dealDet.dealShortTitle,
dealDet.dealDescription,
dealDet.dealUrl as dealKey,
deal.dealSoldCountManipulate,
deal.businessID,
deal.shippingStatus,
deal.attributeSetID,
deal.dealDestinationUrl,
bus.businessKey,
bus.businessRedemption,
busDet.businessName,
dealOptLeast.dealOptionDealPrice as dealOptionLeastDealPrice,
dealOptLeast.dealOptionRegularPrice as dealOptionLeastRegularPrice,
dealOpt.dealOptionID,
dealOpt.optionSKU,
dealOpt.dealOptionDealPrice,
dealOpt.dealOptionRegularPrice,
dealOpt.dealOptionQuantity,
dealOpt.dealQuantityUnlimited,
dealOpt.soldQuantity AS dealOrderItemsCount,
dealOpt.dealOptionAvailAdults,
dealOpt.dealOptionAvailChilds,
dealOpt.dealOptionMaximumDays,
timez.timeZoneDiff,
timez.timeZoneName,
shiprate.rateNational,
TIMESTAMPDIFF(DAY,NOW(),deal.dealEndTime) AS remainingDays,
TIMESTAMPDIFF(HOUR,NOW(),deal.dealEndTime)-TIMESTAMPDIFF(DAY,NOW(),deal.dealEndTime)*24
AS remainingHours,
TIMESTAMPDIFF(MINUTE,NOW(),deal.dealEndTime)-TIMESTAMPDIFF(HOUR,NOW(),deal.dealEndTime)*60 AS
remainingMinutes,
IF(
(CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff)>0),
CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff),
NOW()
) AS timeZoneConverted,
IF(deal.InventoryTrackLevel ='No',
1,
IF(deal.InventoryTrackLevel ='Deal',
(
SELECT
sum(dealOptionQuantity)
FROM
dp_deal_options
WHERE
dealID=deal.dealID
AND
dealOptionStatus='Active'
),
(
SELECT
sum(combinationQty)
FROM
dp_deal_options as dealOpt1
LEFT JOIN
dp_product_combination as proCom1
ON(proCom1.dealOptionID=dealOpt1.dealOptionID)
WHERE
dealOpt1.dealID=deal.dealID
AND
proCom1.status='A'
)
)
)
as dealOptionQuantitySum,
(
SELECT
COUNT(dealOptionID)
FROM
dp_deal_options
WHERE
dealID=deal.dealID
AND
dealOptionStatus='Active'
) AS dealOptionCount,
(
SELECT
SUM(soldQuantity)
FROM
dp_deal_options
WHERE
dealID = deal.dealID
) AS dealOrdersCount,
CASE deal.dealOnlineRedemption
WHEN 'No' THEN
(
SELECT COUNT(dealBusinessLocID)
FROM dp_deal_to_business_locations
WHERE dealID = deal.dealID
)
ELSE
0
END AS locCount,dealDet.dealExclusiveText,deal.dealHideLimitedQuantity,deal.dealHideBuycount,deal.dealHideRemainingTime,
( SELECT
GROUP_CONCAT(dealOptionID SEPARATOR ',')
FROM
dp_deal_options
WHERE
dealID = deal.dealID ) AS dealoptionIDs
,
dealPri.dealPriority
FROM
dp_deals AS deal
LEFT JOIN
dp_deal_details AS dealDet
ON (
deal.dealID = dealDet.dealID
AND
dealDet.languageID = 1
)
LEFT JOIN
dp_attribute_set AS attrSet
ON attrSet.attributeSetID = deal.attributeSetID
LEFT JOIN
dp_deal_to_category AS dealToCat
ON (deal.dealID = dealToCat.dealID)
LEFT JOIN
dp_deal_categories AS dealCat
ON (dealCat.dealCategoryID = dealToCat.dealCategoryID)
LEFT JOIN
dp_deal_priority AS dealPri
ON (
dealPri.cityID = '0'
AND
deal.dealID = dealPri.dealID
AND
dealPri.dealDate = '2021-06-16'
)
LEFT JOIN
dp_business AS bus
ON (deal.businessID = bus.businessID)
LEFT JOIN
dp_business_details AS busDet
ON (bus.businessID = busDet.businessID)
LEFT JOIN
dp_deal_options AS dealOpt
ON (
deal.dealID = dealOpt.dealID
AND
dealOpt.dealOptionStatus = 'Active'
AND
dealOpt.dealOptionDefault = 'Yes'
)
LEFT JOIN
dp_deal_options AS dealOptLeast
ON (
deal.dealID = dealOptLeast.dealID
AND
dealOptLeast.dealOptionStatus = 'Active'
AND
dealOptLeast.dealOptionDealPrice = (SELECT MIN(dealOptionDealPrice)
FROM dp_deal_options WHERE dealID = dealOptLeast.dealID
AND dealOptionStatus = 'Active' )
)
LEFT JOIN
dp_timezones AS timez
ON deal.dealTimeZone = timez.timeZoneID LEFT JOIN
dp_shipping_rates AS shiprate ON shiprate.dealID = deal.dealID
WHERE 1 AND deal.dealTypeID = '4'
AND
deal.dealStatus = 'Active'
AND (
CONVERT_TZ(NOW(),@@session.time_zone,timez.timeZoneDiff)
BETWEEN
deal.dealStartTime
AND
deal.dealEndTime
)
AND
bus.businessStatus = 'Active'
AND
dealToCat.dealCategoryID in ('81')
AND
(
dealCat.dealCategoryStatus = 'Active'
AND
(
dealCat.dealCategoryParent = '0'
OR
EXISTS (
SELECT
dealCat2.dealCategoryID
FROM
dp_deal_categories dealCat2
WHERE
dealCat2.dealCategoryID = dealCat.dealCategoryParent
AND dealCat2.dealCategoryStatus = 'Active'
)
)
) AND (find_in_set('0',deal.userGroupID) OR deal.userGroupID='')
GROUP BY deal.dealID
ORDER BY
FIELD(deal.dealID,0) DESC,
dealPri.dealPriority,
deal.dealCreatedDate DESC LIMIT 0,22