object(DB_Error)#18 (8) { ["error_message_prefix"]=> string(0) "" ["mode"]=> int(16) ["level"]=> int(1024) ["code"]=> int(-1) ["message"]=> string(23) "DB Error: unknown error" ["userinfo"]=> string(1386) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name [nativecode=1582 ** Incorrect parameter count in the call to native function 'RADIANS']" ["backtrace"]=> array(7) { [0]=> array(6) { ["file"]=> string(25) "/usr/local/lib/php/DB.php" ["line"]=> int(888) ["function"]=> string(10) "PEAR_Error" ["class"]=> string(10) "PEAR_Error" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> &string(23) "DB Error: unknown error" [1]=> &int(-1) [2]=> &int(16) [3]=> &string(13) "handle_errors" [4]=> &string(1386) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name [nativecode=1582 ** Incorrect parameter count in the call to native function 'RADIANS']" } } [1]=> array(7) { ["file"]=> string(27) "/usr/local/lib/php/PEAR.php" ["line"]=> int(569) ["function"]=> string(8) "DB_Error" ["class"]=> string(8) "DB_Error" ["type"]=> string(2) "->" ["object"]=> object(DB_Error)#18 (8) { ["error_message_prefix"]=> string(0) "" ["mode"]=> int(16) ["level"]=> int(1024) ["code"]=> int(-1) ["message"]=> string(23) "DB Error: unknown error" ["userinfo"]=> string(1386) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name [nativecode=1582 ** Incorrect parameter count in the call to native function 'RADIANS']" ["backtrace"]=> array(7) { [0]=> array(6) { ["file"]=> string(25) "/usr/local/lib/php/DB.php" ["line"]=> int(888) ["function"]=> string(10) "PEAR_Error" ["class"]=> string(10) "PEAR_Error" ["type"]=> string(2) "->" ["args"]=> array(5) { [0]=> &string(23) "DB Error: unknown error" [1]=> &int(-1) [2]=> &int(16) [3]=> &string(13) "handle_errors" [4]=> &string(1386) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name [nativecode=1582 ** Incorrect parameter count in the call to native function 'RADIANS']" } } [1]=> array(7) { ["file"]=> string(27) "/usr/local/lib/php/PEAR.php" ["line"]=> int(569) ["function"]=> string(8) "DB_Error" ["class"]=> string(8) "DB_Error" ["type"]=> string(2) "->" ["object"]=> *RECURSION* ["args"]=> array(4) { [0]=> &int(-1) [1]=> &int(16) [2]=> &string(13) "handle_errors" [3]=> &string(1386) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name [nativecode=1582 ** Incorrect parameter count in the call to native function 'RADIANS']" } } [2]=> array(7) { ["file"]=> string(32) "/usr/local/lib/php/DB/common.php" ["line"]=> int(1849) ["function"]=> string(10) "raiseError" ["class"]=> string(4) "PEAR" ["type"]=> string(2) "->" ["object"]=> object(DB_mysql)#1 (24) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.2.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(false) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(23) { [1004]=> int(-15) [1005]=> int(-15) [1006]=> int(-15) [1007]=> int(-5) [1008]=> int(-17) [1022]=> int(-5) [1044]=> int(-26) [1046]=> int(-14) [1048]=> int(-3) [1049]=> int(-27) [1050]=> int(-5) [1051]=> int(-18) [1054]=> int(-19) [1061]=> int(-5) [1062]=> int(-5) [1064]=> int(-2) [1091]=> int(-4) [1100]=> int(-21) [1136]=> int(-22) [1142]=> int(-26) [1146]=> int(-18) [1216]=> int(-3) [1217]=> int(-3) } ["connection"]=> resource(7) of type (mysql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["username"]=> string(8) "aaronius" ["password"]=> string(8) "lkjasdf1" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(26) "mysql.ratemyapartments.com" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(3) "rma" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["_db"]=> string(3) "rma" ["fetchmode"]=> int(3) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(1) { [0]=> array(2) { [0]=> string(51) "SELECT name, lat, lon FROM schools WHERE name_id = " [1]=> string(0) "" } } ["prepare_types"]=> array(1) { [0]=> array(1) { [0]=> int(1) } } ["prepared_queries"]=> array(1) { [0]=> string(52) "SELECT name, lat, lon FROM schools WHERE name_id = " } ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["args"]=> array(7) { [0]=> &NULL [1]=> &int(-1) [2]=> &NULL [3]=> &NULL [4]=> &string(1386) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name [nativecode=1582 ** Incorrect parameter count in the call to native function 'RADIANS']" [5]=> &string(8) "DB_Error" [6]=> &bool(true) } } [3]=> array(7) { ["file"]=> string(31) "/usr/local/lib/php/DB/mysql.php" ["line"]=> int(894) ["function"]=> string(10) "raiseError" ["class"]=> string(9) "DB_common" ["type"]=> string(2) "->" ["object"]=> object(DB_mysql)#1 (24) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.2.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(false) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(23) { [1004]=> int(-15) [1005]=> int(-15) [1006]=> int(-15) [1007]=> int(-5) [1008]=> int(-17) [1022]=> int(-5) [1044]=> int(-26) [1046]=> int(-14) [1048]=> int(-3) [1049]=> int(-27) [1050]=> int(-5) [1051]=> int(-18) [1054]=> int(-19) [1061]=> int(-5) [1062]=> int(-5) [1064]=> int(-2) [1091]=> int(-4) [1100]=> int(-21) [1136]=> int(-22) [1142]=> int(-26) [1146]=> int(-18) [1216]=> int(-3) [1217]=> int(-3) } ["connection"]=> resource(7) of type (mysql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["username"]=> string(8) "aaronius" ["password"]=> string(8) "lkjasdf1" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(26) "mysql.ratemyapartments.com" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(3) "rma" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["_db"]=> string(3) "rma" ["fetchmode"]=> int(3) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(1) { [0]=> array(2) { [0]=> string(51) "SELECT name, lat, lon FROM schools WHERE name_id = " [1]=> string(0) "" } } ["prepare_types"]=> array(1) { [0]=> array(1) { [0]=> int(1) } } ["prepared_queries"]=> array(1) { [0]=> string(52) "SELECT name, lat, lon FROM schools WHERE name_id = " } ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["args"]=> array(5) { [0]=> &int(-1) [1]=> &NULL [2]=> &NULL [3]=> &NULL [4]=> &string(74) "1582 ** Incorrect parameter count in the call to native function 'RADIANS'" } } [4]=> array(7) { ["file"]=> string(31) "/usr/local/lib/php/DB/mysql.php" ["line"]=> int(324) ["function"]=> string(15) "mysqlRaiseError" ["class"]=> string(8) "DB_mysql" ["type"]=> string(2) "->" ["object"]=> object(DB_mysql)#1 (24) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.2.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(false) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(23) { [1004]=> int(-15) [1005]=> int(-15) [1006]=> int(-15) [1007]=> int(-5) [1008]=> int(-17) [1022]=> int(-5) [1044]=> int(-26) [1046]=> int(-14) [1048]=> int(-3) [1049]=> int(-27) [1050]=> int(-5) [1051]=> int(-18) [1054]=> int(-19) [1061]=> int(-5) [1062]=> int(-5) [1064]=> int(-2) [1091]=> int(-4) [1100]=> int(-21) [1136]=> int(-22) [1142]=> int(-26) [1146]=> int(-18) [1216]=> int(-3) [1217]=> int(-3) } ["connection"]=> resource(7) of type (mysql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["username"]=> string(8) "aaronius" ["password"]=> string(8) "lkjasdf1" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(26) "mysql.ratemyapartments.com" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(3) "rma" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["_db"]=> string(3) "rma" ["fetchmode"]=> int(3) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(1) { [0]=> array(2) { [0]=> string(51) "SELECT name, lat, lon FROM schools WHERE name_id = " [1]=> string(0) "" } } ["prepare_types"]=> array(1) { [0]=> array(1) { [0]=> int(1) } } ["prepared_queries"]=> array(1) { [0]=> string(52) "SELECT name, lat, lon FROM schools WHERE name_id = " } ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["args"]=> array(0) { } } [5]=> array(7) { ["file"]=> string(32) "/usr/local/lib/php/DB/common.php" ["line"]=> int(1162) ["function"]=> string(11) "simpleQuery" ["class"]=> string(8) "DB_mysql" ["type"]=> string(2) "->" ["object"]=> object(DB_mysql)#1 (24) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.2.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(false) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(23) { [1004]=> int(-15) [1005]=> int(-15) [1006]=> int(-15) [1007]=> int(-5) [1008]=> int(-17) [1022]=> int(-5) [1044]=> int(-26) [1046]=> int(-14) [1048]=> int(-3) [1049]=> int(-27) [1050]=> int(-5) [1051]=> int(-18) [1054]=> int(-19) [1061]=> int(-5) [1062]=> int(-5) [1064]=> int(-2) [1091]=> int(-4) [1100]=> int(-21) [1136]=> int(-22) [1142]=> int(-26) [1146]=> int(-18) [1216]=> int(-3) [1217]=> int(-3) } ["connection"]=> resource(7) of type (mysql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["username"]=> string(8) "aaronius" ["password"]=> string(8) "lkjasdf1" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(26) "mysql.ratemyapartments.com" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(3) "rma" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["_db"]=> string(3) "rma" ["fetchmode"]=> int(3) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(1) { [0]=> array(2) { [0]=> string(51) "SELECT name, lat, lon FROM schools WHERE name_id = " [1]=> string(0) "" } } ["prepare_types"]=> array(1) { [0]=> array(1) { [0]=> int(1) } } ["prepared_queries"]=> array(1) { [0]=> string(52) "SELECT name, lat, lon FROM schools WHERE name_id = " } ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["args"]=> array(1) { [0]=> &string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" } } [6]=> array(7) { ["file"]=> string(50) "/home/aaronius/ratemyapartments.com/apartments.php" ["line"]=> int(259) ["function"]=> string(5) "query" ["class"]=> string(9) "DB_common" ["type"]=> string(2) "->" ["object"]=> object(DB_mysql)#1 (24) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.2.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(false) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(23) { [1004]=> int(-15) [1005]=> int(-15) [1006]=> int(-15) [1007]=> int(-5) [1008]=> int(-17) [1022]=> int(-5) [1044]=> int(-26) [1046]=> int(-14) [1048]=> int(-3) [1049]=> int(-27) [1050]=> int(-5) [1051]=> int(-18) [1054]=> int(-19) [1061]=> int(-5) [1062]=> int(-5) [1064]=> int(-2) [1091]=> int(-4) [1100]=> int(-21) [1136]=> int(-22) [1142]=> int(-26) [1146]=> int(-18) [1216]=> int(-3) [1217]=> int(-3) } ["connection"]=> resource(7) of type (mysql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["username"]=> string(8) "aaronius" ["password"]=> string(8) "lkjasdf1" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(26) "mysql.ratemyapartments.com" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(3) "rma" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["_db"]=> string(3) "rma" ["fetchmode"]=> int(3) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(1) { [0]=> array(2) { [0]=> string(51) "SELECT name, lat, lon FROM schools WHERE name_id = " [1]=> string(0) "" } } ["prepare_types"]=> array(1) { [0]=> array(1) { [0]=> int(1) } } ["prepared_queries"]=> array(1) { [0]=> string(52) "SELECT name, lat, lon FROM schools WHERE name_id = " } ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["args"]=> array(1) { [0]=> &string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" } } } ["callback"]=> string(13) "handle_errors" } ["args"]=> array(4) { [0]=> &int(-1) [1]=> &int(16) [2]=> &string(13) "handle_errors" [3]=> &string(1386) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name [nativecode=1582 ** Incorrect parameter count in the call to native function 'RADIANS']" } } [2]=> array(7) { ["file"]=> string(32) "/usr/local/lib/php/DB/common.php" ["line"]=> int(1849) ["function"]=> string(10) "raiseError" ["class"]=> string(4) "PEAR" ["type"]=> string(2) "->" ["object"]=> object(DB_mysql)#1 (24) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.2.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(false) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(23) { [1004]=> int(-15) [1005]=> int(-15) [1006]=> int(-15) [1007]=> int(-5) [1008]=> int(-17) [1022]=> int(-5) [1044]=> int(-26) [1046]=> int(-14) [1048]=> int(-3) [1049]=> int(-27) [1050]=> int(-5) [1051]=> int(-18) [1054]=> int(-19) [1061]=> int(-5) [1062]=> int(-5) [1064]=> int(-2) [1091]=> int(-4) [1100]=> int(-21) [1136]=> int(-22) [1142]=> int(-26) [1146]=> int(-18) [1216]=> int(-3) [1217]=> int(-3) } ["connection"]=> resource(7) of type (mysql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["username"]=> string(8) "aaronius" ["password"]=> string(8) "lkjasdf1" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(26) "mysql.ratemyapartments.com" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(3) "rma" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["_db"]=> string(3) "rma" ["fetchmode"]=> int(3) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(1) { [0]=> array(2) { [0]=> string(51) "SELECT name, lat, lon FROM schools WHERE name_id = " [1]=> string(0) "" } } ["prepare_types"]=> array(1) { [0]=> array(1) { [0]=> int(1) } } ["prepared_queries"]=> array(1) { [0]=> string(52) "SELECT name, lat, lon FROM schools WHERE name_id = " } ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["args"]=> array(7) { [0]=> &NULL [1]=> &int(-1) [2]=> &NULL [3]=> &NULL [4]=> &string(1386) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name [nativecode=1582 ** Incorrect parameter count in the call to native function 'RADIANS']" [5]=> &string(8) "DB_Error" [6]=> &bool(true) } } [3]=> array(7) { ["file"]=> string(31) "/usr/local/lib/php/DB/mysql.php" ["line"]=> int(894) ["function"]=> string(10) "raiseError" ["class"]=> string(9) "DB_common" ["type"]=> string(2) "->" ["object"]=> object(DB_mysql)#1 (24) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.2.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(false) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(23) { [1004]=> int(-15) [1005]=> int(-15) [1006]=> int(-15) [1007]=> int(-5) [1008]=> int(-17) [1022]=> int(-5) [1044]=> int(-26) [1046]=> int(-14) [1048]=> int(-3) [1049]=> int(-27) [1050]=> int(-5) [1051]=> int(-18) [1054]=> int(-19) [1061]=> int(-5) [1062]=> int(-5) [1064]=> int(-2) [1091]=> int(-4) [1100]=> int(-21) [1136]=> int(-22) [1142]=> int(-26) [1146]=> int(-18) [1216]=> int(-3) [1217]=> int(-3) } ["connection"]=> resource(7) of type (mysql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["username"]=> string(8) "aaronius" ["password"]=> string(8) "lkjasdf1" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(26) "mysql.ratemyapartments.com" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(3) "rma" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["_db"]=> string(3) "rma" ["fetchmode"]=> int(3) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(1) { [0]=> array(2) { [0]=> string(51) "SELECT name, lat, lon FROM schools WHERE name_id = " [1]=> string(0) "" } } ["prepare_types"]=> array(1) { [0]=> array(1) { [0]=> int(1) } } ["prepared_queries"]=> array(1) { [0]=> string(52) "SELECT name, lat, lon FROM schools WHERE name_id = " } ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["args"]=> array(5) { [0]=> &int(-1) [1]=> &NULL [2]=> &NULL [3]=> &NULL [4]=> &string(74) "1582 ** Incorrect parameter count in the call to native function 'RADIANS'" } } [4]=> array(7) { ["file"]=> string(31) "/usr/local/lib/php/DB/mysql.php" ["line"]=> int(324) ["function"]=> string(15) "mysqlRaiseError" ["class"]=> string(8) "DB_mysql" ["type"]=> string(2) "->" ["object"]=> object(DB_mysql)#1 (24) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.2.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(false) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(23) { [1004]=> int(-15) [1005]=> int(-15) [1006]=> int(-15) [1007]=> int(-5) [1008]=> int(-17) [1022]=> int(-5) [1044]=> int(-26) [1046]=> int(-14) [1048]=> int(-3) [1049]=> int(-27) [1050]=> int(-5) [1051]=> int(-18) [1054]=> int(-19) [1061]=> int(-5) [1062]=> int(-5) [1064]=> int(-2) [1091]=> int(-4) [1100]=> int(-21) [1136]=> int(-22) [1142]=> int(-26) [1146]=> int(-18) [1216]=> int(-3) [1217]=> int(-3) } ["connection"]=> resource(7) of type (mysql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["username"]=> string(8) "aaronius" ["password"]=> string(8) "lkjasdf1" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(26) "mysql.ratemyapartments.com" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(3) "rma" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["_db"]=> string(3) "rma" ["fetchmode"]=> int(3) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(1) { [0]=> array(2) { [0]=> string(51) "SELECT name, lat, lon FROM schools WHERE name_id = " [1]=> string(0) "" } } ["prepare_types"]=> array(1) { [0]=> array(1) { [0]=> int(1) } } ["prepared_queries"]=> array(1) { [0]=> string(52) "SELECT name, lat, lon FROM schools WHERE name_id = " } ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["args"]=> array(0) { } } [5]=> array(7) { ["file"]=> string(32) "/usr/local/lib/php/DB/common.php" ["line"]=> int(1162) ["function"]=> string(11) "simpleQuery" ["class"]=> string(8) "DB_mysql" ["type"]=> string(2) "->" ["object"]=> object(DB_mysql)#1 (24) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.2.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(false) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(23) { [1004]=> int(-15) [1005]=> int(-15) [1006]=> int(-15) [1007]=> int(-5) [1008]=> int(-17) [1022]=> int(-5) [1044]=> int(-26) [1046]=> int(-14) [1048]=> int(-3) [1049]=> int(-27) [1050]=> int(-5) [1051]=> int(-18) [1054]=> int(-19) [1061]=> int(-5) [1062]=> int(-5) [1064]=> int(-2) [1091]=> int(-4) [1100]=> int(-21) [1136]=> int(-22) [1142]=> int(-26) [1146]=> int(-18) [1216]=> int(-3) [1217]=> int(-3) } ["connection"]=> resource(7) of type (mysql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["username"]=> string(8) "aaronius" ["password"]=> string(8) "lkjasdf1" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(26) "mysql.ratemyapartments.com" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(3) "rma" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["_db"]=> string(3) "rma" ["fetchmode"]=> int(3) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(1) { [0]=> array(2) { [0]=> string(51) "SELECT name, lat, lon FROM schools WHERE name_id = " [1]=> string(0) "" } } ["prepare_types"]=> array(1) { [0]=> array(1) { [0]=> int(1) } } ["prepared_queries"]=> array(1) { [0]=> string(52) "SELECT name, lat, lon FROM schools WHERE name_id = " } ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["args"]=> array(1) { [0]=> &string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" } } [6]=> array(7) { ["file"]=> string(50) "/home/aaronius/ratemyapartments.com/apartments.php" ["line"]=> int(259) ["function"]=> string(5) "query" ["class"]=> string(9) "DB_common" ["type"]=> string(2) "->" ["object"]=> object(DB_mysql)#1 (24) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["features"]=> array(7) { ["limit"]=> string(5) "alter" ["new_link"]=> string(5) "4.2.0" ["numrows"]=> bool(true) ["pconnect"]=> bool(true) ["prepare"]=> bool(false) ["ssl"]=> bool(false) ["transactions"]=> bool(true) } ["errorcode_map"]=> array(23) { [1004]=> int(-15) [1005]=> int(-15) [1006]=> int(-15) [1007]=> int(-5) [1008]=> int(-17) [1022]=> int(-5) [1044]=> int(-26) [1046]=> int(-14) [1048]=> int(-3) [1049]=> int(-27) [1050]=> int(-5) [1051]=> int(-18) [1054]=> int(-19) [1061]=> int(-5) [1062]=> int(-5) [1064]=> int(-2) [1091]=> int(-4) [1100]=> int(-21) [1136]=> int(-22) [1142]=> int(-26) [1146]=> int(-18) [1216]=> int(-3) [1217]=> int(-3) } ["connection"]=> resource(7) of type (mysql link) ["dsn"]=> array(9) { ["phptype"]=> string(5) "mysql" ["dbsyntax"]=> string(5) "mysql" ["username"]=> string(8) "aaronius" ["password"]=> string(8) "lkjasdf1" ["protocol"]=> string(3) "tcp" ["hostspec"]=> string(26) "mysql.ratemyapartments.com" ["port"]=> bool(false) ["socket"]=> bool(false) ["database"]=> string(3) "rma" } ["autocommit"]=> bool(true) ["transaction_opcount"]=> int(0) ["_db"]=> string(3) "rma" ["fetchmode"]=> int(3) ["fetchmode_object_class"]=> string(8) "stdClass" ["was_connected"]=> NULL ["last_query"]=> string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" ["options"]=> array(8) { ["result_buffering"]=> int(500) ["persistent"]=> bool(false) ["ssl"]=> bool(false) ["debug"]=> int(0) ["seqname_format"]=> string(6) "%s_seq" ["autofree"]=> bool(false) ["portability"]=> int(0) ["optimize"]=> string(11) "performance" } ["last_parameters"]=> array(0) { } ["prepare_tokens"]=> array(1) { [0]=> array(2) { [0]=> string(51) "SELECT name, lat, lon FROM schools WHERE name_id = " [1]=> string(0) "" } } ["prepare_types"]=> array(1) { [0]=> array(1) { [0]=> int(1) } } ["prepared_queries"]=> array(1) { [0]=> string(52) "SELECT name, lat, lon FROM schools WHERE name_id = " } ["_debug"]=> bool(false) ["_default_error_mode"]=> NULL ["_default_error_options"]=> NULL ["_default_error_handler"]=> string(0) "" ["_error_class"]=> string(8) "DB_Error" ["_expected_errors"]=> array(0) { } } ["args"]=> array(1) { [0]=> &string(1298) " SELECT apartments.id AS id, apartments.name_id AS name_id, apartments.status AS status, CASE WHEN SUBSTRING(apartments.name,1,4) = 'The ' THEN CONCAT(SUBSTRING(apartments.name,5,LENGTH(apartments.name) - 4),'\, The') ELSE apartments.name END AS name, COUNT(ratings.id) AS ratings_count, (SELECT COUNT(contracts.id) FROM contracts WHERE contracts.apt_id = apartments.id AND display_end_date > NOW()) AS contracts_count, ROUND(DEGREES(ACOS(SIN(RADIANS())*SIN(RADIANS(apartments.lat))+COS(RADIANS())*COS(RADIANS(apartments.lat))*COS(RADIANS(-apartments.lon))))*60*1.1515,1) AS miles, ROUND(AVG(ratings.quality),1) AS aveQuality, ROUND(AVG(ratings.price),1) AS avePrice, ROUND(AVG(ratings.location),1) AS aveLocation, ROUND(AVG(ratings.social),1) AS aveSocial, ROUND(AVG(ratings.landlord),1) AS aveLandlord, ROUND(AVG(ratings.parking),1) AS aveParking, ROUND(AVG(ratings.quality+ratings.price+ratings.location+ratings.social+ratings.landlord+ratings.parking)/6,1) AS aveOverall FROM apartments LEFT JOIN ratings ON (apartments.id = ratings.apt_id) WHERE (apartments.lat BETWEEN -0.11558997026972 AND 0.11558997026972) AND (apartments.lon BETWEEN -0.17166137695312 AND 0.17166137695312) GROUP BY apartments.id ORDER BY name ASC, apartments.name" } } } ["callback"]=> string(13) "handle_errors" }