When I assign the view taxonomy_term for my vacabulary, then when I check "override" and save the settings, I get the error message:
PDOException: SQLSTATE [HY000]: General error: 1366 Incorrect integer value:''for column 'view_id' at row 1: INSERT INTO {tvi_settings} (type, xid, view_id, display, status) 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] => vocab [: db_insert_placeholder_1] => 1 [: db_insert_placeholder_2] => [: db_insert_placeholder_3] => 1: default [: db_insert_placeholder_4] => 1) function tvi_update_settings () (line 88 in file / //modules/tvi/includes/tvi.query.inc).
Comments
Comment #1
selinav commentedSame message for me
PDOException : SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'view_id' at row 1: INSERT INTO {tvi_settings} (type, xid, view_id, display, status) 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] => vocab [:db_insert_placeholder_1] => 2 [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => 3:default [:db_insert_placeholder_4] => 1 ) dans tvi_update_settings() (ligne 88 dans C:\wamp\www\mysite\sites\all\modules\tvi\includes\tvi.query.inc).
Comment #2
Josias commentedSame Issue for me.
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'view_id' at row 1: INSERT INTO {tvi_settings} (type, xid, view_id, display, status) 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] => term [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => 4:page_1 [:db_insert_placeholder_4] => 1 ) en tvi_update_settings() (línea 88 de
/sites/all/modules/tvi/includes/tvi.query.inc).
Any Idea for this?
Comment #3
drupik commentedPDOException: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'view_id' at row 1: INSERT INTO {tvi_settings} (type, xid, view_id, display, status) 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] => vocab [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => 1:page_1 [:db_insert_placeholder_4] => 1 ) in tvi_update_settings() (line 88 of /home/online/mxxs/sites/all/modules/tvi/includes/tvi.query.inc).Yeah, manually insert to db ;)
INSERT INTO 'new_db'.'tvi_settings' ('type', 'xid', 'view_id', 'display', 'status') VALUES ('vocab', '1', '1', '1:page_1', '1');You can do it with latest views3, just type path eg: /articles/% without this module.
Comment #4
kevinquillen commentedUsing alpha2, I do not get this error, most likely fixed from all the changes today.
Comment #5.0
(not verified) commentedcorrected typo