2011 OC NFL Pick 'em League

• dazedconfused

  

  so it appears that i have clearly failed at this...here's the message i keep getting when trying to pick the games
  

  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.

  any ideas justin?
• vball10set

  justincredible;880679 wrote:Yep.

  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?
• Mr Miyagi

  

  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?

  Miyagi gets the same thing..........And how come every team is 0-0 but the Jets are ranked first lol !
• karen lotz

  

  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.
• vball10set

  karen lotz;883787 wrote:You are at the bottom of the standings.

  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 think
  
  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

  

  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

• vball10set

  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

  

  http://www.ohiochatter.com/pickem/1/standings
• vball10set

  I had to reset my password on my laptop, and now I'm good to go--thanks again
• Mr Miyagi

  

  for some reason i cant make any picks, i keep getting what post # 26 says
• gorocks99

  

  Mr Miyagi;884247 wrote:for some reason i cant make any picks, i keep getting what post # 26 says

  This^^
• royal_k

  

  Mr Miyagi;884247 wrote:for some reason i cant make any picks, i keep getting what post # 26 says

  I get this when I try to look at my picks. It won't be good if I want to change any of them.
• justincredible

  

  Fixed it. Updated the module using the developers script but it did not add the needed column to the table.
• justincredible

  

  Don't forget to signup before tomorrow.
• like_that

  

  justincredible;886551 wrote:Don't forget to signup before tomorrow.

  K.
• justincredible

  

  like_that;886709 wrote:K.

  k thanx bai
• Terry_Tate

  

  I just joined. Are my picks in?
• justincredible

  

  yes
• justincredible

  

  25 of us are tied for 1st after one game.
• wildcats20

  

  I pick the Packers.
• justincredible

  

  I proud of you.
• karen lotz

  

  Can you post the names of those who picked the saints so they can be laughed at?
• justincredible

  

  http://www.ohiochatter.com/pickem/1/standings
• karen lotz

  

  Thanks for nothing.
• justincredible

  

  karen lotz;888615 wrote:Thanks for nothing.

  ?? Anyone without a point picked the Saints.