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
Comment #1
jvandervort commentedFixed commited to dev.
Thanks for the tip!
Comment #2
ghostdog19 commentedThanks, the patch fixed it.