Coppermine 1.4.16 and SMF 1.1.4

[ec225]

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.

[ec225]

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

[Joachim Müller]

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

[ec225]

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: ;

[Joachim Müller]

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

[ec225]

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

[ec225]

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:

[ec225]

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.