aMember + Drupal 6.x

Discussion in 'Integration' started by robmid, Jan 17, 2010.

  1. robmid

    robmid aMember Pro Customer

    Joined:
    Nov 7, 2007
    Messages:
    10
    Having installed the Drupal plugin, I am getting this error:

    # DB - [ftmprogram-com-d6] - incorrect value. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-com-d6role LIMIT 1' at line 1

    It seems to be looking for a table called "role" and that's a Drupal 5.x thing - Drupal 6.x has a user_roles table. So: my plugin is apparently for Drupal 5.0.

    Is this correct? What to do?
  2. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Please contact us in helpdesk I will check what can be wrong.
  3. robmid

    robmid aMember Pro Customer

    Joined:
    Nov 7, 2007
    Messages:
    10
    Problem Solved...Please add this to "readme.txt"

    Thank you, Alexander.

    I heard from Andrey, and learned that:

    * The database cannot have any dashes (-) in the name
    * In the field for entering Drupal dB and table prefix in the plugin configuration, if there is no table prefix a period (.) should be appended: e.g. if Drupal dB name is mysite_drupal, enter mysite_drupal.

    Please include this in the distribution of the drupal plugin, in the readme.txt file.

    I am now going to continue with the integration...let's see how it goes! No error messages thus far.

    -Bram

Share This Page