phpbb bridging not working, fresh install

[donnoman]

I guess I'm going to have to rely on Casper.

Casper, when your admin problem with phpbb is taken care of would you mind testing the uploader code to see if it still causes a problem.

Thanks.

Nibbler, you can click here

[Casper]

Tommy,

all works fine now, with the one exception, which is when trying to view users from the gallery admin menu, which brings this error;

While executing query "SELECT user_id as user_id, username as user_name, user_email as user_email, user_regdate as user_regdate, user_lastvisit as user_lastvisit, user_active as user_active, COUNT(pid) as pic_count, ROUND(SUM(total_filesize)/1024) as disk_usage, group_name, group_quota FROM `clive_cpg`.phpbb_users AS u INNER JOIN devel_usergroups AS g ON u.group_id+100 = g.group_id LEFT JOIN devel_pictures AS p ON p.owner_id = u.user_id GROUP BY user_id ORDER BY user_regdate DESC LIMIT 0, 25;" on 0

mySQL error: Unknown column 'u.group_id' in 'on clause'

[Nibbler]

Comment out this line

Code Select Expand

function view_users() {}

in the bridge file. The users page should be redirecting still, I'll add user list support for phpbb shortly.

[Nibbler]

User list view enabled in phpbb.inc.php 1.40

[Casper]

Yep, that did it. (1.39)

Donnoman, trying the original code now with the fixed bridge file still causes a db error,

While executing query "SELECT user_id as user_id FROM `clive_cpg`.phpbb_users WHERE group_id in (1)" on 0

mySQL error: Unknown column 'group_id' in 'where clause'

With the code commented out, it works fine.

[donnoman]

I finally see what Nibbler was saying.

Yes, I have to concur I don't see how we can get there from here without making changes to the bridge files for each forum that doesn't use a group_id field in the user table.

The only way I see to reliably implement the feature is to add functions for this specific purpose to the bridge files, it will have to wait until 1.5 or NG.

Leave it disabled.