Not Finding all tables in database
Not Finding all tables in database
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!
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!
-
- STHS Owner / Propriétaire du STHS
- Posts: 14798
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Not Finding all tables in database
Hi.
I'm not sure to understand your issue. What are you trying to do?
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 Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Re: Not Finding all tables in database
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.
-
- STHS Owner / Propriétaire du STHS
- Posts: 14798
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Not Finding all tables in database
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 Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Re: Not Finding all tables in database
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.
-
- STHS Owner / Propriétaire du STHS
- Posts: 14798
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Not Finding all tables in database
Show me your website please.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Re: Not Finding all tables in database
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?
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?
-
- STHS Owner / Propriétaire du STHS
- Posts: 14798
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Not Finding all tables in database
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 Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Re: Not Finding all tables in database
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....
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....
-
- STHS Owner / Propriétaire du STHS
- Posts: 14798
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Not Finding all tables in database
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 Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
-
- STHS Owner / Propriétaire du STHS
- Posts: 14798
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Not Finding all tables in database
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.
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 Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
Re: Not Finding all tables in database
Simon - works great for the skaters and goalies! Thank you! No change for the team career stats.
-
- The Passion One / Le Passionné
- Posts: 193
- Joined: Fri Sep 16, 2016 3:16 pm
- Location: Quebec, QC.
- Contact:
Re: Not Finding all tables in database
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.
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.
-
- STHS Owner / Propriétaire du STHS
- Posts: 14798
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: Not Finding all tables in database
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 Manual - Manuel Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English Manual - Manuel Français
-
- The Passion One / Le Passionné
- Posts: 193
- Joined: Fri Sep 16, 2016 3:16 pm
- Location: Quebec, QC.
- Contact:
Re: Not Finding all tables in database
C'est fait Simon, je viens de t'envoyé le tout dans le courriel du STHS Info. J'attends de tes news.
Merci
Merci