Mall Directory and Mall Locator | Malletin.com

Notice (8): Undefined index: state [APP/Controller/Component/FilterComponent.php, line 147]Code Context        if($controller->action == $controllerAction) {
            // setup filter component
            $this->filter = $this->processFilters($controller, $exactMatch);
$controller	=	object(MallsController) {}
$exact	=	array()
$whiteList	=	null
$ret	=	array()
$key	=	'Mall'
$value	=	array(
	'state' => 'AL',
	'city' => '1007'
)
$columns	=	array(
	'id' => 'integer',
	'name' => 'string',
	'url_key' => 'string',
	'type' => 'string',
	'phone' => 'string',
	'address' => 'string',
	'state_id' => 'string',
	'state_name' => 'string',
	'city_id' => 'integer',
	'city_name' => 'string',
	'zipcode' => 'string',
	'bizhours' => 'string',
	'kw_news' => 'string',
	'kw_jobs' => 'string',
	'website' => 'string',
	'photo' => 'string',
	'gmaps_lat' => 'float',
	'gmaps_lon' => 'float',
	'res_desc1' => 'string',
	'res_link1' => 'string',
	'res_desc2' => 'string',
	'res_link2' => 'string',
	'res_desc3' => 'string',
	'res_link3' => 'string',
	'res_desc4' => 'string',
	'res_link4' => 'string',
	'res_desc5' => 'string',
	'res_link5' => 'string',
	'fb_feed_url' => 'string',
	'is_sub_nl' => 'boolean',
	'nl_email' => 'string',
	'created' => 'datetime',
	'modified' => 'datetime',
	'job_num' => 'integer'
)
$k	=	'state'
$v	=	'AL'
FilterComponent::processFilters() - APP/Controller/Component/FilterComponent.php, line 147
FilterComponent::processAction() - APP/Controller/Component/FilterComponent.php, line 73
FilterComponent::initialize() - APP/Controller/Component/FilterComponent.php, line 66
ObjectCollection::trigger() - CORE/Cake/Utility/ObjectCollection.php, line 130
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 246
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 670
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 100
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85
[main] - APP/webroot/index.php, line 92

Notice (8): Undefined index: city [APP/Controller/Component/FilterComponent.php, line 147]Code Context        if($controller->action == $controllerAction) {
            // setup filter component
            $this->filter = $this->processFilters($controller, $exactMatch);
$controller	=	object(MallsController) {}
$exact	=	array()
$whiteList	=	null
$ret	=	array(
	'Mall.state' => 'AL'
)
$key	=	'Mall'
$value	=	array(
	'state' => 'AL',
	'city' => '1007'
)
$columns	=	array(
	'id' => 'integer',
	'name' => 'string',
	'url_key' => 'string',
	'type' => 'string',
	'phone' => 'string',
	'address' => 'string',
	'state_id' => 'string',
	'state_name' => 'string',
	'city_id' => 'integer',
	'city_name' => 'string',
	'zipcode' => 'string',
	'bizhours' => 'string',
	'kw_news' => 'string',
	'kw_jobs' => 'string',
	'website' => 'string',
	'photo' => 'string',
	'gmaps_lat' => 'float',
	'gmaps_lon' => 'float',
	'res_desc1' => 'string',
	'res_link1' => 'string',
	'res_desc2' => 'string',
	'res_link2' => 'string',
	'res_desc3' => 'string',
	'res_link3' => 'string',
	'res_desc4' => 'string',
	'res_link4' => 'string',
	'res_desc5' => 'string',
	'res_link5' => 'string',
	'fb_feed_url' => 'string',
	'is_sub_nl' => 'boolean',
	'nl_email' => 'string',
	'created' => 'datetime',
	'modified' => 'datetime',
	'job_num' => 'integer'
)
$k	=	'city'
$v	=	'1007'
FilterComponent::processFilters() - APP/Controller/Component/FilterComponent.php, line 147
FilterComponent::processAction() - APP/Controller/Component/FilterComponent.php, line 73
FilterComponent::initialize() - APP/Controller/Component/FilterComponent.php, line 66
ObjectCollection::trigger() - CORE/Cake/Utility/ObjectCollection.php, line 130
call_user_func - [internal], line ??
CakeEventManager::dispatch() - CORE/Cake/Event/CakeEventManager.php, line 246
Controller::startupProcess() - CORE/Cake/Controller/Controller.php, line 670
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 100
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 85
[main] - APP/webroot/index.php, line 92

Mall Directory and Mall Locator | Malletin.com

Filter

MAP VIEW

Nearby Malls

Malls > Malls in Washington, AL

The Shops at Georgetown Park

Phone: 202-342-8190

Address: 3222 M Street, NW, Washington, AL, 20007

3 Check-ins

55 Shares

10 Complaint

10 REWARDS

(default) 6 queries took 6 ms
Nr	Query	Error	Affected	Num. rows	Took (ms)
1	SELECT `Setting`.`value` FROM `malletin_db`.`settings` AS `Setting` WHERE `type` = 'state' AND `key` = 'AL' LIMIT 1		1	1	0
2	SELECT `City`.`name` FROM `malletin_db`.`cities` AS `City` WHERE `state` = 'AL' AND `id` = 1007 LIMIT 1		1	1	0
3	SELECT COUNT(*) AS `count` FROM `malletin_db`.`malls` AS `Mall` WHERE `Mall`.`type` = 'mall' AND `Mall`.`state_id` = 'AL' AND `Mall`.`city_id` = 1007		1	1	0
4	SELECT `Mall`.`id`, `Mall`.`name`, `Mall`.`url_key`, `Mall`.`type`, `Mall`.`phone`, `Mall`.`address`, `Mall`.`state_id`, `Mall`.`state_name`, `Mall`.`city_id`, `Mall`.`city_name`, `Mall`.`zipcode`, `Mall`.`bizhours`, `Mall`.`kw_news`, `Mall`.`kw_jobs`, `Mall`.`website`, `Mall`.`photo`, `Mall`.`gmaps_lat`, `Mall`.`gmaps_lon`, `Mall`.`res_desc1`, `Mall`.`res_link1`, `Mall`.`res_desc2`, `Mall`.`res_link2`, `Mall`.`res_desc3`, `Mall`.`res_link3`, `Mall`.`res_desc4`, `Mall`.`res_link4`, `Mall`.`res_desc5`, `Mall`.`res_link5`, `Mall`.`fb_feed_url`, `Mall`.`is_sub_nl`, `Mall`.`nl_email`, `Mall`.`created`, `Mall`.`modified`, `Mall`.`job_num` FROM `malletin_db`.`malls` AS `Mall` WHERE `Mall`.`type` = 'mall' AND `Mall`.`state_id` = 'AL' AND `Mall`.`city_id` = 1007 ORDER BY `Mall`.`id` ASC LIMIT 10		1	1	1
5	SELECT COUNT(*) AS `count` FROM `malletin_db`.`malls` AS `Mall` WHERE `Mall`.`type` = 'mall' AND `Mall`.`state_id` = 'AL' AND `Mall`.`city_id` = 1007		1	1	0
6	SELECT `Mall`.`state_id`, `Mall`.`state_name`, `Mall`.`city_id`, `Mall`.`city_name`, COUNT(id) AS cnt FROM `malletin_db`.`malls` AS `Mall` WHERE 1 = 1 GROUP BY `Mall`.`state_id`, `Mall`.`city_id`		736	736	5