Empty array in getProjectMembers() causes SQL error IN ()

Hi LazyCoders team,

Found in 1.7.63, and still present in SVN trunk: src/Controller/v3/Lazytask_ProjectController.php

Two methods guard their input like this:

php<br><br>// getProjectMembers(), line 379<br><br>if ($projectsId == '') {<br><br>// getProjectInvitedMembers(), line 3131<br><br>if ($projectsId == '') { return &#091;]; }<br><br>

Since PHP 8, &#091;] == '' is **false**, so an empty array gets past the guard. The code then runs implode(', ', array_fill(0, 0, '%s')), which gives '', and the query ends in WHERE projectMembers.project_id IN (). That is a MySQL syntax error, logged as WordPress database error You have an error in your SQL syntax ... near ')'. We saw it about 10 times a day in our PHP error log before patching.

getNoOfTasksByProject() (line 3177) already handles this correctly with a second check:

php<br><br>if ($projectsId == '') { return &#091;]; }<br><br>if (is_array($projectsId) && sizeof($projectsId) == 0) { return &#091;]; }<br><br>

**Suggested fix:** the same guard in the other two methods, or simply:

php<br><br>if (empty($projectsId)) { return &#091;]; }<br><br>

(empty() covers '', null and &#091;]. A project id of 0/'0' is not a valid id here anyway.)

We've been running the empty() version on 12 sites (PHP 8.4 and 8.5) since 2026-09-18 with no side effects. It would be great to have it upstream so we can drop our local patch.

Environment: WordPress 7.2-alpha (nightly), PHP 8.4.25 / 8.5.11, LazyTasks 1.7.63 plus premium, timetracker and whiteboard add-ons.

Thanks!