dazedconfused
Posts: 2,662
Sep 4, 2011 9:03pm
so it appears that i have clearly failed at this...here's the message i keep getting when trying to pick the games
any ideas justin?user warning: Unknown column 'pw.wk_lastgame' in 'field list' query: SELECT g.*, case when '2011-09-04 21:02:25' > g.gametime then 1 else 0 end as 'game_started', case when '2011-09-04 21:02:25' > pw.wk_firstgame then 1 else 0 end as 'week_started', case when '2011-09-04 21:02:25' > date_add(pw.wk_lastgame, INTERVAL 3 HOUR) then 1 else 0 end as 'week_ended', pw.wk_firstgame, pw.wk_number FROM drupal_pickem_games g INNER JOIN drupal_pickem_weeks pw ON pw.wid=g.wid inner join drupal_pickem_leagues l on l.gsid=pw.gsid WHERE l.lid=1 ORDER BY week_ended, g.gametime, g.gid in /home/justin/sites/theoc/sites/all/modules/pickem/pickem.inc on line 457.
V
vball10set
Posts: 24,795
Sep 5, 2011 9:23am
I just checked the site and my name isn't on it (in the standings section)...you did receive my picks, so what's up?justincredible;880679 wrote:Yep.
Mr Miyagi
Posts: 1,211
Sep 5, 2011 11:29am
Miyagi gets the same thing..........And how come every team is 0-0 but the Jets are ranked first lol !dazedconfused;883398 wrote:so it appears that i have clearly failed at this...here's the message i keep getting when trying to pick the games
any ideas justin?
karen lotz
Posts: 22,284
Sep 5, 2011 11:32am
vball10set;883670 wrote:I just checked the site and my name isn't on it (in the standings section)...you did receive my picks, so what's up?
You are at the bottom of the standings.
V
vball10set
Posts: 24,795
Sep 5, 2011 1:19pm
here's what I see when I open up the standings--is it because I'm logged on with a different computer? that shouldn't make a difference I wouldn't thinkkaren lotz;883787 wrote:You are at the bottom of the standings.
Standings
Click on week numbers to see weekly pick summary. Regular Season
| 1. Iliketurtles | |||||||||||||||||||
| 1. Jester | |||||||||||||||||||
| 1. Raw Dawgin' it | |||||||||||||||||||
| 1. bigdaddy2003 | |||||||||||||||||||
| 1. justincredible | |||||||||||||||||||
| 1. karen lotz | |||||||||||||||||||
| 1. like_that |
karen lotz
Posts: 22,284
Sep 5, 2011 1:39pm
| 1. Chesapeake | 0 | ||||||||||||||||||
| 1. Enforcer | 0 | ||||||||||||||||||
| 1. GoChiefs | 0 | ||||||||||||||||||
| 1. Iliketurtles | 0 | ||||||||||||||||||
| 1. Jester | 0 | ||||||||||||||||||
| 1. Mr Miyagi | 0 | ||||||||||||||||||
| 1. Nate | 0 | ||||||||||||||||||
| 1. Raw Dawgin' it | 0 | ||||||||||||||||||
| 1. Rotinaj | 0 | ||||||||||||||||||
| 1. bigdaddy2003 | 0 | ||||||||||||||||||
| 1. dazedconfused | 0 | ||||||||||||||||||
| 1. fiver | 0 | ||||||||||||||||||
| 1. hoops23 | 0 | ||||||||||||||||||
| 1. justincredible | 0 | ||||||||||||||||||
| 1. karen lotz | 0 | ||||||||||||||||||
| 1. like_that | 0 | ||||||||||||||||||
| 1. royal_k | 0 | ||||||||||||||||||
| 1. vball10set | 0 |
V
vball10set
Posts: 24,795
Sep 5, 2011 2:09pm
don't know why I can only get it to show 7 players...here's the link I'm using--any ideas? http://www.ohiochatter.com/pickem/1
karen lotz
Posts: 22,284
Sep 5, 2011 2:14pm
V
vball10set
Posts: 24,795
Sep 5, 2011 2:34pm
I had to reset my password on my laptop, and now I'm good to go--thanks again
Mr Miyagi
Posts: 1,211
Sep 5, 2011 6:12pm
for some reason i cant make any picks, i keep getting what post # 26 says
gorocks99
Posts: 10,760
Sep 6, 2011 3:33pm
This^^Mr Miyagi;884247 wrote:for some reason i cant make any picks, i keep getting what post # 26 says
royal_k
Posts: 4,423
Sep 6, 2011 3:57pm
I get this when I try to look at my picks. It won't be good if I want to change any of them.Mr Miyagi;884247 wrote:for some reason i cant make any picks, i keep getting what post # 26 says
justincredible
Posts: 32,056
Sep 6, 2011 4:39pm
Fixed it. Updated the module using the developers script but it did not add the needed column to the table.
justincredible
Posts: 32,056
Sep 7, 2011 4:28pm
Don't forget to signup before tomorrow.
like_that
Posts: 26,625
Sep 7, 2011 8:03pm
K.justincredible;886551 wrote:Don't forget to signup before tomorrow.
justincredible
Posts: 32,056
Sep 7, 2011 8:44pm
k thanx bailike_that;886709 wrote:K.
Terry_Tate
Posts: 7,606
Sep 8, 2011 9:09am
I just joined. Are my picks in?
justincredible
Posts: 32,056
Sep 8, 2011 10:59am
yes
justincredible
Posts: 32,056
Sep 9, 2011 12:28am
25 of us are tied for 1st after one game.
wildcats20
Posts: 27,794
Sep 9, 2011 12:32am
I pick the Packers.
justincredible
Posts: 32,056
Sep 9, 2011 12:49am
I proud of you.
karen lotz
Posts: 22,284
Sep 9, 2011 12:56am
Can you post the names of those who picked the saints so they can be laughed at?
justincredible
Posts: 32,056
Sep 9, 2011 12:58am
karen lotz
Posts: 22,284
Sep 9, 2011 1:07am
Thanks for nothing.
justincredible
Posts: 32,056
Sep 9, 2011 9:35am
?? Anyone without a point picked the Saints.karen lotz;888615 wrote:Thanks for nothing.