VBulletin integration fail - Unknown column 'amemberid' in 'field list'

Discussion in 'Integration' started by thelaunchcoach, Nov 25, 2009.

  1. thelaunchcoach

    thelaunchcoach New Member

    Joined:
    Nov 25, 2009
    Messages:
    15
    Hey there -

    I'm integrating aMember with VBulletin and everything * looks* fine, but when I test the integration by adding a user I get this:

    MYSQL ERROR:<br />Unknown column 'amemberid' in 'field list'<br />in query:<br />SELECT userid, username, amemberid, usertitle FROM hournav6_mbemforum.user WHERE amemberid = '3'

    My amember database is "hournav6_aminfo" and my vBulletin DB is "hournav6_mbemforum". I have added the custom info in amember's VBulliten plugin config page, so I thought it should work.

    Any ideas? I'm wondering if the problem comes from when I ran setup - the amember database admin's password had special characters in it - } and ) - to make it a strong password. Could that have caused a problem?

    I can change the amember database admin's password via PHPMyAdmin, but I can't find a place in AMember to adjust the config settings for that.

    Thanks,

    Dave
  2. thelaunchcoach

    thelaunchcoach New Member

    Joined:
    Nov 25, 2009
    Messages:
    15
    Ok, I actually found how to change the password and took special characters out, but I'm still getting this error. :-(
  3. thelaunchcoach

    thelaunchcoach New Member

    Joined:
    Nov 25, 2009
    Messages:
    15
    Fixed!

    Stupid me ... I skipped part of the instructions.

    You can close this thread.

Share This Page