Joomla help please...

Discussion in 'Integration' started by sc0tsman, Mar 24, 2010.

  1. sc0tsman

    sc0tsman Member

    Joined:
    Nov 25, 2009
    Messages:
    119
    I am trying to config amember to integrate with joomla however I am not to clever with these things can someone please help.

    I have no idea what t input for "joomla Db and Prefix" when setting up in amember.

    I have tried numerous combinations of joomla.jos etc but it looks like i am going down the wrong route, please help.

    Thanks in advance
  2. davidm1

    davidm1 aMember User & Partner

    Joined:
    May 16, 2006
    Messages:
    4,437
    Go into your joomla configuration screen / server
    Database
    Database Prefix

    You then use the format Database.Database_Prefix in the plugin setting.
    Unless you have added the amember user in your cpanel/mysql to access the joomla database- then you dont need to set the database info- its done automatically.

    David
  3. sc0tsman

    sc0tsman Member

    Joined:
    Nov 25, 2009
    Messages:
    119
    Looks like I may have to skip amember/joomla integration as I simply can not get it to work.

    I tried exactly as you said and still get the following error

    joomla Db and Prefix - incorrect value. Error: Table 'admin_amember.jos_users' doesn't exist
  4. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    What is your aMember database name and what is Joomla database name? I will provide exact example.
  5. sc0tsman

    sc0tsman Member

    Joined:
    Nov 25, 2009
    Messages:
    119
    admin_amember
    admin_joomla

    thanks
  6. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Did you tryed this: admin_joomla.jos_
    and if yes what error you got exactly ?
  7. sc0tsman

    sc0tsman Member

    Joined:
    Nov 25, 2009
    Messages:
    119
    error:

    joomla Db and Prefix - incorrect value. Error: SELECT command denied to user 'admin_amember'@'localhost' for table 'jos_users'
  8. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    So , you need to login into your hosting cpanel go to manage database and grant access permissions for user admin_amember to access database admin_joomla
    Then use admin_joomla.jos_ in plugin configuration. It should work.
  9. sc0tsman

    sc0tsman Member

    Joined:
    Nov 25, 2009
    Messages:
    119
    all access permissions granted and still getting error...

    joomla Db and Prefix - incorrect value. Error: SELECT command denied to user 'admin_amember'@'localhost' for table 'jos_users'

    amember has worked perfect so I know that is fine but it refuses to accept joomla plugin
  10. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Can you include scvreenshot of permission page for this user and DB?
    There is no other explanation for this error message. It means that aMember's mysql user is not able to access table in Joomla database so permissions are not right.
    If you believe that you set permissions right, then something is wrong with cpanel.
    Also if you can please contact us in helpdesk and provide cpanel and aMember CP access info, I will try to configure it myself.
  11. sc0tsman

    sc0tsman Member

    Joined:
    Nov 25, 2009
    Messages:
    119
    I have sent a ticket re: fraudulent amember account please respond

Share This Page