forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 bridging => Topic started by: ec225 on April 12, 2008, 02:39:29 pm

Title: Coppermine 1.4.16 and SMF 1.1.4
Post by: ec225 on April 12, 2008, 02:39:29 pm

Good afternoon, I ahve the following problem when trying to bridge 1.4.16 and smf 1.1.4

using internet explorer it goes through the bridging wizard with the following URls

http://www.northseapilot.com/forum
Rel url ../forum   the coppermine programme is in  northseapilot.com/public_html/cpg1416


but when I click finish it comes up with the following error "There was an error while processing a database query"

If I then use firefox the Photo album comes up as a guest but when i try and login in it takes me to the forum.

I am using seperate databases for the photo and forum.

i would appreciate any help and thankyou.

Title: Re: Coppermine 1.4.16 and SMF 1.1.4
Post by: ec225 on April 12, 2008, 03:14:45 pm

Coppermine install: http://www.northseapilot.com/cpg1416/
Forum install: http://www.northseapilot.com/forum/
Coppermine version: cpg1.4.16
Forum version: smf 1.1.4
Test user account: some_testuser_name / the_password_for_the_test_user_account

BridgeManager settings:
Forum URL:  http://www.northseapilot.com/forum/
Relative path to your BBS's config file:  ../forum/ 
Use post-based groups?:  0
Cookie name/preifx (if applicable)


My apoligies see above for the correct info

Title: Re: Coppermine 1.4.16 and SMF 1.1.4
Post by: Joachim Müller on April 12, 2008, 04:58:13 pm

Enable debug mode, then post the actual error message (not the debug_output).

Title: Re: Coppermine 1.4.16 and SMF 1.1.4
Post by: ec225 on April 12, 2008, 05:16:15 pm

USER:
------------------
Array
(
    [ID] => c098df9eb10f0e42d3c195111dd5b78d
    [am] => 1
    [lang] => english_gb
    [liv] => Array
        (
           

• => 1
[1] => 3
            [2] => 2
        )

   

[search] => Array
        (
            [search] => ecard
            [album] => search
            [title] => on
            [newer_than] =>
            [caption] => on
            [older_than] =>
            [keywords] => on
            [type] => AND
            [params] => Array
                (
                    [title] => on
                    [caption] => on
                    [keywords] => on
                )

        )

    [sort] => nd
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => ec225
    [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 cpg14x_filetypes; (0s)
[1] => select * from cpg14x_plugins order by priority asc; (0s)
    [2] => delete from `ec225_cop1`.cpg14x_sessions where time<1208009430 and remember=0; (0s)
    [3] => delete from `ec225_cop1`.cpg14x_sessions where time<1206803430; (0s)
    [4] => select user_id from `ec225_cop1`.cpg14x_sessions where session_id=md5("e341d40f884e21d2738fe1b8122aa684ebfa6cb8d0b98ad9a2f982d1ebdc843d"); (0s)
    [5] => select user_id as id, user_password as password from `ec225_cop1`.cpg14x_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 `ec225_cop1`.cpg14x_users AS u INNER JOIN `ec225_cop1`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `ec225_cop1`.cpg14x_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 cpg14x_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
    [10] => update `ec225_cop1`.cpg14x_sessions set time='1208013030' where session_id=md5('e341d40f884e21d2738fe1b8122aa684ebfa6cb8d0b98ad9a2f982d1ebdc843d'); (0s)
    [11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0s)
    [12] => SHOW TABLES LIKE 'cpg14x_cms_config' (0s)
    [13] => SELECT * FROM cpg14x_cms_config (0s)
    [14] => DELETE FROM cpg14x_banned WHERE expiry < '2008-04-12 15:10:30' (0s)
    [15] => SELECT * FROM cpg14x_banned WHERE (ip_addr='86.133.43.73' OR ip_addr='86.133.43.73' OR user_id=1) AND brute_force=0 (0s)
    [16] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
    [17] => SELECT * FROM cpg14x_bridge (0s)
    [18] => UPDATE cpg14x_config SET value = '1' WHERE name = 'bridge_enable' (0s)
    [19] => SELECT * FROM cpg14x_bridge (0s)
    [20] => SELECT * FROM cpg14x_config (0s)
    [21] => SELECT * FROM `ec225_smf1`.smf_membergroups (0.055s)
    [22] => SELECT group_id, group_name FROM cpg14x_usergroups WHERE 1 (0.005s)
    [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 ('100', '', '0') (0s)
    [26] => UPDATE cpg14x_usergroups SET group_name = 'Guests' WHERE group_id = '1' LIMIT 1 (0s)
)

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

[ridgemgr_php] =>
)

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

==========================
VERSION INFO :
------------------
PHP version: 5.2.5 - OK
------------------
mySQL version: 5.0.45-community
------------------
Coppermine version: 1.4.16(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 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
XPM 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.45
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.1.2
Linked Version 1.2.3
==========================
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 | dl | dl
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/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 | 10M | 10M
post_max_size | 8M | 8M
==========================
Page generated in 0.807 seconds - 27 queries in 0.06 seconds - Album set : ; Meta set: ;

Title: Re: Coppermine 1.4.16 and SMF 1.1.4
Post by: Joachim Müller on April 12, 2008, 05:19:52 pm

I told you not to post the debug_output! Why do you post it anyway? Do as I suggested!

Title: Re: Coppermine 1.4.16 and SMF 1.1.4
Post by: ec225 on April 12, 2008, 05:26:06 pm

My apologies but what you think you said is not what actualy was interpreted as what you meant, dont forget i am a beginner, it would like me saying to you go fly that helicopter.

I have enabled the debug output and the actual error message is posted above or do you mean something else.

I do appreciate your help tks

Title: Re: Coppermine 1.4.16 and SMF 1.1.4
Post by: ec225 on April 12, 2008, 05:32:14 pm

Hi again is this what you meant.


While executing query "SELECT * FROM cpg14x_banned WHERE (ip_addr='86.133.43.73' OR ip_addr='86.133.43.73' OR user_id=) AND brute_force=0" on 0

mySQL error:

Title: Re: Coppermine 1.4.16 and SMF 1.1.4
Post by: ec225 on April 12, 2008, 05:52:32 pm

I have resolved the error, this was caused by having the same user name and password for both the forum and the gallery, however the login on the gallery still takes me to the forum login page and not the gallery. It also does the same for the new registration.