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=103569,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
)
[66] => Array
(
[value] => Hydronic
[sort] => 4
)
[19] => Array
(
[value] => See Remarks
[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: 30526189 Threads: 10 Questions: 63448531 Slow queries: 0 Opens: 1252 Flush tables: 1 Open tables: 1206 Queries per second avg: 2.078
[sqlstate] => 00000
[protocol_version] => 10
[thread_id] => 10414734
[warning_count] => 0
)
[result:protected] =>
)
[type] => ->
[args] => Array
(
[0] => INSERT INTO listing_views SET list_id=103569,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
Don’t Move your money around
When you find your perfect house, you’ll be tempted to go on a shopping spree.
After all, a new house deserves a new couch! But resist that temptation. Lenders want to see that you’re a sensible spender.
Massive changes in your credit could scare a potential lender away.
Find out More