StatsLab13 - Page 16

Chappy · 06-22-2018, 09:03 AM

Just upgraded to statslab 18 and it doesn't seem to be sending e-mails any more (it did before). I unchecked and rechecked the subscribe box but still no e-mails.

Recte44 · 06-22-2018, 10:35 AM

Is this updated for OOTP19?

Recte44 · 06-30-2018, 01:23 PM

I'm getting this error:
ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table)

Looked in my database, there is a ootp_sql_admin table present

However, I still have no users in the drop down and can't do anything else at this point.

cheo25 · 07-10-2018, 10:53 PM

I keep getting the error message below on StatsLab Validator page when trying to install StatsLab

Current PHP version: 5.6.32 (must be 5.2 or greater)
OK: PHP mcrypt extension loaded.
OK: PHP cURL extension loaded.

OK: config.txt file found.
ERROR: dbopen.php file not found in SQL upload directory. Please create this file based on dbopen.php.sample.
After doing so, return to this page.

Can someone please provide an example of what the config.txt and dbopen.php files look like (minus your password)? I have the SQL upload directory created so I probably either am not pointing it to the right place or I don't have something write in the dbopen.php file.

Thanks for any help anyone can provide.

Recte44 · 07-25-2018, 02:42 PM

Quote:

Originally Posted by cheo25

I keep getting the error message below on StatsLab Validator page when trying to install StatsLab

Current PHP version: 5.6.32 (must be 5.2 or greater)
OK: PHP mcrypt extension loaded.
OK: PHP cURL extension loaded.

OK: config.txt file found.
ERROR: dbopen.php file not found in SQL upload directory. Please create this file based on dbopen.php.sample.
After doing so, return to this page.

Can someone please provide an example of what the config.txt and dbopen.php files look like (minus your password)? I have the SQL upload directory created so I probably either am not pointing it to the right place or I don't have something write in the dbopen.php file.

Thanks for any help anyone can provide.

Same issue.

Sent from my iPhone using Tapatalk

Tiesenberg · 08-16-2018, 05:38 PM

For those leagues that have players with accents in their names, do you get the accent character replaced by a "?" in StatsLab?

For example, Julian Silva's StatsLab page does not show his name properly, whereas his League Report shows up fine as seen here.

Is this a CSS fix or should I be looking elsewhere?

Thanks

Update: Configured the sql to replace accents in game and that worked. That said, if there is an easy fix within the html/css/coding of StatsLab to allow accents, that would be appreciated as well.

McLite · 01-02-2019, 01:23 PM

Just saw the StatsLab 18 patch notes. Does anyone know if this "fixed issue of 2nd and 3rd place award winners appearing as actual winners" will patch up the player cards for all previous years of the league or is it just going forward from the time of the patch?

Thanks

silverwolf · 01-02-2019, 06:58 PM

Quote:

Originally Posted by McLite

Just saw the StatsLab 18 patch notes. Does anyone know if this "fixed issue of 2nd and 3rd place award winners appearing as actual winners" will patch up the player cards for all previous years of the league or is it just going forward from the time of the patch?

Thanks

The change should work for past seasons as well. My understanding of the specific code change was to look up the winner in the league_history table, instead of getting the winner from the player_awards table, which lists the top three finishers but doesn't denote the winner.

Cooleyvol · 01-03-2019, 12:42 PM

Does anyone know if this works with v19?

andjbock · 01-10-2019, 09:14 AM

StatsLab Validator

Current PHP version: 7.0.33 (must be 5.2 or greater)
OK: PHP mcrypt extension loaded.
OK: PHP cURL extension loaded.

OK: config.txt file found.
ERROR: dbopen.php file not found in SQL upload directory. Please create this file based on dbopen.php.sample.
After doing so, return to this page.

ADMINPATH|/home/ootpbiz/mysql

PHP Code:


			
<?php
$sqlhost = 'localhost';
$sqluser = 'ootpbiz_statslab';
$sqlpass = 'omitted';
$sqldb   = 'ootpbiz_statslab';

andjbock · 01-10-2019, 09:47 AM

I moved dbopen.php in the mysql folder and it worked.

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.

fhomess · 01-10-2019, 04:26 PM

Quote:

Originally Posted by andjbock

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?

That error should ONLY show up if the ootp_sql_users table doesn't get created properly. The teams and human managers table shouldn't matter for that.

If you do have that table and would like me to look at it, IM me.

andjbock · 01-10-2019, 05:03 PM

Thanks I will

andjbock · 01-10-2019, 09:32 PM

I was able to get all of the data to populate, but only on a cached chrome page. No data on opera with a vpn session or uncached firefox.

The login page still doesn't have any users in it.
StatsLab Configuration Status: INSECUREbr/> No user table defined. Please load the human_managers table and change the commish password.

http://ootp.biz/statslab/login.php

Robmeister89 · 03-08-2019, 02:23 PM

So I just did a fresh install and I'm being told 'baseball' password is not correct?

fhomess · 03-08-2019, 05:17 PM

Quote:

Originally Posted by Robmeister89

So I just did a fresh install and I'm being told 'baseball' password is not correct?

That's still the default password. Most likely an issue with saving the password. If you need assistance IM me details and I'll take a look.

McLite · 05-11-2019, 11:06 AM

Love the program...been a staple of our online league for 50 seasons. We just upgraded to the latest version.

Two issues related to HoF voting I was hoping someone could help me with.

1. Do all batters show up as DH as ours do? In the admin screen the right position is listed and when they get inducted as well...but in the actual Voting page they don't.
2. The HoF voting section appears to still have the bug where reward winners who finished 2nd or 3rd get credited as the winner, but then the link on the HoF voting page to their StatsLab page has the correct information.

84CubsFan · 05-13-2019, 10:58 PM

Any pointers on how to fix this mess with the playoffs page?

https://www.theuqbl.com/StatsLab/playoffs.php

Three round postseason. Wild Card Round best of five. Pennant Series best of seven. Championship Series best of 7.

Statslab is reading the Pennant Series as another Wild Card round.

fhomess · 05-14-2019, 03:06 PM

Quote:

Originally Posted by McLite

Love the program...been a staple of our online league for 50 seasons. We just upgraded to the latest version.

Two issues related to HoF voting I was hoping someone could help me with.

1. Do all batters show up as DH as ours do? In the admin screen the right position is listed and when they get inducted as well...but in the actual Voting page they don't.
2. The HoF voting section appears to still have the bug where reward winners who finished 2nd or 3rd get credited as the winner, but then the link on the HoF voting page to their StatsLab page has the correct information.

#1 - Your league doesn't appear to have any fielding stats in StatsLab from prior to 2028. That would be why all the players show up as DH's.

#2 - Thanks for pointing that out. I will get it fixed in a patch.

Quote:

Originally Posted by 84CubsFan

Any pointers on how to fix this mess with the playoffs page?

https://www.theuqbl.com/StatsLab/playoffs.php

Three round postseason. Wild Card Round best of five. Pennant Series best of seven. Championship Series best of 7.

Statslab is reading the Pennant Series as another Wild Card round.

This will be fixed in the next patch.

06-22-2018, 09:03 AM	#301
Chappy Hall Of Famer Join Date: Dec 2001 Location: Raleigh, NC Posts: 2,721	Just upgraded to statslab 18 and it doesn't seem to be sending e-mails any more (it did before). I unchecked and rechecked the subscribe box but still no e-mails. __________________ NPBL - Pennsylvania Freedom AFBL - North Carolina Aviators MLB-Pro - Kansas City Royals

06-22-2018, 10:35 AM	#302
Recte44 Global Moderator Join Date: Dec 2001 Location: Oconomowoc, WI Posts: 2,754	Is this updated for OOTP19? __________________ Matt Rectenwald Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)

06-30-2018, 01:23 PM	#303
Recte44 Global Moderator Join Date: Dec 2001 Location: Oconomowoc, WI Posts: 2,754	I'm getting this error: ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table) Looked in my database, there is a ootp_sql_admin table present However, I still have no users in the drop down and can't do anything else at this point. __________________ Matt Rectenwald Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)

08-16-2018, 05:38 PM	#306
Tiesenberg Major Leagues Join Date: Nov 2002 Posts: 306	For those leagues that have players with accents in their names, do you get the accent character replaced by a "?" in StatsLab? For example, Julian Silva's StatsLab page does not show his name properly, whereas his League Report shows up fine as seen here. Is this a CSS fix or should I be looking elsewhere? Thanks Update: Configured the sql to replace accents in game and that worked. That said, if there is an easy fix within the html/css/coding of StatsLab to allow accents, that would be appreciated as well. Last edited by Tiesenberg; 08-16-2018 at 05:49 PM.

01-10-2019, 09:14 AM	#310
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	Need someone to provide an example path please StatsLab Validator Current PHP version: 7.0.33 (must be 5.2 or greater) OK: PHP mcrypt extension loaded. OK: PHP cURL extension loaded. OK: config.txt file found. ERROR: dbopen.php file not found in SQL upload directory. Please create this file based on dbopen.php.sample. After doing so, return to this page. ADMINPATH\|/home/ootpbiz/mysql PHP Code: `<?php $sqlhost = 'localhost'; $sqluser = 'ootpbiz_statslab'; $sqlpass = 'omitted'; $sqldb = 'ootpbiz_statslab';` Attached Images Last edited by andjbock; 01-10-2019 at 09:17 AM.

07-10-2018, 10:53 PM	#304
cheo25 All Star Reserve Join Date: Mar 2011 Location: Louisiana Posts: 708	I keep getting the error message below on StatsLab Validator page when trying to install StatsLab Current PHP version: 5.6.32 (must be 5.2 or greater) OK: PHP mcrypt extension loaded. OK: PHP cURL extension loaded. OK: config.txt file found. ERROR: dbopen.php file not found in SQL upload directory. Please create this file based on dbopen.php.sample. After doing so, return to this page. Can someone please provide an example of what the config.txt and dbopen.php files look like (minus your password)? I have the SQL upload directory created so I probably either am not pointing it to the right place or I don't have something write in the dbopen.php file. Thanks for any help anyone can provide.

01-02-2019, 01:23 PM	#307
McLite Minors (Single A) Join Date: Sep 2009 Posts: 64	Just saw the StatsLab 18 patch notes. Does anyone know if this "fixed issue of 2nd and 3rd place award winners appearing as actual winners" will patch up the player cards for all previous years of the league or is it just going forward from the time of the patch? Thanks

01-03-2019, 12:42 PM	#309
Cooleyvol Hall Of Famer Join Date: Dec 2001 Location: Union City, TN Posts: 6,383	Does anyone know if this works with v19?

01-10-2019, 09:47 AM	#311
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	I moved dbopen.php in the mysql folder and it worked.

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,621	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.

01-10-2019, 05:03 PM	#314
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	Thanks I will

01-10-2019, 09:32 PM	#315
andjbock Hall Of Famer Join Date: Jul 2003 Location: Somerville, MA, USA Bats: Right Throws: Left Posts: 3,621	I was able to get all of the data to populate, but only on a cached chrome page. No data on opera with a vpn session or uncached firefox. The login page still doesn't have any users in it. StatsLab Configuration Status: INSECUREbr/> No user table defined. Please load the human_managers table and change the commish password. http://ootp.biz/statslab/login.php Last edited by andjbock; 01-10-2019 at 11:34 PM.

03-08-2019, 02:23 PM	#316
Robmeister89 Minors (Double A) Join Date: Nov 2015 Posts: 159	So I just did a fresh install and I'm being told 'baseball' password is not correct?

05-11-2019, 11:06 AM	#318
McLite Minors (Single A) Join Date: Sep 2009 Posts: 64	Love the program...been a staple of our online league for 50 seasons. We just upgraded to the latest version. Two issues related to HoF voting I was hoping someone could help me with. 1. Do all batters show up as DH as ours do? In the admin screen the right position is listed and when they get inducted as well...but in the actual Voting page they don't. 2. The HoF voting section appears to still have the bug where reward winners who finished 2nd or 3rd get credited as the winner, but then the link on the HoF voting page to their StatsLab page has the correct information.

05-13-2019, 10:58 PM	#319
84CubsFan Major Leagues Join Date: Mar 2003 Posts: 376	Any pointers on how to fix this mess with the playoffs page? https://www.theuqbl.com/StatsLab/playoffs.php Three round postseason. Wild Card Round best of five. Pennant Series best of seven. Championship Series best of 7. Statslab is reading the Pennant Series as another Wild Card round.