Exception Object ( [message:protected] => Database error: Invalid SQL: SELECT M.MLS_NUM, M.listing_key,M.LastUpdateDate,M.ListMarketPercentage, mls_market_sef_url, mls_is_pic_url_supported, M.ListPrice, M.PropertyType,M.PropertyTypeNew, M.SubType, M.PropertyStyle, M.Beds, M.Baths, M.SQFT, M.TotalAcreage, M.MLSP_ID, M.Stories ,CONCAT(M.MLS_NUM,'-',M.MLSP_ID) As ListingID_MLS, M.YearBuilt, Subdivision, M.Description, M.Description2, TotalPhotos, Main_Photo, DisplayAddress, office_name, Tax, TaxYear, FloorArea, MaintenanceFee, A.StreetNumber, A.StreetName, A.Area, A.Subdivision,A.CityName, A.County, A.State, ZipCode, DATE_FORMAT( ListingDate, '%b %d, %Y' ) ListingDate, DATEDIFF(CURDATE(), ListingDate) AS DayOnMarket, A.StreetType, A.UnitNo, A.StreetDirection, M.Parking, M.YearBuilt, A.Latitude, A.Longitude, business_type_major, business_type_minor, is_openhouse, CONCAT('https://static.estateblock.com/pictures/property/', CONCAT(M.MLS_NUM,'-',M.MLSP_ID), '/0') AS Pic_Path,is_mark_for_deletion,M.is_hotdeal,M.hotdeal_tag,M.hotdeal_description FROM listing_master AS M LEFT JOIN listing_address AS A ON M.MLS_NUM = A.MLS_NUM AND M.MLSP_ID = A.MLSP_ID LEFT JOIN mls_master AS MM ON M.MLSP_ID = MM.MLSP_ID LEFT JOIN mls_master_lang AS MML ON M.MLSP_ID = MML.mlsp_master_id AND mlsp_lang_code = 'en' WHERE 1 AND A.ZipCode = 'V7C 1H8' AND A.State = 'BC' AND M.MLSP_ID IN (4) AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2396748','R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917','2433783','10186756','2441289','R2374891','R2424637','R2400629','R2383547','r2383547' ) ORDER BY display_on_website_datetime desc LIMIT 0, 50
MySQL Error: 1021 (Disk full (/home/tmp/#sql_14bf_2.MAI); waiting for someone to free some space... (errno: 28 "No space left on device"))
[string:Exception:private] => [code:protected] => 0 [file:protected] => /home/estatebl/public_html/libs/mysql5i.php [line:protected] => 665 [trace:Exception:private] => Array ( [0] => Array ( [file] => /home/estatebl/public_html/libs/mysql5i.php [line] => 514 [function] => halt [class] => DB_Sql [type] => -> [args] => Array ( [0] => Invalid SQL: SELECT M.MLS_NUM, M.listing_key,M.LastUpdateDate,M.ListMarketPercentage, mls_market_sef_url, mls_is_pic_url_supported, M.ListPrice, M.PropertyType,M.PropertyTypeNew, M.SubType, M.PropertyStyle, M.Beds, M.Baths, M.SQFT, M.TotalAcreage, M.MLSP_ID, M.Stories ,CONCAT(M.MLS_NUM,'-',M.MLSP_ID) As ListingID_MLS, M.YearBuilt, Subdivision, M.Description, M.Description2, TotalPhotos, Main_Photo, DisplayAddress, office_name, Tax, TaxYear, FloorArea, MaintenanceFee, A.StreetNumber, A.StreetName, A.Area, A.Subdivision,A.CityName, A.County, A.State, ZipCode, DATE_FORMAT( ListingDate, '%b %d, %Y' ) ListingDate, DATEDIFF(CURDATE(), ListingDate) AS DayOnMarket, A.StreetType, A.UnitNo, A.StreetDirection, M.Parking, M.YearBuilt, A.Latitude, A.Longitude, business_type_major, business_type_minor, is_openhouse, CONCAT('https://static.estateblock.com/pictures/property/', CONCAT(M.MLS_NUM,'-',M.MLSP_ID), '/0') AS Pic_Path,is_mark_for_deletion,M.is_hotdeal,M.hotdeal_tag,M.hotdeal_description FROM listing_master AS M LEFT JOIN listing_address AS A ON M.MLS_NUM = A.MLS_NUM AND M.MLSP_ID = A.MLSP_ID LEFT JOIN mls_master AS MM ON M.MLSP_ID = MM.MLSP_ID LEFT JOIN mls_master_lang AS MML ON M.MLSP_ID = MML.mlsp_master_id AND mlsp_lang_code = 'en' WHERE 1 AND A.ZipCode = 'V7C 1H8' AND A.State = 'BC' AND M.MLSP_ID IN (4) AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2396748','R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917','2433783','10186756','2441289','R2374891','R2424637','R2400629','R2383547','r2383547' ) ORDER BY display_on_website_datetime desc LIMIT 0, 50 ) ) [1] => Array ( [file] => /home/estatebl/public_html/db_access/IDXListing.php [line] => 2181 [function] => query [class] => DB_Sql [type] => -> [args] => Array ( [0] => SELECT M.MLS_NUM, M.listing_key,M.LastUpdateDate,M.ListMarketPercentage, mls_market_sef_url, mls_is_pic_url_supported, M.ListPrice, M.PropertyType,M.PropertyTypeNew, M.SubType, M.PropertyStyle, M.Beds, M.Baths, M.SQFT, M.TotalAcreage, M.MLSP_ID, M.Stories ,CONCAT(M.MLS_NUM,'-',M.MLSP_ID) As ListingID_MLS, M.YearBuilt, Subdivision, M.Description, M.Description2, TotalPhotos, Main_Photo, DisplayAddress, office_name, Tax, TaxYear, FloorArea, MaintenanceFee, A.StreetNumber, A.StreetName, A.Area, A.Subdivision,A.CityName, A.County, A.State, ZipCode, DATE_FORMAT( ListingDate, '%b %d, %Y' ) ListingDate, DATEDIFF(CURDATE(), ListingDate) AS DayOnMarket, A.StreetType, A.UnitNo, A.StreetDirection, M.Parking, M.YearBuilt, A.Latitude, A.Longitude, business_type_major, business_type_minor, is_openhouse, CONCAT('https://static.estateblock.com/pictures/property/', CONCAT(M.MLS_NUM,'-',M.MLSP_ID), '/0') AS Pic_Path,is_mark_for_deletion,M.is_hotdeal,M.hotdeal_tag,M.hotdeal_description FROM listing_master AS M LEFT JOIN listing_address AS A ON M.MLS_NUM = A.MLS_NUM AND M.MLSP_ID = A.MLSP_ID LEFT JOIN mls_master AS MM ON M.MLSP_ID = MM.MLSP_ID LEFT JOIN mls_master_lang AS MML ON M.MLSP_ID = MML.mlsp_master_id AND mlsp_lang_code = 'en' WHERE 1 AND A.ZipCode = 'V7C 1H8' AND A.State = 'BC' AND M.MLSP_ID IN (4) AND M.is_mark_for_deletion = 'N' AND display_on_website = 'Yes' AND M.MLS_NUM NOT IN ( 'R2396748','R2324677','C8020260','R2228301','R2234336','R2246159','R2248911','R2268588','439164','R2334065','R2331824','C8021917','2433783','10186756','2441289','R2374891','R2424637','R2400629','R2383547','r2383547' ) ORDER BY display_on_website_datetime desc LIMIT 0, 50 ) ) [2] => Array ( [file] => /home/estatebl/public_html/component/IDXListingComponent.php [line] => 249 [function] => getListingByParam [class] => IDXListing [type] => -> [args] => Array ( [0] => Array ( [MLSP_ID] => 4 [slugLocation] => v7c-1h8,bc [slugProvider] => lower-mainland-commercial [Section] => mls [page_size] => 50 [cur_page] => 0 [start_record] => 0 [resultView] => map [getMapData] => 1 [id] => 93413 [keyword] => V7C 1H8, BC [type] => zipcode [sef_url] => v7c-1h8,bc [State] => BC [ZipCode] => V7C 1H8 [display_order] => 6 [is_active] => Yes [length] => 11 [AllPhoto] => 1 [sort_by] => display_on_website_datetime|desc [viewType] => ListingView ) ) ) [3] => Array ( [file] => /home/estatebl/public_html/search.php [line] => 186 [function] => getSearchData [class] => IDXListingComponent [type] => -> [args] => Array ( [0] => Array ( [MLSP_ID] => 4 [slugLocation] => v7c-1h8,bc [slugProvider] => lower-mainland-commercial [Section] => mls [page_size] => 50 [cur_page] => 0 [start_record] => 0 [resultView] => map [getMapData] => 1 [id] => 93413 [keyword] => V7C 1H8, BC [type] => zipcode [sef_url] => v7c-1h8,bc [State] => BC [ZipCode] => V7C 1H8 [display_order] => 6 [is_active] => Yes [length] => 11 [AllPhoto] => 1 [sort_by] => display_on_website_datetime|desc ) ) ) ) [previous:Exception:private] => )