After a user filled in the predicted score ("Pick the score of each game and get points for correct score differential and winner.") for the matchups of the week and hits "Save Picks", following error message comes up and no data is saved.

PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'picktime' at row 1: INSERT INTO {pickem_picks} (gid, uid, lid, pick_v_score, pick_h_score, picktime) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => 1 [:db_insert_placeholder_4] => 1 [:db_insert_placeholder_5] => 2012-05-04 13:21:36 ) in set_pick() (line 534 of [project]/sites/all/modules/pickem/pickem.inc).

Webserver: Apache/2.2.14 (Ubuntu), MySQL-Client-Version: 5.1.61
phpMyAdmin: 3.3.2deb1ubuntu1
MySQL: Server Version: 5.1.61-0ubuntu0.10.04.1-log

Can you help?

Comments

jvandervort’s picture

Status: Active » Fixed

Fixed commited to dev.
Thanks for the tip!

ghostdog19’s picture

Thanks, the patch fixed it.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.