Working with vBulletin & no table prefixes?

Discussion in 'Setting-up protection' started by Boompop, Jun 29, 2006.

  1. Boompop

    Boompop New Member

    Joined:
    Jun 4, 2006
    Messages:
    4
    Hello. I'm trying your demo for the first time, and I'm having a problem making it work with vB. The problem is that my vB database isn't using any table prefixes. My forums/includes/config.php file says this:

    ==========================================
    // ****** TABLE PREFIX ******
    // Prefix that your vBulletin tables have in the database.
    $config['Database']['tableprefix'] = '';
    ==========================================


    So when setting up the aMember plugin for vB, I've tried several different settings, including:

    ==========================================
    mydatabase
    mydatabase.
    mydatabase._
    mydatabase.vb_
    ==========================================

    And saddly, nothing is working. I'm just getting errors like (it always adds "user" to anything I type in):

    "vbulletin3 Board Db and Prefix - incorrect value. Error: Table 'mydatabase.vb_user' doesn't exist"

    ==========================================

    BTW... I used the 4images plugin and it worked perfectly right away (but I'm using a prefix on the tables in that database).

    So my question.... What setting do I need to use to make this work with vB, since I don't have table prefixes?

    Thank you!
  2. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Use

    mydatabase.

    and paste exact error message here.
  3. wolfyman

    wolfyman New Member

    Joined:
    Oct 9, 2005
    Messages:
    12
    I had the same problem.

    My amember db is called wolfyj_amember, the vbulletin db is called 36new.

    In the top field, it requests:

    Which leads me to believe it wants the name of my vbulletin db. So I put in wolfyj_36new and got this error:

    vbulletin3 Board Db and Prefix - incorrect value. Error: Table 'wolfyj_amember.wolfyj_36newuser' doesn't exist


    Then I did as you suggested and entered "mydatabase.", and got this error:

    vbulletin3 Board Db and Prefix - incorrect value. Error: Access denied for user 'wolfyj_amember'@'localhost' to database 'mydatabase'
  4. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    There was a problem in the plugin - when plugin MySQL username and password are filled-in, it does not work correctly with database name. I hope it is fixed now.
  5. wolfyman

    wolfyman New Member

    Joined:
    Oct 9, 2005
    Messages:
    12
    what do you mean it "was" a problem? I just had that problem yesterday, immediately before I posted my message.

    Has it been fixed since then? I just tried it again and it seems broken still.
  6. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    The same problem happened for another customer and was fixed by our support team, I thought it was you.

    Try to remove vBulletin MySQL username and password from aMember CP->Setup->vBulletin3.

    If that does not help, contact us via helpdesk with link http://www.amember.com/forum/showthread.php?t=4654
    and it will be fixed.
  7. wolfyman

    wolfyman New Member

    Joined:
    Oct 9, 2005
    Messages:
    12
    does the vbulletin plugin work with the trial amember?
  8. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Sure, but described problem exists in last published version.

Share This Page