This page contains the answers to common troubleshooting questions within StatsLab.
No Users in Login Dropdown
If you are unable to login because there are no users in the login dropdown, there are several possible reasons for this. Regardless of the reason, the fix is relatively simple:
- Login to phpMyAdmin or whatever database admin tool you're using for MySQL
- Connect to your StatsLab database
- Drop the human_managers and ootp_sql_users tables
- Open StatsLab in your browser
- Access the sql_file_load.php page
- Load the leagues, sub_leagues, divisions, teams, and team_relations tables
- Load the human_managers table (do this after loading the others)
- You should now be able to access the login page with the drop down populated.
Note that this will not erase user settings or change user passwords.
User Password Doesn't Work
If one of your users is unable to access StatsLab because their password no longer works or they can't remember it, the Admin page has an option to reset the user's password to the default password.
Commish Password Doesn't Work
If the commish password no longer works, the easiest solution is to have another user with commish access reset that user's password. If no other commish users exists, it is possible to use phpMyAdmin to edit the human_managers table for a user whose password works, to make them a commish temporarily. Browse the table to find that user's record, then edit the is_commish field to 1. When done, set it back to 0.
User Is Unable to Add Players to Their Awards Ballot