errors in phpbb2 plus & CPG integ

[jimmyfi]

Warning: Undefined index: user_level in /var/www/galleria/bridge/phpbb.inc.php on line 130

Warning: Undefined index: user_level in /var/www/galleria/bridge/phpbb.inc.php on line 164

I get that kind of errors.. I have PHPBB2 Plus in use and auto-group mod...
and CPG 1.3.0

is there a way to fix this?

[jimmyfi]

uh and theres more errors...

If not logged in and try to go to members pics .. mysql error comes...
as admin press admin tools -- mysql error...

heres the posted errors :
ADMIN TOOLS :
While executing query "SELECT aid, category, IF(username IS NOT NULL, CONCAT('(', username, ') ',title), CONCAT(' - ', title)) AS title FROM cpg11d_albums AS a LEFT JOIN phpbb_users AS u ON category = (10000 + user_id) ORDER BY category, title" on

mySQL error: Table 'galleria.phpbb_users' doesn't exist


USER GALLERIES:
While executing query "SELECT count(*) FROM cpg11d_albums as a WHERE category = '1' and AND a.aid NOT IN (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,82,91,92) " on 0

mySQL error: You have an error in your SQL syntax near 'AND a.aid NOT IN (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,2' at line 1


o_O *beep* is wrong?

uh and the user galleries owners has changed too.. bit stragne ..

[Casper]

mySQL error: Table 'galleria.phpbb_users' doesn't exist

Does this table actually exist, on the galleria database?

uh and the user galleries owners has changed too.. bit stragne ..

The ideal time to bridge is when both installs are new, or the coppermine install is new.  When you already have users on both installs, and you then bridge, it is unlikely they have the same user id on both.  As coppermine sees the pics and albums belonging to, say, user 3, but when you bridge user 3 is a different person, or may not exist, this causes problems.
You will have to change the entries in one of the databases to match the other.

[jimmyfi]

mySQL error: Table 'galleria.phpbb_users' doesn't exist

Does this table actually exist, on the galleria database?

nope that table should be in portal.phpbb_users 

[Casper]

In that case please post the lines of your phpbb.inc.php you edited here. (lines 24 - 51)

Note, do not show the password.

[jimmyfi]

// database configuration
define('PHPBB_DB_NAME', 'portal'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', 'root'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', '***********'); // The password to use to connect to the database

// 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 '/'.
define('PHPBB_WEB_PATH', '/');
// 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', 'phpbb2mysql'); // The prefix used for board cookies

// Prefix and names for the database tables
define('PHPBB_TABLE_PREFIX', 'phpbb_'); // The prefix used for the DB tables
define('PHPBB_USER_TABLE', 'users'); // The members table
define('PHPBB_SESSION_TABLE', 'sessions'); // The session table
define('PHPBB_GROUP_TABLE', 'groups'); // The groups table
define('PHPBB_UGROUP_TABLE', 'user_group'); // The group/user table

[jimmyfi]

uh and the user galleries owners has changed too.. bit stragne ..

The ideal time to bridge is when both installs are new, or the coppermine install is new.  When you already have users on both installs, and you then bridge, it is unlikely they have the same user id on both.  As coppermine sees the pics and albums belonging to, say, user 3, but when you bridge user 3 is a different person, or may not exist, this causes problems.
You will have to change the entries in one of the databases to match the other.

I tried to change them manually but.. ARGH it sucks

[Nibbler]

Get the latest stable version of the phpbb bridge from here.

[jimmyfi]

well still the same errors occurs.. well i think i have to ask for users to upload their pics again.... or do that database editing... :/

[DaMysterious]

Warning: Undefined index: user_level in /var/www/galleria/bridge/phpbb.inc.php on line 130

Warning: Undefined index: user_level in /var/www/galleria/bridge/phpbb.inc.php on line 164

I get that kind of errors.. I have PHPBB2 Plus in use and auto-group mod...
and CPG 1.3.0

is there a way to fix this?

Wich version of the Plus range do you use, v1.2 or v1.3?

[jimmyfi]

Wich version of the Plus range do you use, v1.2 or v1.3?

1.3

[DaMysterious]

Wich version of the Plus range do you use, v1.2 or v1.3?

1.3

Ok I'm using this version to. Maybe I can help.

Database tables from both plus and cpg may reside in a different database for me (I'm on a Windows server).


Place 'cpg_redir.php' into your phpBB Plus root (change the 'gallery' path to yours).

Code Select Expand


<?php 
$cpg_host=$HTTP_SERVER_VARS['HTTP_HOST']; 
$cpg_path='/gallery';  //Change to make your path to Coppermine
header("Location: http://".$cpg_host.$cpg_path); exit; 
?>


Get the lastest phpbb.inc.php and change the settings according your setup.

My settings.

Code Select Expand


// database configuration
define('PHPBB_DB_NAME', 'phpBB'); // The name of the database used by the board
define('PHPBB_BD_HOST', 'localhost'); // The name of the database server
define('PHPBB_DB_USERNAME', 'root'); // The username to use to connect to the database
define('PHPBB_DB_PASSWORD', ''); // The password to use to connect to the database

// 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', '/');
// 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', 'phpbb2mysql'); // The prefix used for board cookies

// Prefix and names for the database tables
define('PHPBB_TABLE_PREFIX', 'phpbb_'); // The prefix used for the DB tables
define('PHPBB_USER_TABLE', 'users'); // The members table
define('PHPBB_SESSION_TABLE', 'sessions'); // The session table
define('PHPBB_GROUP_TABLE', 'groups'); // The groups table
define('PHPBB_UGROUP_TABLE', 'user_group'); // The group/user table


Get the lastest init.inc.php.

Go to your Plus and create a special group eg. 'Gallery Users' and change your autogroup setting to this group. In CPG go as admin to groups and change the settings there and save.

That should solve your problems.

[jimmyfi]

just wondering what tables i actually should edit to get the ownership of the personal galleries to match their real owners? at this point after integ they are messed up... I tried to change few fields but nothing did happen

[DaMysterious]

just wondering what tables i actually should edit to get the ownership of the personal galleries to match their real owners? at this point after integ they are messed up... I tried to change few fields but nothing did happen

If CPG is already populated with users than they have to register in your Plus again (or you import them into the usertable of the Plus) as with use of the bridge the userbase from Plus (table phpbb_users) is used while the CPG userbase (table cpg13_users) is bypassed. After that you have to reassign all users from CPG to theire pictures in Plus (very heavy). May be you could better ask them to reupload theire pics after new registration. All data for pictures resides in 'cpg13_pictures'.

[jimmyfi]

that might be a good idea it was bit frustrating to edit database and nothing happened

[jimmyfi]

Warning: Undefined index: user_level in /var/www/galleria/bridge/phpbb.inc.php on line 130

Warning: Undefined index: user_level in /var/www/galleria/bridge/phpbb.inc.php on line 164

strange.. this error still comes when new member registers to forum and goes to gallery... o_O

[Joachim Müller]

please post a link to your site.

GauGau

[jimmyfi]

i'd rather not Adult site

could that error come because i have 4 special usergroups..?

[Joachim Müller]

It's OK to post a link to an adult site as long as you put a warning next to the link.

GauGau

[Joachim Müller]

I didn't ask to be sent the link over PM. In fact, my signature says not to PM me at all. PMing me even twice the same message doesn't make me more inclined to further look into this.

GauGau