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]
Code | Context
            $out = null;
            if ($error) {
                trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);
$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

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`   

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]
Code | Context
            $out = null;
            if ($error) {
                trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);
$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

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`   

I.T.Professional Job Search Career Tools Tech Forum Blog Advertise Tech TV

Employer Login Post Jobs Products

Search Again

• Match Any words Match All Words
• Advanced By Company Rss

• 
• 

• View: Summary View

Search

Advanced Search By:

• Country:

  UNDO United States

• City:

  UNDO Alton

- Hide Refinements:

• Date Posted
  1 7 10 14 21 30
• + Country
  • » Canada(0)
  • » United States(0)
• + City
  • » Alabaster(0)
  • » Fleming Island(0)
  • » Allgood(0)
  • » Alton(0)
  • » Concord(0)
  • » Los Angeles(0)
  • » Atlanta(0)
  • » florida(0)
  • » Albama city(0)
  • » Nagpur(0)
  • » arkansas(0)
• + State
• + Company
• + Job Type
  • » Regular1

Job	Company	Location	Date
No Record Found

Ads by google comes here.........

Job Search

• By Company
• By Location
• Advanced

Company Profiles

• Profiles
• TV Profiles

Career Tools

• Career Tools

Help

• FAQs

Company

• About Us
• Contact Us
• Site Map

Community

• Forum
• Career Tools

Feedback

• From Job Seeker
• Success Stories

Stay In Touch

• 
• 
• 
• 
• 

Copyright © 2010 TechHotBed.com. All Right Reserved.. Website Privacy | Terms & Conditions