|
||||
|
08-25-2009, 01:10 AM | #101 |
Minors (Double A)
Join Date: Jun 2009
Posts: 149
|
I'm getting these errors when I click the load SQL Files button on the admin page.
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.../ootpsqlou/db_update.php on line 152 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.../ootpsqlou/db_update.php on line 193 Warning: Cannot modify header information - headers already sent by (output started at /home/.../ootpsqlou/db_update.php:152) in /home/.../ootpsqlou/db_update.php on line 200 It tells me this: LOAD STATUS: No files loaded! You may have one of the following problems: 1. The path to the SQL files is incorrect. 2. The SQL files are not uploaded to the server. 3. The SQL files are older than the last time you loaded them. Review/delete sqlloadlog.txt in your admin directory. None of the 3 are the problem. The path to SQL is fine, as far as I can tell. The program is able to write to it and see it. The SQL files are uploaded to the proper directory. The SQL files are not old - I've only uploaded one batch and haven't been able to load it. Last edited by BobDylanRH; 08-25-2009 at 03:47 AM. |
08-26-2009, 11:14 AM | #102 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Are you running this on your local PC, and if so, are you running a web server with PHP installed?
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
08-26-2009, 11:16 AM | #103 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
|
08-26-2009, 11:45 AM | #104 | ||
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
Quote:
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. Last edited by fhomess; 08-26-2009 at 12:26 PM. |
||
08-27-2009, 07:13 PM | #105 |
Minors (Double A)
Join Date: Jun 2009
Posts: 149
|
Alright, I think I managed to fix the fetch errors. They went away when I fixed the league ID.
Now I have an error at the top of the page in a red block that reads: ERROR: OOTP SQL Utilities not configured properly (no lgSettings.txt) EDIT: I got rid of the error by manually creating a lgSettings.txt file and dumping it into the settings folder. I don't believe, however, that it's being written to because the admin panel doesn't save the settings I enter in. I check all the boxes, hit save, and when the page refreshes, the links aren't in the nav bar. The directory has any permissions it would need. Heck, I don't even know if the lgSettings.txt file has anything to do with that, but that's the issue I face now. If there is a simple solution, I'll be grateful. Otherwise I'm just going to keep fooling with it until I figure out what the problem is. Last edited by BobDylanRH; 08-27-2009 at 07:23 PM. |
08-27-2009, 07:57 PM | #106 |
Minors (Double A)
Join Date: Jun 2009
Posts: 149
|
fhomess,
Your inbox is full. Can't respond to PM. |
08-27-2009, 10:02 PM | #107 |
Minors (Double A)
Join Date: Jun 2009
Posts: 149
|
Back.
I think I've got just about everything fixed. There are only small issues now. The two main issues: The export tracker error -- ERROR: No League File Found at: "/home/.../leaguefile/MLB.lg.tar.gz" /home/.../csv/ootpsqlSettings.txt The league file is there, but does not have .lg on its extension. Do I need to extract the archive in the server? Second... The manager page doesn't read from the profiles. And then some smaller issues with formatting... The admin pages have no header. The text on these pages also isn't correct, and is displaying in Times New Roman. The manager page also has formatting issues similar to the admin pages. I imagine this goes hand in hand with it not reading from the profiles. Also, the actual profile pages draw the wrong images on the top left hand side. |
08-27-2009, 10:20 PM | #108 |
Minors (Double A)
Join Date: Feb 2002
Location: Ashburn, VA
Posts: 136
|
Hey Fhom - your PM inbox is full so can't respond to your answer to my earlier setup question.
I had schedule the regular historical import ammy draft for 3/1, and then on 3/2 done a release all and reschedule a fantasy draft. Looks like a bug with the file keeping the original 3/1 date is making my sql file have the 3/1 date still. Is it possible to manually edit that SQL file to change to date and get it working? Thanks! Eric
__________________
Join the CBL Rewind, a great historical OOTP 15 league! http://thecblonline.com/cblr/cblr.php Commish : wedgeeric@aol.com Join the Computer Baseball League, one of the longest running OOTP leagues in history (OOTP5)! http://www.thecblonline.com/cbl.php |
08-28-2009, 01:18 PM | #109 | ||
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
Quote:
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
||
08-28-2009, 01:20 PM | #110 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Yeah, you can edit it. PM sent with instructions on how to do this. As long as the players are flagged as draft eligible, they'll show up in the draft warroom. I've never tested the util with inaugural drafts, though, so I'm not 100% sure if the database is set that way.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
08-28-2009, 02:21 PM | #111 | |
Minors (Double A)
Join Date: Jun 2009
Posts: 149
|
Quote:
On the formatting issues, unfortunately I haven't worked them out. I sent you a PM with the login information to take a closer look. |
|
08-28-2009, 05:42 PM | #112 | |
Hall Of Famer
Join Date: Aug 2002
Location: Rapid City, SD
Posts: 3,639
|
Quote:
Thanks.
__________________
培傑西 I have never taken a lesson on how to talk on TV in my life. - Tim McCarver Guns have only two enemies; rust and liberals. The world is a comedy to those that think; a tragedy to those that feel. |
|
08-28-2009, 06:07 PM | #113 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
I'm aware of a couple of workarounds: 1. Use a different browser. I've heard it produces this problem in Firefox and Safari, but I've used it just fine in the latest version of both browsers. I've never heard of this problem happening in IE. 2. Use the sort to determine who you want to vote for, then refresh the page and select the players you want without sorting.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
|
08-28-2009, 06:48 PM | #114 |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
08-28-2009, 07:16 PM | #115 | |
Hall Of Famer
Join Date: Aug 2002
Location: Rapid City, SD
Posts: 3,639
|
Quote:
__________________
培傑西 I have never taken a lesson on how to talk on TV in my life. - Tim McCarver Guns have only two enemies; rust and liberals. The world is a comedy to those that think; a tragedy to those that feel. |
|
08-31-2009, 12:35 PM | #116 | |
Minors (Triple A)
Join Date: Apr 2004
Posts: 272
|
Quote:
|
|
08-31-2009, 01:15 PM | #117 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
|
08-31-2009, 01:15 PM | #118 |
All Star Starter
Join Date: Dec 2005
Posts: 1,255
|
I get this error every time I try to install:
ERROR: OOTP SQL Utilities not configured properly (no config.txt) The instructions aren't very specific about what permissions the utility needs to the sqldump folder. I tried 777 temporarily and it still can't seem to create the config.txt file. It creates the dbopen.php and ootpsqlsettings.txt successfully. Any ideas?
__________________
Brewers League Baseball |
08-31-2009, 01:20 PM | #119 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,585
|
Quote:
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
|
08-31-2009, 01:33 PM | #120 |
All Star Starter
Join Date: Dec 2005
Posts: 1,255
|
Strange, it was 755 by default for me but didn't work until I set the sqldump, ootpsqlou and settings folder to 777 temporarily. I switched them all back to 755 after it wrote the files.
__________________
Brewers League Baseball |
Bookmarks |
|
|