Closed
Description
Is it possible to use views for login and also enable register end-point? I've successfully used views to login active users but the register endpoint is now throwing error.
<b>Fatal error</b>: Uncaught PDOException: SQLSTATE[HY000]: General error: 1471 The target table active_users of the INSERT is not insertable-into in ...
My view contains a join between the users table and roles table
select id, username, password,is_active, role_id
from users left join roles on roles.id = users.role_id
where is_active = 1
and role_id <> 0
Originally posted by @dswdcares in #892 (comment)