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 *, ban.bannerID, GROUP_CONCAT(cityName) AS cityName FROM dp_banner AS ban LEFT JOIN dp_banner_details AS banDet ON banDet.bannerID = ban.bannerID LEFT JOIN dp_business AS business ON business.businessID = ban.businessID LEFT JOIN dp_business_details AS busDet ON (busDet.businessID = business.businessID AND busDet.languageID = '1') LEFT JOIN dp_banner_to_city AS banCit ON banCit.bannerID = ban.bannerID LEFT JOIN dp_city_details AS citDet ON ( banCit.cityID = citDet.cityID AND citDet.languageID = '1' ) WHERE ban.bannerStatus != 'Deleted' AND (banDet.languageID = '1') AND (banCit.cityID IS NULL OR banCit.cityID ='1') AND ( '2021-06-16' BETWEEN bannerStartTime AND bannerEndTime OR bannerStartTime='0000-00-00' AND bannerEndTime='0000-00-00' OR '2021-06-16' > bannerStartTime AND bannerEndTime='0000-00-00' OR bannerStartTime ='0000-00-00' AND bannerEndTime > '2021-06-16' ) AND ban.bannerStatus = 'Active' AND ban.bannerLoc = 'home' GROUP BY ban.bannerID ORDER BY ban.bannerOrder ASC


MYSQL ERROR : Can't create/write to file '/tmp/#sql_51be_0.MYI' (Errcode: 28 - No space left on device)
Query : SELECT proBan.bannerID, proBan.bannerTypeID, proBan.bannerDisplayType, proBan.bannerURL, proBan.bannerStatus, proBan.bannerCreatedDate, proBan.bannerStartTime, proBan.bannerEndTime, proBanDet.bannerImage, proBanDet.bannerScript, proBanDet.bannerSwf, proBanDet.bannerCaption, GROUP_CONCAT(cityName) AS cityName, proBanTyp.bannerTypeWidth, proBanTyp.bannerTypeHeight FROM dp_promotional_banners proBan LEFT JOIN dp_promotional_banner_details proBanDet ON(proBanDet.bannerID=proBan.bannerID AND proBanDet.languageID = '1') INNER JOIN dp_promotional_banners_type proBanTyp ON (proBanTyp.bannerTypeID = proBan.bannerTypeID) LEFT JOIN dp_promotional_banners_to_city AS banCit ON ( banCit.bannerID=proBan.bannerID ) LEFT JOIN dp_city_details AS citDet ON ( banCit.cityID = citDet.cityID AND citDet.languageID = '1' ) WHERE proBan.bannerStatus <>'Deleted' AND proBanTyp.bannerTypeStatus <>'Deleted' AND proBan.bannerTypeID IN (5,6,7,8) AND proBanTyp.bannerTypeID IN (5,6,7,8) AND proBan.bannerStatus = 'Active' AND proBanTyp.bannerTypeStatus = 'Active' AND ( '2021-06-16' BETWEEN bannerStartTime AND bannerEndTime OR bannerStartTime='0000-00-00' AND bannerEndTime='0000-00-00' OR '2021-06-16' > bannerStartTime AND bannerEndTime='0000-00-00' OR bannerStartTime ='0000-00-00' AND bannerEndTime > '2021-06-16' ) AND ( banCit.cityID IS NULL OR banCit.cityID ='1' ) GROUP BY proBan.bannerID

Home : Oman’s Exclusive Online Marketplace for brands, stores and more. Shop the best on ezaars.com. Bringing Brands Closer.
image