SQLSTATE [HY093]: Invalid parameter number: mixed named and positional parameters

I’m having a problem registering a user and getting an error [SQLSTATE[HY093]: Invalid parameter number: mixed named and positional parameters

> select * from `verifications` where
> `{"role_name":"user","mobile":null,"email":"tesst@gmail`.`com","full_name":"test","status":"pending","access_content":true,"affiliate":false,"timezone":"Asia/Bangkok","created_at":1697102421,"id":1062}`
> = email and `expired_at` > 1697102421 and (`user_id` is null or exists (select * from `users` where `verifications`.`user_id` =
> `users`.`id`)) limit 1

(https://i.stack.imgur.com/YWiwN.png)[query error screen shot][1]
i use“`
Rocket LMS – Learning Management & Academy Script

error detail : https://flareapp.io/share/KPgWDwJP


Current PHP version 8.0


Can anyone help me shed some light upon this situation?


  [1]: https://i.stack.imgur.com/Y0ik9.png