StatsLab13

[cody8200]

Probably not the solution you are looking for but I pay 2 bucks per month for my host and it handles my sql files loads like a champ all at once. It's belira.info.

[Halara]

Originally Posted by cody8200

Probably not the solution you are looking for but I pay 2 bucks per month for my host and it handles my sql files loads like a champ all at once. It's belira.info.

It would have been a great solution back when I was trying to figure out which host to use. I think godaddy has me on the hook for two years though, so if I can find a solution that involves using what I've already paid for, that'd be ideal

That said, at $2 a month it's a solid backup plan.

Thanks Cody!

[fhomess]

I've heard of many issues with StatsLab and GoDaddy. If you have the ability to access the server command line, I'd highly recommend using the server side SQL upload routine. That goes for EVERY league using StatsLab, actually. It's much faster and you never have to worry about timing out the browser.

[Halara]

Originally Posted by fhomess

I've heard of many issues with StatsLab and GoDaddy. If you have the ability to access the server command line, I'd highly recommend using the server side SQL upload routine. That goes for EVERY league using StatsLab, actually. It's much faster and you never have to worry about timing out the browser.

Thanks Frank! I was going to ask about this. I know that I can get ssh access to godaddy if I jump through some hoops. Lets say I do that and I use the server side SQL upload routine to do this I assume StatsLab will not be aware that the DB has been updated since I'd be doing that outside of StatsLab. Would I still be able to generate park factors and win shares if StatsLab doesn't know that my DB has been updated?

Thanks,
Justin

[Stu]

Originally Posted by WillieMaysHayes

Just one more problem - I have a draft with no timer between about 10PM and 7AM. 3 Hour pick timer. I had my schedule set and everything was correct but when someone makes a pick at 11PM, the next pick is due at 2AM instead of 10AM. It's like that pick resets the whole schedule of the draft.

We're having this issue as well. The timer seems to run all the time regardless of the timer settings.

[WillieMaysHayes]

Originally Posted by cody8200

Probably not the solution you are looking for but I pay 2 bucks per month for my host and it handles my sql files loads like a champ all at once. It's belira.info.

Thanks for that - might switch over my host next time I'm up for a resubscribe.

[kleric]

My host updated my PHP and I now get these errors/warnings on every page in the site:

Deprecated: mktime() [function.mktime]: The is_dst parameter is deprecated in /home/kleric/monkeytorium.org/ttbl/StatsLab/adodb-time.inc.php on line 732

Deprecated: gmmktime() [function.gmmktime]: The is_dst parameter is deprecated in /home/kleric/monkeytorium.org/ttbl/StatsLab/adodb-time.inc.php on line 732

Is there a known fix for this?

[fhomess]

What version of StatsLab and what version of PHP are you running. I thought I had removed all references to adodb in the current released versions of SL.

[kleric]

Originally Posted by fhomess

What version of StatsLab and what version of PHP are you running. I thought I had removed all references to adodb in the current released versions of SL.

StatsLab SQL Utilities for OOTP13 v.3.0.12
PHP Version 5.3.27

And for what it's worth, I did go ahead and just edit the one line mentioned in my original post and it seems to work fine now.

[WillieMaysHayes]

Originally Posted by Stu

We're having this issue as well. The timer seems to run all the time regardless of the timer settings.

Did you get a fix for this? I'm having the same problem. The draft just doesn't shut off when it's supposed to.

[Stu]

Originally Posted by WillieMaysHayes

Did you get a fix for this? I'm having the same problem. The draft just doesn't shut off when it's supposed to.

No, we just encouraged people to use draft lists and corrected the timer manually as best we could.

[WillieMaysHayes]

Originally Posted by Stu

No, we just encouraged people to use draft lists and corrected the timer manually as best we could.

I have been pausing the draft timer at the end of the night. Requires you to go in every night and morning (to turn the draft back on), but that's been my workaround.

[fhomess]

Hi folks,

I believe I've fixed the draft scheduling issue and date function issue that you guys are talking about. As such, I'm releasing to you patch 13, which includes a few extras.

StatsLab v3.0.13 Fixes and Enhancements:
- Fixed issue with deprecated function in adodb date library
- Fixed issue with draft scheduler continuing to run after hours
- Added Awards History pages to the History module
- Added Annual Leaderboards to the History module's leaderboards pages - will display each season's top 10 finishers
- The Teams Stats page (under the Season module) now includes breakout of team record based on runs scored and allowed.
- Other minor fixes and improvements

The first post of this thread has been updated to reflect this latest release.

[cody8200]

The new update really is awesome! Thanks again for doing so much work on this amazing utility. The new awards page is incredible!

[McLite]

Love it...what would our online league be without it...boring!

Had a question. Since we've updated to OOTP14 and Statslab 13 the time it takes for the SQL dump for MySQL has gone from around 2-3 minutes to 10 minutes or more. Not a huge deal but just curious if we are doing something wrong. My only thought is that now it shows we have Statslab for HS through MLB which is seven levels in our league...and I don't recall it being like that in Statslab 12. If that is new is there a way just to go back to the MLB level only or would that not matter.

[fhomess]

Matt... I think it may just be nomenclature, but make sure you have the StatsLab version for OOTP14 rather than the one for use with OOTP13. There are some changes in the SQL dump in OOTP14 that StatsLab13 doesn't take into account. The version at the bottom of the StatsLab pages should say "StatsLab SQL Utilities for OOTP14 v.3.0.13".

Beyond that, the SQL load is a little bit larger in OOTP14, but not significantly so. The fact that you can review all the different leagues in StatsLab shouldn't affect the load much, either, as that data was always being loaded into the database just not being used.

[Dbobola22]

I'm not sure why I keep getting this error:

StatsLab Configuration Status: INSECUREbr/> No user table defined. Please load the human_managers table and change the commish password.


I go and configure SQL Dump and all human_manager boxes are checked.

Any ideas?

[fhomess]

Originally Posted by Dbobola22

I'm not sure why I keep getting this error:

StatsLab Configuration Status: INSECUREbr/> No user table defined. Please load the human_managers table and change the commish password.


I go and configure SQL Dump and all human_manager boxes are checked.

Any ideas?

Well, you only need the basic one, but something about it is not getting loaded. Does human_managers.mysql.sql contain any records?

[McLite]

Originally Posted by fhomess

Matt... I think it may just be nomenclature, but make sure you have the StatsLab version for OOTP14 rather than the one for use with OOTP13. There are some changes in the SQL dump in OOTP14 that StatsLab13 doesn't take into account. The version at the bottom of the StatsLab pages should say "StatsLab SQL Utilities for OOTP14 v.3.0.13".

Beyond that, the SQL load is a little bit larger in OOTP14, but not significantly so. The fact that you can review all the different leagues in StatsLab shouldn't affect the load much, either, as that data was always being loaded into the database just not being used.

Thanks for the reply. We do have the latest and appreciate all your hard work. I can live with the extra 5 minutes or so, just wanted to make sure I wasn't doing anything wrong.

[Dbobola22]

Not sure what's still going on but when I go to log in there are no names listed. I have done the validator.php and everything is successful but names will not show up. I have checked the human_manager mysql and there is text in there.

Anyone have any ideas? Been struggling with this for over a week!

Below is a copy of my validator report:

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

OK: config.txt file found.
OK: dbopen.php file found in SQL upload directory.

OK: divisions.mysql.sql found in SQL upload directory.
OK: games.mysql.sql found in SQL upload directory.
OK: games_score.mysql.sql found in SQL upload directory.
OK: human_managers.mysql.sql found in SQL upload directory.
OK: league_playoffs.mysql.sql found in SQL upload directory.
OK: leagues.mysql.sql found in SQL upload directory.
OK: parks.mysql.sql found in SQL upload directory.
OK: players.mysql.sql found in SQL upload directory.
OK: players_awards.mysql.sql found in SQL upload directory.
OK: players_batting.mysql.sql found in SQL upload directory.
OK: players_career_batting_stats.mysql.sql found in SQL upload directory.
OK: players_career_fielding_stats.mysql.sql found in SQL upload directory.
OK: players_career_pitching_stats.mysql.sql found in SQL upload directory.
OK: players_contract.mysql.sql found in SQL upload directory.
OK: players_contract_extension.mysql.sql found in SQL upload directory.
OK: players_fielding.mysql.sql found in SQL upload directory.
OK: players_game_batting.mysql.sql found in SQL upload directory.
OK: players_game_pitching_stats.mysql.sql found in SQL upload directory.
OK: players_league_leader.mysql.sql found in SQL upload directory.
OK: players_pitching.mysql.sql found in SQL upload directory.
OK: players_roster_status.mysql.sql found in SQL upload directory.
OK: players_streak.mysql.sql found in SQL upload directory.
OK: sub_leagues.mysql.sql found in SQL upload directory.
OK: team_batting_stats.mysql.sql found in SQL upload directory.
OK: team_fielding_stats_stats.mysql.sql found in SQL upload directory.
OK: team_financials.mysql.sql found in SQL upload directory.
OK: team_history.mysql.sql found in SQL upload directory.
OK: team_history_batting_stats.mysql.sql found in SQL upload directory.
OK: team_history_fielding_stats_stats.mysql.sql found in SQL upload directory.
OK: team_history_financials.mysql.sql found in SQL upload directory.
OK: team_history_pitching_stats.mysql.sql found in SQL upload directory.
OK: team_history_record.mysql.sql found in SQL upload directory.
OK: team_pitching_stats.mysql.sql found in SQL upload directory.
OK: team_record.mysql.sql found in SQL upload directory.
OK: team_relations.mysql.sql found in SQL upload directory.
OK: team_roster.mysql.sql found in SQL upload directory.
OK: teams.mysql.sql found in SQL upload directory.
OK: 37 of 37 SQL files present.

***** MySQL Connection Errors ****************************************
*
************************************************** *****************
(If the above section is blank, you've got a valid connection to your database)