codeareena

codeareena supports this item

Supported

This author's response time can be up to 2 business days.

350 comments found.

Is it possible to share the job on Social Media ?

ojchris

ojchris Purchased

I bought this script in January and up to this time there is no script update of any kind even though many features are lacking (like saved search and job alerts for saved search). Your last update was 30th November, 2016 (6 months ago today). Very unusual for a codecanyon script, has the script been abandoned? I need to see at least one update to be sure how to rate the work on this.

ojchris

ojchris Purchased

And support could be better in terms of response time (takes 5 to 15 days to get a response at times). You guys have done a good job but you need to step up in these areas (update and support) to sustain this script and increase sales.

Getting this error in admin panel, when selecting “manage skills”

A Database Error Occurred

Error Number: 1055

Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘milvol-DWASi35SNDOEIIS.pp_seeker_skills.ID’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT *, COUNT AS total_times FROM (`pp_seeker_skills`) GROUP BY `skill_name` ORDER BY `skill_name` ASC

Filename: /srv/users/serverpilot/apps/milduravolunteer/public/models/jobseeker_skills_model.php

Line Number: 67

Just need to add these four lines in jp_app/models/jobseeker_skills_model.php:

public function get_all_grouped_skills() {
    $this->db->select(', COUNT(skill_name) AS total_times');
    $this->db->from($this->table_name);
$this->db->group_by("skill_name");

 // add these two lines
 $this->db->group_by("ID");
$this->db->group_by("seeker_ID");
$this->db->order_by("skill_name", "ASC");
    $Q = $this->db->get();
    if ($Q->num_rows > 0) {
        $return = $Q->result();
    } else {
        $return = 0;
    }
    $Q->free_result();
    return $return;
}
public function get_all_grouped_skills_by_limit($end,$start) {
    $this->db->select(', COUNT(skill_name) AS total_times');
    $this->db->from($this->table_name);
$this->db->group_by("skill_name");
 //add these two lines      
 $this->db->group_by("ID");
$this->db->group_by("seeker_ID");
$this->db->order_by("total_times", "DESC");
$this->db->limit($end, $start);
    $Q = $this->db->get();
    if ($Q->num_rows > 0) {
        $return = $Q->result();
    } else {
        $return = 0;
    }
    $Q->free_result();
    return $return;
}

Also need to fix this file: jp_app/models/job_alert_model.php

Line 166 GROUP BY jaq.job_ID,jaq.ID”);

codegurru

codegurru Author Team

Dear,

As you are using the mySQL 5.7 you can disable the safe_mode.

Login into your server.

1. sudo vim /etc/mysql/conf.d/mysql.cnf 2. Scroll to the bottom of file Copy and paste the below code at the bottom of the file. [mysqld] sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

3. Save the file.

4. Restart the mySQL services. sudo service mysql restart

Other solution is you can use “ANY_VALUE()” with database field names to fix this issue.

hello, liked your product, pre-buying question, when candidates fill the apply now form, whom the query notify 1st admin or the listed company ?

Hello it will notify to listed company

if i need that form query should go to admin 1st, then admin should approve. basically i need admin should act like an agent.

yes you can modify the code to do this action. if you want our services we will do it.

HOW TO INSTALL

garimam

garimam Purchased

Hi,

We are facing error while sending email invite to Employer. However, jobseeker invite email procedure is working absolutely fine. Please let us know how to fix the issue on urgent basis.

Thanks.

Hi… can you send us your ftp details please so can check your issue, send details at: codegurru@codeareena.com

How to install in local host database name ?

i got it good

ok great, if any other issue let us know

gauravdeve

gauravdeve Purchased

hi bro there is bug with pagination on job search:

http://codeareena.com/jobportal/search-jobs/2

why pagination not shows here please fix it on urgent basis

Manage prohibited words : now working , please fix it

1: Where to change Indeed api key 2: where to update google adsence script 3: Mails not going 4: Manage prohibited words : not working 5: can invite email be in Html 6: can you update about job alerts when it will be done

by
by
by
by
by
by