• Hi there,

    All of the leave requests under WPHR Leave > Requests have vanished yet we can see them on the calendar under WPHR Leave > Calendar. I have installed Query monitor and I see that there are 3 database errors relating to WPHR. I’ll paste the errors below:

    SELECT COUNT(id) as num
    FROM wpqa_wphr_hr_leave_requests
    WHERE status = 1
    AND is_archived = 0 ''
    GROUP BY status;	
    wphr_hr_leave_get_requests_count()
    Plugin: wp-hr-manager-premium	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' GROUP BY status' at line 1	1064
    SELECT status, COUNT(id) as num
    FROM wpqa_wphr_hr_leave_requests
    WHERE status != 0 ''
    GROUP BY status;	
    wphr_hr_leave_get_requests_count()
    Plugin: wp-hr-manager-premium	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''' GROUP BY status' at line 1	1064
    SELECT req.id, req.user_id, u.display_name, req.policy_id, pol.name as policy_name, req.status, req.reason, req.comments, req.created_on, req.days, req.start_date, req.end_date
    FROM %1
    LEFT JOIN wpqa_wphr_hr_leave_policies AS pol
    ON pol.id = req.policy_id
    LEFT JOIN wpqa_users AS u
    ON req.user_id = u.ID %2
    ORDER BY %3 %4
    LIMIT 0, 0	
    wphr_hr_get_leave_requests()
    Plugin: wp-hr-manager-premium	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '%1 LEFT JOIN wpqa_wphr_hr_leave_policies AS pol ON pol.id = req.policy_id LEFT J' at line 1	1064
Viewing 4 replies - 1 through 4 (of 4 total)
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘No requests found’ is closed to new replies.