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

selinav’s picture

Same 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).

Josias’s picture

Same 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?

drupik’s picture

PDOException: 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).

Any Idea for this?

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.

kevinquillen’s picture

Status: Active » Fixed

Using alpha2, I do not get this error, most likely fixed from all the changes today.

Status: Fixed » Closed (fixed)

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

Anonymous’s picture

Issue summary: View changes

corrected typo