There are only ten out of the 13 games listed in the pool for week eight. What;s the problem and how do I correct this without making manual edits to the DB?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Administration > Advanced Administration > Load Games >
reload entire games database - YES
This will drop the games data in your local database and
allow it to be
reloaded from the master server. Then as you go back and
view each week the pages will read that there is no data and
it will reload each week as you click on it's link. You may
have to refresh each page then to see the data after it is
loaded into the database.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
That statement was very helpful. Thank you. However, I have the same exact problem with every other game for the rest of the season since I have reloaded the games table through the application. There are only ten games showing for each week in the DB. Any ideas why that might be?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
There are only ten out of the 13 games listed in the pool for week eight. What;s the problem and how do I correct this without making manual edits to the DB?
You can reload the entire games database.
Administration > Advanced Administration > Load Games >
reload entire games database - YES
This will drop the games data in your local database and
allow it to be
reloaded from the master server. Then as you go back and
view each week the pages will read that there is no data and
it will reload each week as you click on it's link. You may
have to refresh each page then to see the data after it is
loaded into the database.
I've already done this and am still not seeing the three missing games. Do you a have any other suggestions by chance?
Here is the sql statement to add in the games from this week. I hope this helps.
INSERT INTO `games` (`id`, `team1`, `score1`, `team2`, `score2`, `status`, `game_time`, `game_day`, `week`, `year`, `season`) VALUES
(2850, 'Rams', 0, 'Lions', 0, '', 1257098400, 'Sun. 11/1', 8, 2009, 'regular'),
(2851, 'Dolphins', 0, 'Jets', 0, '', 1257098400, 'Sun. 11/1', 8, 2009, 'regular'),
(2852, 'Vikings', 0, 'Packers', 0, '', 1257098400, 'Sun. 11/1', 8, 2009, 'regular'),
(2853, '49ers', 0, 'Colts', 0, '', 1257098400, 'Sun. 11/1', 8, 2009, 'regular'),
(2854, 'Broncos', 0, 'Ravens', 0, '', 1257098400, 'Sun. 11/1', 8, 2009, 'regular'),
(2855, 'Texans', 0, 'Bills', 0, '', 1257098400, 'Sun. 11/1', 8, 2009, 'regular'),
(2856, 'Browns', 0, 'Bears', 0, '', 1257098400, 'Sun. 11/1', 8, 2009, 'regular'),
(2857, 'Seahawks', 0, 'Cowboys', 0, '', 1257098400, 'Sun. 11/1', 8, 2009, 'regular'),
(2858, 'Jaguars', 0, 'Titans', 0, '', 1257109500, 'Sun. 11/1', 8, 2009, 'regular'),
(2859, 'Raiders', 0, 'Chargers', 0, '', 1257109500, 'Sun. 11/1', 8, 2009, 'regular'),
(2860, 'Giants', 0, 'Eagles', 0, '', 1257110100, 'Sun. 11/1', 8, 2009, 'regular'),
(2861, 'Panthers', 0, 'Cardinals', 0, '', 1257110100, 'Sun. 11/1', 8, 2009, 'regular'),
(2862, 'Falcons', 0, 'Saints', 0, '', 1257211800, 'Mon. 11/2', 8, 2009, 'regular');
That statement was very helpful. Thank you. However, I have the same exact problem with every other game for the rest of the season since I have reloaded the games table through the application. There are only ten games showing for each week in the DB. Any ideas why that might be?