install\schemas\schema_data.sql line 552 assigns f_subscribe to the read only forum role. That role is then assigned to guests, but guests can't actually receive notifications and they can't subscribe in the interface.

f_subscribe should not be added to Read Only role during installation.

Also the LIKE part of the WHERE clause is unnecessary since auth_option is already using an IN rather than NOT IN.