I tried to import my php using php2drupal to drupal version 6 with no luck, so I have created the site again in drupal 7, hoping it will work this time. When I go through the steps I end up with the following errors:

This was importing forums:

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'tid' at row 1: INSERT INTO {taxonomy_index} (nid, tid, sticky, created) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => 28 [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => 1267549521 ) in taxonomy_field_insert() (line 1725 of /home//public_html/modules/taxonomy/taxonomy.module).

When I try to do posts it said congratulations imported but they are not. Thanks for your help in advance.

Users I get this error:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'user_yim' for key 2: INSERT INTO {profile_field} (title, name, explanation, category, page, type, weight, required, register, visibility, options) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10), (:db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21), (:db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32), (:db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41, :db_insert_placeholder_42, :db_insert_placeholder_43), (:db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47, :db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53, :db_insert_placeholder_54), (:db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59, :db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65), (:db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71, :db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76); Array ( [:db_insert_placeholder_0] => YIM [:db_insert_placeholder_1] => user_yim [:db_insert_placeholder_2] => [:db_insert_placeholder_3] => Contact [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => textfield [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => 1 [:db_insert_placeholder_9] => 2 [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => AIM [:db_insert_placeholder_12] => user_aim [:db_insert_placeholder_13] => [:db_insert_placeholder_14] => Contact [:db_insert_placeholder_15] => [:db_insert_placeholder_16] => textfield [:db_insert_placeholder_17] => 0 [:db_insert_placeholder_18] => 0 [:db_insert_placeholder_19] => 1 [:db_insert_placeholder_20] => 2 [:db_insert_placeholder_21] => [:db_insert_placeholder_22] => icq [:db_insert_placeholder_23] => user_icq [:db_insert_placeholder_24] => [:db_insert_placeholder_25] => Contact [:db_insert_placeholder_26] => [:db_insert_placeholder_27] => textfield [:db_insert_placeholder_28] => 0 [:db_insert_placeholder_29] => 0 [:db_insert_placeholder_30] => 1 [:db_insert_placeholder_31] => 2 [:db_insert_placeholder_32] => [:db_insert_placeholder_33] => Website [:db_insert_placeholder_34] => user_website [:db_insert_placeholder_35] => [:db_insert_placeholder_36] => Contact [:db_insert_placeholder_37] => [:db_insert_placeholder_38] => url [:db_insert_placeholder_39] => 0 [:db_insert_placeholder_40] => 0 [:db_insert_placeholder_41] => 1 [:db_insert_placeholder_42] => 2 [:db_insert_placeholder_43] => [:db_insert_placeholder_44] => Location [:db_insert_placeholder_45] => user_from [:db_insert_placeholder_46] => [:db_insert_placeholder_47] => Personal [:db_insert_placeholder_48] => [:db_insert_placeholder_49] => textfield [:db_insert_placeholder_50] => 0 [:db_insert_placeholder_51] => 0 [:db_insert_placeholder_52] => 1 [:db_insert_placeholder_53] => 2 [:db_insert_placeholder_54] => [:db_insert_placeholder_55] => Occupation [:db_insert_placeholder_56] => user_occ [:db_insert_placeholder_57] => [:db_insert_placeholder_58] => Personal [:db_insert_placeholder_59] => [:db_insert_placeholder_60] => textfield [:db_insert_placeholder_61] => 0 [:db_insert_placeholder_62] => 0 [:db_insert_placeholder_63] => 1 [:db_insert_placeholder_64] => 2 [:db_insert_placeholder_65] => [:db_insert_placeholder_66] => Interests [:db_insert_placeholder_67] => user_interests [:db_insert_placeholder_68] => [:db_insert_placeholder_69] => Personal [:db_insert_placeholder_70] => [:db_insert_placeholder_71] => textfield [:db_insert_placeholder_72] => 0 [:db_insert_placeholder_73] => 0 [:db_insert_placeholder_74] => 1 [:db_insert_placeholder_75] => 2 [:db_insert_placeholder_76] => ) in phpbb2drupal_import_users() (line 331 of /home/ /public_html/sites/all/modules/phpbb2drupal/phpbb2drupal.mo

Comments

Lemontonix’s picture

Same problem with me....

JeremyFrench’s picture

Status: Active » Closed (cannot reproduce)

I think this is an issue with the old version of the module, could you try again, re open if you have the same problem.