Hi there,

Thanks for creating an IPB bridge! I get this error when trying to login:

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'lee' for key 2: INSERT INTO {users} (uid, name, pass, mail, created, access, status, init) 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); Array ( [:db_insert_placeholder_0] => 2 [:db_insert_placeholder_1] => lee [:db_insert_placeholder_2] => $S$C8Dw/dxNvWTAvJ45EHLNEVkZhUEvMw9dLO.RTfHeHRFfHC8nQeVD [:db_insert_placeholder_3] => lee@apexdc.net [:db_insert_placeholder_4] => 1294847990 [:db_insert_placeholder_5] => 1294847990 [:db_insert_placeholder_6] => 1 [:db_insert_placeholder_7] => lee ) in drupal_write_record() (line 6776 of /home/apexdc/public_html/drupal/includes/common.inc).

Any help to rectify this issue is appreciated :)

Comments

stefan vaduva’s picture

stefan vaduva commented

Hi,

Sorry for this late reply. I'll get back to this module very soon. Did you had any old users in the Drupal database before activating this module? It seems that when the module tries to register a new user in Drupal (coming from IPB) it finds and existing one with the same name and that is why it has the error. Normally it should't happen, but I'll check to see what I'm missing.

Can you tell me if you have this with the final version of D7 or with an pre-release version?

sammyman’s picture

sammyman commented

Thanks for your work on this module! I am getting the same or very similar error as the user above. I just installed a fresh version of drupal 7, and was hoping to tie into the user database of ipb3. This is my error:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'landy_ipb3.ibf_members' doesn't exist: SELECT u.member_id AS member_id, u.name AS name, u.members_pass_hash AS members_pass_hash, u.members_pass_salt AS members_pass_salt, u.email AS email FROM {ibf_members} u WHERE (u.name = :db_condition_placeholder_0) ; Array ( [:db_condition_placeholder_0] => xxx@gmail.com ) in ipbridge_authenticate_validate() (line 52 of /home/xxx/public_html/manuals/modules/ipbridge/ipbridge.module).

stefan vaduva’s picture

stefan vaduva commented

It seems that your IPB database is not correctly configured (in settings.php)

Check in phpmyadmin (or other mysql manager) if you database really is landy_ipb3 and if table prefix is ibf_

stefan vaduva’s picture

stefan vaduva commented
Status: Active » Closed (fixed)