Drupal errors

Discussion in 'Integration' started by jjanney, Mar 29, 2007.

  1. jjanney

    jjanney New Member

    Joined:
    Mar 29, 2007
    Messages:
    11
    Drupal Db and Prefix - incorrect value. Error: Table 'amember.drupalrole' doesn't e

    I downloaded the latest ZEND version of aMember and the latest Drupal (5.x) and am trying to integrate them. I am following the instructions (as best I can) and it doesn't seem to work.

    INSTALLATION:
    1. Copy plugin files to amember/plugins/protect/Drupal/ folder

    Okay, I'm not sure what files, but I looked in the folder and there were already three files there: config.inc.php, drupal.inc.php and readme.txt

    2. Enable plugin at aMember CP -> Setup -> Plugins

    Done

    3. Configure plugin at aMember CP -> Setup -> Drupal

    This is where I have trouble. I enter the database name (I didn't set any prefixes when installing Drupal, so I just entered the database name: drupaldb) and the system returns the following error:

    Drupal Db and Prefix - incorrect value. Error: Table 'amember.drupaldbrole' doesn't exist

    4. Login to Drupal and create user roles using Drupal admin panel
    (for example: "paid", "members", etc.)

    Okay, done (members)

    5. Adjust product settings at aMember CP -> Edit Products

    Okay... I don't see where there is any place to edit anything related to a Drupal role. Am I missing something?

    6. Try it - add "Paid" subscription to member and this user
    will be added to Drupal database. Delete this subscription,
    or mark it as "Not-Paid" and user will be blocked. Delete
    user from aMember database (using aMember CP controls) and
    user will be locked in Drupal database.

    Well, I'm unable to test because I can't get this far with the process. Any help on the forum will be greatly appreciated.
  2. jjanney

    jjanney New Member

    Joined:
    Mar 29, 2007
    Messages:
    11
    Drupal Db and Prefix - incorrect value.

    I dug into the Manual and found an important detail: placing a dot after the database name. Now, I'm getting the

    Drupal Db and Prefix - incorrect value. Error: select command denied to user: 'amember@localhost' for table 'role'

    error, but I found a post explaining that I need to add amember as a user to the Drupal database.
  3. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    it is necessary to allow MySQL user "amember" access to Drupal database and tables.
  4. jjanney

    jjanney New Member

    Joined:
    Mar 29, 2007
    Messages:
    11
    custom logout for drupal/amember

    When users click "Log out" in the Drupal-supplied menu, Drupal logs them out but aMember does not. If users click "Log out" in aMember, it logs them out of both aMember and Drupal. I would like to replace the Drupal-supplied menu item ([domain name]/logout) to the aMember log out link ([domain name]/amember/logout.php) but I am having trouble finding where/how to do this. When I tried to edit the menu item from the Drupal admin, it was not editable.

    -------------------------------------------------------------------------------------

    Problem Solved!

    I had to hard-code the link in Drupal's modules/user/user.module file, line 781 as follows:

    From:

    Code:
        $items[] = array('path' => 'logout', 'title' => t('Log out'),
    To:

    Code:
        $items[] = array('path' => 'amember/logout.php', 'title' => t('Log out'),
  5. alex

    alex aMember Pro Customer Staff Member

    Joined:
    Jan 24, 2004
    Messages:
    6,021
    Thank you very much, we will add it to manual.
  6. nonprofitexpressions

    nonprofitexpressions New Member

    Joined:
    Nov 20, 2007
    Messages:
    1
    Does not work

    I have tried this fix for Drupal to log out of amember with no luck..

    How do I get amember to login into drual, and how do I get drupal to log out of amember?

    Thanks,

    Aaron
  7. newrider

    newrider New Member

    Joined:
    Mar 11, 2009
    Messages:
    1
    I'd like to know as well

    I'd like to know as well
  8. codeispoetry

    codeispoetry aMember Pro Customer

    Joined:
    Jan 12, 2009
    Messages:
    336
    There is a Drupal plugin which you can use for this integration. You can purchase it from aMember.

    Lee

Share This Page