Unable to enable Bridging Unable to enable Bridging
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Unable to enable Bridging

Started by hoss021, December 13, 2007, 04:52:54 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

hoss021

Ok here is the scoop of installing coppermine on my smf board.  I recently installed CPG1.4.14 stable version, I am attempting to enable the sharing of my SMF Members to the Gallery section, when I attempt to bridge, I get to the type of board SMF 2.x, then it asks for the locations, I update that, and then I click on next, and when it gets to disable / enable, ENABLE does not work.  I attempted to verify the paths are correct but to no avail, still unable to do so.. any help / support if available is greatly appreciated.
Thanks

Coppermine install: http://www.aftershockcc.com/gallery/
Forum install: http://aftershockcc.com/gallery
Coppermine version: cpg1.4.14 (stable)
Forum version: smf 1.1.4
Test user account: test / test

BridgeManager settings:
Forum URL:  http://www.aftershockcc.com/forums
Relative path to your BBS's config file:  ../forums/ 
Use post-based groups?:  0
Cookie name/preifx

Unable to set  use post-based groups and did not have cookie name/prefix setup.

Joachim Müller


hoss021

I'm sorry for the long delay, but I can not enable the bridging.  I use the correct URL for the forums, but I can not enable the bridge.  They are on different DB from apache.

hoss021

what happens is after the bridge I get

"There was an error while processing a database query "
So I need to have the gallery on the same DB for this to bridge correctly?

Joachim Müller

Quote from: hoss021 on December 29, 2007, 08:29:05 PM
So I need to have the gallery on the same DB for this to bridge correctly?
Not necesarilly.

Quote from: hoss021 on December 29, 2007, 08:29:05 PM
"There was an error while processing a database query "
Enable debug_mode in coppermine's config to see the actual query that causes the fatal error. Post the error message here (not the debug_output).

MattBW

I have exactly the same problem, I click enable, and it refreshes with disabled once finish has been clicked.
Quote
USER:
------------------
Array
(
    [ID] => 3aa9dbc3c992d15e721e382ec38ad9c0
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => admin
    [groups] => Array
        (
           
  • => 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
    (
       
  • => SELECT extension, mime, content, player FROM cpg_filetypes; (0.002s)
        [1] => select * from cpg_plugins order by priority asc; (0s)
        [2] => delete from `nuke`.cpg_sessions where time<1199269688 and remember=0; (0.001s)
        [3] => delete from `nuke`.cpg_sessions where time<1198063688; (0s)
        [4] => select user_id from `nuke`.cpg_sessions where session_id=md5("e8458f6b2f3cd41d46a169832afd1c202113689c7946ef67c087c3e15fb80b1a"); (0.001s)
        [5] => select user_id as id, user_password as password from `nuke`.cpg_users where user_id=1 (0s)
        [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `nuke`.cpg_users AS u INNER JOIN `nuke`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
        [7] => SELECT user_group_list FROM `nuke`.cpg_users AS u WHERE user_id='1' 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 cpg_usergroups WHERE group_id in (1) (0.001s)
        [9] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 1 (0.001s)
        [10] => update `nuke`.cpg_sessions set time='1199273288' where session_id=md5('e8458f6b2f3cd41d46a169832afd1c202113689c7946ef67c087c3e15fb80b1a'); (0.001s)
        [11] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 1 (0s)
        [12] => DELETE FROM cpg_banned WHERE expiry < '2008-01-02 11:28:08' (0.035s)
        [13] => SELECT * FROM cpg_banned WHERE (ip_addr='195.92.109.20' OR ip_addr='195.92.109.20' OR user_id=1) AND brute_force=0 (0.041s)
        [14] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0s)
        [15] => SELECT * FROM cpg_bridge (0s)
        [16] => UPDATE cpg_config SET value = '1' WHERE name = 'bridge_enable' (0.001s)
        [17] => SELECT * FROM cpg_bridge (0s)
        [18] => SELECT * FROM cpg_config (0.001s)
        [19] => DELETE FROM cpg_usergroups WHERE 1 (0.096s)
        [20] => INSERT INTO cpg_usergroups
                            VALUES (1, 'Administrators', 0, 1, 1, 1, 1, 1, 1, 0, 0, 3, 0, 5, 3) (0.001s)
        [21] => INSERT INTO cpg_usergroups
                            VALUES (2, 'Registered', 1024, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3) (0s)
        [22] => INSERT INTO cpg_usergroups
                            VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3) (0s)
        [23] => INSERT INTO cpg_usergroups
                            VALUES (4, 'Banned', 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3) (0s)
    )

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

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

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 4.4.2 - OK
    ------------------
    mySQL version: 4.1.11
    ------------------
    Coppermine version: 1.4.10(stable)
    ==========================
    Module: GD
    ------------------
    GD Version: bundled (2.0.28 compatible)
    FreeType Support:
    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 4.1.11
    MYSQL_MODULE_TYPE external
    MYSQL_SOCKET /var/lib/mysql/mysql.sock
    MYSQL_INCLUDE -I/usr/home/builder/pb_work_dir/plesk7.5.4_hotfix6_7.5.4/psa/release/dist/usr/local/psa/mysql/include/mysql
    MYSQL_LIBS -L/usr/home/builder/pb_work_dir/plesk7.5.4_hotfix6_7.5.4/psa/release/dist/usr/local/psa/mysql/lib/mysql -lmysqlclient 
    ==========================
    Module: zlib
    ------------------
    ZLib Support enabled
    Compiled Version 1.1.4
    Linked Version 1.1.4    
    ==========================
    Server restrictions (safe mode)?
    ------------------
    Directive | Local Value | Master Value
    safe_mode | On | On
    safe_mode_exec_dir | /nonexec | /nonexec
    safe_mode_gid | On | Off
    safe_mode_include_dir | no value | no value
    safe_mode_exec_dir | /nonexec | /nonexec
    sql.safe_mode | Off | Off
    disable_functions | no value | no value
    file_uploads | On | On
    include_path | .:/usr/local/psa/apache/lib/php | .:/usr/local/psa/apache/lib/php
    open_basedir | /usr/local/psa/home/vhosts/lrp-alliance.com/httpdocs:/tmp | no value
    ==========================
    email
    ------------------
    Directive | Local Value | Master Value
    sendmail_from | me@localhost.com | me@localhost.com
    sendmail_path | /usr/sbin/sendmail -t -i -fCL2243 | /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 | -1 | -1
    upload_max_filesize | 17M | 17M
    post_max_size | 16M | 16M
    ==========================
    Page generated in 0.579 seconds - 24 queries in 0.183 seconds - Album set : ; Meta set: ;

Joachim Müller

Quote from: MattBW on January 02, 2008, 12:58:18 PM
I have exactly the same problem, I click enable, and it refreshes with disabled once finish has been clicked.
You may or may not have the same issue.  ::)
However, you broke some rules:
1) Don't try to hijack other's threads.
2) There is a sticky thread on this sub-board labelled "When requesting bridge support - mandatory!" as well as a documentation section named "Bridging support". Do exactly as suggested there. There is a reason why we have that sticky thread and why it has been named that way.
3) Don't post debug_output unless a supporter explicitely asks for it! I told the thread starter to enable debug_mode and post the error message. I told him explicitely not to post debug_output!

So stay out of this thread and do as suggested instead.