STHS Forum

converting my league over to be fully V3 and SQL driven - got this error when trying to utilize CAreerStats (which is a huge deal) for the league...

got these errors:

Unable to prepare statement: 1, no such table: GoalerProStat in C:\xampp\htdocs\STHSTesting\CareerStatGoaliesStat.php on line 99 - when clicking the goalie page

Unable to prepare statement: 1, no such table: TeamProStat in C:\xampp\htdocs\STHSTesting\CareerStatTeamsStat.php on line 124 - on the team page

Unable to prepare statement: 1, no such table: PlayerProStat in C:\xampp\htdocs\STHSTesting\CareerStatPlayersStat.php on line 120 - on the player page.

Otherwise all the fields come up, but no data to sort. Not sure where to go next.

Thanks!


Hi.

I'm not sure to understand your issue. What are you trying to do?

Hi Simon, for example, when I click on the "Team Career Stat" link, I get this warning at the top of the page "Warning: SQLite3::query(): Unable to prepare statement: 1, no such table: TeamProStat in C:\xampp\htdocs\STHSTesting\CareerStatTeamsStat.php on line 124" and no data is displayed in the page.

Your CareerStat Database is corrupt. You should recreate it from the STHS.

hey Simon, I tried a couple things (my career stats includes V1 data, and was also looking for players who were tagged as 'retired') but it still gives me this error. Any suggestions? When I look for individual players, the career data comes up fine. I'm stuck for ideas.

Show me your website please.

hi Simon - sorry for the delay, was traveling for work. Fixed original problem, found another.

http://www.nehll.com/

new problem - my career data goes back to V1 time, where the first 6-7 seasons were created. It's not showing up in the overall roll up, but when you click on individual names, the data is there. Any thoughts?

What do you mean by overall roll up? Can you give me an example of a player name?

Check --> Todd Newberry (#5 in the CareerStat list) http://nehll.com/PlayerReport.php?Player=437

on the CareerStat page his stats are 767GP 358-591-949, but his career includes a bunch of other seasons shown on the CAreerProStat view which aren't totaled up in the main page....

Can you send me your .STCareer file by email. I'll look at it lately this week.

Hi.

The issue is that I did the year grouping via the UniqueID who is a version 2 or 3 attribute. This means all your version 1 players were group together in 1 line (See Francis Rode).

If you download the following pages and upload them on your website, it should fix your issue.
https://github.com/SimonT-STHS/STHS-Dyn ... esStat.php
https://github.com/SimonT-STHS/STHS-Dyn ... rsStat.php

If it does, please confirm it.

Simon - works great for the skaters and goalies! Thank you! No change for the team career stats.

Simon, par le fait même cette modification, tu as aussi régler mon problème concernant le carreer stats des saisons antérieurs. (Sur la page CareerStatPlayersStat.php) Par contre j'ai encore un problème avec la page Player Report.

Tu peux regarder ici: http://simlhs.ca/File/Saison19/PlayerRe ... Player=490

Regarde Patrick Marleau avec un total de 1127 pts dans la page player report

Et regarde ici: http://simlhs.ca/File/Saison19/CareerSt ... rsStat.php

Patrick Marleau dans la liste, il a un total de 1054 pts.

ImSteveK wrote: ↑Sat Dec 23, 2017 4:31 pm Simon - works great for the skaters and goalies! Thank you! No change for the team career stats.

Hi.

Version 1 of STHS CareerStat didn't include Team stat do it's not applies. (And you didn't have any V1 Team CareerStat).

Dominic,

Mon dernier courriel du 2 décembre est encore valide. Tu m'a jamais envoyé ton fichier .STCarrer par courriel.

C'est fait Simon, je viens de t'envoyé le tout dans le courriel du STHS Info. J'attends de tes news.

Merci