SQL errors when trying to read several threads
Moderator: Aitrus
SQL errors when trying to read several threads
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.
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
Re: SQL errors when trying to read several threads
Fire the webmaster!
Owner/creator of TSPcalc.com - "Know your numbers"
Re: SQL errors when trying to read several threads
Did you drop a bunch of db tables MJ?mjedlin66 wrote:Fire the webmaster!
Re: SQL errors when trying to read several threads
Probably. They have been restored. I suspect that recent reputation points have been lost 

Owner/creator of TSPcalc.com - "Know your numbers"
Re: SQL errors when trying to read several threads
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...
[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...
Re: SQL errors when trying to read several threads
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.
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.
Re: SQL errors when trying to read several threads
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.
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.
Re: SQL errors when trying to read several threads
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.
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
Re: SQL errors when trying to read several threads
Ahhh. Yep. That’s it.
Re: SQL errors when trying to read several threads
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"
Re: SQL errors when trying to read several threads
Thank you for your efforts!
Re: SQL errors when trying to read several threads
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.
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"
Re: SQL errors when trying to read several threads
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.
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"
Re: SQL errors when trying to read several threads
Currently 2019-09-05
Owner/creator of TSPcalc.com - "Know your numbers"
Fund Prices2025-02-14
Fund | Price | Day | YTD |
G | $18.86 | 0.01% | 0.57% |
F | $19.69 | 0.32% | 1.10% |
C | $96.75 | 0.02% | 4.11% |
S | $94.73 | 0.13% | 5.08% |
I | $44.47 | -0.13% | 6.15% |
L2070 | $10.93 | -0.02% | 4.91% |
L2065 | $18.44 | -0.02% | 4.92% |
L2060 | $18.44 | -0.02% | 4.92% |
L2055 | $18.45 | -0.02% | 4.91% |
L2050 | $36.36 | 0.01% | 4.19% |
L2045 | $16.50 | 0.01% | 3.98% |
L2040 | $59.95 | 0.01% | 3.75% |
L2035 | $15.74 | 0.01% | 3.50% |
L2030 | $52.08 | 0.01% | 3.24% |
L2025 | $14.02 | 0.02% | 1.89% |
Linc | $27.21 | 0.02% | 1.76% |