Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method Configure::read() should not be called statically in /home/techhot/public_html/cake/basics.php on line 213
Strict Standards: Non-static method Configure::getInstance() should not be called statically in /home/techhot/public_html/cake/libs/configure.php on line 154
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 657
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 657
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 668
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 668
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 668
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 673
Warning (512): SQL Error: 1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'techhot_techh.Employer.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [CORE/cake/libs/model/datasources/dbo_source.php, line 673]
$sql = "SELECT `Employer`.`id`, `Employer`.`techhotbed_id`, `Employer`.`company` FROM `employers` AS `Employer` LEFT JOIN `countries` AS `Country` ON (`Employer`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Employer`.`state_id` = `State`.`id`) LEFT JOIN `emp_company_profiles` AS `EmpCompanyProfile` ON (`EmpCompanyProfile`.`employer_id` = `Employer`.`id`) LEFT JOIN `emp_enhanced_profiles` AS `EmpEnhancedProfile` ON (`EmpEnhancedProfile`.`employer_id` = `Employer`.`id`) WHERE `Employer`.`status` = "Active" GROUP BY `Employer`.`company` "
$error = "1055: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'techhot_techh.Employer.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 673
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 263
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 407
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 812
Model::find() - CORE/cake/libs/model/model.php, line 2087
SearchJobsController::searchJobResult() - APP/controllers/search_jobs_controller.php, line 208
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Strict Standards: Non-static method Configure::read() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 308
Strict Standards: Non-static method Configure::getInstance() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/configure.php on line 154
Strict Standards: Non-static method CakeLog::write() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 311
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 311
Strict Standards: Non-static method CakeLog::getInstance() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/cake_log.php on line 230
Strict Standards: Non-static method App::import() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/cake_log.php on line 180
Strict Standards: Non-static method App::getInstance() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/configure.php on line 894
Strict Standards: Non-static method Inflector::underscore() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/configure.php on line 925
Strict Standards: Non-static method Inflector::getInstance() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/inflector.php on line 512
Query: SELECT `Employer`.`id`, `Employer`.`techhotbed_id`, `Employer`.`company` FROM `employers` AS `Employer` LEFT JOIN `countries` AS `Country` ON (`Employer`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Employer`.`state_id` = `State`.`id`) LEFT JOIN `emp_company_profiles` AS `EmpCompanyProfile` ON (`EmpCompanyProfile`.`employer_id` = `Employer`.`id`) LEFT JOIN `emp_enhanced_profiles` AS `EmpEnhancedProfile` ON (`EmpEnhancedProfile`.`employer_id` = `Employer`.`id`) WHERE `Employer`.`status` = "Active" GROUP BY `Employer`.`company`
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 398
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 657
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 657
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 668
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 668
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 668
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 673
Warning (512): SQL Error: 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'techhot_techh.EmployerJob.state_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [CORE/cake/libs/model/datasources/dbo_source.php, line 673]
$sql = "SELECT DISTINCT(`State`.`name`), `EmployerJob`.`state_id`, (SELECT count( employer_jobs.id ) FROM employer_jobs WHERE `employer_jobs`.`status` = "Active" AND `employer_jobs`.`verified` = "1" AND ( `employer_jobs`.`job_posted` BETWEEN SUBDATE( now( ) , INTERVAL 30 DAY ) AND now( ) ) AND `employer_jobs`.`state_id` = `EmployerJob`.`state_id`) as job_count, `EmployerJob`.`id` FROM `employer_jobs` AS `EmployerJob` LEFT JOIN `countries` AS `Country` ON (`EmployerJob`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`EmployerJob`.`state_id` = `State`.`id`) LEFT JOIN `job_categories` AS `JobCategory` ON (`EmployerJob`.`job_category_id` = `JobCategory`.`id`) LEFT JOIN `job_types` AS `JobType` ON (`EmployerJob`.`job_type_id` = `JobType`.`id`) LEFT JOIN `industries` AS `Industry` ON (`EmployerJob`.`industry_id` = `Industry`.`id`) LEFT JOIN `employers` AS `Employer` ON (`EmployerJob`.`employer_id` = `Employer`.`id`) WHERE ((`EmployerJob`.`status` = "Active") AND (`EmployerJob`.`verified` = "1") AND (`EmployerJob`.`country_id` = 1)) AND `EmployerJob`.`state_id` > 0 GROUP BY `State`.`name` "
$error = "1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'techhot_techh.EmployerJob.state_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 673
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 263
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 407
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 812
Model::find() - CORE/cake/libs/model/model.php, line 2087
SearchJobsController::searchJobResult() - APP/controllers/search_jobs_controller.php, line 247
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
Strict Standards: Non-static method Configure::read() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 308
Strict Standards: Non-static method Configure::getInstance() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/configure.php on line 154
Strict Standards: Non-static method CakeLog::write() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 311
Strict Standards: Non-static method String::insert() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/debugger.php on line 311
Strict Standards: Non-static method CakeLog::getInstance() should not be called statically, assuming $this from incompatible context in /home/techhot/public_html/cake/libs/cake_log.php on line 230
Query: SELECT DISTINCT(`State`.`name`), `EmployerJob`.`state_id`, (SELECT count( employer_jobs.id ) FROM employer_jobs WHERE `employer_jobs`.`status` = "Active" AND `employer_jobs`.`verified` = "1" AND ( `employer_jobs`.`job_posted` BETWEEN SUBDATE( now( ) , INTERVAL 30 DAY ) AND now( ) ) AND `employer_jobs`.`state_id` = `EmployerJob`.`state_id`) as job_count, `EmployerJob`.`id` FROM `employer_jobs` AS `EmployerJob` LEFT JOIN `countries` AS `Country` ON (`EmployerJob`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`EmployerJob`.`state_id` = `State`.`id`) LEFT JOIN `job_categories` AS `JobCategory` ON (`EmployerJob`.`job_category_id` = `JobCategory`.`id`) LEFT JOIN `job_types` AS `JobType` ON (`EmployerJob`.`job_type_id` = `JobType`.`id`) LEFT JOIN `industries` AS `Industry` ON (`EmployerJob`.`industry_id` = `Industry`.`id`) LEFT JOIN `employers` AS `Employer` ON (`EmployerJob`.`employer_id` = `Employer`.`id`) WHERE ((`EmployerJob`.`status` = "Active") AND (`EmployerJob`.`verified` = "1") AND (`EmployerJob`.`country_id` = 1)) AND `EmployerJob`.`state_id` > 0 GROUP BY `State`.`name`