No requests found
-
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.