Array
(
[ERR_NO] => 1452
[ERROR] => Cannot add or update a child row: a foreign key constraint fails (`tgadmin_zero`.`listing_views`, CONSTRAINT `listing_views_ibfk_1` FOREIGN KEY (`list_id`) REFERENCES `listings` (`list_id`) ON DELETE CASCADE)
[SQL] => INSERT INTO listing_views SET list_id=103854,stamp=1711929600,year=2024,month=4
)
Array
(
[file] => /var/www/listzero/app/models/Listing.php
[line] => 429
[function] => query
[class] => Db
[object] => Listing Object
(
[attributes:protected] => Array
(
[property_type] => Array
(
[attribute_id] => 1
[name] => Property Type
[values] => Array
(
[46] => Array
(
[value] => Single Family Home
[sort] => 0
)
[47] => Array
(
[value] => Apartment Complex
[sort] => 1
)
[48] => Array
(
[value] => Town Home / Condo
[sort] => 2
)
[63] => Array
(
[value] => Multi Family Home
[sort] => 3
)
[64] => Array
(
[value] => Manufactured
[sort] => 4
)
[68] => Array
(
[value] => Vacant Land
[sort] => 5
)
)
)
[home_style] => Array
(
[attribute_id] => 2
[name] => Home Style
[values] => Array
(
[6] => Array
(
[value] => 1-Story
[sort] => 1
)
[7] => Array
(
[value] => 1-Story with Basement
[sort] => 2
)
[8] => Array
(
[value] => 2-Story
[sort] => 3
)
[9] => Array
(
[value] => 2-Story with basement
[sort] => 4
)
[10] => Array
(
[value] => Multi Level
[sort] => 5
)
[11] => Array
(
[value] => Twin Home
[sort] => 6
)
[50] => Array
(
[value] => Town Home
[sort] => 7
)
[51] => Array
(
[value] => Condo
[sort] => 8
)
[52] => Array
(
[value] => Row House
[sort] => 9
)
[53] => Array
(
[value] => Other
[sort] => 10
)
)
)
[foundation] => Array
(
[attribute_id] => 3
[name] => Foundation
[values] => Array
(
[12] => Array
(
[value] => Full Basement
[sort] => 1
)
[13] => Array
(
[value] => Half Basement
[sort] => 2
)
[14] => Array
(
[value] => Slab
[sort] => 3
)
[15] => Array
(
[value] => Crawl Space
[sort] => 4
)
)
)
[heating] => Array
(
[attribute_id] => 4
[name] => Heating
[values] => Array
(
[16] => Array
(
[value] => Forced Air
[sort] => 1
)
[17] => Array
(
[value] => Radiant Heat
[sort] => 2
)
[18] => Array
(
[value] => Geothermal
[sort] => 3
)
[19] => Array
(
[value] => See Remarks
[sort] => 4
)
[66] => Array
(
[value] => Hydronic
[sort] => 4
)
[65] => Array
(
[value] => Steam Radiant
[sort] => 5
)
)
)
[cooling] => Array
(
[attribute_id] => 5
[name] => Cooling
[values] => Array
(
[20] => Array
(
[value] => Central Air
[sort] => 1
)
[21] => Array
(
[value] => Evaporative Cooling
[sort] => 2
)
[22] => Array
(
[value] => See Remarks
[sort] => 3
)
[67] => Array
(
[value] => Air Condintioning- Window
[sort] => 4
)
)
)
[roof] => Array
(
[attribute_id] => 6
[name] => Roof
[values] => Array
(
[23] => Array
(
[value] => Asphalt Shingles
[sort] => 1
)
[24] => Array
(
[value] => Metal
[sort] => 2
)
[25] => Array
(
[value] => Wood Shingles
[sort] => 3
)
[26] => Array
(
[value] => Tar Gravel
[sort] => 4
)
[27] => Array
(
[value] => See Remarks
[sort] => 5
)
)
)
[profession] => Array
(
[attribute_id] => 7
[name] => Profession
[values] => Array
(
[28] => Array
(
[value] => Realtor
[sort] => 1
)
[29] => Array
(
[value] => Lender
[sort] => 2
)
[30] => Array
(
[value] => Appraiser
[sort] => 3
)
[31] => Array
(
[value] => Title Company
[sort] => 4
)
[32] => Array
(
[value] => Insurance
[sort] => 5
)
[33] => Array
(
[value] => Inspector
[sort] => 6
)
[34] => Array
(
[value] => Mover
[sort] => 7
)
[69] => Array
(
[value] => Photographer/Stager
[sort] => 8
)
[70] => Array
(
[value] => Attorney
[sort] => 9
)
[71] => Array
(
[value] => Marketing Expert
[sort] => 10
)
[72] => Array
(
[value] => Home Warranty
[sort] => 11
)
[35] => Array
(
[value] => Other Pro
[sort] => 12
)
)
)
[building_type] => Array
(
[attribute_id] => 8
[name] => Building Type
[values] => Array
(
[1] => Array
(
[value] => Single Family
[sort] => 1
)
[2] => Array
(
[value] => Duplex
[sort] => 2
)
[3] => Array
(
[value] => Triplex
[sort] => 3
)
[4] => Array
(
[value] => Fourplex
[sort] => 4
)
)
)
[exterior] => Array
(
[attribute_id] => 9
[name] => Exterior Material
[values] => Array
(
[38] => Array
(
[value] => Stucco
[sort] => 1
)
[39] => Array
(
[value] => Siding
[sort] => 2
)
[54] => Array
(
[value] => Brick
[sort] => 3
)
[55] => Array
(
[value] => Stucco/Brick
[sort] => 4
)
[56] => Array
(
[value] => Siding/Brick
[sort] => 5
)
[57] => Array
(
[value] => Other
[sort] => 6
)
)
)
[fireplace] => Array
(
[attribute_id] => 10
[name] => Fireplace
[values] => Array
(
[40] => Array
(
[value] => 1FP
[sort] => 0
)
[41] => Array
(
[value] => 2FP
[sort] => 1
)
[58] => Array
(
[value] => 3FP
[sort] => 2
)
[59] => Array
(
[value] => 4FP
[sort] => 3
)
[60] => Array
(
[value] => 1WS
[sort] => 4
)
[61] => Array
(
[value] => 2WS
[sort] => 5
)
[62] => Array
(
[value] => 3WS
[sort] => 6
)
)
)
)
[attributes_by_id:protected] => Array
(
[1] => Array
(
[code] => property_type
[name] => Property Type
)
[2] => Array
(
[code] => home_style
[name] => Home Style
)
[3] => Array
(
[code] => foundation
[name] => Foundation
)
[4] => Array
(
[code] => heating
[name] => Heating
)
[5] => Array
(
[code] => cooling
[name] => Cooling
)
[6] => Array
(
[code] => roof
[name] => Roof
)
[7] => Array
(
[code] => profession
[name] => Profession
)
[8] => Array
(
[code] => building_type
[name] => Building Type
)
[9] => Array
(
[code] => exterior
[name] => Exterior Material
)
[10] => Array
(
[code] => fireplace
[name] => Fireplace
)
)
[amenities:protected] => Array
(
[1] => Array
(
[amenity_id] => 1
[amenity] => Sprinklers
[sort] => 1
[status] => 1
)
[2] => Array
(
[amenity_id] => 2
[amenity] => Pool
[sort] => 2
[status] => 1
)
[3] => Array
(
[amenity_id] => 3
[amenity] => Wheelchair Access
[sort] => 3
[status] => 1
)
[4] => Array
(
[amenity_id] => 4
[amenity] => Fence
[sort] => 4
[status] => 1
)
[5] => Array
(
[amenity_id] => 5
[amenity] => Outbuildings
[sort] => 5
[status] => 1
)
[6] => Array
(
[amenity_id] => 6
[amenity] => Refrigerator
[sort] => 6
[status] => 1
)
[7] => Array
(
[amenity_id] => 7
[amenity] => Washer
[sort] => 7
[status] => 1
)
[8] => Array
(
[amenity_id] => 8
[amenity] => Dryer
[sort] => 8
[status] => 1
)
[9] => Array
(
[amenity_id] => 9
[amenity] => Stove
[sort] => 9
[status] => 1
)
[10] => Array
(
[amenity_id] => 10
[amenity] => Range
[sort] => 10
[status] => 1
)
[11] => Array
(
[amenity_id] => 11
[amenity] => Microwave
[sort] => 11
[status] => 1
)
[12] => Array
(
[amenity_id] => 12
[amenity] => Other
[sort] => 12
[status] => 1
)
)
[_listing:protected] => Array
(
)
[_model:protected] => Listing
[handle:protected] => mysqli Object
(
[affected_rows] => -1
[client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $
[client_version] => 50012
[connect_errno] => 0
[connect_error] =>
[errno] => 1452
[error] => Cannot add or update a child row: a foreign key constraint fails (`tgadmin_zero`.`listing_views`, CONSTRAINT `listing_views_ibfk_1` FOREIGN KEY (`list_id`) REFERENCES `listings` (`list_id`) ON DELETE CASCADE)
[error_list] => Array
(
[0] => Array
(
[errno] => 1452
[sqlstate] => 23000
[error] => Cannot add or update a child row: a foreign key constraint fails (`tgadmin_zero`.`listing_views`, CONSTRAINT `listing_views_ibfk_1` FOREIGN KEY (`list_id`) REFERENCES `listings` (`list_id`) ON DELETE CASCADE)
)
)
[field_count] => 5
[host_info] => Localhost via UNIX socket
[info] =>
[insert_id] => 0
[server_info] => 5.7.42-0ubuntu0.18.04.1
[server_version] => 50742
[stat] => Uptime: 29881447 Threads: 10 Questions: 55986340 Slow queries: 0 Opens: 1241 Flush tables: 1 Open tables: 1195 Queries per second avg: 1.873
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 8974826
[warning_count] => 0
)
[result:protected] =>
)
[type] => ->
[args] => Array
(
[0] => INSERT INTO listing_views SET list_id=103854,stamp=1711929600,year=2024,month=4
)
)
Home for sale at , , - Listzero.com - ListZero.com
Bedroom(s)
Bathrooms
Sq. Ft.
Acres
Tips and Tricks
to buying a home
Take the emotions out of it
You see that house. It’s so cute and quaint.
You fall in love. 10 years down the road you could be hating your quaint little house
because you fell in love too soon. So take the emotion out. Make a checklist of the things
you have to have, the things you’d like to have and the thing’s you definitely don’t want
before you go house shopping. That way you can make sure your house matches your reality.
Find out More