Struggling with PHPBB integration.

Discussion in 'Integration' started by yesfan, Dec 5, 2007.

  1. yesfan

    yesfan New Member

    Joined:
    Dec 5, 2007
    Messages:
    3
    Currently using the trial software to see if it all suits my needs.

    Cant get the db name correct so everything ties in together. I am assuming the db name is the mysql db name? the table prefix is phpbb_ (managed to work that out). Phpbb installed directly from my hosting account and automatically created a sql db with a similar name to this: web90-a-foru-67.

    So would the db name and prefix be web90-a-foru-67.phpbb_ ? Tried this but it wouldnt work? Is the db name in the wrong format. I can create a new db but how to I get phpbb to read the new db?

    As you can see, I am a bit of a db noob and any help will be welcomed. Thx
  2. yesfan

    yesfan New Member

    Joined:
    Dec 5, 2007
    Messages:
    3
    Getting this error now:

    phpBB Board Db and Prefix - 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 '-a-foru-57.phpbb_users LIMIT 1' at line 1
  3. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    Try to specify this in plugin configuration: `web90-a-foru-57`.phpbb_
  4. yesfan

    yesfan New Member

    Joined:
    Dec 5, 2007
    Messages:
    3
    Ok....reinstalled amember and phpbb. Db name is web87-a-foru-57 and prefix is phpbb_. Entered this as db name in amember:

    web87-a-foru-57.phpbb_

    Now get this error

    Phpbb plugin error. Cannot select MySQL database [web87-a-foru-57].
    Error

    Got amember in the root and not in amember dir......would this make any difference?
  5. alexander

    alexander Administrator Staff Member

    Joined:
    Jan 8, 2003
    Messages:
    6,279
    No. This does not make any difference. Please contact as in helpdesk and provide access info we will help.

Share This Page