MosPlus PHPBB Integration w/ Coppermine

[dwessell]

Heyas all...

I am using Mosplus which is basically phpbb integrating with Mambo for login purposes. I'm attempting use Coppermine in the bunch..

I'm getting this error message:
---
While executing query "SELECT user_id, username as user_name, user_level FROM `soljzjqc_mambo`.mos_session INNER JOIN `soljzjqc_mambo`.mos_users ON session_user_id = user_id WHERE session_id='2ee65ab5b5848fd83cb3427016b9fd95' AND session_user_id ='2' AND user_active='1'" on 0

mySQL error: Column: 'username' in field list is ambiguous
----

My bridge file looks something like this:
----
// The web path to your phpBB directory
// If your URL to your board is for example 'http://yoursite_name.com/phpBB2/',
// you'll have to set the below var to '/phpBB2/'.
define('PHPBB_WEB_PATH', '/forums/');
// Logout Flag
// the value of this boolean constant depends on your phpBB version:
// If your version of phpBB is 2.0.4 or lower - change the value to FALSE;
// if your version of phpBB is 2.0.5 or newer - leave it as TRUE
define('PHPBB_LOGOUT_GET', TRUE);
// ------------------------------------------------------------------------- //
// You can keep the default values below if your instalation is standard
// ------------------------------------------------------------------------- //
// The prefix for the phpBB cookies
define('PHPBB_COOKIE_PREFIX', 'mosphpbb'); // The prefix used for board cookies

// Prefix and names for the database tables
define('PHPBB_TABLE_PREFIX', ''); // The prefix used for the DB tables
define('PHPBB_USER_TABLE', 'mos_users'); // The members table
define('PHPBB_SESSION_TABLE', 'mos_session'); // The session table
define('PHPBB_GROUP_TABLE', 'phpbb_groups'); // The groups table
define('PHPBB_UGROUP_TABLE', 'phpbb_user_group'); // The group/user table
----

I have the line that is causing the error message, but I don't quite 100% understand the message (Learning SQL).. Can anyone toss me a bone?

Thanks
David

[Nibbler]

It means there is a 'username' field in both mos_session and mos_users and you need to specify which one youre talking about. Try changing username to mos_users.username in the query.

[dwessell]

Thank you! Not only a fast reply, but I learned something.

Thanks
David