OOTP Developments Forums - View Single Post

andjbock · 01-10-2019, 11:37 AM

Anyone have any additional tips on the above error?
-I verified I am a Commish via the human_managers report (I am the only manager as well since this is a solo fic league).

-I have gone through the steps below.

-The teams & human_managers don't show up in phpMyAdmin like the ootp_sql_uers table does. Can the issue be related to this?

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. First, make sure that you have assigned at least one human GM to a team (a commish who manages no teams is not sufficient). Then, 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.

01-10-2019, 11:37 AM	#312
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,637	StatsLab Configuration Status: INSECUREbr/> No user table defined. Please load the human_managers ta Anyone have any additional tips on the above error? -I verified I am a Commish via the human_managers report (I am the only manager as well since this is a solo fic league). -I have gone through the steps below. -The teams & human_managers don't show up in phpMyAdmin like the ootp_sql_uers table does. Can the issue be related to this? 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. First, make sure that you have assigned at least one human GM to a team (a commish who manages no teams is not sufficient). Then, 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.