Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: [Solved]: phpbb3.0.2 bridged with CPG 1.4.21  (Read 15720 times)

0 Members and 1 Guest are viewing this topic.

lordtygr

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
[Solved]: phpbb3.0.2 bridged with CPG 1.4.21
« on: March 22, 2009, 06:50:25 am »

I have the following issue when trying to bridge coppermine 1.4.21 and phpBB3.0.2:

I have the same issue that many people seemd to used to have but has since been fixed.  Once I enable the bridge, if i try to login to cpg, i am directed to my forum, if i click from my forum back to cpg i am still not logged in.  once i disable the bridge everything is fine.  I've been at this for over 8 hours, reading and re-reading the docs (still doesnt mean i didn't miss something).  doing an uninstall/reinstall, going thru the forums and reading posts over and over.  I'm such a noob, i'm probably missing something simple, please forgive me if i've provided too much, or not enough.  And thank you in Advance.

Coppermine install: http://www.houstonlancers.com/photos
Forum install: http://www.houstonlancers.com/forums
Coppermine version: cpg1.4.21
Forum version: phpBB3.0.2 with BOARD3 portal mod
Test user account: for cpg: testuser/helpplz
                      for forums: testuzr/helpplz

BridgeManager settings:
Forum URL:  http://www.houstonlancers.com/forums
Relative path to your BBS's config file:  ../forums/ 
Use post-based groups?:  1 (currently set to 1, i've tried both options with other differing settings)
Cookie name/preifx (if applicable): phpbb3_m8j8i_

the bridge file i used is from nibbler's post: http://forum.coppermine-gallery.net/index.php/topic,53678.0.html
I've read thru that thing several times now, and still haven't gotten anything in there to work.

Also read this post: http://forum.coppermine-gallery.net/index.php/topic,57832.0.html
i though i should delete the underscore, but if i do, when i try to log into cpg, i get "Fatal Error" and nothing else.  So i've been keeping the underscore on there

And this topic:  http://forum.coppermine-gallery.net/index.php/topic,58102.0.html
so i turned on debug mode and this is what it looks like right before i enable bridging:

Code: [Select]
USER:
------------------
Array
(
    [ID] => c92ddfb91b07b694a437696908c7f56e
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => lordtygr62
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
    [1] => select * from cpg14x_plugins order by priority asc; (0s)
    [2] => delete from `tygrdenc_halophotos`.cpg14x_sessions where time<1237696602 and remember=0; (0s)
    [3] => delete from `tygrdenc_halophotos`.cpg14x_sessions where time<1236490602; (0s)
    [4] => select user_id from `tygrdenc_halophotos`.cpg14x_sessions where session_id = 'c257ebb8bbdae8b0f6f26e5d3cb496d6' (0.002s)
    [5] => select user_id as id, user_password as password from `tygrdenc_halophotos`.cpg14x_users where user_id=2 (0s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `tygrdenc_halophotos`.cpg14x_users AS u INNER JOIN `tygrdenc_halophotos`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='2' (0s)
    [7] => SELECT user_group_list FROM `tygrdenc_halophotos`.cpg14x_users AS u WHERE user_id='2' and user_group_list <> ''; (0s)
    [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg14x_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
    [10] => update `tygrdenc_halophotos`.cpg14x_sessions set time='1237700202' where session_id = 'c257ebb8bbdae8b0f6f26e5d3cb496d6' (0s)
    [11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 2 (0s)
    [12] => DELETE FROM cpg14x_banned WHERE expiry < '2009-03-22 00:36:42' (0s)
    [13] => SELECT * FROM cpg14x_banned WHERE (ip_addr='99.49.159.52' OR ip_addr='99.49.159.52' OR user_id=2) AND brute_force=0 (0s)
    [14] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
    [15] => SELECT * FROM cpg14x_bridge (0.001s)
    [16] => UPDATE cpg14x_config SET value = '0' WHERE name = 'bridge_enable' (0s)
    [17] => SELECT * FROM cpg14x_bridge (0s)
    [18] => SELECT * FROM cpg14x_config (0s)
    [19] => DELETE FROM cpg14x_usergroups WHERE 1 (0s)
    [20] => INSERT INTO cpg14x_usergroups
                        VALUES (1, 'Administrators', 0, 1, 1, 1, 1, 1, 1, 0, 0, 3, 0, 5, 3) (0s)
    [21] => INSERT INTO cpg14x_usergroups
                        VALUES (2, 'Registered', 1024, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3) (0s)
    [22] => INSERT INTO cpg14x_usergroups
                        VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3) (0s)
    [23] => INSERT INTO cpg14x_usergroups
                        VALUES (4, 'Banned', 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3) (0s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 4.4.9 - OK
------------------
mySQL version: 5.0.75-community-log
------------------
Coppermine version: 1.4.21(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.75
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64 -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1.2
Linked Version 1.2.1.2
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | /usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php | /usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.095 seconds - 24 queries in 0.003 seconds - Album set : ; Meta set: ;

And:
Quote
Notices
/include/themes.inc.php
Notice line 226: Undefined variable: USER_ID
Notice line 823: Undefined variable: pm_link
/bridgemgr.php
Notice line 567: Undefined index: step
Notice line 184: Undefined index: bridge_enable
Notice line 189: Undefined index: clear_unused_db_fields
Notice line 195: Undefined variable: return
Notice line 1137: Undefined index: submit
Notice line 1154: Undefined index: short_name_used
Notice line 1154: Undefined index: license_number_used
Notice line 1154: Undefined index: db_database_name_used
Notice line 1154: Undefined index: db_hostname_used
Notice line 1154: Undefined index: db_username_used
Notice line 1154: Undefined index: db_password_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: relative_path_of_forum_from_webroot_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: logout_flag_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: table_prefix_used
Notice line 1154: Undefined index: user_table_used
Notice line 1154: Undefined index: session_table_used
Notice line 1154: Undefined index: group_table_used
Notice line 1154: Undefined index: group_relation_table_used
Notice line 1154: Undefined index: group_mapping_table_used
Notice line 1154: Undefined index: use_standard_groups_used
Notice line 1154: Undefined index: validating_group_used
Notice line 1154: Undefined index: guest_group_used
Notice line 1154: Undefined index: member_group_used
Notice line 1154: Undefined index: admin_group_used
Notice line 1154: Undefined index: banned_group_used
Notice line 1154: Undefined index: global_moderators_group_used
Notice line 1154: Undefined index: recovery_logon_failures_used
Notice line 1154: Undefined index: recovery_logon_timestamp_used
Notice line 1154: Undefined index: avatar_path_used
Notice line 1209: Undefined index: submit

And After I Enabel:

Code: [Select]
USER:
------------------
Array
(
    [ID] => c92ddfb91b07b694a437696908c7f56e
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2
    [user_name] => lordtygr62
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
    [1] => select * from cpg14x_plugins order by priority asc; (0s)
    [2] => delete from `tygrdenc_halophotos`.cpg14x_sessions where time<1237696787 and remember=0; (0s)
    [3] => delete from `tygrdenc_halophotos`.cpg14x_sessions where time<1236490787; (0s)
    [4] => select user_id from `tygrdenc_halophotos`.cpg14x_sessions where session_id = 'c257ebb8bbdae8b0f6f26e5d3cb496d6' (0.001s)
    [5] => select user_id as id, user_password as password from `tygrdenc_halophotos`.cpg14x_users where user_id=2 (0s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `tygrdenc_halophotos`.cpg14x_users AS u INNER JOIN `tygrdenc_halophotos`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='2' (0.001s)
    [7] => SELECT user_group_list FROM `tygrdenc_halophotos`.cpg14x_users AS u WHERE user_id='2' and user_group_list <> ''; (0s)
    [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg14x_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0.001s)
    [10] => update `tygrdenc_halophotos`.cpg14x_sessions set time='1237700387' where session_id = 'c257ebb8bbdae8b0f6f26e5d3cb496d6' (0s)
    [11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 2 (0s)
    [12] => DELETE FROM cpg14x_banned WHERE expiry < '2009-03-22 00:39:47' (0s)
    [13] => SELECT * FROM cpg14x_banned WHERE (ip_addr='99.49.159.52' OR ip_addr='99.49.159.52' OR user_id=2) AND brute_force=0 (0s)
    [14] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
    [15] => SELECT * FROM cpg14x_bridge (0s)
    [16] => UPDATE cpg14x_config SET value = '1' WHERE name = 'bridge_enable' (0s)
    [17] => SELECT * FROM cpg14x_bridge (0s)
    [18] => SELECT * FROM cpg14x_config (0s)
    [19] => SELECT * FROM `tygrdenc_phpb1`.phpbb_groups WHERE group_name <> '' (0s)
    [20] => SELECT group_id, group_name FROM cpg14x_usergroups WHERE 1 (0.001s)
    [21] => DELETE FROM cpg14x_usergroups WHERE group_id = '1' LIMIT 1 (0s)
    [22] => DELETE FROM cpg14x_usergroups WHERE group_id = '2' LIMIT 1 (0s)
    [23] => DELETE FROM cpg14x_usergroups WHERE group_id = '3' LIMIT 1 (0s)
    [24] => DELETE FROM cpg14x_usergroups WHERE group_id = '4' LIMIT 1 (0s)
    [25] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('101', 'GUESTS', '0') (0s)
    [26] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('102', 'REGISTERED', '0') (0s)
    [27] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('103', 'REGISTERED_COPPA', '0') (0s)
    [28] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('104', 'GLOBAL_MODERATORS', '0') (0s)
    [29] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('105', 'ADMINISTRATORS', '1') (0s)
    [30] => INSERT INTO cpg14x_usergroups (group_id, group_name, has_admin_access) VALUES ('106', 'BOTS', '0') (0s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
    [bridge_enable] => 1
    [submit] => Finish
    [step] => finalize
    [force_startpage] => 1
)

==========================
VERSION INFO :
------------------
PHP version: 4.4.9 - OK
------------------
mySQL version: 5.0.75-community-log
------------------
Coppermine version: 1.4.21(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 2
Client API version 5.0.75
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64 -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1.2
Linked Version 1.2.1.2
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | /usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php | /usr/lib/php:.:/usr/php4/lib/php:/usr/local/php4/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.104 seconds - 31 queries in 0.004 seconds - Album set : ; Meta set: ;

with:
Quote
Notices
/include/themes.inc.php
Notice line 226: Undefined variable: USER_ID
Notice line 823: Undefined variable: pm_link
/bridgemgr.php
Notice line 189: Undefined index: clear_unused_db_fields
Notice line 195: Undefined variable: return
Notice line 1154: Undefined index: short_name_used
Notice line 1154: Undefined index: license_number_used
Notice line 1154: Undefined index: db_database_name_used
Notice line 1154: Undefined index: db_hostname_used
Notice line 1154: Undefined index: db_username_used
Notice line 1154: Undefined index: db_password_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: relative_path_of_forum_from_webroot_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: logout_flag_used
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1174: Use of undefined constant radio - assumed 'radio'
Notice line 1154: Undefined index: table_prefix_used
Notice line 1154: Undefined index: user_table_used
Notice line 1154: Undefined index: session_table_used
Notice line 1154: Undefined index: group_table_used
Notice line 1154: Undefined index: group_relation_table_used
Notice line 1154: Undefined index: group_mapping_table_used
Notice line 1154: Undefined index: use_standard_groups_used
Notice line 1154: Undefined index: validating_group_used
Notice line 1154: Undefined index: guest_group_used
Notice line 1154: Undefined index: member_group_used
Notice line 1154: Undefined index: admin_group_used
Notice line 1154: Undefined index: banned_group_used
Notice line 1154: Undefined index: global_moderators_group_used
Notice line 1154: Undefined index: recovery_logon_failures_used
Notice line 1154: Undefined index: recovery_logon_timestamp_used
Notice line 1154: Undefined index: avatar_path_used
Notice line 1209: Undefined index: wizard_finished
/bridge/phpbb3.inc.php
Notice line 44: Constant USE_BRIDGEMGR already defined
/bridge/udb_base.inc.php
Notice line 544: Undefined property: group_overrride
 

and if i click "home" directly after i've enabled bridging, it logs me out.  debug gives this:


Code: [Select]
USER:
------------------
Array
(
    [ID] => c92ddfb91b07b694a437696908c7f56e
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
            [0] => 1
        )

    [group_quota] => 0
    [can_rate_pictures] =>
    [can_send_ecards] =>
    [can_post_comments] =>
    [can_upload_pictures] =>
    [can_create_albums] => 0
    [pub_upl_need_approval] =>
    [priv_upl_need_approval] =>
    [upload_form_config] =>
    [num_file_upload] =>
    [num_URI_upload] =>
    [custom_user_upload] =>
    [disk_max] =>
    [disk_min] =>
    [ufc_max] =>
    [ufc_min] =>
    [has_admin_access] => 0
    [group_name] =>
    [can_see_all_albums] => 0
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
    [1] => select * from cpg14x_plugins order by priority asc; (0s)
    [2] => SELECT * FROM cpg14x_bridge (0s)
    [3] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg14x_usergroups WHERE group_id in (1) (0.001s)
    [4] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0.001s)
    [5] => DELETE FROM cpg14x_banned WHERE expiry < '2009-03-22 00:41:31' (0s)
    [6] => SELECT * FROM cpg14x_banned WHERE (ip_addr='99.49.159.52' OR ip_addr='99.49.159.52' OR user_id=0) AND brute_force=0 (0s)
    [7] => SELECT aid, category FROM cpg14x_albums WHERE visibility != '0' AND visibility !='10000' AND visibility NOT IN (1) (0s)
    [8] => SELECT aid FROM cpg14x_albums (0s)
    [9] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = ''  ORDER BY name (0s)
    [10] => SELECT aid FROM cpg14x_albums as a WHERE category>=10000 (0s)
    [11] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
    [12] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = '1'  ORDER BY name (0s)
    [13] => SELECT aid FROM cpg14x_albums as a WHERE category = '0' (0s)
    [14] => SELECT count(*) FROM cpg14x_albums as a WHERE 1 (0s)
    [15] => SELECT count(*) FROM cpg14x_categories WHERE 1 (0s)
    [16] => SELECT count(*) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0s)
    [17] => SELECT sum(hits) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON p.aid=a.aid WHERE 1 (0s)
    [18] => SELECT count(*) FROM cpg14x_comments as c LEFT JOIN cpg14x_pictures as p ON c.pid=p.pid LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 (0s)
    [19] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '0' (0s)
    [20] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES' AND aid IN (-1)  ORDER BY RAND() LIMIT 8 (0s)
    [21] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES' AND aid IN (-1)  (0s)
    [22] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES' AND aid IN (-1)  ORDER BY pid DESC  LIMIT 0 ,8 (0s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
Page generated in 0.088 seconds - 23 queries in 0.002 seconds - Album set : ; Meta set: AND aid IN (-1) ;

with this:

Notices
/bridge/udb_base.inc.php
Notice line 114: Undefined variable: row
/include/themes.inc.php
Notice line 226: Undefined variable: USER_ID
Notice line 823: Undefined variable: pm_link
Notice line 2772: Undefined variable: loginFormHtml
/include/functions.inc.php
Notice line 88: Undefined variable: cpg_show_private_album
Notice line 109: Undefined variable: meta_album_set_array
Warning line 109: array_diff() [function.array-diff]: Argument #1 is not an array
 
« Last Edit: March 23, 2009, 09:39:05 am by Joachim Müller »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: phpbb3.0.2 bridged with CPG 1.4.21
« Reply #1 on: March 22, 2009, 12:31:53 pm »

Turn notices display off if you don't know what notices mean, i.e. if you're not a coder.
Logged

Nibbler

  • Guest
Re: phpbb3.0.2 bridged with CPG 1.4.21
« Reply #2 on: March 22, 2009, 03:59:50 pm »

Your cookie prefix should be set to phpbb3_m8j8i - without the underscore at the end. With debug mode enabled you will get a better message than just fatal error.
Logged

lordtygr

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: phpbb3.0.2 bridged with CPG 1.4.21
« Reply #3 on: March 22, 2009, 06:31:11 pm »

ok. turned off notices and removed the underscore from the prefix.

Fatal Error with debug on now gives this:

Quote
While executing query "SELECT u.user_id AS id, u.username AS username, u.user_password AS password, u. AS avatar_url, u. AS notify, u. AS auto_subscribe_post, u. AS auto_subscribe_comment, u.group_id+100 AS group_id FROM `tygrdenc_phpb1`.phpbb_users AS u INNER JOIN `tygrdenc_phpb1`.phpbb_groups AS g ON u.group_id=g.group_id WHERE u.user_id='2'" on Resource id #16

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS avatar_url, u. AS notify, u. AS auto_subscribe_post, u. AS auto_subscribe_com' at line 1

i don't understand it, but it looks as though it's trying to find info from my personal (original site) site?  Using FTP the actual file structure for everything is:

http://www.tygrden.com/public_html/houstonlancers/forums
http://www.tygrden.com/public_html/houstonlancers/photos

is this where my problem lies? www.houstonlancers.com is an actual domain, it's just the files for it are embedded in my original site.  will the bridge file not recognize that? or am i totally off the mark here?  lol

Thanks again!
Logged

Nibbler

  • Guest
Re: phpbb3.0.2 bridged with CPG 1.4.21
« Reply #4 on: March 22, 2009, 06:32:40 pm »

Get Coppermine working properly by itself before trying to use the modpack. I don't know if it supports the phpbb3 bridge.
Logged

lordtygr

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: phpbb3.0.2 bridged with CPG 1.4.21
« Reply #5 on: March 22, 2009, 07:24:58 pm »

ah... if it's that simple i'm going to shoot myself.  not dead, just like in the foot or something.  j/k ;)

okies i'll do that, the reason i had installed it in the first place, was it was the first thing i saw when i searched for bridging phpbb3 and cpg.
Logged

lordtygr

  • Coppermine newbie
  • Offline Offline
  • Posts: 4
Re: phpbb3.0.2 bridged with CPG 1.4.21
« Reply #6 on: March 23, 2009, 05:02:13 am »

alrighty, that seems to have gotten it.  too bad i'm missing a toe now  ;)  j/k  :)

thanks again guys!!
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: [Solved]: phpbb3.0.2 bridged with CPG 1.4.21
« Reply #7 on: March 23, 2009, 09:40:38 am »

For the benefit of others, here's the summary / resolution:

the phpbb3 bridge file and Stramm's modpack currently are not compatible. Stramm's modpack only works with some bridge files, which are being mentioned in the sticky announcement thread of the modpack.
Logged
Pages: [1]   Go Up
 

Page created in 0.024 seconds with 19 queries.