object(CDbException)#444 (8) {
["errorInfo"]=>
array(3) {
[0]=>
string(5) "23000"
[1]=>
int(1452)
[2]=>
string(228) "Cannot add or update a child row: a foreign key constraint fails (`yr24`.`house_info`, CONSTRAINT `house_info_ibfk_1` FOREIGN KEY (`geo_global_region`) REFERENCES `geo_global_region` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION)"
}
["message":protected]=>
string(588) "CDbCommand не удалось исполнить SQL-запрос: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`yr24`.`house_info`, CONSTRAINT `house_info_ibfk_1` FOREIGN KEY (`geo_global_region`) REFERENCES `geo_global_region` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION). The SQL statement executed was: INSERT INTO `house_info` (`id_city`, `street_name`, `street_home`, `date_edit`) VALUES (:yp0, :yp1, :yp2, :yp3). Bound with :yp0=11, :yp1='северо-западный мкр', :yp2='43', :yp3=1714082941"
["string":"Exception":private]=>
string(0) ""
["code":protected]=>
int(23000)
["file":protected]=>
string(54) "/home/www/an24.org/backend/framework/db/CDbCommand.php"
["line":protected]=>
int(358)
["trace":"Exception":private]=>
array(12) {
[0]=>
array(6) {
["file"]=>
string(60) "/home/www/an24.org/backend/framework/db/ar/CActiveRecord.php"
["line"]=>
int(1080)
["function"]=>
string(7) "execute"
["class"]=>
string(10) "CDbCommand"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[1]=>
array(6) {
["file"]=>
string(60) "/home/www/an24.org/backend/framework/db/ar/CActiveRecord.php"
["line"]=>
int(809)
["function"]=>
string(6) "insert"
["class"]=>
string(13) "CActiveRecord"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
NULL
}
}
[2]=>
array(6) {
["file"]=>
string(71) "/home/www/an24.org/backend/protected/components/utils/HouseInfoUtil.php"
["line"]=>
int(236)
["function"]=>
string(4) "save"
["class"]=>
string(13) "CActiveRecord"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[3]=>
array(6) {
["file"]=>
string(71) "/home/www/an24.org/backend/protected/components/utils/HouseInfoUtil.php"
["line"]=>
int(294)
["function"]=>
string(14) "get_house_info"
["class"]=>
string(13) "HouseInfoUtil"
["type"]=>
string(2) "::"
["args"]=>
array(4) {
[0]=>
string(2) "11"
[1]=>
bool(false)
[2]=>
bool(false)
[3]=>
string(2) "43"
}
}
[4]=>
array(6) {
["file"]=>
string(72) "/home/www/an24.org/backend/protected/controllers/ApartmentController.php"
["line"]=>
int(274)
["function"]=>
string(14) "view_home_info"
["class"]=>
string(13) "HouseInfoUtil"
["type"]=>
string(2) "::"
["args"]=>
array(1) {
[0]=>
object(Apartment)#387 (45) {
["tmpImgDir"]=>
string(0) ""
["ISA_K"]=>
NULL
["_age"]=>
NULL
["avgPrice"]=>
NULL
["info"]=>
NULL
["price_m2"]=>
float(25424)
["notActualize"]=>
NULL
["IDs"]=>
NULL
["dataProvider"]=>
NULL
["mapDataProvider":"Apartment":private]=>
NULL
["toStat":protected]=>
bool(false)
["_isKricItem":"Apartment":private]=>
NULL
["_isDranItem":"Apartment":private]=>
NULL
["_isOwnItem":"Apartment":private]=>
NULL
["_isCompanyItem":"Apartment":private]=>
NULL
["_isOwnerItem":"Apartment":private]=>
NULL
["_isAH24Item":"Apartment":private]=>
NULL
["_isYrItem":"Apartment":private]=>
NULL
["_isOtherInet":"Apartment":private]=>
NULL
["_fullPrice":"Apartment":private]=>
NULL
["analyzeText"]=>
NULL
["_maxPrice":"Apartment":private]=>
NULL
["_minPrice":"Apartment":private]=>
NULL
["_avgPrice":"Apartment":private]=>
NULL
["_maxS":"Apartment":private]=>
NULL
["_minS":"Apartment":private]=>
NULL
["_avgS":"Apartment":private]=>
NULL
["_maxAge":"Apartment":private]=>
NULL
["_minAge":"Apartment":private]=>
NULL
["_avgAge":"Apartment":private]=>
NULL
["isIncViews":"Apartment":private]=>
bool(false)
["_oldAttributes":"Apartment":private]=>
array(81) {
["id"]=>
string(7) "1434596"
["category"]=>
string(1) "3"
["pr"]=>
string(2) "50"
["show"]=>
string(1) "2"
["reserve"]=>
string(1) "0"
["user_add"]=>
string(1) "4"
["date_add"]=>
string(10) "1508554968"
["date_add_public"]=>
string(10) "1508554968"
["user_edit"]=>
string(1) "4"
["date_edit"]=>
string(10) "1508554968"
["date_edit_public"]=>
string(10) "1508554968"
["manager_id"]=>
string(1) "0"
["possible_owner_id"]=>
string(1) "0"
["owner_id"]=>
string(1) "4"
["owner_type"]=>
string(0) ""
["apartment"]=>
string(2) "12"
["geo_country"]=>
string(1) "1"
["geo_global_region"]=>
string(2) "24"
["geo_region"]=>
string(2) "11"
["geo_area"]=>
string(1) "0"
["geo_landmarks"]=>
NULL
["point_lat"]=>
NULL
["point_long"]=>
NULL
["seller_id"]=>
string(1) "0"
["seller_name"]=>
string(12) "Любовь"
["seller_contact"]=>
string(0) ""
["seller_email"]=>
string(0) ""
["seller_type"]=>
string(42) "Источник (авито собств)"
["seller_type_int"]=>
string(2) "11"
["seller_format"]=>
string(1) "0"
["buyer_id"]=>
string(1) "0"
["bank"]=>
string(0) ""
["dev_contragent"]=>
NULL
["estate_name"]=>
string(0) ""
["estate_id"]=>
string(1) "0"
["street_build"]=>
string(0) ""
["street_home_build"]=>
string(0) ""
["street_fact"]=>
string(36) "Северо-западный мкр"
["street_home_fact"]=>
string(2) "43"
["kv"]=>
NULL
["year"]=>
string(1) "0"
["porch"]=>
string(1) "0"
["material"]=>
string(2) "П"
["floor"]=>
string(1) "1"
["floor_do"]=>
NULL
["floors"]=>
string(1) "5"
["tier"]=>
string(1) "0"
["s"]=>
string(5) "47.20"
["s_live"]=>
NULL
["s_kitchen"]=>
NULL
["studio"]=>
NULL
["house_type"]=>
string(1) "0"
["wc"]=>
NULL
["balcony"]=>
NULL
["walls"]=>
NULL
["plane"]=>
NULL
["elevator"]=>
NULL
["own_period"]=>
NULL
["price"]=>
string(7) "1200000"
["discount_procent"]=>
NULL
["discount_rubs"]=>
NULL
["services"]=>
string(1) "1"
["services_procent"]=>
NULL
["services_rubs"]=>
NULL
["srvcs"]=>
string(2) "[]"
["views"]=>
string(1) "0"
["phone_show"]=>
string(1) "0"
["img"]=>
string(1) "0"
["enableReservation"]=>
string(1) "0"
["parameters"]=>
array(4) {
["parsedFrom"]=>
string(5) "avito"
["parsedUrl"]=>
string(71) "https://m.avito.ru/kansk/kvartiry/2-k_kvartira_47.2_m_15_et._1153167885"
["yandexAddressFail"]=>
bool(true)
["import_id"]=>
int(1153167885)
}
["other_parameters"]=>
NULL
["description"]=>
string(58) "Продам 2-комнатную квартиру,47,2м2"
["comment"]=>
NULL
["yr24_comment"]=>
string(0) ""
["auto_landmarks"]=>
string(1) "0"
["show_rate"]=>
string(1) "1"
["bestGroup_id"]=>
string(8) "29eddf91"
["bestGroup_position"]=>
string(1) "2"
["bestGroup_count"]=>
string(2) "38"
["groupIndex"]=>
string(32) "340218be0ddebcf71e55b414f18a743e"
["date_build"]=>
string(0) ""
}
["fromFrame"]=>
bool(false)
["_new":"CActiveRecord":private]=>
bool(false)
["_attributes":"CActiveRecord":private]=>
array(80) {
["id"]=>
string(7) "1434596"
["category"]=>
string(1) "3"
["pr"]=>
string(2) "50"
["show"]=>
string(1) "2"
["reserve"]=>
string(1) "0"
["user_add"]=>
string(1) "4"
["date_add"]=>
string(10) "1508554968"
["date_add_public"]=>
string(10) "1508554968"
["user_edit"]=>
string(1) "4"
["date_edit"]=>
string(10) "1508554968"
["date_edit_public"]=>
string(10) "1508554968"
["manager_id"]=>
string(1) "0"
["possible_owner_id"]=>
string(1) "0"
["owner_id"]=>
string(1) "4"
["owner_type"]=>
string(0) ""
["apartment"]=>
string(2) "12"
["geo_country"]=>
string(1) "1"
["geo_global_region"]=>
string(2) "24"
["geo_region"]=>
string(2) "11"
["geo_area"]=>
string(1) "0"
["geo_landmarks"]=>
NULL
["point_lat"]=>
NULL
["point_long"]=>
NULL
["seller_id"]=>
string(1) "0"
["seller_name"]=>
string(12) "Любовь"
["seller_contact"]=>
string(0) ""
["seller_email"]=>
string(0) ""
["seller_type"]=>
string(42) "Источник (авито собств)"
["seller_type_int"]=>
string(2) "11"
["seller_format"]=>
string(1) "0"
["buyer_id"]=>
string(1) "0"
["bank"]=>
string(0) ""
["dev_contragent"]=>
NULL
["estate_name"]=>
string(0) ""
["estate_id"]=>
string(1) "0"
["street_build"]=>
string(0) ""
["street_home_build"]=>
string(0) ""
["street_fact"]=>
string(36) "Северо-западный мкр"
["street_home_fact"]=>
string(2) "43"
["kv"]=>
NULL
["year"]=>
string(1) "0"
["porch"]=>
string(1) "0"
["material"]=>
string(2) "П"
["floor"]=>
string(1) "1"
["floor_do"]=>
NULL
["floors"]=>
string(1) "5"
["tier"]=>
string(1) "0"
["s"]=>
string(5) "47.20"
["s_live"]=>
NULL
["s_kitchen"]=>
NULL
["studio"]=>
NULL
["house_type"]=>
string(1) "0"
["wc"]=>
NULL
["balcony"]=>
NULL
["walls"]=>
NULL
["plane"]=>
NULL
["elevator"]=>
NULL
["own_period"]=>
NULL
["price"]=>
string(7) "1200000"
["discount_procent"]=>
NULL
["discount_rubs"]=>
NULL
["services"]=>
string(1) "1"
["services_procent"]=>
NULL
["services_rubs"]=>
NULL
["srvcs"]=>
string(2) "[]"
["views"]=>
string(1) "0"
["phone_show"]=>
string(1) "0"
["img"]=>
string(1) "0"
["enableReservation"]=>
string(1) "0"
["parameters"]=>
array(4) {
["parsedFrom"]=>
string(5) "avito"
["parsedUrl"]=>
string(71) "https://m.avito.ru/kansk/kvartiry/2-k_kvartira_47.2_m_15_et._1153167885"
["yandexAddressFail"]=>
bool(true)
["import_id"]=>
int(1153167885)
}
["other_parameters"]=>
NULL
["description"]=>
string(58) "Продам 2-комнатную квартиру,47,2м2"
["comment"]=>
NULL
["yr24_comment"]=>
string(0) ""
["auto_landmarks"]=>
string(1) "0"
["show_rate"]=>
string(1) "1"
["bestGroup_id"]=>
string(8) "29eddf91"
["bestGroup_position"]=>
string(1) "2"
["bestGroup_count"]=>
string(2) "38"
["groupIndex"]=>
string(32) "340218be0ddebcf71e55b414f18a743e"
}
["_related":"CActiveRecord":private]=>
array(4) {
["geoRegion"]=>
NULL
["geoArea"]=>
NULL
["images"]=>
array(0) {
}
["owner"]=>
object(User)#394 (20) {
["_isAH24":"User":private]=>
NULL
["password2"]=>
NULL
["old_password"]=>
NULL
["new_password"]=>
NULL
["slave"]=>
bool(false)
["_added"]=>
int(0)
["_edited"]=>
int(0)
["_edited_landmarks"]=>
int(0)
["_deleted"]=>
int(0)
["_new":"CActiveRecord":private]=>
bool(false)
["_attributes":"CActiveRecord":private]=>
array(52) {
["id"]=>
string(1) "4"
["category"]=>
string(1) "1"
["parent_id"]=>
string(1) "0"
["group_id"]=>
string(1) "0"
["active"]=>
string(1) "1"
["tarif_id"]=>
string(1) "2"
["next_tarif_id"]=>
string(1) "0"
["site"]=>
string(1) "1"
["money"]=>
string(2) "50"
["rid"]=>
string(1) "0"
["login"]=>
string(5) "robot"
["password"]=>
string(32) "a4375564b7d273de3d8c04ad724d6c1c"
["email_valid_token"]=>
string(0) ""
["fio"]=>
string(15) "Робот yr24"
["short_name"]=>
string(15) "Робот yr24"
["email"]=>
string(0) ""
["reservation_email"]=>
string(0) ""
["phone"]=>
string(0) ""
["address"]=>
string(0) ""
["usl_percent"]=>
string(3) "3.0"
["usl_rub"]=>
string(1) "0"
["usl_min_rub"]=>
string(1) "0"
["refer_percent"]=>
string(4) "50.0"
["refer_rub"]=>
string(1) "0"
["refer_min_rub"]=>
string(1) "0"
["refer_yr24"]=>
string(4) "50.0"
["url"]=>
string(0) ""
["page_title"]=>
string(0) ""
["logo"]=>
string(0) ""
["txt_about"]=>
string(0) ""
["txt_services"]=>
string(0) ""
["txt_contacts"]=>
string(0) ""
["txt_review"]=>
string(0) ""
["txt_news"]=>
string(0) ""
["reg_date"]=>
string(1) "0"
["payed_to"]=>
string(11) "17239435187"
["payed_to_fact"]=>
string(11) "17239435187"
["role"]=>
string(10) "agent_an24"
["session_count"]=>
string(3) "100"
["promo"]=>
string(0) ""
["meta_params"]=>
array(6) {
["3days_expired_mail_sended"]=>
bool(true)
["reg_from"]=>
string(7) "an_krsk"
["tarif_pays"]=>
string(1) "0"
["day_expired_mail_sended"]=>
bool(true)
["oncePayed"]=>
bool(true)
["defaultGeoRegion"]=>
string(1) "1"
}
["portrait"]=>
string(0) ""
["comment_yr24"]=>
string(0) ""
["ip"]=>
string(0) ""
["user_agent"]=>
string(0) ""
["geo_global_region"]=>
string(2) "24"
["oldTarif"]=>
string(1) "1"
["sideChosen"]=>
string(1) "1"
["id_card"]=>
string(1) "0"
["avatarbb_auth"]=>
string(0) ""
["avatarbb_id"]=>
string(1) "0"
["avatarbb_price"]=>
string(1) "0"
}
["_related":"CActiveRecord":private]=>
array(1) {
["parent"]=>
NULL
}
["_c":"CActiveRecord":private]=>
NULL
["_pk":"CActiveRecord":private]=>
string(1) "4"
["_alias":"CActiveRecord":private]=>
string(1) "t"
["_errors":"CModel":private]=>
array(0) {
}
["_validators":"CModel":private]=>
NULL
["_scenario":"CModel":private]=>
string(6) "update"
["_e":"CComponent":private]=>
NULL
["_m":"CComponent":private]=>
NULL
}
}
["_c":"CActiveRecord":private]=>
NULL
["_pk":"CActiveRecord":private]=>
string(7) "1434596"
["_alias":"CActiveRecord":private]=>
string(1) "t"
["_errors":"CModel":private]=>
array(0) {
}
["_validators":"CModel":private]=>
NULL
["_scenario":"CModel":private]=>
string(6) "update"
["_e":"CComponent":private]=>
NULL
["_m":"CComponent":private]=>
NULL
["date_build"]=>
string(0) ""
}
}
}
[5]=>
array(6) {
["file"]=>
string(66) "/home/www/an24.org/backend/framework/web/actions/CInlineAction.php"
["line"]=>
int(49)
["function"]=>
string(10) "actionView"
["class"]=>
string(19) "ApartmentController"
["type"]=>
string(2) "->"
["args"]=>
array(0) {
}
}
[6]=>
array(6) {
["file"]=>
string(56) "/home/www/an24.org/backend/framework/web/CController.php"
["line"]=>
int(308)
["function"]=>
string(13) "runWithParams"
["class"]=>
string(13) "CInlineAction"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
array(1) {
["id"]=>
string(7) "1434596"
}
}
}
[7]=>
array(6) {
["file"]=>
string(56) "/home/www/an24.org/backend/framework/web/CController.php"
["line"]=>
int(286)
["function"]=>
string(9) "runAction"
["class"]=>
string(11) "CController"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
object(CInlineAction)#17 (4) {
["_id":"CAction":private]=>
string(4) "view"
["_controller":"CAction":private]=>
object(ApartmentController)#16 (15) {
["layout"]=>
string(7) "column1"
["menu"]=>
array(0) {
}
["breadcrumbs"]=>
array(0) {
}
["defaultAction"]=>
string(5) "index"
["_id":"CController":private]=>
string(9) "apartment"
["_action":"CController":private]=>
*RECURSION*
["_pageTitle":"CController":private]=>
NULL
["_cachingStack":"CController":private]=>
NULL
["_clips":"CController":private]=>
NULL
["_dynamicOutput":"CController":private]=>
NULL
["_pageStates":"CController":private]=>
NULL
["_module":"CController":private]=>
NULL
["_widgetStack":"CBaseController":private]=>
array(0) {
}
["_e":"CComponent":private]=>
NULL
["_m":"CComponent":private]=>
NULL
}
["_e":"CComponent":private]=>
NULL
["_m":"CComponent":private]=>
NULL
}
}
}
[8]=>
array(6) {
["file"]=>
string(56) "/home/www/an24.org/backend/framework/web/CController.php"
["line"]=>
int(265)
["function"]=>
string(20) "runActionWithFilters"
["class"]=>
string(11) "CController"
["type"]=>
string(2) "->"
["args"]=>
array(2) {
[0]=>
object(CInlineAction)#17 (4) {
["_id":"CAction":private]=>
string(4) "view"
["_controller":"CAction":private]=>
object(ApartmentController)#16 (15) {
["layout"]=>
string(7) "column1"
["menu"]=>
array(0) {
}
["breadcrumbs"]=>
array(0) {
}
["defaultAction"]=>
string(5) "index"
["_id":"CController":private]=>
string(9) "apartment"
["_action":"CController":private]=>
*RECURSION*
["_pageTitle":"CController":private]=>
NULL
["_cachingStack":"CController":private]=>
NULL
["_clips":"CController":private]=>
NULL
["_dynamicOutput":"CController":private]=>
NULL
["_pageStates":"CController":private]=>
NULL
["_module":"CController":private]=>
NULL
["_widgetStack":"CBaseController":private]=>
array(0) {
}
["_e":"CComponent":private]=>
NULL
["_m":"CComponent":private]=>
NULL
}
["_e":"CComponent":private]=>
NULL
["_m":"CComponent":private]=>
NULL
}
[1]=>
array(0) {
}
}
}
[9]=>
array(6) {
["file"]=>
string(60) "/home/www/an24.org/backend/framework/web/CWebApplication.php"
["line"]=>
int(282)
["function"]=>
string(3) "run"
["class"]=>
string(11) "CController"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(4) "view"
}
}
[10]=>
array(6) {
["file"]=>
string(45) "/home/www/an24.org/site/templates/default.php"
["line"]=>
int(865)
["function"]=>
string(13) "runController"
["class"]=>
string(15) "CWebApplication"
["type"]=>
string(2) "->"
["args"]=>
array(1) {
[0]=>
string(15) "/apartment/view"
}
}
[11]=>
array(4) {
["file"]=>
string(28) "/home/www/an24.org/index.php"
["line"]=>
int(69)
["args"]=>
array(1) {
[0]=>
string(45) "/home/www/an24.org/site/templates/default.php"
}
["function"]=>
string(7) "include"
}
}
["previous":"Exception":private]=>
NULL
}