Question regarding bridging between Coppermine 1.4.2 and SMF 1.1 RC2

[Immolatus]

I'm hoping this is in the right forum...


I'm attempting to bridge SMF, Joomla!, and Coppermine all together. This is what I've done so far:

Installed Joomla! in the public_html directory at http://primoguild.com
Installed SMF at http://primoguild.com/forums
Bridged SMF and Joomla! through Wolverine's bridge.
Joomla! works fine standalone.
SMF works fine standalone.

Joomla! and SMF are bridged together successfully - when a user registers with http://primoguild.com they are also registered with SMF at the same time and can immediately use the forums under the same name without needing to reregister on SMF.
Joomla! and SMF are on the same database.

Coppermine was installed via Fantastico in to http://primoguild.com/cmpg

When I attempt to bridge Coppermine with SMF through the coppermine bridge wizard I set the forum URL to http://primoguild.com/forums and set the relative path to "../forums/", click next, turn off post-based groups, click next, and then enable the bridge.

When I click on "Users" in coppermine it gives me a Critical Error message stating "There was an error while processing a database query" and then sometimes sends me back to the SMF login screen.

What am I doing wrong? I've tried a bunch of different URLs and relative paths  (with www, without www, using the home directory, etc) and have had no luck.

Once I get Coppermine to bridge to SMF, will I need to then bridge Coppermine to Joomla! too, or will it be okay just being "daisy-chained" to Joomla! via SMF?

[Nibbler]

Check for board for other posts about this combination. Whenever you get 'There was an error while processing a database query' message you should enable debug mode and reproduce the error to get a more detailed error message. Note that the SMF bridge is only designed to link to a normal SMF.

[Immolatus]

Here are my debugging messages:

While executing query "SELECT count(*) FROM `primogui_joom1`.smf_members WHERE 1" on 0

mySQL error:

File: /home/primogui/public_html/cmpg/include/functions.inc.php - Line: 248

USER:
------------------
Array
(
    [ID] => 4daf6adbde35a98fbc33c1520b759893
    [am] => 1
    [lang] => english
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Immolatus
    [groups] => Array
        (
           

• => 1
              [1] => 4
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 0
      [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; (0s)
      [1] => select * from cpg_plugins order by priority asc; (0s)
      [2] => SELECT * FROM cpg_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 cpg_usergroups WHERE group_id in (1,4) (0s)
      [4] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 1 (0s)
      [5] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 1 (0s)
      [6] => DELETE FROM cpg_banned WHERE expiry < '2006-05-04 15:52:59' (0s)
      [7] => SELECT * FROM cpg_banned WHERE (ip_addr='12.7.1.130' OR ip_addr='12.7.1.130' OR user_id=1) AND brute_force=0 (0s)
      [8] => DELETE FROM cpg_users WHERE user_name = '' LIMIT 1 (0s)
      [9] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0s)
      [10] => SELECT count(*) FROM `primogui_joom1`.smf_members WHERE 1 (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
      [mgr_php] =>
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 5.0.4 - OK
  ------------------
  mySQL version: 4.1.18-standard-log
  ------------------
  Coppermine version: 1.4.2(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
  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 4.1.18
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/lib/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib/mysql -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/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 | -1 | -1
  upload_max_filesize | 50M | 50M
  post_max_size | 55M | 55M
  ==========================
  Page generated in 0.138 seconds - 11 queries in 0 seconds - Album set : ; Meta set: ;
  
  
  
  
  
  
  
  "Note that the SMF bridge is only designed to link to a normal SMF."
  Is it the version that I'm running that makes it considered abnormal? I believe 1.1 RC2 is an official stable release, but I might be wrong

[Nibbler]

You should update your gallery to the latest stable version. That should be your first step when you have a problem with any software. I don't how the joomba-smf bridge works, if it alters SMF's auth methods then it might prevent the cpg-smf bridge from operating.

[Joachim Müller]

...don't post debug_output unless requested.