Notice (8): Undefined offset: 0 [APP/Controller/BusinessProfile2Controller.php, line 438]Code Context $this->viewPath = 'CategoryInCounty';
$this->set('hasResultsCSS'," ");
$this->set('title', 'Top 10 Best Favorite '. $bizProf0[0]["category_name"] .' in '.$bizProf0[0]["county_name"].', '.$bizProf0[0]["state"].' on Beelocal');
$_routeParam5 = ''
$url = '/accounting-bookkeeping-tax-preparation/spokane-county/wa/'
$expURL = array(
(int) 0 => '',
(int) 1 => 'accounting-bookkeeping-tax-preparation',
(int) 2 => 'spokane-county',
(int) 3 => 'wa',
(int) 4 => ''
)
$_routeParam1Orig = 'accounting-bookkeeping-tax-preparation'
$_routeParam2Orig = 'spokane-county'
$_routeParam3Orig = 'wa'
$_routeParam4Orig = ''
$_routeParam5Orig = ''
$_routeParam1 = 'accountingbookkeepingtaxpreparation'
$_routeParam2 = 'spokanecounty'
$_routeParam3 = 'wa'
$_routeParam4 = ''
$_ipAddress = '216.73.216.47'
$conn = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 1
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array()
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 1
[protected] _queriesTime => (float) 1
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array()
[protected] _sources => null
[protected] _transactionStarted => false
}
$conn2 = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 1
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array()
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 1
[protected] _queriesTime => (float) 1
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array()
[protected] _sources => null
[protected] _transactionStarted => false
}
$queryBusinesses = 'SELECT
category_id, category AS category_name, category_condensed,
name, name_condensed ,
address,
city, city_condensed,
county AS county_name,
county_condensed,
state,
zip
FROM bl_business_profile
WHERE county_condensed='spokanecounty' AND state ='wa'
AND category_condensed='accountingbookkeepingtaxpreparation'
ORDER BY city LIMIT 50'
$queryTopCategories = ''
$query0 = 'SELECT county_name , category_name, state
FROM bl_topcategories_per_county
WHERE state='wa'
and county_condensed='spokanecounty'
and category_condensed='accountingbookkeepingtaxpreparation' LIMIT 1'
$stmt0 = object(PDOStatement) {
queryString => 'SELECT county_name , category_name, state
FROM bl_topcategories_per_county
WHERE state='wa'
and county_condensed='spokanecounty'
and category_condensed='accountingbookkeepingtaxpreparation' LIMIT 1'
}
$bizProf0 = array()BusinessProfile2Controller::id() - APP/Controller/BusinessProfile2Controller.php, line 438
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160
[main] - APP/webroot/index.php, line 108
Notice (8): Undefined offset: 0 [APP/Controller/BusinessProfile2Controller.php, line 438]Code Context $this->viewPath = 'CategoryInCounty';
$this->set('hasResultsCSS'," ");
$this->set('title', 'Top 10 Best Favorite '. $bizProf0[0]["category_name"] .' in '.$bizProf0[0]["county_name"].', '.$bizProf0[0]["state"].' on Beelocal');
$_routeParam5 = ''
$url = '/accounting-bookkeeping-tax-preparation/spokane-county/wa/'
$expURL = array(
(int) 0 => '',
(int) 1 => 'accounting-bookkeeping-tax-preparation',
(int) 2 => 'spokane-county',
(int) 3 => 'wa',
(int) 4 => ''
)
$_routeParam1Orig = 'accounting-bookkeeping-tax-preparation'
$_routeParam2Orig = 'spokane-county'
$_routeParam3Orig = 'wa'
$_routeParam4Orig = ''
$_routeParam5Orig = ''
$_routeParam1 = 'accountingbookkeepingtaxpreparation'
$_routeParam2 = 'spokanecounty'
$_routeParam3 = 'wa'
$_routeParam4 = ''
$_ipAddress = '216.73.216.47'
$conn = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 1
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array()
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 1
[protected] _queriesTime => (float) 1
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array()
[protected] _sources => null
[protected] _transactionStarted => false
}
$conn2 = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 1
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array()
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 1
[protected] _queriesTime => (float) 1
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array()
[protected] _sources => null
[protected] _transactionStarted => false
}
$queryBusinesses = 'SELECT
category_id, category AS category_name, category_condensed,
name, name_condensed ,
address,
city, city_condensed,
county AS county_name,
county_condensed,
state,
zip
FROM bl_business_profile
WHERE county_condensed='spokanecounty' AND state ='wa'
AND category_condensed='accountingbookkeepingtaxpreparation'
ORDER BY city LIMIT 50'
$queryTopCategories = ''
$query0 = 'SELECT county_name , category_name, state
FROM bl_topcategories_per_county
WHERE state='wa'
and county_condensed='spokanecounty'
and category_condensed='accountingbookkeepingtaxpreparation' LIMIT 1'
$stmt0 = object(PDOStatement) {
queryString => 'SELECT county_name , category_name, state
FROM bl_topcategories_per_county
WHERE state='wa'
and county_condensed='spokanecounty'
and category_condensed='accountingbookkeepingtaxpreparation' LIMIT 1'
}
$bizProf0 = array()BusinessProfile2Controller::id() - APP/Controller/BusinessProfile2Controller.php, line 438
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160
[main] - APP/webroot/index.php, line 108
Notice (8): Undefined offset: 0 [APP/Controller/BusinessProfile2Controller.php, line 438]Code Context $this->viewPath = 'CategoryInCounty';
$this->set('hasResultsCSS'," ");
$this->set('title', 'Top 10 Best Favorite '. $bizProf0[0]["category_name"] .' in '.$bizProf0[0]["county_name"].', '.$bizProf0[0]["state"].' on Beelocal');
$_routeParam5 = ''
$url = '/accounting-bookkeeping-tax-preparation/spokane-county/wa/'
$expURL = array(
(int) 0 => '',
(int) 1 => 'accounting-bookkeeping-tax-preparation',
(int) 2 => 'spokane-county',
(int) 3 => 'wa',
(int) 4 => ''
)
$_routeParam1Orig = 'accounting-bookkeeping-tax-preparation'
$_routeParam2Orig = 'spokane-county'
$_routeParam3Orig = 'wa'
$_routeParam4Orig = ''
$_routeParam5Orig = ''
$_routeParam1 = 'accountingbookkeepingtaxpreparation'
$_routeParam2 = 'spokanecounty'
$_routeParam3 = 'wa'
$_routeParam4 = ''
$_ipAddress = '216.73.216.47'
$conn = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 1
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array()
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 1
[protected] _queriesTime => (float) 1
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array()
[protected] _sources => null
[protected] _transactionStarted => false
}
$conn2 = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 1
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array()
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 1
[protected] _queriesTime => (float) 1
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array()
[protected] _sources => null
[protected] _transactionStarted => false
}
$queryBusinesses = 'SELECT
category_id, category AS category_name, category_condensed,
name, name_condensed ,
address,
city, city_condensed,
county AS county_name,
county_condensed,
state,
zip
FROM bl_business_profile
WHERE county_condensed='spokanecounty' AND state ='wa'
AND category_condensed='accountingbookkeepingtaxpreparation'
ORDER BY city LIMIT 50'
$queryTopCategories = ''
$query0 = 'SELECT county_name , category_name, state
FROM bl_topcategories_per_county
WHERE state='wa'
and county_condensed='spokanecounty'
and category_condensed='accountingbookkeepingtaxpreparation' LIMIT 1'
$stmt0 = object(PDOStatement) {
queryString => 'SELECT county_name , category_name, state
FROM bl_topcategories_per_county
WHERE state='wa'
and county_condensed='spokanecounty'
and category_condensed='accountingbookkeepingtaxpreparation' LIMIT 1'
}
$bizProf0 = array()BusinessProfile2Controller::id() - APP/Controller/BusinessProfile2Controller.php, line 438
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160
[main] - APP/webroot/index.php, line 108
Notice (8): Undefined offset: 0 [APP/Controller/BusinessProfile2Controller.php, line 439]Code Context $this->set('hasResultsCSS'," ");
$this->set('title', 'Top 10 Best Favorite '. $bizProf0[0]["category_name"] .' in '.$bizProf0[0]["county_name"].', '.$bizProf0[0]["state"].' on Beelocal');
$this->set('resultsHeaderTitle', "Favorite Local ".$bizProf0[0]["category_name"]." in<br> <a href='https://www.beelocal.io/".$_routeParam2Orig."/".$_routeParam3Orig."'>".$bizProf0[0]["county_name"]."</a>" );
$_routeParam5 = ''
$url = '/accounting-bookkeeping-tax-preparation/spokane-county/wa/'
$expURL = array(
(int) 0 => '',
(int) 1 => 'accounting-bookkeeping-tax-preparation',
(int) 2 => 'spokane-county',
(int) 3 => 'wa',
(int) 4 => ''
)
$_routeParam1Orig = 'accounting-bookkeeping-tax-preparation'
$_routeParam2Orig = 'spokane-county'
$_routeParam3Orig = 'wa'
$_routeParam4Orig = ''
$_routeParam5Orig = ''
$_routeParam1 = 'accountingbookkeepingtaxpreparation'
$_routeParam2 = 'spokanecounty'
$_routeParam3 = 'wa'
$_routeParam4 = ''
$_ipAddress = '216.73.216.47'
$conn = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 1
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array()
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 1
[protected] _queriesTime => (float) 1
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array()
[protected] _sources => null
[protected] _transactionStarted => false
}
$conn2 = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 1
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array()
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 1
[protected] _queriesTime => (float) 1
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array()
[protected] _sources => null
[protected] _transactionStarted => false
}
$queryBusinesses = 'SELECT
category_id, category AS category_name, category_condensed,
name, name_condensed ,
address,
city, city_condensed,
county AS county_name,
county_condensed,
state,
zip
FROM bl_business_profile
WHERE county_condensed='spokanecounty' AND state ='wa'
AND category_condensed='accountingbookkeepingtaxpreparation'
ORDER BY city LIMIT 50'
$queryTopCategories = ''
$query0 = 'SELECT county_name , category_name, state
FROM bl_topcategories_per_county
WHERE state='wa'
and county_condensed='spokanecounty'
and category_condensed='accountingbookkeepingtaxpreparation' LIMIT 1'
$stmt0 = object(PDOStatement) {
queryString => 'SELECT county_name , category_name, state
FROM bl_topcategories_per_county
WHERE state='wa'
and county_condensed='spokanecounty'
and category_condensed='accountingbookkeepingtaxpreparation' LIMIT 1'
}
$bizProf0 = array()BusinessProfile2Controller::id() - APP/Controller/BusinessProfile2Controller.php, line 439
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160
[main] - APP/webroot/index.php, line 108
Notice (8): Undefined offset: 0 [APP/Controller/BusinessProfile2Controller.php, line 439]Code Context $this->set('hasResultsCSS'," ");
$this->set('title', 'Top 10 Best Favorite '. $bizProf0[0]["category_name"] .' in '.$bizProf0[0]["county_name"].', '.$bizProf0[0]["state"].' on Beelocal');
$this->set('resultsHeaderTitle', "Favorite Local ".$bizProf0[0]["category_name"]." in<br> <a href='https://www.beelocal.io/".$_routeParam2Orig."/".$_routeParam3Orig."'>".$bizProf0[0]["county_name"]."</a>" );
$_routeParam5 = ''
$url = '/accounting-bookkeeping-tax-preparation/spokane-county/wa/'
$expURL = array(
(int) 0 => '',
(int) 1 => 'accounting-bookkeeping-tax-preparation',
(int) 2 => 'spokane-county',
(int) 3 => 'wa',
(int) 4 => ''
)
$_routeParam1Orig = 'accounting-bookkeeping-tax-preparation'
$_routeParam2Orig = 'spokane-county'
$_routeParam3Orig = 'wa'
$_routeParam4Orig = ''
$_routeParam5Orig = ''
$_routeParam1 = 'accountingbookkeepingtaxpreparation'
$_routeParam2 = 'spokanecounty'
$_routeParam3 = 'wa'
$_routeParam4 = ''
$_ipAddress = '216.73.216.47'
$conn = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 1
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array()
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 1
[protected] _queriesTime => (float) 1
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array()
[protected] _sources => null
[protected] _transactionStarted => false
}
$conn2 = object(Mysql) {
description => 'MySQL DBO Driver'
startQuote => '`'
endQuote => '`'
fieldParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'comment' => array(
[maximum depth reached]
)
)
tableParameters => array(
'charset' => array(
[maximum depth reached]
),
'collate' => array(
[maximum depth reached]
),
'engine' => array(
[maximum depth reached]
)
)
columns => array(
'primary_key' => array(
[maximum depth reached]
),
'string' => array(
[maximum depth reached]
),
'text' => array(
[maximum depth reached]
),
'biginteger' => array(
[maximum depth reached]
),
'integer' => array(
[maximum depth reached]
),
'float' => array(
[maximum depth reached]
),
'datetime' => array(
[maximum depth reached]
),
'timestamp' => array(
[maximum depth reached]
),
'time' => array(
[maximum depth reached]
),
'date' => array(
[maximum depth reached]
),
'binary' => array(
[maximum depth reached]
),
'boolean' => array(
[maximum depth reached]
)
)
index => array(
'PRI' => 'primary',
'MUL' => 'index',
'UNI' => 'unique'
)
alias => 'AS '
cacheMethods => true
useNestedTransactions => false
fullDebug => true
affected => (int) 0
numRows => (int) 0
took => (float) 1
configKeyName => 'default'
virtualFieldSeparator => '__'
connected => true
config => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'prefix' => '*****',
'persistent' => false,
'datasource' => 'Database/Mysql'
)
cacheSources => true
[protected] _baseConfig => array(
'password' => '*****',
'login' => '*****',
'host' => '*****',
'database' => '*****',
'port' => '*****',
'persistent' => true
)
[protected] _connection => object(PDO) {}
[protected] _useAlias => true
[protected] _charsets => array()
[protected] _result => object(PDOStatement) {}
[protected] _queriesCnt => (int) 1
[protected] _queriesTime => (float) 1
[protected] _queriesLog => array(
(int) 0 => array(
[maximum depth reached]
)
)
[protected] _queriesLogMax => (int) 200
[protected] _queryCache => array()
[protected] _sqlOps => array(
(int) 0 => 'like',
(int) 1 => 'ilike',
(int) 2 => 'or',
(int) 3 => 'not',
(int) 4 => 'in',
(int) 5 => 'between',
(int) 6 => 'regexp',
(int) 7 => 'similar to'
)
[protected] _transactionNesting => (int) 0
[protected] _queryDefaults => array(
'conditions' => array([maximum depth reached]),
'fields' => null,
'table' => null,
'alias' => null,
'order' => null,
'limit' => null,
'joins' => array([maximum depth reached]),
'group' => null,
'offset' => null
)
[protected] _methodCacheChange => false
[protected] _descriptions => array()
[protected] _sources => null
[protected] _transactionStarted => false
}
$queryBusinesses = 'SELECT
category_id, category AS category_name, category_condensed,
name, name_condensed ,
address,
city, city_condensed,
county AS county_name,
county_condensed,
state,
zip
FROM bl_business_profile
WHERE county_condensed='spokanecounty' AND state ='wa'
AND category_condensed='accountingbookkeepingtaxpreparation'
ORDER BY city LIMIT 50'
$queryTopCategories = ''
$query0 = 'SELECT county_name , category_name, state
FROM bl_topcategories_per_county
WHERE state='wa'
and county_condensed='spokanecounty'
and category_condensed='accountingbookkeepingtaxpreparation' LIMIT 1'
$stmt0 = object(PDOStatement) {
queryString => 'SELECT county_name , category_name, state
FROM bl_topcategories_per_county
WHERE state='wa'
and county_condensed='spokanecounty'
and category_condensed='accountingbookkeepingtaxpreparation' LIMIT 1'
}
$bizProf0 = array()BusinessProfile2Controller::id() - APP/Controller/BusinessProfile2Controller.php, line 439
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - CORE/Cake/Controller/Controller.php, line 490
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 185
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 160
[main] - APP/webroot/index.php, line 108
Warning (2): Cannot modify header information - headers already sent by (output started at /home/beelocal/public_html/lib/Cake/Utility/Debugger.php:800) [APP/View/Layouts/default.ctp, line 53]Code Contextif ( strpos($_host,"www") !== false ){
$redirect = "https://beelocal.io". (strlen($_SERVER['REQUEST_URI']) > 1 ? "/".$_SERVER['REQUEST_URI'] :"" );
header("Location:".$redirect );
$viewFile = '/home/beelocal/public_html/app/View/Layouts/default.ctp'
$dataForView = array(
'code' => (int) 500,
'url' => '/accounting-bookkeeping-tax-preparation/spokane-county/wa/?url=accounting-bookkeeping-tax-preparation%2Fspokane-county%2Fwa%2F',
'name' => 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lat' in 'field list'',
'error' => object(PDOException) {
errorInfo => array(
[maximum depth reached]
)
queryString => 'CALL sp_bl_search_for_cities_near_countystate('spokanecounty','wa' )'
[protected] message => 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lat' in 'field list''
[protected] code => '42S22'
[protected] file => '/home/beelocal/public_html/lib/Cake/Model/Datasource/DboSource.php'
[protected] line => (int) 458
},
'_serialize' => array(
(int) 0 => 'code',
(int) 1 => 'url',
(int) 2 => 'name',
(int) 3 => 'error'
),
'content_for_layout' => '
<h2>Oops, we found a bug!</h2>
<br>
ERR0DP
<br>
',
'scripts_for_layout' => '',
'title_for_layout' => 'Errors'
)
$code = (int) 500
$url = '/accounting-bookkeeping-tax-preparation/spokane-county/wa/?url=accounting-bookkeeping-tax-preparation%2Fspokane-county%2Fwa%2F'
$name = 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lat' in 'field list''
$error = object(PDOException) {
errorInfo => array(
(int) 0 => '42S22',
(int) 1 => (int) 1054,
(int) 2 => 'Unknown column 'lat' in 'field list''
)
queryString => 'CALL sp_bl_search_for_cities_near_countystate('spokanecounty','wa' )'
[protected] message => 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'lat' in 'field list''
[protected] code => '42S22'
[protected] file => '/home/beelocal/public_html/lib/Cake/Model/Datasource/DboSource.php'
[protected] line => (int) 458
}
$_serialize = array(
(int) 0 => 'code',
(int) 1 => 'url',
(int) 2 => 'name',
(int) 3 => 'error'
)
$content_for_layout = '
<h2>Oops, we found a bug!</h2>
<br>
ERR0DP
<br>
'
$scripts_for_layout = ''
$title_for_layout = 'Errors'
$_version = (int) 1780529523
$cakeDescription = 'CakePHP: the rapid development php framework'
$httpSSL = ''
$_host = 'www.beelocal.io'
$redirect = 'https://beelocal.io//accounting-bookkeeping-tax-preparation/spokane-county/wa/'header - [internal], line ??
include - APP/View/Layouts/default.ctp, line 53
View::_evaluate() - CORE/Cake/View/View.php, line 935
View::_render() - CORE/Cake/View/View.php, line 897
View::renderLayout() - CORE/Cake/View/View.php, line 529
View::render() - CORE/Cake/View/View.php, line 474
Controller::render() - CORE/Cake/Controller/Controller.php, line 954
ExceptionRenderer::_outputMessage() - CORE/Cake/Error/ExceptionRenderer.php, line 273
ExceptionRenderer::pdoError() - CORE/Cake/Error/ExceptionRenderer.php, line 262
ExceptionRenderer::render() - CORE/Cake/Error/ExceptionRenderer.php, line 175
ErrorHandler::handleException() - CORE/Cake/Error/ErrorHandler.php, line 120
[main] - [internal], line ??