Home | Webstore
Latest News: OOTP 27 Buy Now - FHM 12 Available - OOTP Go! 27 Available

Out of the Park Baseball 27 Buy Now!

  

Go Back   OOTP Developments Forums > Prior Versions of Our Games > Earlier versions of Out of the Park Baseball > Earlier versions of OOTP: Online Leagues
Reload this Page MySQL/PHP reports
Register FAQ Calendar Today's Posts Search

Reply
 
Thread Tools
Old 07-18-2011, 04:44 AM   #1
hbomb
Minors (Double A)
 
hbomb's Avatar
 
Join Date: Jul 2008
Location: Toronto Canada
Posts: 155
MySQL/PHP reports
I'm wondering if there's any other commish out there that can tell me what's going wrong with my reports using the new format. I can upload the file, extract the data, but there's no content under the league menu

Here's the output:
Please wait...
Command: tar xzf '/home/wikedne1/public_html/bigleagues.org/game/lgreports/reports.tar.gz' 2>&1:
Successfully unpacked the reports.tar.gz file...

Opened reports file reports_1.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_2.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_3.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_4.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_5.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_6.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_7.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_8.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_9.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_10.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_11.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_12.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_13.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_14.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_15.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_16.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_17.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_18.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_19.txt...Valid lines = 75, Invalid lines = 0, Inserts = 0, Updates = 75, Errors = 0, Success = 75

Valid lines = 9075, Invalid lines = 0, Inserts = 0, Updates = 9075, Errors = 0, Success = 9075

Here's what I mean - try clicking on any report here:
BNN Home Page
hbomb is offline   Reply With Quote
Old 07-18-2011, 05:17 AM   #2
Andreas Raht
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,992
Please post the content of the .htaccess file here.
Andreas Raht is offline   Reply With Quote
Old 07-18-2011, 05:28 AM   #3
Tony M
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,156
I've had the same issue. I went back to uploading file by file in the end.

.htaccess contains

RewriteEngine on
RewriteOptions MaxRedirects=1

RewriteRule ^box_scores/(.*)\.html$ '/ueba/reports/index.php?type=e&name=$1' [L]
RewriteRule ^coaches/(.*)\.html$ '/ueba/reports/index.php?type=g&name=$1' [L]
RewriteRule ^game_logs/(.*)\.html$ '/ueba/reports/index.php?type=f&name=$1' [L]
RewriteRule ^history/(.*)\.html$ '/ueba/reports/index.php?type=h&name=$1' [L]
RewriteRule ^leagues/(.*)\.html$ '/ueba/reports/index.php?type=b&name=$1' [L]
RewriteRule ^players/(.*)\.html$ '/ueba/reports/index.php?type=d&name=$1' [L]
RewriteRule ^teams/(.*)\.html$ '/ueba/reports/index.php?type=c&name=$1' [L]
__________________
This signature is intentionally blank
Tony M is offline   Reply With Quote
Old 07-18-2011, 05:47 AM   #4
Tony M
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,156
I've got it to at least not give a 404 error (it's redirecting ok now)

but now I get

Report 'league_100_home\\\'' (type 'b') not found in database

I don't know why the \\\ is appearing in the name
__________________
This signature is intentionally blank
Tony M is offline   Reply With Quote
Old 07-18-2011, 06:07 AM   #5
Tony M
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,156
Quote:
Originally Posted by hbomb View Post
I'm wondering if there's any other commish out there that can tell me what's going wrong with my reports using the new format. I can upload the file, extract the data, but there's no content under the league menu

Here's the output:
Please wait...
Command: tar xzf '/home/wikedne1/public_html/bigleagues.org/game/lgreports/reports.tar.gz' 2>&1:
Successfully unpacked the reports.tar.gz file...

Opened reports file reports_1.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_2.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_3.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_4.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_5.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_6.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_7.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_8.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_9.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_10.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_11.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_12.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_13.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_14.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_15.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_16.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_17.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_18.txt...Valid lines = 500, Invalid lines = 0, Inserts = 0, Updates = 500, Errors = 0, Success = 500
Opened reports file reports_19.txt...Valid lines = 75, Invalid lines = 0, Inserts = 0, Updates = 75, Errors = 0, Success = 75

Valid lines = 9075, Invalid lines = 0, Inserts = 0, Updates = 9075, Errors = 0, Success = 9075

Here's what I mean - try clicking on any report here:
BNN Home Page
Your problem is the reports path field. If you click on a report it gives the following error

The requested URL /bigleagues.org/game/lgreports/index.php was not found on this server.

So it's looking for I believe http://www.bigleagues.org/game/lgrep...orts/index.php

I've got the following in my .htaccess

RewriteRule ^box_scores/(.*)\.html$ '/ueba/reports/index.php?type=e&name=$1' [L]
RewriteRule ^coaches/(.*)\.html$ '/ueba/reports/index.php?type=g&name=$1' [L]
RewriteRule ^game_logs/(.*)\.html$ '/ueba/reports/index.php?type=f&name=$1' [L]
RewriteRule ^history/(.*)\.html$ '/ueba/reports/index.php?type=h&name=$1' [L]
RewriteRule ^leagues/(.*)\.html$ '/ueba/reports/index.php?type=b&name=$1' [L]
RewriteRule ^players/(.*)\.html$ '/ueba/reports/index.php?type=d&name=$1' [L]
RewriteRule ^teams/(.*)\.html$ '/ueba/reports/index.php?type=c&name=$1' [L]

and if you look at yours you've probably got /bigleagues.org/ at the start of each address after .html$ - you need to remove that I believe.
__________________
This signature is intentionally blank
Tony M is offline   Reply With Quote
Old 07-18-2011, 08:58 AM   #6
Andreas Raht
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,992
It works well here: BNN Home Page

When I log into that server via FTP, the base directory contains the /TLB directory. The .htaccess file looks like this:

PHP Code:
RewriteEngine on
RewriteOptions MaxRedirects=1

RewriteRule ^box_scores/(.*)\.html$ '/TLB/reports/index.php?type=e&name=$1' [L]
RewriteRule ^coaches/(.*)\.html$ '/TLB/reports/index.php?type=g&name=$1' [L]
RewriteRule ^game_logs/(.*)\.html$ '/TLB/reports/index.php?type=f&name=$1' [L]
RewriteRule ^history/(.*)\.html$ '/TLB/reports/index.php?type=h&name=$1' [L]
RewriteRule ^leagues/(.*)\.html$ '/TLB/reports/index.php?type=b&name=$1' [L]
RewriteRule ^players/(.*)\.html$ '/TLB/reports/index.php?type=d&name=$1' [L]
RewriteRule ^teams/(.*)\.html$ '/TLB/reports/index.php?type=c&name=$1' [L] 
Andreas Raht is offline   Reply With Quote
Old 07-18-2011, 09:14 AM   #7
Andreas Raht
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,992
Quote:
Originally Posted by hbomb View Post
I'm wondering if there's any other commish out there that can tell me what's going wrong with my reports using the new format. I can upload the file, extract the data, but there's no content under the league menu
....

Here's what I mean - try clicking on any report here:
BNN Home Page
When I try to open your index.php page directly, I get an error message:

PHP Code:
http://bigleagues.org/game/lgreports/index.php 
http://bigleagues.org/game/lgreports/index.php

I guess there's a typo in your dbconfig.php... a missing " or ; or something like that.
Andreas Raht is offline   Reply With Quote
Old 07-18-2011, 09:32 AM   #8
Andreas Raht
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,992
Quote:
Originally Posted by Tony M View Post
I've got it to at least not give a 404 error (it's redirecting ok now)

but now I get

Report 'league_100_home\\\'' (type 'b') not found in database

I don't know why the \\\ is appearing in the name
Works: BNN Home Page
Andreas Raht is offline   Reply With Quote
Old 07-18-2011, 09:43 AM   #9
Tony M
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,156
Quote:
Originally Posted by Andreas Raht View Post
I've been editing the .htaccess to get it to work and it does now. I took out all of the ' surrounding the redirect path.
__________________
This signature is intentionally blank
Tony M is offline   Reply With Quote
Old 07-18-2011, 06:08 PM   #10
hbomb
Minors (Double A)
 
hbomb's Avatar
 
Join Date: Jul 2008
Location: Toronto Canada
Posts: 155
Quote:
Originally Posted by Andreas Raht View Post
Please post the content of the .htaccess file here.
RewriteEngine on
RewriteOptions MaxRedirects=1

RewriteRule ^box_scores/(.*)\.html$ '/bigleagues.org/game/lgreports/index.php?type=e&name=$1' [L]
RewriteRule ^coaches/(.*)\.html$ '/bigleagues.org/game/lgreports/index.php?type=g&name=$1' [L]
RewriteRule ^game_logs/(.*)\.html$ '/bigleagues.org/game/lgreports/index.php?type=f&name=$1' [L]
RewriteRule ^history/(.*)\.html$ '/bigleagues.org/game/lgreports/index.php?type=h&name=$1' [L]
RewriteRule ^leagues/(.*)\.html$ '/bigleagues.org/game/lgreports/index.php?type=b&name=$1' [L]
RewriteRule ^players/(.*)\.html$ '/bigleagues.org/game/lgreports/index.php?type=d&name=$1' [L]
RewriteRule ^teams/(.*)\.html$ '/bigleagues.org/game/lgreports/index.php?type=c&name=$1' [L]
hbomb is offline   Reply With Quote
Old 07-18-2011, 06:16 PM   #11
hbomb
Minors (Double A)
 
hbomb's Avatar
 
Join Date: Jul 2008
Location: Toronto Canada
Posts: 155
here's the DB config... I changed the password to a false one, for display:

<?php
$db_host = "localhost"; // MySQL Hostname, usually localhost
$db_name = "wikedne1_fullcount12"; // MySQL Database
$db_user = "wikedne1_full12u"; // MySQL Username
$db_pass = "J777CgdkyX7o"; // MySQL Password
$db_port = "3306"; // MySQL Port, usually 3306
$db_table = "reports"; // Name of table for reports data
$reports_url = "http://bigleagues.org/game/lgreports/"; // URL of reports web space, for example: http://www.your-domain.com/your-league/reports/
$reports_url_path = "/bigleagues.org/game/lgreports/"; // Path from document root to reports folder, i.e. if the URL is http://www.your-domain.com/your-league/reports/, the path is /your-league/reports/
?>
hbomb is offline   Reply With Quote
Old 07-18-2011, 08:10 PM   #12
hbomb
Minors (Double A)
 
hbomb's Avatar
 
Join Date: Jul 2008
Location: Toronto Canada
Posts: 155
1. Do I need to edit .htaccess in the lgreports folder, or the core .htaccess on bigleagues.org? (see above for example)
2. Does my lgreports folder need to be 777 write permission? currently 755

Anything else you guys can think of?
hbomb is offline   Reply With Quote
Old 07-19-2011, 05:24 AM   #13
Andreas Raht
Administrator
 
Andreas Raht's Avatar
 
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,992
Quote:
Originally Posted by hbomb View Post
$reports_url = "http://bigleagues.org/game/lgreports/"; // URL of reports web space, for example: http://www.your-domain.com/your-league/reports/
$reports_url_path = "/bigleagues.org/game/lgreports/"; // Path from document root to reports folder, i.e. if the URL is http://www.your-domain.com/your-league/reports/, the path is /your-league/reports/
?>
The $reports_url_path is wrong I guess. It should not contain the domain. Should be /game/lgreports/

Only edit the .htaccess file in the reports folder! Do not edit any other .htaccess file.

The reports folder should have permissions set to 777 because otherwise the unpack script cannot unpack the tar.gz file.

Try this for your htaccess file:

PHP Code:
RewriteEngine on
RewriteOptions MaxRedirects=1

RewriteRule ^box_scores/(.*)\.html$ /game/lgreports/index.php?type=e&name=$1 [L]
RewriteRule ^coaches/(.*)\.html$ /game/lgreports/index.php?type=g&name=$1 [L]
RewriteRule ^game_logs/(.*)\.html$ /game/lgreports/index.php?type=f&name=$1 [L]
RewriteRule ^history/(.*)\.html$ /game/lgreports/index.php?type=h&name=$1 [L]
RewriteRule ^leagues/(.*)\.html$ /game/lgreports/index.php?type=b&name=$1 [L]
RewriteRule ^players/(.*)\.html$ /game/lgreports/index.php?type=d&name=$1 [L]
RewriteRule ^teams/(.*)\.html$ /game/lgreports/index.php?type=c&name=$1 [L] 
Andreas Raht is offline   Reply With Quote
Old 07-19-2011, 06:11 AM   #14
hbomb
Minors (Double A)
 
hbomb's Avatar
 
Join Date: Jul 2008
Location: Toronto Canada
Posts: 155
Thanks Andreas, that did it.
hbomb is offline   Reply With Quote
Reply

Bookmarks

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -4. The time now is 10:03 AM.

Contact Us - Out of the Park Developments - Privacy Statement - Top
 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

  

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2026, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments