Hi @Aleem,
I’m sorry to hear that!
You can check whether there are any journals without managers using the following database query (on your pre-upgrade database):
SELECT j.path, j.journal_id FROM journals j LEFT JOIN roles r ON (r.journal_id = j.journal_id AND r.role_id=16) GROUP BY j.journal_id HAVING count(r.role_id) = 0;
If any journals are listed, then they have no managers. You can correct this by choosing a user from the users
table, and adding a new role with its user_id
:
INSERT INTO roles (journal_id, user_id, role_id) VALUES (123, 456, 16);
…with the journal_id
from the first query in place of 123
, and the user_id
of the person you want to designate as manager in place of 456
.
Regards,
Alec Smecher
Public Knowledge Project Team