I get this error when trying to save a node, after uploading a video.
user warning: Incorrect integer value: '' for column 'field_jfvideo_status_ts' at row 1 query: INSERT INTO content_type_blog (field_jfvideo_id, field_jfvideo_status, field_jfvideo_status_ts, field_jfvideo_fid, vid, nid) VALUES ('K7hzUn5nyAg', 0, '', 0, 9, 9) in C:\Documents and Settings\jimfennacy\My Documents\Websites\drupal_5\includes\database.mysql.inc on line 172.
If I run the SQL changing the '' to UNIX_TIMESTAMP(now()), edit the node and save it again, then the node displays the video just fine. However when saving the node a second time I get this error:
user warning: Incorrect integer value: '' for column 'field_jfvideo_status_ts' at row 1 query: UPDATE content_type_blog SET field_jfvideo_id = '', field_jfvideo_status = 0, field_jfvideo_status_ts = '', field_jfvideo_fid = 0 WHERE vid = 9 AND nid = 9 in C:\Documents and Settings\jimfennacy\My Documents\Websites\drupal_5\includes\database.mysql.inc on line 172.
I am working on my localhost trying to prepare a demo for a client. I have tried 5.x-1.0-beta2 and 5.x-1.x-dev. My configuration seems to be ok in that I do not get any errors on the CCK field screen. The video DOES upload to YouTube and I can see it there (http://www.youtube.com/watch?v=K7hzUn5nyAg). Drupal 5.7, CCK 5.x-1.10, PHP 5.2.6, MySQL 5.0.67, Windows XP Pro, Apache 2.2.
JF
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | contributions-modules-video_upload-DRUPAL-5.patch | 1.06 KB | graper |
Comments
Comment #1
graper commentedthe problem is with a value of '' being assigned as the default values to the field with the field is a integer type field and not a string.
Comment #2
graper commented