Hi,

If I try to update the user account to add any Twitter sync data I get the following error upon pressing submit.

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'start_date' at row 1: INSERT INTO {flickrsync_users} (uid, nsid, identifier, start_date, tags) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => 48640969@N06 [:db_insert_placeholder_2] => Danielle Hallett [:db_insert_placeholder_3] => [:db_insert_placeholder_4] => ) in flickrsync_user_presave() (line 223 of /home/danielle/public_html/sites/all/modules/flickrsync/flickrsync.module).

Looks like the array has the right data, but fails when trying to write to the db.

No debugging other than trying it on two sites and getting the same result; I'll look into it more when I get back later.

Danielle x

Comments

gclicon’s picture

gclicon commented

Thanks reporting the issue. The D7 version of the module is still being ported from D6. If you come across a solution, we'd be more than happy to commit a patch.

gclicon’s picture

gclicon commented
Status: Active » Closed (fixed)

I was unable to reproduce this issue, but upon some code review and review of commits, I found that we actually fixed this issue by adding a check to the start_date field:

$start_date = is_numeric($start_date) ? $start_date : 0;

WIthout this check, the start_date column was being set to a non integer value if it was empty.

Closing and marking as fixed.