meta_refresh(3, append_sid("{$phpbb_root_path}index.$phpEx"));
$message = $message . '<br /><br />' . sprintf($user->lang['RETURN_INDEX'], '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a> ');
09. Februar 2015 um 22:01 - 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'
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'
$sql = "SELECT *, {$this->field['username']} AS user_name, "
. "{$this->field['email']} AS user_email, "
. "{$this->field['regdate']} AS user_regdate, "
. "{$this->field['location']} AS user_location, "
. "{$this->field['website']} AS user_website "
. "FROM {$this->usertable} WHERE {$this->field['user_id']} = '$uid'";
$result = cpg_db_query($sql, $this->link_id);
// Table field names
$this->field = array(
'username' => 'username', // name of 'username' field in users table
'user_id' => 'user_id', // name of 'id' field in users table
'password' => 'user_password', // name of 'password' field in users table
'email' => 'user_email', // name of 'email' field in users table
'regdate' => 'user_regdate', // name of 'registered' field in users table
'active' => 'user_active', // is user account active?
'lastvisit' => 'user_lastvisit', // name of 'location' field in users table
'location' => 'user_from', // name of 'location' field in users table
'website' => 'user_website', // name of 'website' field in users table
'usertbl_group_id' => 'group_id', // name of 'group id' field in users table
'grouptbl_group_id' => 'group_id', // name of 'group id' field in groups table
'grouptbl_group_name' => 'group_name' // name of 'group name' field in groups table
);
'location' => 'user_from', // name of 'location' field in users table
If the bridge files aren't included in the Coppermine package ...I was checking the 'cpg1.5 bridging' forum right now and as I did not find the files right away I ask myself is the following:
Again, the redirect has to be done by editing the phpBB files, not the Coppermine files.Got that. In ucp.php as I understood...
I'll try and do an install of phpBB locally tomorrow and see what changes there are.That would be great!!
That is something better asked over at the phpBB forums as we do not know their code.I will do so...
I'll try and do an install of phpBB locally tomorrow and see what changes there are.I'll do this now and post what I found out when I finish my work today.
array(
'target' => PROFILE_FIELDS_DATA_TABLE,
'primary' => 'users.user_id',
'query_first' => array(
array('target', $convert->truncate_statement . PROFILE_FIELDS_DATA_TABLE),
),
array('user_id', 'users.user_id', 'phpbb_user_id'),
array('pf_phpbb_occupation', 'users.user_occ', array('function1' => 'phpbb_set_encoding')),
array('pf_phpbb_interests', 'users.user_interests', array('function1' => 'phpbb_set_encoding')),
array('pf_phpbb_location', 'users.user_from', array('function1' => 'phpbb_set_encoding')),
array('pf_phpbb_icq', 'users.user_icq', array('function1' => 'phpbb_set_encoding')),
array('pf_phpbb_wlm', 'users.user_msnm', array('function1' => 'phpbb_set_encoding')),
array('pf_phpbb_yahoo', 'users.user_yim', array('function1' => 'phpbb_set_encoding')),
array('pf_phpbb_aol', 'users.user_aim', array('function1' => 'phpbb_set_encoding')),
array('pf_phpbb_website', 'users.user_website', 'validate_website'),
'where' => 'users.user_id <> -1',
),
'location' => 'user_from', // name of 'location' field in users table
'website' => 'user_website', // name of 'website' field in users table
with 'location' => "''", // name of 'location' field in users table
'website' => "''", // name of 'website' field in users table
But what about the redirecting back from phpbb after logging in??
The current code in udb_base.inc.php doesn't support joining other tables. But as neither user_location nor user_website is used anywhere in the rest of the Coppermine code (at least I haven't found a direct access to it), we can simply replaceCode: [Select]'location' => 'user_from', // name of 'location' field in users table
with
'website' => 'user_website', // name of 'website' field in users tableCode: [Select]'location' => "''", // name of 'location' field in users table
'website' => "''", // name of 'website' field in users table
This should fix the error message when bridged to phpBB 3.1 and should also work with phpBB 3.0. If somebody can verify that it works for both, I'll update the bridge file accordingly.
ecards went again in the spam folder. With bridge enabled and without... :-[That will be a setting on your mail client. Nothing we can do to help with that.
Create a file in your phpBB root directory named cpg_redir.phpCould that still do the trick??
Content:Code: [Select]<?php
if (!$_SERVER['HTTP_HOST']) {
$cpg_host=$HTTP_SERVER_VARS['HTTP_HOST'];
} else {
$cpg_host=$_SERVER['HTTP_HOST'];
}
$cpg_path='/gallery';
header("Location: http://".$cpg_host.$cpg_path);
exit;
?>
Please unterstand that we're not the phpBB support. Either test it yourself or ask the phpBB team/community.
<?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);
.
.
.
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);
}
.
.
.