Forum update

Forum info, updates, discussion. If you have a request for something you want to see on the forum, feel free to bring it up here.
User avatar
sealhall74
Posts: 5770
Joined: Fri Apr 18, 2014 1:18 pm
Location: Wherever, Windblows

Ouch, Patty V, we have a problem. Looks like the conference site has a new way of displaying results and getting to the boxscores and it looks like scraping the stats to automatically fill in the weekly StatPick result will need some work. Not a big issue as I can easily enter the StatPick value by hand like I did this week but ST, if you any ideas on how best to scrape dynamic javascript-generated page content, I would be a willing listener.
Embrace the pace of the race.
User avatar
ST_Lawson
Site Admin
Posts: 8247
Joined: Wed Apr 16, 2014 1:15 pm
Location: Macomb, IL
Contact:

Just FYI, I was putting in my picks tonight and it kept giving me an error message as it was trying to save them. I think it did, but if not, I can PM you a pdf of my picks before Saturday. I don't know if everyone is having the same issue, or if it's just me, but I thought I should let you know.
Scott Lawson - Board Admin
Western Illinois University Alum/Fan/Employee
Member of the Marching Leathernecks - 1996-2000
User avatar
sealhall74
Posts: 5770
Joined: Fri Apr 18, 2014 1:18 pm
Location: Wherever, Windblows

ST_Lawson wrote: Thu Sep 14, 2017 12:20 am Just FYI, I was putting in my picks tonight and it kept giving me an error message as it was trying to save them. I think it did, but if not, I can PM you a pdf of my picks before Saturday. I don't know if everyone is having the same issue, or if it's just me, but I thought I should let you know.
Do you recall what the error message was? It looks like your picks are there now. I am urging everyone to login sometime after submitting to make sure their picks are good. The one problem that I am seeing occasionally is sometimes I see 12 blank rows in the main Picks sheet. Not sure if someone timed out during the submit process or what is going on. When that happens, it screws up the formulas and a few other things. A player could then login and it would appear to them they have no picks in place. Easy to fix, I just delete the empty rows and resort (if necessary) the picks for the week. Next season, we are moving to MySql for sure.

Update: This might be what you ran into:

2017-09-14 01:17:43 Form Submit 3 Caught Exception with message=Service error: Spreadsheets
Embrace the pace of the race.
User avatar
sealhall74
Posts: 5770
Joined: Fri Apr 18, 2014 1:18 pm
Location: Wherever, Windblows

ST, does your hosting service provider support running node.js/javascript apps? If I have throw a lot of code away, I am leaning to Node.js/express.js framework on the server and AngularJS framework in the browser along with Mysql as the backend database.
Embrace the pace of the race.
User avatar
ST_Lawson
Site Admin
Posts: 8247
Joined: Wed Apr 16, 2014 1:15 pm
Location: Macomb, IL
Contact:

sealhall74 wrote: Wed Sep 20, 2017 5:20 pm ST, does your hosting service provider support running node.js/javascript apps? If I have throw a lot of code away, I am leaning to Node.js/express.js framework on the server and AngularJS framework in the browser along with Mysql as the backend database.
Here's the situation with node.js on the current host: https://help.dreamhost.com/hc/en-us/art ... s-overview
We currently run on shared hosting, but the lowest level of VPS might be within the current website budget. I'd have to take a look at what the ad has brought in on average and see if we can swing it.
Scott Lawson - Board Admin
Western Illinois University Alum/Fan/Employee
Member of the Marching Leathernecks - 1996-2000
User avatar
sealhall74
Posts: 5770
Joined: Fri Apr 18, 2014 1:18 pm
Location: Wherever, Windblows

ST_Lawson wrote: Wed Sep 20, 2017 9:26 pm
sealhall74 wrote: Wed Sep 20, 2017 5:20 pm ST, does your hosting service provider support running node.js/javascript apps? If I have throw a lot of code away, I am leaning to Node.js/express.js framework on the server and AngularJS framework in the browser along with Mysql as the backend database.
Here's the situation with node.js on the current host: https://help.dreamhost.com/hc/en-us/art ... s-overview
We currently run on shared hosting, but the lowest level of VPS might be within the current website budget. I'd have to take a look at what the ad has brought in on average and see if we can swing it.
I would be willing make up the difference to take us to the level above the lowest level if you are interested in going there. Regardless of level, moving to the SSD that comes with the VPS should be a noticeable improvement for everyone.
Embrace the pace of the race.
User avatar
ST_Lawson
Site Admin
Posts: 8247
Joined: Wed Apr 16, 2014 1:15 pm
Location: Macomb, IL
Contact:

sealhall74 wrote: Wed Sep 20, 2017 10:11 pm I would be willing make up the difference to take us to the level above the lowest level if you are interested in going there. Regardless of level, moving to the SSD that comes with the VPS should be a noticeable improvement for everyone.
Did a check of what the ad has made for the site, and since I instituted it in April of 2014, we have averaged just a bit over $33 per month of revenue.

The entire account that we have currently is using 1.8 GB of disk space.

Dreamhost has 1GB of RAM and 30GB of SSD storage for $15/month
or 2GB of RAM and 60GB SSD for $30/month

Over the past year we've averaged 37,389 pageviews per month, which works out to (if you consider the site "active" 12 hours of the day), approximately 1.5 pageviews per minute, and our "busiest" day in the past year would have been 4.2 pageviews per minute.

It's unlikely we'll max out 30 GB any time soon unless we have some specific need, but do you think the difference in RAM is going to make a huge difference to the speed of the site and stuff?

I can get you lots of other numbers if you want, or we can see about going ahead and moving to the $30 level, having the website fund cover it and if we get to the point where we're not averaging $30/month, then I'll let you know and you can chip in some.
Or, we could go with the $15/month level, start with that, see how it goes, and if we decide we need to step up to the next level, we can do that pretty easily (since it's a virtual server).

Thoughts?
Scott Lawson - Board Admin
Western Illinois University Alum/Fan/Employee
Member of the Marching Leathernecks - 1996-2000
User avatar
sealhall74
Posts: 5770
Joined: Fri Apr 18, 2014 1:18 pm
Location: Wherever, Windblows

ST_Lawson wrote: Thu Sep 21, 2017 11:30 am
sealhall74 wrote: Wed Sep 20, 2017 10:11 pm I would be willing make up the difference to take us to the level above the lowest level if you are interested in going there. Regardless of level, moving to the SSD that comes with the VPS should be a noticeable improvement for everyone.
Did a check of what the ad has made for the site, and since I instituted it in April of 2014, we have averaged just a bit over $33 per month of revenue.

The entire account that we have currently is using 1.8 GB of disk space.

Dreamhost has 1GB of RAM and 30GB of SSD storage for $15/month
or 2GB of RAM and 60GB SSD for $30/month

Over the past year we've averaged 37,389 pageviews per month, which works out to (if you consider the site "active" 12 hours of the day), approximately 1.5 pageviews per minute, and our "busiest" day in the past year would have been 4.2 pageviews per minute.

It's unlikely we'll max out 30 GB any time soon unless we have some specific need, but do you think the difference in RAM is going to make a huge difference to the speed of the site and stuff?

I can get you lots of other numbers if you want, or we can see about going ahead and moving to the $30 level, having the website fund cover it and if we get to the point where we're not averaging $30/month, then I'll let you know and you can chip in some.
Or, we could go with the $15/month level, start with that, see how it goes, and if we decide we need to step up to the next level, we can do that pretty easily (since it's a virtual server).

Thoughts?
I think the $15/month plan is sufficient to get started. Question: when someone posts with an image from the web, does the image get copied to PHPBB or does it just maintain the link to the image?
Embrace the pace of the race.
User avatar
ST_Lawson
Site Admin
Posts: 8247
Joined: Wed Apr 16, 2014 1:15 pm
Location: Macomb, IL
Contact:

sealhall74 wrote: Thu Sep 21, 2017 12:40 pm
ST_Lawson wrote: Thu Sep 21, 2017 11:30 am
sealhall74 wrote: Wed Sep 20, 2017 10:11 pm I would be willing make up the difference to take us to the level above the lowest level if you are interested in going there. Regardless of level, moving to the SSD that comes with the VPS should be a noticeable improvement for everyone.
Did a check of what the ad has made for the site, and since I instituted it in April of 2014, we have averaged just a bit over $33 per month of revenue.

The entire account that we have currently is using 1.8 GB of disk space.

Dreamhost has 1GB of RAM and 30GB of SSD storage for $15/month
or 2GB of RAM and 60GB SSD for $30/month

Over the past year we've averaged 37,389 pageviews per month, which works out to (if you consider the site "active" 12 hours of the day), approximately 1.5 pageviews per minute, and our "busiest" day in the past year would have been 4.2 pageviews per minute.

It's unlikely we'll max out 30 GB any time soon unless we have some specific need, but do you think the difference in RAM is going to make a huge difference to the speed of the site and stuff?

I can get you lots of other numbers if you want, or we can see about going ahead and moving to the $30 level, having the website fund cover it and if we get to the point where we're not averaging $30/month, then I'll let you know and you can chip in some.
Or, we could go with the $15/month level, start with that, see how it goes, and if we decide we need to step up to the next level, we can do that pretty easily (since it's a virtual server).

Thoughts?
I think the $15/month plan is sufficient to get started. Question: when someone posts with an image from the web, does the image get copied to PHPBB or does it just maintain the link to the image?
Ok, I'll look into switching over at some point. Says that it might take a little bit to do and the site would be down, so I'd want to do it when there's a slow time.

At this point, when someone puts in an image, it's hosted elsewhere and it's just linked to from here (other than the profile images).
Scott Lawson - Board Admin
Western Illinois University Alum/Fan/Employee
Member of the Marching Leathernecks - 1996-2000
User avatar
sealhall74
Posts: 5770
Joined: Fri Apr 18, 2014 1:18 pm
Location: Wherever, Windblows

During test and development, I will be prototyping the new app by using sqlite instead of mysql for the database. I see that Dreamhost makes sqlite available on all of their servers so it could be a possibility for production as well if we dont need a full-blown database server. Sqlite is blazingly fast but not generally used for apps with a lot of concurrent users.
Embrace the pace of the race.
Post Reply