Affect version: Upgraded BioStar 2.8.9 / 2.8.10 (Previously version is 2.6.4 or lower version)
Fixed version: BioStar 2.8.12
If the BioStar 2 server has upgraded from 2.6.4 to 2.8.x version, the BioStar 2 administrator can have an issue with BioStar 2TA menu access with automatic logout.
In V2.6.4, a permission-related column (perm_id) was added to the TA in the user table, and BioStar 2 AC and BioStar 2 TA had to be synchronized for permission update. This is a problem that occurs when the TA perm_id becomes empty when synchronization is not achieved.
How to check the issue
1. Go to C:\Program Files\BioStar 2(x64)\ta\logs and confirm the recent generated log file
2. Confirm if there is the below description in the log file.
error: failed to login
{ id: undefined, message: 'perm_id is required.', message_key: 'REQUIRED_FIELD', language: 'en', status_code: 'REQUIRED_FIELD' }
{ id: undefined, message: 'perm_id is required.', message_key: 'REQUIRED_FIELD', language: 'en', status_code: 'REQUIRED_FIELD' }
3. If you have the same description in the log file, please read the following further.
How to solve the issue
UPDATE biostar_tna.sync_last_index
SET last_sync_index = 0
WHERE table_name like 't_usr';