Bridging issues Coppermine 1.5.34 with phpBB 3.1.x

zorbas2 · Post by **zorbas2** » Sat Feb 14, 2015 2:14 pm

I am not sure if this is the right place to post my issue...
I searched here and the coppermine support forums but found no final solution to my issue:
Since the update to phpBB 3.1.x the bridge file in the coppermine folder (phpbb3.inc.php) won't work properly as there were some changes to the tables in phpbb 3.1.x
Does anyone managed to adapt the phpbb3.inc.php to the latest phpBB version??
Also it seems that I need to manually edit my ucp.php in phpBB to get the redirects working properly when bridging.
Has anyone a clue what to do in this file?? (I guess I am right that edits are needed...?)

Post by **Brf** » Sat Feb 14, 2015 3:29 pm

Mods for phpBB 3.0 will not work with 3.1.

zorbas2 · Post by **zorbas2** » Sat Feb 14, 2015 6:19 pm

Brf wrote:Mods for phpBB 3.0 will not work with 3.1.

I understand this, but I had a different question...

Lumpy Burgertushie · Post by **Lumpy Burgertushie** » Sat Feb 14, 2015 8:56 pm

I would assume that you would have to askt the people that work with coppermine if and when they are going to upgrade their bridge to work with the new version of phpbb.

robert

zorbas2 · Post by **zorbas2** » Sat Feb 14, 2015 9:09 pm

I am in constant contact with them especially regarding the bridge file phpbb3.inc.php
But they suggested to post also in this forum because you guys know the phpBB files better. Especially regarding the redirects in ucp.php

Ibedejo · Post by **Ibedejo** » Sat Feb 14, 2015 10:45 pm

Hi,

what does " the bridge file in the coppermine folder (phpbb3.inc.php) won't work properly" in your case mean?
For quite a while I'm testing this in various scenarios: initial install of Coppermine 1.5.34 bridged with phpBB 3.0.11 then phpBB upgrade to 3.1.2/3.1.3, new install phpBB 3.1.3 and Coppermine, then bridging.

As far as I can see up to now, everything seems to be working the way it should - out of the box.

zorbas2 wrote:Also it seems that I need to manually edit my ucp.php in phpBB to get the redirects working properly when bridging.

Same here: which "redirects"?

zorbas2 · Post by **zorbas2** » Sun Feb 15, 2015 8:23 am

I have an updated phpBB 3.1.3. plus an updated cpg 1.5.34
The bridge was working ok (after login in phpbb user was also logged in in cpg) except of the following issues:

N°1
When sending an ecard I get the following error:

Code: Select all

While executing query 'SELECT *, username AS user_name, user_email AS user_email, user_regdate AS user_regdate, user_from AS user_location, user_website AS user_website FROM `db466936751`.phpbb3_users WHERE user_id = '2'' in bridge/udb_base.inc.php on line 413 the following error was encountered: 
Unknown column 'user_from' in 'field list'

This probably is because
in the table
'prefix_users' there is no field anymore corresponding to 'location'

However, this field is found now in the table
'prefix_profile_fields_data' named as 'pf_phpbb_location'

But in phpbb3.inc.php it says:

Code: Select all

'location' => 'user_from', // name of 'location' field in users table

N°2
When I click on 'login' in cpg I get redirected to the phpBB-login. After logging in I don't get redirected back to cpg.
But I am logged in there as well if I go back manually...
Don't know about logging out though. Haven't tried that yet...
People told me this redirect is handled by the ucp.php from phpBB (?)

zorbas2 · Post by **zorbas2** » Sun Feb 15, 2015 7:26 pm

Problem N°1 Solved.
Solution can be found here:http://forum.coppermine-gallery.net/ind ... #msg377669

But I am still searching for problem N°2
After successful login in phpbb I am not redirected back to coppermine...

zorbas2 · Post by **zorbas2** » Mon Feb 16, 2015 3:26 pm

As I am still searching for a solution I need to go on to chase this subject.
As said in my last post a solution for the bridge file has been found. Table and fields associations are working well now.

But there is still this 'redirect problem':
When clicking on 'Login' in cpg I get redirected to phpBB to perform the login. But after successful login I am not automatically redirected back to cpg.
Same thing when logging out.
Isn't somewhere out there a phpBB pro who would know what to do??

zorbas2 · Post by **zorbas2** » Tue Feb 17, 2015 4:35 pm

A solution for the redirect issue has been found:

Create a file which I named 'redirect.php' in the phpbb root folder (see below)

My redirect.php:

Code: Select all

<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);

$redirect_target = '../CoppermineFolder';    /* Path to Coppermine!  */

$user->session_begin(); 
$auth->acl($user->data);

if(!$user->data['is_registered'])
{
login_box($redirect_target);
}
else if ($user->data['user_id'] != ANONYMOUS && $request->is_set('sid') && $request->variable('sid', '') === $user->session_id)
        {
            $user->session_kill();
        }

redirect($redirect_target);

In the bridge file phpbb3.inc.php the following part need to be changed:

Code: Select all

.
.
.

        function login_page()
        {
            global $CONFIG;

            $redirect = urlencode($CONFIG['site_url']);
            $this->redirect("/redirect.php");
        }

        function logout_page()
        {
            global $CONFIG;

            $redirect = urlencode($CONFIG['site_url']);
            $this->redirect("/redirect.php?mode=logout&redirect=$redirect&sid=" . $this->session_id);
        }
.
.
.

Works perfectly fo me now...