Hi,

I get the following error when I try to import categories:

Forum vid: 1
Error message
PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'parent' at row 1: INSERT INTO {taxonomy_term_hierarchy} (tid, parent) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => 15 [:db_insert_placeholder_1] => ) in taxonomy_term_save() (line 645 of C:\xampp\htdocs\japnorthwest\modules\taxonomy\taxonomy.module).

I've checked the code and data and I cant see the problem at all. All of the values look like they are integers in the temp table that the module creates.

Any help please?

Thanks,

Paul.

Comments

pradbone’s picture

Assigned: pradbone » Unassigned
Priority: Major » Critical
mbutelman’s picture

I'm getting something similar:

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'parent' at row 1: INSERT INTO {taxonomy_term_hierarchy} (tid, parent) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1); Array ( [:db_insert_placeholder_0] => 11 [:db_insert_placeholder_1] => ) in taxonomy_term_save() (line 648 of /var/www/drupal7/modules/taxonomy/taxonomy.module).

JeremyFrench’s picture

Status: Active » Postponed (maintainer needs more info)

Is anyone still getting this issue with more recent versions of the code?

marktheshark’s picture

FWIW, I don't get this error with the 2.x branch.

JeremyFrench’s picture

Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Thanks. I think this is an old bug then. Anyone please re open if you are still having issues with it.