Drupal 7 integration problem

Events happening in the community are now at Drupal community events on www.drupal.org.
jinkler's picture
Posted by jinkler on March 9, 2011 at 6:17am

Hi,

I've just installed Drupal 7 to give this a whirl.

I'm getting a strange error though:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'talkford_ips.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] => monkeyrablue ) in ipbridge_authenticate_validate() (line 52 of /home/talkford/public_html/development/drupal7/modules/ipbridge/ipbridge.module)...

Specifically:

Table 'talkford_ips.ibf_members' doesn't exist:

Correct, it doesn't exist. Why is it calling ibf_members? That table doesn't exist within my IP.Board database. I have ipsmembers, but no ibf_members. Running version 3.1.4.

Any help appreciated!

Comments

in ipbridge.module change

Posted by stefan vaduva on March 9, 2011 at 9:13am
stefan vaduva's picture

in ipbridge.module change "ibf_members" with "ipsmembers". This will be editable in the admin interface in a future version.

Thanks Stefan! Funnily enough

Posted by jinkler on March 9, 2011 at 10:06am
jinkler's picture

Thanks Stefan!

Funnily enough I did jump into that file, didn't look hard enough.

I can now report it works fine :-)

Are there any plans for it to authenticate with IP.Converge?

Thanks

Nick

Sorry, no plans for

Posted by stefan vaduva on March 9, 2011 at 10:14am
stefan vaduva's picture

Sorry, no plans for IP.Converge. But if you or somebody else is willing to do this, I'll more than happy to add him as co-maintainer for this module.

If only I had the skills....

Posted by jinkler on March 9, 2011 at 10:20am
jinkler's picture

If only I had the skills.... my programming knowledge is pretty much limited to minor file edits I'm afraid. I have read the IP.converge developers notes, it's all a foreign language to me!

For those using IP.Board 3.4.x

Posted by Vane on March 4, 2013 at 6:55am
Vane's picture

In the IP.Bridge.module, open it and look for this

$records = db_select('ibf_members', 'u', array('target' => 'ipb'))
->fields('u', array('member_id', 'name', 'members_pass_hash', 'members_pass_salt', 'email'))
->condition('u.name', $name, '=')
->execute();

================================
Now change it to look like this

================================
$records = db_select('members', 'u', array('target' => 'ipb'))
->fields('u', array('member_id', 'name', 'members_pass_hash', 'members_pass_salt', 'email'))
->condition('u.name', $name, '=')

->execute();

The main note being, ibf_members, is now members.

This is for IP.Board 3.4.2

Should work with 3.4.x

Next suite coming out is 4.0.

A module should never

Posted by demon326 on March 4, 2013 at 10:58am
demon326's picture

A module should never hardcode tablenames and also not the prefixes.... I realy hope that there will be a bridge that does better so that password changes also work....