Pueblo RE/MAX ::

Notice (8): Undefined offset:  0 [CORE/app/controllers/residential_controller.php, line 146]

Context | Code

$mls	=	"126947"
$listing	=	array()
$openhouse	=	array()
$images	=	array(0 => array, 1 => array, 2 => array, 3 => array, 4 => array)


        $listing = $this->Residential->findAllBymls($mls);


        $openhouse = $this->Openhouse->findAllBymls($mls);


                $images = $this->Image->findAllBymls($mls);


        $agent = $this->AgentList->find('agent_id = '.$listing[0]['Residential']['agent']." and office_id = ".$listing[0]['Residential']['office']);


        $office = $this->OfficeList->findAllByoffice_id($listing[0]['Residential']['office']);

ResidentialController::details() - CORE/app/controllers/residential_controller.php, line 146
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 341
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 323
[main] - CORE/app/webroot/index.php, line 83

Query: SELECT `Agent`.`agent_id`, `Agent`.`first`, `Agent`.`last`, `Agent`.`address`, `Agent`.`address1`, `Agent`.`city`, `Agent`.`state`, `Agent`.`zip`, `Agent`.`phone`, `Agent`.`mobile`, `Agent`.`fax`, `Agent`.`email`, `Agent`.`web_address`, `Agent`.`office_id` FROM `agent_list` AS `Agent` WHERE agent_id = and office_id = LIMIT 1

Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and office_id =    LIMIT 1' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 463]

Context | Code

$sql	=	"SELECT `Agent`.`agent_id`, `Agent`.`first`, `Agent`.`last`, `Agent`.`address`, `Agent`.`address1`, `Agent`.`city`, `Agent`.`state`, `Agent`.`zip`, `Agent`.`phone`, `Agent`.`mobile`, `Agent`.`fax`, `Agent`.`email`, `Agent`.`web_address`, `Agent`.`office_id` FROM `agent_list` AS `Agent`   WHERE agent_id =  and office_id =    LIMIT 1"
$error	=	"1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and office_id =    LIMIT 1' at line 1"


        if (($this->debug || $error) && Configure::read() > 0) {


            e("<p style = \"text-align:left\"><b>Query:</b> {$sql} ");


            if ($error) {


                trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);


            } else {

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 463
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 289
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 331
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 593
Model::findAll() - CORE/cake/libs/model/model.php, line 1451
Model::find() - CORE/cake/libs/model/model.php, line 1378
ResidentialController::details() - CORE/app/controllers/residential_controller.php, line 146
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 341
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 323
[main] - CORE/app/webroot/index.php, line 83

Notice (8): Undefined offset:  0 [CORE/app/controllers/residential_controller.php, line 147]

Context | Code

$mls	=	"126947"
$listing	=	array()
$openhouse	=	array()
$images	=	array(0 => array, 1 => array, 2 => array, 3 => array, 4 => array)
$agent	=	false


        $openhouse = $this->Openhouse->findAllBymls($mls);


                $images = $this->Image->findAllBymls($mls);


        $agent = $this->AgentList->find('agent_id = '.$listing[0]['Residential']['agent']." and office_id = ".$listing[0]['Residential']['office']);


        $office = $this->OfficeList->findAllByoffice_id($listing[0]['Residential']['office']);

ResidentialController::details() - CORE/app/controllers/residential_controller.php, line 147
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 341
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 323
[main] - CORE/app/webroot/index.php, line 83

Notice (8): Undefined offset:  0 [CORE/app/controllers/residential_controller.php, line 150]

Context | Code

$mls	=	"126947"
$listing	=	array()
$openhouse	=	array()
$images	=	array(0 => array, 1 => array, 2 => array, 3 => array, 4 => array)
$agent	=	false
$office	=	array()


        $office = $this->OfficeList->findAllByoffice_id($listing[0]['Residential']['office']);


        


        #pr ($openhouse);


        $this->pageTitle = " :: ".$listing[0]['Residential']['number']." ".$listing[0]['Residential']['address']." ".$listing[0]['Residential']['city'];


        $this->set('openhouse',$openhouse);

ResidentialController::details() - CORE/app/controllers/residential_controller.php, line 150
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 341
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 323
[main] - CORE/app/webroot/index.php, line 83

Pueblo RE/MAX ::

IDX information is provided exclusively for consumer's personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS.

Please send us your comments and suggestions
or e-mail our .
Privacy Statement/Terms of Use

9 queries took 737 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	DESCRIBE `agent_list`		14	14	5
2	DESCRIBE `office_list`		9	9	4
3	DESCRIBE `openhouses`		5	5	3
4	DESCRIBE `images`		7	7	4
5	SELECT `Residential`.`mls`, `Residential`.`ts`, `Residential`.`type`, `Residential`.`area`, `Residential`.`price`, `Residential`.`number`, `Residential`.`direction`, `Residential`.`address`, `Residential`.`city`, `Residential`.`state`, `Residential`.`zip`, `Residential`.`bedrooms`, `Residential`.`bathrooms`, `Residential`.`style`, `Residential`.`garage`, `Residential`.`basement`, `Residential`.`fireplace`, `Residential`.`above_sqft`, `Residential`.`total_gross_sqft`, `Residential`.`zoning`, `Residential`.`year_built`, `Residential`.`taxes`, `Residential`.`tax_year`, `Residential`.`sqft_source`, `Residential`.`master_bdrm_level`, `Residential`.`master_bdrm_size`, `Residential`.`bdrm2_level`, `Residential`.`bdrm2_size`, `Residential`.`bdrm3_level`, `Residential`.`bdrm3_size`, `Residential`.`bdrm4_level`, `Residential`.`bdrm4_size`, `Residential`.`bdrm5_level`, `Residential`.`bdrm5_size`, `Residential`.`kitchen_level`, `Residential`.`kitchen_size`, `Residential`.`kitchen_eating`, `Residential`.`dining_level`, `Residential`.`dining_size`, `Residential`.`dining_type`, `Residential`.`living_level`, `Residential`.`living_size`, `Residential`.`family_level`, `Residential`.`family_size`, `Residential`.`remarks`, `Residential`.`int_features`, `Residential`.`ext_features`, `Residential`.`office`, `Residential`.`agent`, `Residential`.`sub_area`, `Residential`.`school_district`, `Residential`.`virtual_tour`, `Residential`.`laundry_level` FROM `residential` AS `Residential` WHERE `Residential`.`mls` = 126947		0	0	2
6	SELECT `openhouse`.`id`, `openhouse`.`mls`, `openhouse`.`type`, `openhouse`.`start`, `openhouse`.`end` FROM `openhouses` AS `openhouse` WHERE `openhouse`.`mls` = 126947		0	0	3
7	SELECT `Image`.`imageId`, `Image`.`mls`, `Image`.`imgUrl`, `Image`.`label`, `Image`.`dateModified`, `Image`.`photoOrder`, `Image`.`portrait` FROM `images` AS `Image` WHERE `Image`.`mls` = 126947		5	5	714
8	SELECT `Agent`.`agent_id`, `Agent`.`first`, `Agent`.`last`, `Agent`.`address`, `Agent`.`address1`, `Agent`.`city`, `Agent`.`state`, `Agent`.`zip`, `Agent`.`phone`, `Agent`.`mobile`, `Agent`.`fax`, `Agent`.`email`, `Agent`.`web_address`, `Agent`.`office_id` FROM `agent_list` AS `Agent` WHERE agent_id = and office_id = LIMIT 1	1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'and office_id = LIMIT 1' at line 1			1
9	SELECT `Office`.`office_id`, `Office`.`name`, `Office`.`address`, `Office`.`address1`, `Office`.`city`, `Office`.`state`, `Office`.`zip`, `Office`.`phone`, `Office`.`email` FROM `office_list` AS `Office` WHERE `Office`.`office_id` IS NULL		0	0	1