Dehood
Woodbridge, NJ
Dehood
<p>There is no 'root'@'%' registered QUERY: Select<br /> 'http://www.dehood.com/places/j93a52/fremont/priority-dispatch' as url,<br /> ifnull(( Select idbrand from yp_listToBrand x where x.idlocation = a.id order by id desc limit 1 ),0) as idbrand,<br /> geo_distance(0,0, b.lat, b.lon) as distance, </p> <p> a.id,<br /> location_useradded(a.id) as useradded,<br /> a.company,<br /> a.address,</p> <p> a.city,<br /> a.st,<br /> a.zip,<br /> a.phone,<br /> 'icon.gif' as icon,<br /> 10 as idgroup,<br /> location_count(a.id,'picture') as pictures,<br /> location_count(a.id,'checkin') as total_checkin,<br /> location_count(a.id,'virtualcheckin') as virtualcheckin,<br /> location_count(a.id,'checkin') as checkin,<br /> location_count(a.id,'deal') as deals,<br /> 10 as reports,<br /> lat as latitude,<br /> lon as longitude,<br /> location_getRelationship(a.id,'king') as userking,<br /> location_getRelationship(a.id,'firstcheckin') as userfirst<br /> from<br /> yp_list a<br /> left join yp_coords b on a.id=b.id<br /> where a.id=1153894474 limit 1</p>

There is no 'root'@'%' registered QUERY: Select
'http://www.dehood.com/places/j93a52/fremont/priority-dispatch' as url,
ifnull(( Select idbrand from yp_listToBrand x where x.idlocation = a.id order by id desc limit 1 ),0) as idbrand,
geo_distance(0,0, b.lat, b.lon) as distance,

a.id,
location_useradded(a.id) as useradded,
a.company,
a.address,

a.city,
a.st,
a.zip,
a.phone,
'icon.gif' as icon,
10 as idgroup,
location_count(a.id,'picture') as pictures,
location_count(a.id,'checkin') as total_checkin,
location_count(a.id,'virtualcheckin') as virtualcheckin,
location_count(a.id,'checkin') as checkin,
location_count(a.id,'deal') as deals,
10 as reports,
lat as latitude,
lon as longitude,
location_getRelationship(a.id,'king') as userking,
location_getRelationship(a.id,'firstcheckin') as userfirst
from
yp_list a
left join yp_coords b on a.id=b.id
where a.id=1153894474 limit 1

There is no 'root'@'%' registered QUERY: Select
'http://www.dehood.com/places/j93a52/fremont/priority-dispatch' as url,
ifnull(( Select idbrand from yp_listToBrand x where x.idlocation = a.id order by id desc limit 1 ),0) as idbrand,
geo_distance(0,0, b.lat, b.lon) as distance,

a.id,
location_useradded(a.id) as useradded,
a.company,
a.address,

a.city,
a.st,
a.zip,
a.phone,
'icon.gif' as icon,
10 as idgroup,
location_count(a.id,'picture') as pictures,
location_count(a.id,'checkin') as total_checkin,
location_count(a.id,'virtualcheckin') as virtualcheckin,
location_count(a.id,'checkin') as checkin,
location_count(a.id,'deal') as deals,
10 as reports,
lat as latitude,
lon as longitude,
location_getRelationship(a.id,'king') as userking,
location_getRelationship(a.id,'firstcheckin') as userfirst
from
yp_list a
left join yp_coords b on a.id=b.id
where a.id=1153894474 limit 1


DatabaseException Object
(
[message:protected] => There is no 'root'@'%' registered QUERY: Select
'http://www.dehood.com/places/j93a52/fremont/priority-dispatch' as url,
ifnull(( Select idbrand from yp_listToBrand x where x.idlocation = a.id order by id desc limit 1 ),0) as idbrand,
geo_distance(0,0, b.lat, b.lon) as distance,

a.id,
location_useradded(a.id) as useradded,
a.company,
a.address,

a.city,
a.st,
a.zip,
a.phone,
'icon.gif' as icon,
10 as idgroup,
location_count(a.id,'picture') as pictures,
location_count(a.id,'checkin') as total_checkin,
location_count(a.id,'virtualcheckin') as virtualcheckin,
location_count(a.id,'checkin') as checkin,
location_count(a.id,'deal') as deals,
10 as reports,
lat as latitude,
lon as longitude,
location_getRelationship(a.id,'king') as userking,
location_getRelationship(a.id,'firstcheckin') as userfirst
from
yp_list a
left join yp_coords b on a.id=b.id
where a.id=1153894474 limit 1
[string:private] => exception 'DatabaseException' with message 'There is no 'root'@'%' registered QUERY: Select
'http://www.dehood.com/places/j93a52/fremont/priority-dispatch' as url,
ifnull(( Select idbrand from yp_listToBrand x where x.idlocation = a.id order by id desc limit 1 ),0) as idbrand,
geo_distance(0,0, b.lat, b.lon) as distance,

a.id,
location_useradded(a.id) as useradded,
a.company,
a.address,

a.city,
a.st,
a.zip,
a.phone,
'icon.gif' as icon,
10 as idgroup,
location_count(a.id,'picture') as pictures,
location_count(a.id,'checkin') as total_checkin,
location_count(a.id,'virtualcheckin') as virtualcheckin,
location_count(a.id,'checkin') as checkin,
location_count(a.id,'deal') as deals,
10 as reports,
lat as latitude,
lon as longitude,
location_getRelationship(a.id,'king') as userking,
location_getRelationship(a.id,'firstcheckin') as userfirst
from
yp_list a
left join yp_coords b on a.id=b.id
where a.id=1153894474 limit 1' in /srv/web/www/www.dehood.com/engine/lib/database.php:294
Stack trace:
#0 /srv/web/www/www.dehood.com/api/app/models/API_Location_Model.php(392): get_data_row('Select ????'htt...')
#1 /srv/web/www/www.dehood.com/engine/lib/modules/Places.php(44): API_Location_Model->getDetails(1153894474)
#2 /srv/web/www/www.dehood.com/engine/lib/Module_Bootstrap.php(82): Places_Module->renderModule(Array, NULL)
#3 /srv/web/www/www.dehood.com/engine/lib/Module_Bootstrap.php(53): Module_Boostrap->loadModule('places', Array, NULL)
#4 /srv/web/www/www.dehood.com/engine/handlers/module_handler.php(12): Module_Boostrap->loadRoute('places/j93a52/f...')
#5 {main}
[code:protected] => 0
[file:protected] => /srv/web/www/www.dehood.com/engine/lib/database.php
[line:protected] => 294
[trace:private] => Array
(
[0] => Array
(
[file] => /srv/web/www/www.dehood.com/api/app/models/API_Location_Model.php
[line] => 392
[function] => get_data_row
[args] => Array
(
[0] => Select
'http://www.dehood.com/places/j93a52/fremont/priority-dispatch' as url,
ifnull(( Select idbrand from yp_listToBrand x where x.idlocation = a.id order by id desc limit 1 ),0) as idbrand,
geo_distance(0,0, b.lat, b.lon) as distance,

a.id,
location_useradded(a.id) as useradded,
a.company,
a.address,

a.city,
a.st,
a.zip,
a.phone,
'icon.gif' as icon,
10 as idgroup,
location_count(a.id,'picture') as pictures,
location_count(a.id,'checkin') as total_checkin,
location_count(a.id,'virtualcheckin') as virtualcheckin,
location_count(a.id,'checkin') as checkin,
location_count(a.id,'deal') as deals,
10 as reports,
lat as latitude,
lon as longitude,
location_getRelationship(a.id,'king') as userking,
location_getRelationship(a.id,'firstcheckin') as userfirst
from
yp_list a
left join yp_coords b on a.id=b.id
where a.id=1153894474 limit 1
)

)

[1] => Array
(
[file] => /srv/web/www/www.dehood.com/engine/lib/modules/Places.php
[line] => 44
[function] => getDetails
[class] => API_Location_Model
[type] => ->
[args] => Array
(
[0] => 1153894474
)

)

[2] => Array
(
[file] => /srv/web/www/www.dehood.com/engine/lib/Module_Bootstrap.php
[line] => 82
[function] => renderModule
[class] => Places_Module
[type] => ->
[args] => Array
(
[0] => Array
(
[0] => places
[1] => j93a52
[2] => fremont
[3] => priority-dispatch
)

[1] =>
)

)

[3] => Array
(
[file] => /srv/web/www/www.dehood.com/engine/lib/Module_Bootstrap.php
[line] => 53
[function] => loadModule
[class] => Module_Boostrap
[type] => ->
[args] => Array
(
[0] => places
[1] => Array
(
[0] => places
[1] => j93a52
[2] => fremont
[3] => priority-dispatch
)

[2] =>
)

)

[4] => Array
(
[file] => /srv/web/www/www.dehood.com/engine/handlers/module_handler.php
[line] => 12
[function] => loadRoute
[class] => Module_Boostrap
[type] => ->
[args] => Array
(
[0] => places/j93a52/fremont/priority-dispatch
)

)

)

)