Improved online scripts for reports - Page 2

byzeil · 02-04-2016, 11:41 AM

Quote:

Originally Posted by captaincoop17

Can someone post the template file then?

I sent him the file and it appears that that fixed his issue.

motnagoh79 · 02-04-2016, 09:38 PM

Quote:

Originally Posted by byzeil

It is the 'reports' table in your MYSQL database. Only applies if you are loading your reports into MYSQL. The script updates your reports in MYSQL. If you are just uploading your reports as HTML this script really don't do anything for you.

I'm still getting the bottom of my web pages cut off with the new script. Is there something else I should be doing to correct this?

byzeil · 02-04-2016, 10:24 PM

Quote:

Originally Posted by motnagoh79

I'm still getting the bottom of my web pages cut off with the new script. Is there something else I should be doing to correct this?

Did you drop all of the report tables (created by the new script) from your MYSQL database. Basically you have to do the initial procedure again with the revised scripts.

motnagoh79 · 02-04-2016, 11:43 PM

Quote:

Originally Posted by byzeil

Did you drop all of the report tables (created by the new script) from your MYSQL database. Basically you have to do the initial procedure again with the revised scripts.

I guess I dont understand what you are asking me to do. Is there a walk-thru on it somewhere?

Andreas Raht · 02-05-2016, 03:41 AM

Quote:

Originally Posted by motnagoh79

I guess I dont understand what you are asking me to do. Is there a walk-thru on it somewhere?

There's no walk-thru, sorry.
Please delete the reports tables from the database, use the latest scripts from the opening post and run them again. They will create new tables with a different format.

Phelps8312 · 02-05-2016, 05:42 PM

I DL these the other night as my reports having caused some server issues, Installed them as instructed and when i went to upload i got the image attached.

Andreas Raht · 02-06-2016, 07:34 AM

Quote:

Originally Posted by Phelps8312

I DL these the other night as my reports having caused some server issues, Installed them as instructed and when i went to upload i got the image attached.

I'd like to test this with your reports file which you uploaded to the server. Could you please PM me a link to the reports .tar.gz file on your server? Thanks.

motnagoh79 · 02-11-2016, 08:00 PM

Is there anyone on here that can give me the path to where these report tables are located?

Andreas Raht · 02-12-2016, 06:10 AM

Quote:

Originally Posted by motnagoh79

Is there anyone on here that can give me the path to where these report tables are located?

The report tables are in the MySQL database on your web server. That's totally optional. Did you create a MySQL database on your web server for your league?

motnagoh79 · 02-13-2016, 05:36 PM

No i did not. I have gone thru the entire directory structure on CPanel and cannot find the report tables you refer to.

motnagoh79 · 02-13-2016, 05:40 PM

Quote:

Originally Posted by Andreas Raht

The report tables are in the MySQL database on your web server. That's totally optional. Did you create a MySQL database on your web server for your league?

If I did not create the MySQL database then where else would the tables reside? This problem with the bottoms of the pages getting cut off is driving me nuts.

byzeil · 02-13-2016, 11:25 PM

Quote:

Originally Posted by motnagoh79

If I did not create the MySQL database then where else would the tables reside? This problem with the bottoms of the pages getting cut off is driving me nuts.

Did you implement the new scripts as described in the opening post of this thread? If so, the first step has you dropping the reports table in you MYSQL database. The scripts create a series of tables in this same MYSQL database.

If you don't have a MYSQL database then the reports are stored as individual HTML files on your server. They would either be loaded individually or as a compressed archive.

Did you set up your reports on your webserver initially or did someone else do it for you? If you have been uploading reports in MYSQL then someone had to set up the MYSQL database. To use these scripts at any point you would need a MYSQL database to store the reports tables.

f.montoya · 02-13-2016, 11:42 PM

Quote:

Originally Posted by motnagoh79

No i did not. I have gone thru the entire directory structure on CPanel and cannot find the report tables you refer to.

In cPanel, go to "phpMyAdmin". Then find the table that has your reports. If you're on AllSimBaseball's service, that would be something like "_repdb". Click on it to show the tables. Then just select all of them and then below that, you should see a selector dropbox with the choice to "Drop". Do that, then start over and it should work.

byzeil · 02-18-2016, 11:38 AM

Andreas....are these new scripts included in the most recent update (16.11.43) or do we need to reinstall them after updating?

byzeil · 02-18-2016, 01:56 PM

Quote:

Originally Posted by byzeil

Andreas....are these new scripts included in the most recent update (16.11.43) or do we need to reinstall them after updating?

Heard from Andreas via PM

Quote:

Originally Posted by Andreas Raht

Unfortunately, you'll need to reinstall them.

thompsw8 · 02-19-2016, 05:21 PM

I have a question. I am working on a new host for my websites and they said that their server now only supports 5.5 PHP. I was wondering if this script update will work on a 5.5 PHP. They said 5.4 is End-of-Life and is no longer supported by its developers. Just curious if this will work. Any help would be greatly appreciated.

Andreas Raht · 02-19-2016, 05:47 PM

Quote:

Originally Posted by thompsw8

I have a question. I am working on a new host for my websites and they said that their server now only supports 5.5 PHP. I was wondering if this script update will work on a 5.5 PHP. They said 5.4 is End-of-Life and is no longer supported by its developers. Just curious if this will work. Any help would be greatly appreciated.

I'm afraid my code would even work with PHP 3.0

If it doesn't work with 5.x, please let me know.

PBCA Commish · 02-22-2016, 02:49 PM

Quote:

Originally Posted by byzeil

Andreas....are these new scripts included in the most recent update (16.11.43) or do we need to reinstall them after updating?

Will they be in OOTP 17 when it comes out?

Andreas Raht · 02-22-2016, 03:25 PM

Quote:

Originally Posted by PBCA Commish

Will they be in OOTP 17 when it comes out?

Yes they will. I just did not want to add them to the OOTP16 updates because in existing online leagues, they should be installed manually.

thompsw8 · 02-25-2016, 01:03 PM

Ok we tried to get the reports to work on the PHP 5.5 but it gives me this error and we can see the index page but the links won't work to the other pages. The link to the reports page is BNN Home Page
Any help would be greatly appreciated.

02-05-2016, 05:42 PM	#26
Phelps8312 Minors (Rookie Ball) Join Date: Aug 2009 Posts: 27	upload issue I DL these the other night as my reports having caused some server issues, Installed them as instructed and when i went to upload i got the image attached. Attached Images

02-25-2016, 01:03 PM	#40
thompsw8 All Star Reserve Join Date: Dec 2006 Location: TX Posts: 897	Ok we tried to get the reports to work on the PHP 5.5 but it gives me this error and we can see the index page but the links won't work to the other pages. The link to the reports page is BNN Home Page Any help would be greatly appreciated. Attached Images

02-11-2016, 08:00 PM	#28
motnagoh79 Bat Boy Join Date: Feb 2016 Posts: 16	Is there anyone on here that can give me the path to where these report tables are located?

02-13-2016, 05:36 PM	#30
motnagoh79 Bat Boy Join Date: Feb 2016 Posts: 16	No i did not. I have gone thru the entire directory structure on CPanel and cannot find the report tables you refer to.

02-18-2016, 11:38 AM	#34
byzeil Hall Of Famer Join Date: Aug 2009 Location: NJ, US Posts: 2,004	Andreas....are these new scripts included in the most recent update (16.11.43) or do we need to reinstall them after updating?

02-19-2016, 05:21 PM	#36
thompsw8 All Star Reserve Join Date: Dec 2006 Location: TX Posts: 897	I have a question. I am working on a new host for my websites and they said that their server now only supports 5.5 PHP. I was wondering if this script update will work on a 5.5 PHP. They said 5.4 is End-of-Life and is no longer supported by its developers. Just curious if this will work. Any help would be greatly appreciated.