2011 OC NFL Pick 'em League

Home ▸ Archive ▸ Pro Sports ▸ 2011 OC NFL Pick 'em League
dazedconfused's avatar

dazedconfused

Senior Member

2,662 posts
Sep 4, 2011 9:03 PM
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?
Sep 4, 2011 9:03pm
V

vball10set

paying it forward

24,795 posts
Sep 5, 2011 9:23 AM
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?
Sep 5, 2011 9:23am
Mr Miyagi's avatar

Mr Miyagi

wax on, wax off

1,211 posts
Sep 5, 2011 11:29 AM
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 !
Sep 5, 2011 11:29am
karen lotz's avatar

karen lotz

TuTu Train

22,284 posts
Sep 5, 2011 11:32 AM
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.
Sep 5, 2011 11:32am
V

vball10set

paying it forward

24,795 posts
Sep 5, 2011 1:19 PM
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
Sep 5, 2011 1:19pm
karen lotz's avatar

karen lotz

TuTu Train

22,284 posts
Sep 5, 2011 1:39 PM
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
Sep 5, 2011 1:39pm
V

vball10set

paying it forward

24,795 posts
Sep 5, 2011 2:09 PM
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
Sep 5, 2011 2:09pm
V

vball10set

paying it forward

24,795 posts
Sep 5, 2011 2:34 PM
I had to reset my password on my laptop, and now I'm good to go--thanks again
Sep 5, 2011 2:34pm
Mr Miyagi's avatar

Mr Miyagi

wax on, wax off

1,211 posts
Sep 5, 2011 6:12 PM
for some reason i cant make any picks, i keep getting what post # 26 says
Sep 5, 2011 6:12pm
gorocks99's avatar

gorocks99

Senior Member

10,760 posts
Sep 6, 2011 3:33 PM
Mr Miyagi;884247 wrote:for some reason i cant make any picks, i keep getting what post # 26 says
This^^
Sep 6, 2011 3:33pm
royal_k's avatar

royal_k

Senior Member

4,423 posts
Sep 6, 2011 3:57 PM
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.
Sep 6, 2011 3:57pm
justincredible's avatar

justincredible

Nick Mangold

32,056 posts
Sep 6, 2011 4:39 PM
Fixed it. Updated the module using the developers script but it did not add the needed column to the table.
Sep 6, 2011 4:39pm
justincredible's avatar

justincredible

Nick Mangold

32,056 posts
Sep 7, 2011 4:28 PM
Don't forget to signup before tomorrow.
Sep 7, 2011 4:28pm
like_that's avatar

like_that

1st Team All-PWN

26,625 posts
Sep 7, 2011 8:03 PM
justincredible;886551 wrote:Don't forget to signup before tomorrow.
K.
Sep 7, 2011 8:03pm
justincredible's avatar

justincredible

Nick Mangold

32,056 posts
Sep 7, 2011 8:44 PM
like_that;886709 wrote:K.
k thanx bai
Sep 7, 2011 8:44pm
Terry_Tate's avatar

Terry_Tate

Senior Member

7,606 posts
Sep 8, 2011 9:09 AM
I just joined. Are my picks in?
Sep 8, 2011 9:09am
justincredible's avatar

justincredible

Nick Mangold

32,056 posts
Sep 8, 2011 10:59 AM
yes
Sep 8, 2011 10:59am
justincredible's avatar

justincredible

Nick Mangold

32,056 posts
Sep 9, 2011 12:28 AM
25 of us are tied for 1st after one game.
Sep 9, 2011 12:28am
wildcats20's avatar

wildcats20

In ROY I Trust!!

27,794 posts
Sep 9, 2011 12:32 AM
I pick the Packers.
Sep 9, 2011 12:32am
justincredible's avatar

justincredible

Nick Mangold

32,056 posts
Sep 9, 2011 12:49 AM
I proud of you.
Sep 9, 2011 12:49am
karen lotz's avatar

karen lotz

TuTu Train

22,284 posts
Sep 9, 2011 12:56 AM
Can you post the names of those who picked the saints so they can be laughed at?
Sep 9, 2011 12:56am
karen lotz's avatar

karen lotz

TuTu Train

22,284 posts
Sep 9, 2011 1:07 AM
Thanks for nothing.
Sep 9, 2011 1:07am
justincredible's avatar

justincredible

Nick Mangold

32,056 posts
Sep 9, 2011 9:35 AM
karen lotz;888615 wrote:Thanks for nothing.
?? Anyone without a point picked the Saints.
Sep 9, 2011 9:35am