Forums Bug Reports Thread

Helpdesk: creating a queue fails with SQLSTATE[HY093] Invalid parameter number

Patrick Bass · Jun 6 · 18 · 1 Locked

[Major] [High Priority] [Bug Fixed] [Always Reproduces]

Oldest Newest Top

Patrick Bass 🚀 OP Jun 6, 2026 4:38pm

Where. /admin/helpdesk/queues/new

What happens. Submitting the new-queue form fails with:

Create failed: SQLSTATE[HY093]: Invalid parameter number

Reproduced on. dev.mobieus.io and support.mobieus.io.

Likely cause. Mismatch between the number of bound parameters and the placeholders in the queue INSERT (HY093 = parameter count/name mismatch).

Expected. The queue is created and the admin returns to the queue list.

Status: verified, reproducible (always). Open — not yet actioned.

Patrick Bass
@mobieus

Patrick Bass 🚀 Jun 7, 2026 10:01am

Resolved and deployed to production. Commit 0753b320f6.

Queue::create() was passing 7 bound params for 8 SQL placeholders — the :sla param for sla_plan_id was absent, causing PDO to throw HY093. Added 'sla' => sla_plan_id to the params array. Creating a queue now works.

Status: fixed. Thread closed.

Patrick Bass
@mobieus

Helpdesk: creating a queue fails with SQLSTATE[HY093] Invalid parameter number

Related Discussions