Not Finding all tables in database

Any questions related to version 2 or version 3 should be ask here. / Toutes les questions sur la version 2 ou la version 3 devraient être demandées ici.
ImSteveK
The Accomplished One / L'Accompli
Posts: 62
Joined: Tue Aug 04, 2009 9:37 pm

Not Finding all tables in database

Post by ImSteveK »

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!

SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: Not Finding all tables in database

Post by SimonT »

Hi.

I'm not sure to understand your issue. What are you trying to do?
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
ImSteveK
The Accomplished One / L'Accompli
Posts: 62
Joined: Tue Aug 04, 2009 9:37 pm

Re: Not Finding all tables in database

Post by ImSteveK »

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.
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: Not Finding all tables in database

Post by SimonT »

Your CareerStat Database is corrupt. You should recreate it from the STHS.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
ImSteveK
The Accomplished One / L'Accompli
Posts: 62
Joined: Tue Aug 04, 2009 9:37 pm

Re: Not Finding all tables in database

Post by ImSteveK »

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.
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: Not Finding all tables in database

Post by SimonT »

Show me your website please.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
ImSteveK
The Accomplished One / L'Accompli
Posts: 62
Joined: Tue Aug 04, 2009 9:37 pm

Re: Not Finding all tables in database

Post by ImSteveK »

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?
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: Not Finding all tables in database

Post by SimonT »

What do you mean by overall roll up? Can you give me an example of a player name?
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
ImSteveK
The Accomplished One / L'Accompli
Posts: 62
Joined: Tue Aug 04, 2009 9:37 pm

Re: Not Finding all tables in database

Post by ImSteveK »

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....
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: Not Finding all tables in database

Post by SimonT »

Can you send me your .STCareer file by email. I'll look at it lately this week.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: Not Finding all tables in database

Post by SimonT »

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.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
ImSteveK
The Accomplished One / L'Accompli
Posts: 62
Joined: Tue Aug 04, 2009 9:37 pm

Re: Not Finding all tables in database

Post by ImSteveK »

Simon - works great for the skaters and goalies! Thank you! No change for the team career stats.
Showtime Hockey
The Passion One / Le Passionné
Posts: 189
Joined: Fri Sep 16, 2016 3:16 pm
Location: Quebec, QC.
Contact:

Re: Not Finding all tables in database

Post by Showtime Hockey »

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.
Image
SimonT
STHS Owner / Propriétaire du STHS
Posts: 14758
Joined: Sat Oct 08, 2005 4:18 pm
Location: Montreal, Canada
Contact:

Re: Not Finding all tables in database

Post by SimonT »

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.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Showtime Hockey
The Passion One / Le Passionné
Posts: 189
Joined: Fri Sep 16, 2016 3:16 pm
Location: Quebec, QC.
Contact:

Re: Not Finding all tables in database

Post by Showtime Hockey »

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

Merci
Image
Post Reply