[Getch]

Originally Posted by mikev

You're saying I have to wait until next sim, which will put the league to 4/21/1996, and then upload the HTML reports before I run genDev.html again. Then it should read correctly and show 4/21/1996 on the development.html page?

Yes. Each development change is logged with a date. Subsequent runs of the utility don't go back and edit previous changes, and it won't detect any changes since you are using the same .csv files as the last time you ran it. Once it's logged, it's logged permamently (unless you go in and manually edit).

I also assume this means the utility is not hanging anymore?

[mikev]

Originally Posted by Getch

Yes. Each development change is logged with a date. Subsequent runs of the utility don't go back and edit previous changes, and it won't detect any changes since you are using the same .csv files as the last time you ran it. Once it's logged, it's logged permamently (unless you go in and manually edit).

I also assume this means the utility is not hanging anymore?

Actually, it did hang. It finishes, it just doesn't redirect to development.html

[Zubes]

I keep getting a 500 Internal Server Error when i try to run the script to make sure its working. i am pretty sure i have everything setup correctly.

any ideas why i would be getting this error? im thinking its a permissions error, but i have tried on 644 and 755 and it still doesnt work.

[mikev]

Originally Posted by Zubes

I keep getting a 500 Internal Server Error when i try to run the script to make sure its working. i am pretty sure i have everything setup correctly.

any ideas why i would be getting this error? im thinking its a permissions error, but i have tried on 644 and 755 and it still doesnt work.

You probably uploaded the files as binary instead of ASCII when you put the .html and .pm files on the server.


BTW, Getch. It's not working again. I don't know what I did wrong this time since I was the simmer. I did everything last night EXCEPT export csv and run the development stuff. I created HTML last night, uploaded it, adn it was all correct, showing 5/1/1996 as the league date.

I created the CSV this morning, uploaded it, and ran the script. Still shows 4/21/1996 and no new development.

[Zubes]

ok i reuploaded in ASCII, and i am still getting a 500 Internal Server Error on genDev.html

[Comedian2004]

See this link to resolve error 500 messages...

http://www.checkupdown.com/status/E500.html

[Getch]

Originally Posted by mikev

\
I created the CSV this morning, uploaded it, and ran the script. Still shows 4/21/1996 and no new development.

Sure you uploaded the .csv files to the right location? If no change in the development on 4/21, then it's likely you put them in the wrong dir. Also, check the prevRatings.txt and .tmp files in the cgi-bin directory... are they the same? If they are not the same, make backups of them before going any further (and backup the development directory into a zip file too). If they are, double check your .csv location and if that's the right .csv files.

[Getch]

Originally Posted by Zubes

ok i reuploaded in ASCII, and i am still getting a 500 Internal Server Error on genDev.html

Try:

chmod +x genDev.html

If not, just run it from the server (go to cgi-bin directory and type ./genDev.html) and you'll get your error message that'll tell you what's wrong. One thing you have to make sure is that the location of the perl executable is correct at the top of each .html file. Might be in a different directory.

[mikev]

Originally Posted by Getch

Sure you uploaded the .csv files to the right location? If no change in the development on 4/21, then it's likely you put them in the wrong dir. Also, check the prevRatings.txt and .tmp files in the cgi-bin directory... are they the same? If they are not the same, make backups of them before going any further (and backup the development directory into a zip file too). If they are, double check your .csv location and if that's the right .csv files.

Weird enough, I did it this last sim and everything is fine. It must have been a typo on my part or something.

[Zubes]

Originally Posted by Getch

If not, just run it from the server (go to cgi-bin directory and type ./genDev.html) and you'll get your error message that'll tell you what's wrong.

im confused about this.

did the chmod, same 500 internal error.

[Getch]

Originally Posted by Zubes

im confused about this.

did the chmod, same 500 internal error.

Telnet or SSH to the server (download putty if you do not have a utility to do this). Then go to the cgi-bin directory, or whatever directory your files exist in, and run the genDev.html file there. It's not an actual HTML file, but a perl script, so it is executable (the html extension is to workaround a Firefox bug). It'll likely print back an error message, paste or PM me the error and we'll work it out.

[Zubes]

error is as follows:

readline () on closed filehandle IN at ./genDev.html line .146
ERROR - players.csv bad or not found.


I am guessing that i probably have my setup file scrwed up, or maybe not.

I probably need an example of how that stuff should be written in there.

[Getch]

Originally Posted by Zubes

error is as follows:

readline () on closed filehandle IN at ./genDev.html line .146
ERROR - players.csv bad or not found.

I am guessing that i probably have my setup file scrwed up, or maybe not.

I probably need an example of how that stuff should be written in there.

CSV should just be the full directory path where the .csv files are. Probably the easiest thing to is to go to the directory where you uploaded the .csv files and type "pwd" (stands for print working directory). It'll give you the directory path, and just plug that into the CSV: entry in the setup.txt file.

[Zubes]

Originally Posted by Getch

CSV should just be the full directory path where the .csv files are. Probably the easiest thing to is to go to the directory where you uploaded the .csv files and type "pwd" (stands for print working directory). It'll give you the directory path, and just plug that into the CSV: entry in the setup.txt file.

i verified it, i have the correct path.

even re-uploaded a new set of csv files after a few days were simmed and its still not working.

the waiver page shows up, but nothing is being pulled.

[Getch]

One last check... you have the forward slash at the beginning of the directory name, and no forward slash at the end, correct? So something like:

/home/user/csv

If so, I'll have to get you a debug patch, or just log onto your system and get it running (if you let me, of course). Let me know.

[Zubes]

Originally Posted by Getch

One last check... you have the forward slash at the beginning of the directory name, and no forward slash at the end, correct? So something like:

/home/user/csv

If so, I'll have to get you a debug patch, or just log onto your system and get it running (if you let me, of course). Let me know.

yes the forward slash is there. i will need the debug patch, its not my server account so i dont want to pass on that info.

Thanks.

[mikev]

Originally Posted by mikev

Weird enough, I did it this last sim and everything is fine. It must have been a typo on my part or something.

So apparently every other time I do this, it works. I did it this time, and it's not updated again.

I follow the same process every time.

1. Generate league reports
2. Generate CSV
3. Upload both to server as seperate tarballs
4. Extract tarball for HTML, verify that it's updated on League Home Page (currently 6/1/1996)
5. Extract CSV tarball into csv directory specified in setup.txt
6. Run genDev.html
7. Check development html page which shows 5/21/1996.

I don't think I missed a step, did I?

[Getch]

Originally Posted by mikev

So apparently every other time I do this, it works. I did it this time, and it's not updated again.

I follow the same process every time.

1. Generate league reports
2. Generate CSV
3. Upload both to server as seperate tarballs
4. Extract tarball for HTML, verify that it's updated on League Home Page (currently 6/1/1996)
5. Extract CSV tarball into csv directory specified in setup.txt
6. Run genDev.html
7. Check development html page which shows 5/21/1996.

I don't think I missed a step, did I?

It only works when there is a Waxing Gibbous moon, did I tell you that? Sorry, just wanted to say "Waxing Gibbous". Steps look fine. I can log into your server and take a peek around, if you're ok with that.

Were there any development updates between this 5/21/1996 and the previous one? Or was there just no change altogether? PM me, I think the natives are getting tired of our banter.

[Getch]

Just in case anyone was having the same issue as Zubes, the issue was because the .csv files had semilcolon delimiters and not comma.

[Getch]

Upgraded for 2007:

http://www.ootpdevelopments.com/boar...35#post2114335

It'll still work off of the 2006 utility, so you don't have to lose your development history upgrading!