Error: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'email_address' in field list is ambiguous

SQL Query: SELECT `BasicModuleBranchInfo`.`org_id`, `BasicModuleBranchInfo`.`office_type_id`, `BasicModuleBranchInfo`.`branch_name`, `BasicModuleBranchInfo`.`branch_code`, `BasicModuleBranchInfo`.`district_id`, `BasicModuleBranchInfo`.`upazila_id`, `BasicModuleBranchInfo`.`road_name_or_village`, `BasicModuleBranchInfo`.`mohalla_or_post_office`, `BasicModuleBranchInfo`.`mailing_address`, `BasicModuleBranchInfo`.`lat`, `BasicModuleBranchInfo`.`long`, `BasicModuleBranchInfo`.`image_name`, (CONCAT_WS(', ', CASE WHEN email_address IS NOT NULL AND REPLACE(email_address, ' ','') != '' THEN email_address ELSE NULL END, REPLACE(phone_no, ' ',''), CASE WHEN fax IS NOT NULL AND REPLACE(fax, ' ','') != '' THEN CONCAT(' fax: ', fax) ELSE NULL END)) AS `BasicModuleBranchInfo__contact_info`, (CONCAT_WS('', full_name_of_org, CASE WHEN full_name_of_org != '' AND short_name_of_org != '' THEN CONCAT_WS('', ' (<strong>', short_name_of_org, '</strong>)') ELSE short_name_of_org END)) AS `BasicModuleBranchInfo__org_name` FROM `dbnational`.`basic_module_branch_infos` AS `BasicModuleBranchInfo` LEFT JOIN `dbnational`.`basic_module_basic_informations` AS `BasicModuleBasicInformation` ON (`BasicModuleBranchInfo`.`org_id` = `BasicModuleBasicInformation`.`id`) WHERE `BasicModuleBranchInfo`.`office_type_id` = 1

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

CORE/Cake/Model/Datasource/DboSource.php line 461 → PDOStatement->execute(array)

        try {
            $query = $this->_connection->prepare($sql, $prepareOptions);
            $query->setFetchMode(PDO::FETCH_LAZY);
            if (!$query->execute($params)) {
                $this->_results = $query;

array()

CORE/Cake/Model/Datasource/DboSource.php line 427 → DboSource->_execute(string, array)

        $options += array('log' => $this->fullDebug);

        $t = microtime(true);
        $this->_result = $this->_execute($sql, $params);

'SELECT `BasicModuleBranchInfo`.`org_id`, `BasicModuleBranchInfo`.`office_type_id`, `BasicModuleBranchInfo`.`branch_name`, `BasicModuleBranchInfo`.`branch_code`, `BasicModuleBranchInfo`.`district_id`, `BasicModuleBranchInfo`.`upazila_id`, `BasicModuleBranchInfo`.`road_name_or_village`, `BasicModuleBranchInfo`.`mohalla_or_post_office`, `BasicModuleBranchInfo`.`mailing_address`, `BasicModuleBranchInfo`.`lat`, `BasicModuleBranchInfo`.`long`, `BasicModuleBranchInfo`.`image_name`, (CONCAT_WS(', ', CASE WHEN email_address IS NOT NULL AND REPLACE(email_address, ' ','') != '' THEN email_address ELSE NULL END, REPLACE(phone_no, ' ',''), CASE WHEN fax IS NOT NULL AND REPLACE(fax, ' ','') != '' THEN CONCAT(' fax: ', fax) ELSE NULL END)) AS  `BasicModuleBranchInfo__contact_info`, (CONCAT_WS('', full_name_of_org, CASE WHEN full_name_of_org != '' AND short_name_of_org != '' THEN CONCAT_WS('', ' (<strong>', short_name_of_org, '</strong>)') ELSE short_name_of_org END)) AS  `BasicModuleBranchInfo__org_name` FROM `dbnational`.`basic_module_branch_infos` AS `BasicModuleBranchInfo` LEFT JOIN `dbnational`.`basic_module_basic_informations` AS `BasicModuleBasicInformation` ON (`BasicModuleBranchInfo`.`org_id` = `BasicModuleBasicInformation`.`id`)  WHERE `BasicModuleBranchInfo`.`office_type_id` = 1'
array()

CORE/Cake/Model/Datasource/DboSource.php line 669 → DboSource->execute(string, array, array)

        if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
            return $cached;
        }
        $result = $this->execute($sql, array(), $params);
        if ($result) {

'SELECT `BasicModuleBranchInfo`.`org_id`, `BasicModuleBranchInfo`.`office_type_id`, `BasicModuleBranchInfo`.`branch_name`, `BasicModuleBranchInfo`.`branch_code`, `BasicModuleBranchInfo`.`district_id`, `BasicModuleBranchInfo`.`upazila_id`, `BasicModuleBranchInfo`.`road_name_or_village`, `BasicModuleBranchInfo`.`mohalla_or_post_office`, `BasicModuleBranchInfo`.`mailing_address`, `BasicModuleBranchInfo`.`lat`, `BasicModuleBranchInfo`.`long`, `BasicModuleBranchInfo`.`image_name`, (CONCAT_WS(', ', CASE WHEN email_address IS NOT NULL AND REPLACE(email_address, ' ','') != '' THEN email_address ELSE NULL END, REPLACE(phone_no, ' ',''), CASE WHEN fax IS NOT NULL AND REPLACE(fax, ' ','') != '' THEN CONCAT(' fax: ', fax) ELSE NULL END)) AS  `BasicModuleBranchInfo__contact_info`, (CONCAT_WS('', full_name_of_org, CASE WHEN full_name_of_org != '' AND short_name_of_org != '' THEN CONCAT_WS('', ' (<strong>', short_name_of_org, '</strong>)') ELSE short_name_of_org END)) AS  `BasicModuleBranchInfo__org_name` FROM `dbnational`.`basic_module_branch_infos` AS `BasicModuleBranchInfo` LEFT JOIN `dbnational`.`basic_module_basic_informations` AS `BasicModuleBasicInformation` ON (`BasicModuleBranchInfo`.`org_id` = `BasicModuleBasicInformation`.`id`)  WHERE `BasicModuleBranchInfo`.`office_type_id` = 1'
array()
array()

CORE/Cake/Model/Datasource/DboSource.php line 1118 → DboSource->fetchAll(string, boolean)

        // Build SQL statement with the primary model, plus hasOne and belongsTo associations
        $query = $this->buildAssociationQuery($Model, $queryData);

        $resultSet = $this->fetchAll($query, $Model->cacheQueries);
        unset($query);

'SELECT `BasicModuleBranchInfo`.`org_id`, `BasicModuleBranchInfo`.`office_type_id`, `BasicModuleBranchInfo`.`branch_name`, `BasicModuleBranchInfo`.`branch_code`, `BasicModuleBranchInfo`.`district_id`, `BasicModuleBranchInfo`.`upazila_id`, `BasicModuleBranchInfo`.`road_name_or_village`, `BasicModuleBranchInfo`.`mohalla_or_post_office`, `BasicModuleBranchInfo`.`mailing_address`, `BasicModuleBranchInfo`.`lat`, `BasicModuleBranchInfo`.`long`, `BasicModuleBranchInfo`.`image_name`, (CONCAT_WS(', ', CASE WHEN email_address IS NOT NULL AND REPLACE(email_address, ' ','') != '' THEN email_address ELSE NULL END, REPLACE(phone_no, ' ',''), CASE WHEN fax IS NOT NULL AND REPLACE(fax, ' ','') != '' THEN CONCAT(' fax: ', fax) ELSE NULL END)) AS  `BasicModuleBranchInfo__contact_info`, (CONCAT_WS('', full_name_of_org, CASE WHEN full_name_of_org != '' AND short_name_of_org != '' THEN CONCAT_WS('', ' (<strong>', short_name_of_org, '</strong>)') ELSE short_name_of_org END)) AS  `BasicModuleBranchInfo__org_name` FROM `dbnational`.`basic_module_branch_infos` AS `BasicModuleBranchInfo` LEFT JOIN `dbnational`.`basic_module_basic_informations` AS `BasicModuleBasicInformation` ON (`BasicModuleBranchInfo`.`org_id` = `BasicModuleBasicInformation`.`id`)  WHERE `BasicModuleBranchInfo`.`office_type_id` = 1'
false

CORE/Cake/Model/Model.php line 3031 → DboSource->read(BasicModuleBranchInfo, array)

 * @return array
 */
    protected function _readDataSource($type, $query) {
        $results = $this->getDataSource()->read($this, $query);
        $this->resetAssociations();

object(BasicModuleBranchInfo) {
	actsAs => array(
		(int) 0 => 'Containable'
	)
	belongsTo => array(
		'BasicModuleBasicInformation' => array(
			'className' => 'BasicModuleBasicInformation',
			'fields' => 'id, license_no, full_name_of_org, short_name_of_org, name_of_org, name_of_org_with_license',
			'foreignKey' => 'org_id',
			'conditions' => '',
			'order' => '',
			'counterCache' => ''
		)
	)
	virtualFields => array(
		'branch_with_address' => 'CONCAT_WS(', ', CONCAT_WS('', branch_name, CASE WHEN branch_name != '' AND branch_code != '' THEN CONCAT_WS('', ' (', branch_code, ')') ELSE branch_code END), mailing_address)',
		'branch_with_code' => 'CONCAT_WS('', branch_name, CASE WHEN branch_name != '' AND branch_code != '' THEN CONCAT_WS('', ' (', branch_code, ')') ELSE branch_code END)',
		'contact_info' => 'CONCAT_WS(', ', CASE WHEN email_address IS NOT NULL AND REPLACE(email_address, ' ','') != '' THEN email_address ELSE NULL END, REPLACE(phone_no, ' ',''), CASE WHEN fax IS NOT NULL AND REPLACE(fax, ' ','') != '' THEN CONCAT(' fax: ', fax) ELSE NULL END)',
		'org_name' => 'CONCAT_WS('', full_name_of_org, CASE WHEN full_name_of_org != '' AND short_name_of_org != '' THEN CONCAT_WS('', ' (<strong>', short_name_of_org, '</strong>)') ELSE short_name_of_org END)'
	)
	validate => array(
		'office_type_id' => array(
			'required' => true,
			'allowEmpty' => false,
			'rule' => array(
				[maximum depth reached]
			),
			'on' => 'null',
			'message' => 'An office type is required'
		),
		'branch_name' => array(
			'required' => true,
			'allowEmpty' => false,
			'rule' => array(
				[maximum depth reached]
			),
			'on' => 'null',
			'message' => 'Office name is required'
		),
		'mailing_address' => array(
			'required' => true,
			'allowEmpty' => false,
			'rule' => array(
				[maximum depth reached]
			),
			'on' => 'null',
			'message' => 'Mailing address is required'
		),
		'district_id' => array(
			'required' => true,
			'allowEmpty' => false,
			'rule' => array(
				[maximum depth reached]
			),
			'on' => 'null',
			'message' => 'A district name is required'
		),
		'upazila_id' => array(
			'required' => true,
			'allowEmpty' => false,
			'rule' => array(
				[maximum depth reached]
			),
			'on' => 'null',
			'message' => 'A upazila name is required'
		),
		'mohalla_or_post_office' => array(
			'required' => true,
			'allowEmpty' => false,
			'rule' => array(
				[maximum depth reached]
			),
			'on' => 'null',
			'message' => 'A mahalla/post office name is required'
		),
		'road_name_or_village' => array(
			'required' => true,
			'allowEmpty' => false,
			'rule' => array(
				[maximum depth reached]
			),
			'on' => 'null',
			'message' => 'A road name/village name is required'
		),
		'mobile_no' => array(
			'required' => true,
			'allowEmpty' => false,
			'rule' => array(
				[maximum depth reached]
			),
			'on' => 'null',
			'message' => 'A mobile no. is required'
		),
		'lat' => array(
			'required' => true,
			'allowEmpty' => false,
			'rule' => array(
				[maximum depth reached]
			),
			'on' => 'null',
			'message' => 'A Latitude value is required'
		),
		'long' => array(
			'required' => true,
			'allowEmpty' => false,
			'rule' => array(
				[maximum depth reached]
			),
			'on' => 'null',
			'message' => 'A Longitude value is required'
		)
	)
	useDbConfig => 'default'
	useTable => 'basic_module_branch_infos'
	id => false
	data => array()
	schemaName => 'dbnational'
	table => 'basic_module_branch_infos'
	primaryKey => 'id'
	validationErrors => array()
	validationDomain => null
	plugin => null
	name => 'BasicModuleBranchInfo'
	alias => 'BasicModuleBranchInfo'
	tableToModel => array(
		'basic_module_branch_infos' => 'BasicModuleBranchInfo',
		'lookup_basic_office_types' => 'LookupBasicOfficeType',
		'basic_module_basic_informations' => 'BasicModuleBasicInformation'
	)
	cacheQueries => false
	hasOne => array()
	hasMany => array()
	hasAndBelongsToMany => array()
	Behaviors => object(BehaviorCollection) {
		modelName => 'BasicModuleBranchInfo'
		defaultPriority => (int) 10
		[protected] _methods => array(
			[maximum depth reached]
		)
		[protected] _mappedMethods => array([maximum depth reached])
		[protected] _enabled => array(
			[maximum depth reached]
		)
		[protected] _loaded => array(
			[maximum depth reached]
		)
	}
	whitelist => array()
	cacheSources => true
	findQueryType => 'all'
	recursive => (int) 0
	order => null
	__backAssociation => array(
		'belongsTo' => array(
			'BasicModuleBasicInformation' => array(
				[maximum depth reached]
			),
			'LookupBasicOfficeType' => array(
				[maximum depth reached]
			),
			'LookupAdminBoundaryDistrict' => array(
				[maximum depth reached]
			),
			'LookupAdminBoundaryUpazila' => array(
				[maximum depth reached]
			),
			'LookupAdminBoundaryUnion' => array(
				[maximum depth reached]
			),
			'LookupAdminBoundaryMauza' => array(
				[maximum depth reached]
			)
		)
	)
	__backInnerAssociation => array()
	__backOriginalAssociation => array()
	__backContainableAssociation => array()
	__safeUpdateMode => false
	useConsistentAfterFind => true
	findMethods => array(
		'all' => true,
		'first' => true,
		'count' => true,
		'neighbors' => true,
		'list' => true,
		'threaded' => true
	)
	LookupBasicOfficeType => object(LookupBasicOfficeType) {
		useDbConfig => 'default'
		useTable => 'lookup_basic_office_types'
		id => false
		data => array([maximum depth reached])
		schemaName => 'dbnational'
		table => 'lookup_basic_office_types'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		name => 'LookupBasicOfficeType'
		alias => 'LookupBasicOfficeType'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		belongsTo => array([maximum depth reached])
		hasOne => array([maximum depth reached])
		hasMany => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		virtualFields => array([maximum depth reached])
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => null
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	BasicModuleBasicInformation => object(BasicModuleBasicInformation) {
		belongsTo => array(
			[maximum depth reached]
		)
		virtualFields => array(
			[maximum depth reached]
		)
		hasOne => array(
			[maximum depth reached]
		)
		hasMany => array(
			[maximum depth reached]
		)
		useDbConfig => 'default'
		useTable => 'basic_module_basic_informations'
		id => false
		data => array([maximum depth reached])
		schemaName => 'dbnational'
		table => 'basic_module_basic_informations'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		name => 'BasicModuleBasicInformation'
		alias => 'BasicModuleBasicInformation'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	tablePrefix => ''
	[protected] _schema => array(
		'id' => array(
			'type' => 'string',
			'null' => false,
			'default' => null,
			'length' => (int) 8,
			'key' => 'primary',
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'org_id' => array(
			'type' => 'integer',
			'null' => false,
			'default' => null,
			'length' => (int) 11,
			'unsigned' => false
		),
		'branch_serial' => array(
			'type' => 'integer',
			'null' => false,
			'default' => '0',
			'length' => (int) 11,
			'unsigned' => false
		),
		'office_type_id' => array(
			'type' => 'integer',
			'null' => true,
			'default' => null,
			'length' => (int) 11,
			'unsigned' => false
		),
		'branch_name' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 800,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'branch_code' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 50,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'mailing_address' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 1000,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'district_id' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 4,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'upazila_id' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 6,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'union_id' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 8,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'mauza_id' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 12,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'mohalla_or_post_office' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 800,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'road_name_or_village' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 800,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'email_address' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 200,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'phone_no' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 200,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'mobile_no' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 200,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'fax' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 200,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'image_name' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 200,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'lat' => array(
			'type' => 'float',
			'null' => true,
			'default' => null,
			'length' => null,
			'unsigned' => false
		),
		'long' => array(
			'type' => 'float',
			'null' => true,
			'default' => null,
			'length' => null,
			'unsigned' => false
		),
		'deactivation_request_date' => array(
			'type' => 'date',
			'null' => true,
			'default' => null,
			'length' => null
		),
		'deactivation_reasons' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 1500,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'activation_request_date' => array(
			'type' => 'date',
			'null' => true,
			'default' => null,
			'length' => null
		),
		'activation_reasons' => array(
			'type' => 'string',
			'null' => true,
			'default' => null,
			'length' => (int) 1500,
			'collate' => 'utf8_general_ci',
			'charset' => 'utf8'
		),
		'is_approved' => array(
			'type' => 'integer',
			'null' => true,
			'default' => null,
			'length' => (int) 11,
			'unsigned' => false
		),
		'approval_date' => array(
			'type' => 'date',
			'null' => true,
			'default' => null,
			'length' => null
		),
		'is_active' => array(
			'type' => 'integer',
			'null' => true,
			'default' => null,
			'length' => (int) 11,
			'unsigned' => false
		),
		'auto_number' => array(
			'type' => 'integer',
			'null' => false,
			'default' => null,
			'length' => (int) 11,
			'unsigned' => false,
			'key' => 'index'
		)
	)
	[protected] _associationKeys => array(
		'belongsTo' => array(
			(int) 0 => 'className',
			(int) 1 => 'foreignKey',
			(int) 2 => 'conditions',
			(int) 3 => 'fields',
			(int) 4 => 'order',
			(int) 5 => 'counterCache'
		),
		'hasOne' => array(
			(int) 0 => 'className',
			(int) 1 => 'foreignKey',
			(int) 2 => 'conditions',
			(int) 3 => 'fields',
			(int) 4 => 'order',
			(int) 5 => 'dependent'
		),
		'hasMany' => array(
			(int) 0 => 'className',
			(int) 1 => 'foreignKey',
			(int) 2 => 'conditions',
			(int) 3 => 'fields',
			(int) 4 => 'order',
			(int) 5 => 'limit',
			(int) 6 => 'offset',
			(int) 7 => 'dependent',
			(int) 8 => 'exclusive',
			(int) 9 => 'finderQuery',
			(int) 10 => 'counterQuery'
		),
		'hasAndBelongsToMany' => array(
			(int) 0 => 'className',
			(int) 1 => 'joinTable',
			(int) 2 => 'with',
			(int) 3 => 'foreignKey',
			(int) 4 => 'associationForeignKey',
			(int) 5 => 'conditions',
			(int) 6 => 'fields',
			(int) 7 => 'order',
			(int) 8 => 'limit',
			(int) 9 => 'offset',
			(int) 10 => 'unique',
			(int) 11 => 'finderQuery'
		)
	)
	[protected] _associations => array(
		(int) 0 => 'belongsTo',
		(int) 1 => 'hasOne',
		(int) 2 => 'hasMany',
		(int) 3 => 'hasAndBelongsToMany'
	)
	[protected] _insertID => null
	[protected] _sourceConfigured => true
	[protected] _eventManager => object(CakeEventManager) {
		[protected] _generalManager => object(CakeEventManager) {}
		[protected] _listeners => array(
			[maximum depth reached]
		)
		[protected] _isGlobal => false
	}
	[protected] _validator => null
}
array(
	'conditions' => array(
		'BasicModuleBranchInfo.office_type_id' => (int) 1
	),
	'fields' => array(
		(int) 0 => 'org_id',
		(int) 1 => 'org_name',
		(int) 2 => 'office_type_id',
		(int) 3 => 'branch_name',
		(int) 4 => 'branch_code',
		(int) 5 => 'district_id',
		(int) 6 => 'upazila_id',
		(int) 7 => 'road_name_or_village',
		(int) 8 => 'mohalla_or_post_office',
		(int) 9 => 'mailing_address',
		(int) 10 => 'lat',
		(int) 11 => 'long',
		(int) 12 => 'contact_info',
		(int) 13 => 'image_name'
	),
	'joins' => array(),
	'limit' => null,
	'offset' => null,
	'order' => array(
		(int) 0 => null
	),
	'page' => (int) 1,
	'group' => null,
	'callbacks' => true,
	'recursive' => (int) 0
)

CORE/Cake/Model/Model.php line 3003 → Model->_readDataSource(string, array)

            return null;
        }

        return $this->_readDataSource($type, $query);
    }

'all'
array(
	'conditions' => array(
		'BasicModuleBranchInfo.office_type_id' => (int) 1
	),
	'fields' => array(
		(int) 0 => 'org_id',
		(int) 1 => 'org_name',
		(int) 2 => 'office_type_id',
		(int) 3 => 'branch_name',
		(int) 4 => 'branch_code',
		(int) 5 => 'district_id',
		(int) 6 => 'upazila_id',
		(int) 7 => 'road_name_or_village',
		(int) 8 => 'mohalla_or_post_office',
		(int) 9 => 'mailing_address',
		(int) 10 => 'lat',
		(int) 11 => 'long',
		(int) 12 => 'contact_info',
		(int) 13 => 'image_name'
	),
	'joins' => array(),
	'limit' => null,
	'offset' => null,
	'order' => array(
		(int) 0 => null
	),
	'page' => (int) 1,
	'group' => null,
	'callbacks' => true,
	'recursive' => (int) 0
)

APP/Controller/ReportModuleReportViewersController.php line 355 → Model->find(string, array)

        $fields = array('org_id', 'org_name', 'office_type_id', 'branch_name', 'branch_code', 'district_id', 'upazila_id', 'road_name_or_village',
            'mohalla_or_post_office', 'mailing_address', 'lat', 'long', 'contact_info', 'image_name');

        $branchInfos = $this->BasicModuleBranchInfo->find("all", array('fields' => $fields, 'conditions' => $conditions, 'recursive' => 0)); //, 'limit'=>100
//        debug(count($branchInfos));

'all'
array(
	'fields' => array(
		(int) 0 => 'org_id',
		(int) 1 => 'org_name',
		(int) 2 => 'office_type_id',
		(int) 3 => 'branch_name',
		(int) 4 => 'branch_code',
		(int) 5 => 'district_id',
		(int) 6 => 'upazila_id',
		(int) 7 => 'road_name_or_village',
		(int) 8 => 'mohalla_or_post_office',
		(int) 9 => 'mailing_address',
		(int) 10 => 'lat',
		(int) 11 => 'long',
		(int) 12 => 'contact_info',
		(int) 13 => 'image_name'
	),
	'conditions' => array(
		'BasicModuleBranchInfo.office_type_id' => (int) 1
	),
	'recursive' => (int) 0
)

[internal function] → ReportModuleReportViewersController->branches_location_map()

CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(ReportModuleReportViewersController, array)

                    'action' => $request->params['action']
                ));
            }
            return $method->invokeArgs($this, $request->params['pass']);

object(ReportModuleReportViewersController) {
	helpers => array(
		'Form' => null,
		'Html' => null,
		'Js' => null,
		'Paginator' => null,
		'Time' => null,
		'Session' => null
	)
	paginate => array()
	components => array(
		'Session' => array(
			'timeout' => (int) 5
		),
		'Auth' => array(
			'loginAction' => array(
				[maximum depth reached]
			),
			'loginRedirect' => array(
				[maximum depth reached]
			),
			'logoutRedirect' => array(
				[maximum depth reached]
			),
			'authenticate' => array(
				[maximum depth reached]
			)
		)
	)
	name => 'ReportModuleReportViewers'
	uses => array(
		(int) 0 => 'ReportModuleReportViewer',
		(int) 1 => 'BasicModuleBasicInformation',
		(int) 2 => 'BasicModuleBranchInfo'
	)
	request => object(CakeRequest) {
		params => array(
			[maximum depth reached]
		)
		data => array([maximum depth reached])
		query => array([maximum depth reached])
		url => 'ReportModuleReportViewers/branches_location_map'
		base => '/mfi-dbms-live-map'
		webroot => '/mfi-dbms-live-map/'
		here => '/mfi-dbms-live-map/ReportModuleReportViewers/branches_location_map'
		[protected] _detectors => array(
			[maximum depth reached]
		)
		[protected] _input => ''
	}
	response => object(CakeResponse) {
		[protected] _statusCodes => array(
			[maximum depth reached]
		)
		[protected] _mimeTypes => array(
			[maximum depth reached]
		)
		[protected] _protocol => 'HTTP/1.1'
		[protected] _status => (int) 200
		[protected] _contentType => 'text/html'
		[protected] _headers => array([maximum depth reached])
		[protected] _body => null
		[protected] _file => null
		[protected] _fileRange => null
		[protected] _charset => 'UTF-8'
		[protected] _cacheDirectives => array([maximum depth reached])
		[protected] _cookies => array([maximum depth reached])
	}
	viewPath => 'ReportModuleReportViewers'
	layoutPath => null
	viewVars => array()
	view => 'branches_location_map'
	layout => 'ajax'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {
		defaultPriority => (int) 10
		[protected] _Controller => object(ReportModuleReportViewersController) {}
		[protected] _enabled => array(
			[maximum depth reached]
		)
		[protected] _loaded => array(
			[maximum depth reached]
		)
	}
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array()
	scaffold => false
	methods => array(
		(int) 0 => 'report_map_viewer',
		(int) 1 => 'map_data',
		(int) 2 => 'get_loan_info',
		(int) 3 => 'branch_info',
		(int) 4 => 'map_location',
		(int) 5 => 'branches_location_map',
		(int) 6 => 'get_branches_location',
		(int) 7 => 'get_branche_count_info',
		(int) 8 => 'get_all_info',
		(int) 10 => 'executeQuery',
		(int) 11 => 'dtSource',
		(int) 12 => 'getUserHitCount',
		(int) 13 => 'updateUserHitCount'
	)
	modelClass => 'ReportModuleReportViewer'
	modelKey => 'report_module_report_viewer'
	validationErrors => null
	Session => object(SessionComponent) {
		settings => array(
			[maximum depth reached]
		)
		components => array([maximum depth reached])
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	Auth => object(AuthComponent) {
		components => array(
			[maximum depth reached]
		)
		authenticate => array(
			[maximum depth reached]
		)
		authorize => false
		ajaxLogin => null
		flash => array(
			[maximum depth reached]
		)
		loginAction => array(
			[maximum depth reached]
		)
		loginRedirect => array(
			[maximum depth reached]
		)
		logoutRedirect => array(
			[maximum depth reached]
		)
		authError => false
		unauthorizedRedirect => true
		allowedActions => array(
			[maximum depth reached]
		)
		request => object(CakeRequest) {}
		response => object(CakeResponse) {}
		settings => array(
			[maximum depth reached]
		)
		[protected] _authenticateObjects => array([maximum depth reached])
		[protected] _authorizeObjects => array([maximum depth reached])
		[protected] _user => array([maximum depth reached])
		[protected] _methods => array(
			[maximum depth reached]
		)
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	BasicModuleBasicInformation => object(BasicModuleBasicInformation) {
		belongsTo => array(
			[maximum depth reached]
		)
		virtualFields => array(
			[maximum depth reached]
		)
		hasOne => array(
			[maximum depth reached]
		)
		hasMany => array(
			[maximum depth reached]
		)
		useDbConfig => 'default'
		useTable => 'basic_module_basic_informations'
		id => false
		data => array([maximum depth reached])
		schemaName => 'dbnational'
		table => 'basic_module_basic_informations'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		name => 'BasicModuleBasicInformation'
		alias => 'BasicModuleBasicInformation'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	BasicModuleBranchInfo => object(BasicModuleBranchInfo) {
		actsAs => array(
			[maximum depth reached]
		)
		belongsTo => array(
			[maximum depth reached]
		)
		virtualFields => array(
			[maximum depth reached]
		)
		validate => array(
			[maximum depth reached]
		)
		useDbConfig => 'default'
		useTable => 'basic_module_branch_infos'
		id => false
		data => array([maximum depth reached])
		schemaName => 'dbnational'
		table => 'basic_module_branch_infos'
		primaryKey => 'id'
		validationErrors => array([maximum depth reached])
		validationDomain => null
		plugin => null
		name => 'BasicModuleBranchInfo'
		alias => 'BasicModuleBranchInfo'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		hasOne => array([maximum depth reached])
		hasMany => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => 'all'
		recursive => (int) 0
		order => null
		__backAssociation => array(
			[maximum depth reached]
		)
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		LookupBasicOfficeType => object(LookupBasicOfficeType) {}
		BasicModuleBasicInformation => object(BasicModuleBasicInformation) {}
		tablePrefix => ''
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {
		[protected] _generalManager => object(CakeEventManager) {}
		[protected] _listeners => array(
			[maximum depth reached]
		)
		[protected] _isGlobal => false
	}
}
array()

CORE/Cake/Routing/Dispatcher.php line 193 → Controller->invokeAction(CakeRequest)


        $response = $controller->response;
        $render = true;
        $result = $controller->invokeAction($request);
        if ($result instanceof CakeResponse) {

object(CakeRequest) {
	params => array(
		'plugin' => null,
		'controller' => 'ReportModuleReportViewers',
		'action' => 'branches_location_map',
		'named' => array(),
		'pass' => array(),
		'models' => array(
			'Session' => array(
				[maximum depth reached]
			),
			'BasicModuleBasicInformation' => array(
				[maximum depth reached]
			),
			'BasicModuleBranchInfo' => array(
				[maximum depth reached]
			),
			'LookupBasicOfficeType' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'ReportModuleReportViewers/branches_location_map'
	base => '/mfi-dbms-live-map'
	webroot => '/mfi-dbms-live-map/'
	here => '/mfi-dbms-live-map/ReportModuleReportViewers/branches_location_map'
	[protected] _detectors => array(
		'get' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'GET'
		),
		'post' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'POST'
		),
		'put' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PUT'
		),
		'delete' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'DELETE'
		),
		'head' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'HEAD'
		),
		'options' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'OPTIONS'
		),
		'ssl' => array(
			'env' => 'HTTPS',
			'value' => (int) 1
		),
		'ajax' => array(
			'env' => 'HTTP_X_REQUESTED_WITH',
			'value' => 'XMLHttpRequest'
		),
		'flash' => array(
			'env' => 'HTTP_USER_AGENT',
			'pattern' => '/^(Shockwave|Adobe) Flash/'
		),
		'mobile' => array(
			'env' => 'HTTP_USER_AGENT',
			'options' => array(
				[maximum depth reached]
			)
		),
		'requested' => array(
			'param' => 'requested',
			'value' => (int) 1
		),
		'json' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'json'
		),
		'xml' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'xml'
		)
	)
	[protected] _input => ''
}

CORE/Cake/Routing/Dispatcher.php line 167 → Dispatcher->_invoke(ReportModuleReportViewersController, CakeRequest)

            ));
        }

        $response = $this->_invoke($controller, $request);
        if (isset($request->params['return'])) {

object(ReportModuleReportViewersController) {
	helpers => array(
		'Form' => null,
		'Html' => null,
		'Js' => null,
		'Paginator' => null,
		'Time' => null,
		'Session' => null
	)
	paginate => array()
	components => array(
		'Session' => array(
			'timeout' => (int) 5
		),
		'Auth' => array(
			'loginAction' => array(
				[maximum depth reached]
			),
			'loginRedirect' => array(
				[maximum depth reached]
			),
			'logoutRedirect' => array(
				[maximum depth reached]
			),
			'authenticate' => array(
				[maximum depth reached]
			)
		)
	)
	name => 'ReportModuleReportViewers'
	uses => array(
		(int) 0 => 'ReportModuleReportViewer',
		(int) 1 => 'BasicModuleBasicInformation',
		(int) 2 => 'BasicModuleBranchInfo'
	)
	request => object(CakeRequest) {
		params => array(
			[maximum depth reached]
		)
		data => array([maximum depth reached])
		query => array([maximum depth reached])
		url => 'ReportModuleReportViewers/branches_location_map'
		base => '/mfi-dbms-live-map'
		webroot => '/mfi-dbms-live-map/'
		here => '/mfi-dbms-live-map/ReportModuleReportViewers/branches_location_map'
		[protected] _detectors => array(
			[maximum depth reached]
		)
		[protected] _input => ''
	}
	response => object(CakeResponse) {
		[protected] _statusCodes => array(
			[maximum depth reached]
		)
		[protected] _mimeTypes => array(
			[maximum depth reached]
		)
		[protected] _protocol => 'HTTP/1.1'
		[protected] _status => (int) 200
		[protected] _contentType => 'text/html'
		[protected] _headers => array([maximum depth reached])
		[protected] _body => null
		[protected] _file => null
		[protected] _fileRange => null
		[protected] _charset => 'UTF-8'
		[protected] _cacheDirectives => array([maximum depth reached])
		[protected] _cookies => array([maximum depth reached])
	}
	viewPath => 'ReportModuleReportViewers'
	layoutPath => null
	viewVars => array()
	view => 'branches_location_map'
	layout => 'ajax'
	autoRender => true
	autoLayout => true
	Components => object(ComponentCollection) {
		defaultPriority => (int) 10
		[protected] _Controller => object(ReportModuleReportViewersController) {}
		[protected] _enabled => array(
			[maximum depth reached]
		)
		[protected] _loaded => array(
			[maximum depth reached]
		)
	}
	viewClass => 'View'
	View => null
	ext => '.ctp'
	plugin => null
	cacheAction => false
	passedArgs => array()
	scaffold => false
	methods => array(
		(int) 0 => 'report_map_viewer',
		(int) 1 => 'map_data',
		(int) 2 => 'get_loan_info',
		(int) 3 => 'branch_info',
		(int) 4 => 'map_location',
		(int) 5 => 'branches_location_map',
		(int) 6 => 'get_branches_location',
		(int) 7 => 'get_branche_count_info',
		(int) 8 => 'get_all_info',
		(int) 10 => 'executeQuery',
		(int) 11 => 'dtSource',
		(int) 12 => 'getUserHitCount',
		(int) 13 => 'updateUserHitCount'
	)
	modelClass => 'ReportModuleReportViewer'
	modelKey => 'report_module_report_viewer'
	validationErrors => null
	Session => object(SessionComponent) {
		settings => array(
			[maximum depth reached]
		)
		components => array([maximum depth reached])
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array([maximum depth reached])
	}
	Auth => object(AuthComponent) {
		components => array(
			[maximum depth reached]
		)
		authenticate => array(
			[maximum depth reached]
		)
		authorize => false
		ajaxLogin => null
		flash => array(
			[maximum depth reached]
		)
		loginAction => array(
			[maximum depth reached]
		)
		loginRedirect => array(
			[maximum depth reached]
		)
		logoutRedirect => array(
			[maximum depth reached]
		)
		authError => false
		unauthorizedRedirect => true
		allowedActions => array(
			[maximum depth reached]
		)
		request => object(CakeRequest) {}
		response => object(CakeResponse) {}
		settings => array(
			[maximum depth reached]
		)
		[protected] _authenticateObjects => array([maximum depth reached])
		[protected] _authorizeObjects => array([maximum depth reached])
		[protected] _user => array([maximum depth reached])
		[protected] _methods => array(
			[maximum depth reached]
		)
		[protected] _Collection => object(ComponentCollection) {}
		[protected] _componentMap => array(
			[maximum depth reached]
		)
	}
	BasicModuleBasicInformation => object(BasicModuleBasicInformation) {
		belongsTo => array(
			[maximum depth reached]
		)
		virtualFields => array(
			[maximum depth reached]
		)
		hasOne => array(
			[maximum depth reached]
		)
		hasMany => array(
			[maximum depth reached]
		)
		useDbConfig => 'default'
		useTable => 'basic_module_basic_informations'
		id => false
		data => array([maximum depth reached])
		schemaName => 'dbnational'
		table => 'basic_module_basic_informations'
		primaryKey => 'id'
		validate => array([maximum depth reached])
		validationErrors => array([maximum depth reached])
		validationDomain => null
		tablePrefix => ''
		plugin => null
		name => 'BasicModuleBasicInformation'
		alias => 'BasicModuleBasicInformation'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		hasAndBelongsToMany => array([maximum depth reached])
		actsAs => null
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => null
		recursive => (int) 1
		order => null
		__backAssociation => array([maximum depth reached])
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	BasicModuleBranchInfo => object(BasicModuleBranchInfo) {
		actsAs => array(
			[maximum depth reached]
		)
		belongsTo => array(
			[maximum depth reached]
		)
		virtualFields => array(
			[maximum depth reached]
		)
		validate => array(
			[maximum depth reached]
		)
		useDbConfig => 'default'
		useTable => 'basic_module_branch_infos'
		id => false
		data => array([maximum depth reached])
		schemaName => 'dbnational'
		table => 'basic_module_branch_infos'
		primaryKey => 'id'
		validationErrors => array([maximum depth reached])
		validationDomain => null
		plugin => null
		name => 'BasicModuleBranchInfo'
		alias => 'BasicModuleBranchInfo'
		tableToModel => array(
			[maximum depth reached]
		)
		cacheQueries => false
		hasOne => array([maximum depth reached])
		hasMany => array([maximum depth reached])
		hasAndBelongsToMany => array([maximum depth reached])
		Behaviors => object(BehaviorCollection) {}
		whitelist => array([maximum depth reached])
		cacheSources => true
		findQueryType => 'all'
		recursive => (int) 0
		order => null
		__backAssociation => array(
			[maximum depth reached]
		)
		__backInnerAssociation => array([maximum depth reached])
		__backOriginalAssociation => array([maximum depth reached])
		__backContainableAssociation => array([maximum depth reached])
		__safeUpdateMode => false
		useConsistentAfterFind => true
		findMethods => array(
			[maximum depth reached]
		)
		LookupBasicOfficeType => object(LookupBasicOfficeType) {}
		BasicModuleBasicInformation => object(BasicModuleBasicInformation) {}
		tablePrefix => ''
		[protected] _schema => array(
			[maximum depth reached]
		)
		[protected] _associationKeys => array(
			[maximum depth reached]
		)
		[protected] _associations => array(
			[maximum depth reached]
		)
		[protected] _insertID => null
		[protected] _sourceConfigured => true
		[protected] _eventManager => object(CakeEventManager) {}
		[protected] _validator => null
	}
	[protected] _responseClass => 'CakeResponse'
	[protected] _mergeParent => 'AppController'
	[protected] _eventManager => object(CakeEventManager) {
		[protected] _generalManager => object(CakeEventManager) {}
		[protected] _listeners => array(
			[maximum depth reached]
		)
		[protected] _isGlobal => false
	}
}
object(CakeRequest) {
	params => array(
		'plugin' => null,
		'controller' => 'ReportModuleReportViewers',
		'action' => 'branches_location_map',
		'named' => array(),
		'pass' => array(),
		'models' => array(
			'Session' => array(
				[maximum depth reached]
			),
			'BasicModuleBasicInformation' => array(
				[maximum depth reached]
			),
			'BasicModuleBranchInfo' => array(
				[maximum depth reached]
			),
			'LookupBasicOfficeType' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'ReportModuleReportViewers/branches_location_map'
	base => '/mfi-dbms-live-map'
	webroot => '/mfi-dbms-live-map/'
	here => '/mfi-dbms-live-map/ReportModuleReportViewers/branches_location_map'
	[protected] _detectors => array(
		'get' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'GET'
		),
		'post' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'POST'
		),
		'put' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PUT'
		),
		'delete' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'DELETE'
		),
		'head' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'HEAD'
		),
		'options' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'OPTIONS'
		),
		'ssl' => array(
			'env' => 'HTTPS',
			'value' => (int) 1
		),
		'ajax' => array(
			'env' => 'HTTP_X_REQUESTED_WITH',
			'value' => 'XMLHttpRequest'
		),
		'flash' => array(
			'env' => 'HTTP_USER_AGENT',
			'pattern' => '/^(Shockwave|Adobe) Flash/'
		),
		'mobile' => array(
			'env' => 'HTTP_USER_AGENT',
			'options' => array(
				[maximum depth reached]
			)
		),
		'requested' => array(
			'param' => 'requested',
			'value' => (int) 1
		),
		'json' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'json'
		),
		'xml' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'xml'
		)
	)
	[protected] _input => ''
}

APP/webroot/index.php line 108 → Dispatcher->dispatch(CakeRequest, CakeResponse)

$Dispatcher->dispatch(
    new CakeRequest(),
    new CakeResponse()
);

object(CakeRequest) {
	params => array(
		'plugin' => null,
		'controller' => 'ReportModuleReportViewers',
		'action' => 'branches_location_map',
		'named' => array(),
		'pass' => array(),
		'models' => array(
			'Session' => array(
				[maximum depth reached]
			),
			'BasicModuleBasicInformation' => array(
				[maximum depth reached]
			),
			'BasicModuleBranchInfo' => array(
				[maximum depth reached]
			),
			'LookupBasicOfficeType' => array(
				[maximum depth reached]
			)
		)
	)
	data => array()
	query => array()
	url => 'ReportModuleReportViewers/branches_location_map'
	base => '/mfi-dbms-live-map'
	webroot => '/mfi-dbms-live-map/'
	here => '/mfi-dbms-live-map/ReportModuleReportViewers/branches_location_map'
	[protected] _detectors => array(
		'get' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'GET'
		),
		'post' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'POST'
		),
		'put' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'PUT'
		),
		'delete' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'DELETE'
		),
		'head' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'HEAD'
		),
		'options' => array(
			'env' => 'REQUEST_METHOD',
			'value' => 'OPTIONS'
		),
		'ssl' => array(
			'env' => 'HTTPS',
			'value' => (int) 1
		),
		'ajax' => array(
			'env' => 'HTTP_X_REQUESTED_WITH',
			'value' => 'XMLHttpRequest'
		),
		'flash' => array(
			'env' => 'HTTP_USER_AGENT',
			'pattern' => '/^(Shockwave|Adobe) Flash/'
		),
		'mobile' => array(
			'env' => 'HTTP_USER_AGENT',
			'options' => array(
				[maximum depth reached]
			)
		),
		'requested' => array(
			'param' => 'requested',
			'value' => (int) 1
		),
		'json' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'json'
		),
		'xml' => array(
			'accept' => array(
				[maximum depth reached]
			),
			'param' => 'ext',
			'value' => 'xml'
		)
	)
	[protected] _input => ''
}
object(CakeResponse) {
	[protected] _statusCodes => array(
		(int) 100 => 'Continue',
		(int) 101 => 'Switching Protocols',
		(int) 200 => 'OK',
		(int) 201 => 'Created',
		(int) 202 => 'Accepted',
		(int) 203 => 'Non-Authoritative Information',
		(int) 204 => 'No Content',
		(int) 205 => 'Reset Content',
		(int) 206 => 'Partial Content',
		(int) 300 => 'Multiple Choices',
		(int) 301 => 'Moved Permanently',
		(int) 302 => 'Found',
		(int) 303 => 'See Other',
		(int) 304 => 'Not Modified',
		(int) 305 => 'Use Proxy',
		(int) 307 => 'Temporary Redirect',
		(int) 400 => 'Bad Request',
		(int) 401 => 'Unauthorized',
		(int) 402 => 'Payment Required',
		(int) 403 => 'Forbidden',
		(int) 404 => 'Not Found',
		(int) 405 => 'Method Not Allowed',
		(int) 406 => 'Not Acceptable',
		(int) 407 => 'Proxy Authentication Required',
		(int) 408 => 'Request Time-out',
		(int) 409 => 'Conflict',
		(int) 410 => 'Gone',
		(int) 411 => 'Length Required',
		(int) 412 => 'Precondition Failed',
		(int) 413 => 'Request Entity Too Large',
		(int) 414 => 'Request-URI Too Large',
		(int) 415 => 'Unsupported Media Type',
		(int) 416 => 'Requested range not satisfiable',
		(int) 417 => 'Expectation Failed',
		(int) 429 => 'Too Many Requests',
		(int) 500 => 'Internal Server Error',
		(int) 501 => 'Not Implemented',
		(int) 502 => 'Bad Gateway',
		(int) 503 => 'Service Unavailable',
		(int) 504 => 'Gateway Time-out',
		(int) 505 => 'Unsupported Version'
	)
	[protected] _mimeTypes => array(
		'html' => array(
			(int) 0 => 'text/html',
			(int) 1 => '*/*'
		),
		'json' => 'application/json',
		'xml' => array(
			(int) 0 => 'application/xml',
			(int) 1 => 'text/xml'
		),
		'rss' => 'application/rss+xml',
		'ai' => 'application/postscript',
		'bcpio' => 'application/x-bcpio',
		'bin' => 'application/octet-stream',
		'ccad' => 'application/clariscad',
		'cdf' => 'application/x-netcdf',
		'class' => 'application/octet-stream',
		'cpio' => 'application/x-cpio',
		'cpt' => 'application/mac-compactpro',
		'csh' => 'application/x-csh',
		'csv' => array(
			(int) 0 => 'text/csv',
			(int) 1 => 'application/vnd.ms-excel'
		),
		'dcr' => 'application/x-director',
		'dir' => 'application/x-director',
		'dms' => 'application/octet-stream',
		'doc' => 'application/msword',
		'docx' => 'application/vnd.openxmlformats-officedocument.wordprocessingml.document',
		'drw' => 'application/drafting',
		'dvi' => 'application/x-dvi',
		'dwg' => 'application/acad',
		'dxf' => 'application/dxf',
		'dxr' => 'application/x-director',
		'eot' => 'application/vnd.ms-fontobject',
		'eps' => 'application/postscript',
		'exe' => 'application/octet-stream',
		'ez' => 'application/andrew-inset',
		'flv' => 'video/x-flv',
		'gtar' => 'application/x-gtar',
		'gz' => 'application/x-gzip',
		'bz2' => 'application/x-bzip',
		'7z' => 'application/x-7z-compressed',
		'hdf' => 'application/x-hdf',
		'hqx' => 'application/mac-binhex40',
		'ico' => 'image/x-icon',
		'ips' => 'application/x-ipscript',
		'ipx' => 'application/x-ipix',
		'js' => 'application/javascript',
		'latex' => 'application/x-latex',
		'lha' => 'application/octet-stream',
		'lsp' => 'application/x-lisp',
		'lzh' => 'application/octet-stream',
		'man' => 'application/x-troff-man',
		'me' => 'application/x-troff-me',
		'mif' => 'application/vnd.mif',
		'ms' => 'application/x-troff-ms',
		'nc' => 'application/x-netcdf',
		'oda' => 'application/oda',
		'otf' => 'font/otf',
		'pdf' => 'application/pdf',
		'pgn' => 'application/x-chess-pgn',
		'pot' => 'application/vnd.ms-powerpoint',
		'pps' => 'application/vnd.ms-powerpoint',
		'ppt' => 'application/vnd.ms-powerpoint',
		'pptx' => 'application/vnd.openxmlformats-officedocument.presentationml.presentation',
		'ppz' => 'application/vnd.ms-powerpoint',
		'pre' => 'application/x-freelance',
		'prt' => 'application/pro_eng',
		'ps' => 'application/postscript',
		'roff' => 'application/x-troff',
		'scm' => 'application/x-lotusscreencam',
		'set' => 'application/set',
		'sh' => 'application/x-sh',
		'shar' => 'application/x-shar',
		'sit' => 'application/x-stuffit',
		'skd' => 'application/x-koan',
		'skm' => 'application/x-koan',
		'skp' => 'application/x-koan',
		'skt' => 'application/x-koan',
		'smi' => 'application/smil',
		'smil' => 'application/smil',
		'sol' => 'application/solids',
		'spl' => 'application/x-futuresplash',
		'src' => 'application/x-wais-source',
		'step' => 'application/STEP',
		'stl' => 'application/SLA',
		'stp' => 'application/STEP',
		'sv4cpio' => 'application/x-sv4cpio',
		'sv4crc' => 'application/x-sv4crc',
		'svg' => 'image/svg+xml',
		'svgz' => 'image/svg+xml',
		'swf' => 'application/x-shockwave-flash',
		't' => 'application/x-troff',
		'tar' => 'application/x-tar',
		'tcl' => 'application/x-tcl',
		'tex' => 'application/x-tex',
		'texi' => 'application/x-texinfo',
		'texinfo' => 'application/x-texinfo',
		'tr' => 'application/x-troff',
		'tsp' => 'application/dsptype',
		'ttc' => 'font/ttf',
		'ttf' => 'font/ttf',
		'unv' => 'application/i-deas',
		'ustar' => 'application/x-ustar',
		'vcd' => 'application/x-cdlink',
		'vda' => 'application/vda',
		'xlc' => 'application/vnd.ms-excel',
		'xll' => 'application/vnd.ms-excel',
		'xlm' => 'application/vnd.ms-excel',
		'xls' => 'application/vnd.ms-excel',
		'xlsx' => 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet',
		'xlw' => 'application/vnd.ms-excel',
		'zip' => 'application/zip',
		'aif' => 'audio/x-aiff',
		'aifc' => 'audio/x-aiff',
		'aiff' => 'audio/x-aiff',
		'au' => 'audio/basic',
		'kar' => 'audio/midi',
		'mid' => 'audio/midi',
		'midi' => 'audio/midi',
		'mp2' => 'audio/mpeg',
		'mp3' => 'audio/mpeg',
		'mpga' => 'audio/mpeg',
		'ogg' => 'audio/ogg',
		'oga' => 'audio/ogg',
		'spx' => 'audio/ogg',
		'ra' => 'audio/x-realaudio',
		'ram' => 'audio/x-pn-realaudio',
		'rm' => 'audio/x-pn-realaudio',
		'rpm' => 'audio/x-pn-realaudio-plugin',
		'snd' => 'audio/basic',
		'tsi' => 'audio/TSP-audio',
		'wav' => 'audio/x-wav',
		'aac' => 'audio/aac',
		'asc' => 'text/plain',
		'c' => 'text/plain',
		'cc' => 'text/plain',
		'css' => 'text/css',
		'etx' => 'text/x-setext',
		'f' => 'text/plain',
		'f90' => 'text/plain',
		'h' => 'text/plain',
		'hh' => 'text/plain',
		'htm' => array(
			(int) 0 => 'text/html',
			(int) 1 => '*/*'
		),
		'ics' => 'text/calendar',
		'm' => 'text/plain',
		'rtf' => 'text/rtf',
		'rtx' => 'text/richtext',
		'sgm' => 'text/sgml',
		'sgml' => 'text/sgml',
		'tsv' => 'text/tab-separated-values',
		'tpl' => 'text/template',
		'txt' => 'text/plain',
		'text' => 'text/plain',
		'avi' => 'video/x-msvideo',
		'fli' => 'video/x-fli',
		'mov' => 'video/quicktime',
		'movie' => 'video/x-sgi-movie',
		'mpe' => 'video/mpeg',
		'mpeg' => 'video/mpeg',
		'mpg' => 'video/mpeg',
		'qt' => 'video/quicktime',
		'viv' => 'video/vnd.vivo',
		'vivo' => 'video/vnd.vivo',
		'ogv' => 'video/ogg',
		'webm' => 'video/webm',
		'mp4' => 'video/mp4',
		'm4v' => 'video/mp4',
		'f4v' => 'video/mp4',
		'f4p' => 'video/mp4',
		'm4a' => 'audio/mp4',
		'f4a' => 'audio/mp4',
		'f4b' => 'audio/mp4',
		'gif' => 'image/gif',
		'ief' => 'image/ief',
		'jpg' => 'image/jpeg',
		'jpeg' => 'image/jpeg',
		'jpe' => 'image/jpeg',
		'pbm' => 'image/x-portable-bitmap',
		'pgm' => 'image/x-portable-graymap',
		'png' => 'image/png',
		'pnm' => 'image/x-portable-anymap',
		'ppm' => 'image/x-portable-pixmap',
		'ras' => 'image/cmu-raster',
		'rgb' => 'image/x-rgb',
		'tif' => 'image/tiff',
		'tiff' => 'image/tiff',
		'xbm' => 'image/x-xbitmap',
		'xpm' => 'image/x-xpixmap',
		'xwd' => 'image/x-xwindowdump',
		'ice' => 'x-conference/x-cooltalk',
		'iges' => 'model/iges',
		'igs' => 'model/iges',
		'mesh' => 'model/mesh',
		'msh' => 'model/mesh',
		'silo' => 'model/mesh',
		'vrml' => 'model/vrml',
		'wrl' => 'model/vrml',
		'mime' => 'www/mime',
		'pdb' => 'chemical/x-pdb',
		'xyz' => 'chemical/x-pdb',
		'javascript' => 'application/javascript',
		'form' => 'application/x-www-form-urlencoded',
		'file' => 'multipart/form-data',
		'xhtml' => array(
			(int) 0 => 'application/xhtml+xml',
			(int) 1 => 'application/xhtml',
			(int) 2 => 'text/xhtml'
		),
		'xhtml-mobile' => 'application/vnd.wap.xhtml+xml',
		'atom' => 'application/atom+xml',
		'amf' => 'application/x-amf',
		'wap' => array(
			(int) 0 => 'text/vnd.wap.wml',
			(int) 1 => 'text/vnd.wap.wmlscript',
			(int) 2 => 'image/vnd.wap.wbmp'
		),
		'wml' => 'text/vnd.wap.wml',
		'wmlscript' => 'text/vnd.wap.wmlscript',
		'wbmp' => 'image/vnd.wap.wbmp',
		'woff' => 'application/x-font-woff',
		'webp' => 'image/webp',
		'appcache' => 'text/cache-manifest',
		'manifest' => 'text/cache-manifest',
		'htc' => 'text/x-component',
		'rdf' => 'application/xml',
		'crx' => 'application/x-chrome-extension',
		'oex' => 'application/x-opera-extension',
		'xpi' => 'application/x-xpinstall',
		'safariextz' => 'application/octet-stream',
		'webapp' => 'application/x-web-app-manifest+json',
		'vcf' => 'text/x-vcard',
		'vtt' => 'text/vtt',
		'mkv' => 'video/x-matroska',
		'pkpass' => 'application/vnd.apple.pkpass'
	)
	[protected] _protocol => 'HTTP/1.1'
	[protected] _status => (int) 200
	[protected] _contentType => 'text/html'
	[protected] _headers => array()
	[protected] _body => null
	[protected] _file => null
	[protected] _fileRange => null
	[protected] _charset => 'UTF-8'
	[protected] _cacheDirectives => array()
	[protected] _cookies => array()
}

Database Error

Stack Trace