SQL errors when trying to read several threads

Questions about FantasyTSP or suggestions for improvements should be directed here.

Moderator: Aitrus

Post Reply
User avatar
bop
Posts: 29
Joined: Sun Jun 03, 2018 10:41 pm

SQL errors when trying to read several threads

Post by bop »

I'm seeing SQL errors when trying to read several threads, including:

Bugtracker
Move to S Fund tomorrow?
TSP Forecast 16-20 Nov

Here is the error message:
General Error
SQL ERROR [ mysqli ]

Table 'tspcenter.phpbb_medals' doesn't exist [1146]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
The lyf so short, the craft so long to lerne. - Geoffrey Chaucer

User avatar
mjedlin66
Site Admin
Posts: 1502
Joined: Wed Oct 02, 2013 7:51 pm

Re: SQL errors when trying to read several threads

Post by mjedlin66 »

Fire the webmaster!
Owner/creator of TSPcalc.com - "Know your numbers"

User avatar
bloobs
Posts: 1378
Joined: Tue May 21, 2019 8:00 pm

Re: SQL errors when trying to read several threads

Post by bloobs »

mjedlin66 wrote:Fire the webmaster!
Did you drop a bunch of db tables MJ?

User avatar
mjedlin66
Site Admin
Posts: 1502
Joined: Wed Oct 02, 2013 7:51 pm

Re: SQL errors when trying to read several threads

Post by mjedlin66 »

Probably. They have been restored. I suspect that recent reputation points have been lost :(
Owner/creator of TSPcalc.com - "Know your numbers"

strohz
Posts: 14
Joined: Fri Dec 30, 2016 6:08 pm

Re: SQL errors when trying to read several threads

Post by strohz »

I don't know if it's the same issue, but when I click to view the fantasyTSP button I get a page of errors starting with this:

[phpBB Debug] PHP Warning: in file /home/tspcenter/public_html/summary.php on line 270: array_reverse() expects parameter 1 to be array, string given
[phpBB Debug] PHP Warning: in file /home/tspcenter/public_html/summary.php on line 542: Division by zero
[phpBB Debug] PHP Warning: in file /home/tspcenter/public_html/summary.php on line 550: Division by zero
repeats...

Midway
Posts: 226
Joined: Tue Feb 28, 2012 6:09 pm

Re: SQL errors when trying to read several threads

Post by Midway »

Same problem here if I click on any ones Fantasy TSP including my own.
edit: this occurs when clicking a members Fantasy TSP button in Forums or My FantasyTSP. However, if I scroll DOWN far enough, the page is there. It is missing data from the Allocation chart and Allocation History though.
If I access a members page through my watch list or Leader board the page shows front and center, but has many error codes if I scroll UP.

Ericdelee
Posts: 213
Joined: Thu May 30, 2013 7:09 pm

Re: SQL errors when trying to read several threads

Post by Ericdelee »

Something definitely going on...
either mjedlin66 is not getting enough cash for craft beers; or he’s had too many craft beers. Lol

Looks like all of the Fantasy stuff was wiped when it comes to what they’ve earned. Mine reset back to $100k.

User avatar
bop
Posts: 29
Joined: Sun Jun 03, 2018 10:41 pm

Re: SQL errors when trying to read several threads

Post by bop »

It’s probably related to the work described in this announcement: viewtopic.php?f=14&p=88620#p88620

It warns the numbers would be mixed up until the recalculation process finished.
The lyf so short, the craft so long to lerne. - Geoffrey Chaucer

Ericdelee
Posts: 213
Joined: Thu May 30, 2013 7:09 pm

Re: SQL errors when trying to read several threads

Post by Ericdelee »

Ahhh. Yep. That’s it.

User avatar
mjedlin66
Site Admin
Posts: 1502
Joined: Wed Oct 02, 2013 7:51 pm

Re: SQL errors when trying to read several threads

Post by mjedlin66 »

Yes, this is related to the recalculation. It has failed several times now. Mostly my fault. Hopefully it will be done in a few hours.
Owner/creator of TSPcalc.com - "Know your numbers"

jbirdway
Posts: 32
Joined: Fri Jan 27, 2012 2:12 pm

Re: SQL errors when trying to read several threads

Post by jbirdway »

Thank you for your efforts!

User avatar
mjedlin66
Site Admin
Posts: 1502
Joined: Wed Oct 02, 2013 7:51 pm

Re: SQL errors when trying to read several threads

Post by mjedlin66 »

Current status: It has calculated all accounts through 2017-11-18, and is still running.

It gets slower as it gets closer to current date, because there are more accounts to calculate.

I also figured out how to run it in the background on the server so that my computer losing internet connection won't interrupt it anymore.
Owner/creator of TSPcalc.com - "Know your numbers"

User avatar
mjedlin66
Site Admin
Posts: 1502
Joined: Wed Oct 02, 2013 7:51 pm

Re: SQL errors when trying to read several threads

Post by mjedlin66 »

Now 2018-03-27. It took two hours to calculate 4 months. 30 minutes per month, with 32 months remaining. That would put us at 4pm pacific on Monday to be done calculating.

Plus it's going to slow down as more and more accounts have joined in 2019 and 2020. Yikes.
Owner/creator of TSPcalc.com - "Know your numbers"

User avatar
mjedlin66
Site Admin
Posts: 1502
Joined: Wed Oct 02, 2013 7:51 pm

Re: SQL errors when trying to read several threads

Post by mjedlin66 »

Currently 2019-09-05
Owner/creator of TSPcalc.com - "Know your numbers"

Post Reply

Fund Prices2022-08-10

FundPriceDayYTD
G $16.99 0.01% 1.49%
F $19.12 0.15% -8.47%
C $64.14 2.13% -10.85%
S $69.64 3.34% -16.54%
I $33.95 2.14% -13.91%
L2065 $13.02 2.29% -12.54%
L2060 $13.02 2.29% -12.53%
L2055 $13.02 2.29% -12.52%
L2050 $26.81 1.90% -10.69%
L2045 $12.31 1.78% -9.98%
L2040 $45.22 1.66% -9.20%
L2035 $12.03 1.53% -8.34%
L2030 $40.33 1.39% -7.43%
L2025 $11.63 0.94% -5.02%
Linc $22.96 0.56% -2.25%

Live Charts

Pending Allocations

Under development. For now, you may view Pending Allocations by going to "fantasy TSP" and selecting "Leaderboard sort" of "Pending Allocations".