Intergrating Coppermine and SMF

[nameless]

I have done a search but couldn't find much info. However, I found this. So I'm not sure what I am trying to achieve will work.

Just to let you know this is the directory structure I have.

/home/domain/public_html/nameless - this is set as http://nameless.domain.com (this only an example and not a real subdomain -Wordpress Blog)
/home/domain/public_html/nameless/board this is set as http://nameless.domain.com/board (this is a SMF board that I have upgraded from Enigma portal/YaBBSE)
/home/domain/public_html/nameless/pics this is set as http://nameless.domain.com/pics (this is my Coppermine 1.3 installation)

init.inc.php

Code Select Expand

define('COPPERMINE_VERSION', '1.3.0');
// User database integration
// Uncomment the applicable line if you want to use it
// define('UDB_INTEGRATION', 'phpbb');
// define('UDB_INTEGRATION', 'invisionboard');
// define('UDB_INTEGRATION', 'vbulletin23');
// define('UDB_INTEGRATION', 'vbulletin30');
// define('UDB_INTEGRATION', 'yabbse');
define('UDB_INTEGRATION', 'smf');
// define('UDB_INTEGRATION', 'woltlab21');
if (!defined('IN_COPPERMINE')) die('Not in Coppermine...');

smf.inc.php

Code Select Expand

// WARNING : Do not activate this bridge if you already have pictures or     //
//           usergroups in your gallery.                                     //
// ------------------------------------------------------------------------- //

// Set this to the location of your Settings file:
$path = '../board';

// Comment this out if you want to default user's group to 'Registered'
// rather than using Post Count based groups.
define('USE_POST_GROUPS', 1);

// Set the names of implied groups here
define('CM_ADMIN_GROUP_NAME', 'Administrators');
define('CM_MEMBERS_GROUP_NAME', 'Registered');
define('CM_GUEST_GROUP_NAME', 'Anonymous');
define('CM_BANNED_GROUP_NAME', 'Banned');
define('CM_GMOD_GROUP_NAME', 'Global Moderators');

Below is the error message I get:

Fatal error :
There was an error while processing a database query

Your help is greatly appreciated.

[Nibbler]

re-comment the line in init.inc.php, enable debug mode, post the actual sql error.

[nameless]

Thanks Nibbler for helping me out.

Fatal error: Call to undefined function: reloadsettings() in /home/domain/public_html/nameless/pics/bridge/smf.inc.php on line 150
(this is what I get when commented out)

debug has this:

Code Select Expand

USER:
------------------
Array
(
    [ID] => 2551181ab1bb12977451b3625b42a409
    [am] => 1
    [liv] => Array
        (
            [0] => 2480
            [1] => 2481
            [2] => 2482
            [3] => 2483
            [4] => 2484
        )

    [lap] => 2
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => Nameless
    [user_password] => ********
    [user_lastvisit] => 2005-04-18 02:51:07
    [user_regdate] => 2004-06-14 00:30:18
    [user_group_list] =>
    [user_email] =>
    [user_website] =>
    [user_location] =>
    [user_interests] =>
    [user_occupation] =>
    [user_actkey] =>
    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 1
    [ufc_min] => 1
    [custom_user_upload] => 1
    [num_file_upload] => 10
    [num_URI_upload] => 10
    [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] => 1
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
    [groups] => Array
        (
            [1] => 1
        )

)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content FROM cpg130_filetypes;
    [1] => SELECT * FROM cpg130_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'ba6ae29cb2ee2f5d01fb3097a7e1f569'
    [2] => 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 cpg130_usergroups WHERE group_id in (1)
    [3] => SELECT group_name FROM  cpg130_usergroups WHERE group_id= 1
    [4] => DELETE FROM cpg130_banned WHERE expiry < 1113922955
    [5] => SELECT * FROM cpg130_banned WHERE ip_addr='67.164.123.218' OR ip_addr='67.164.123.218' OR user_id=1
    [6] => UPDATE cpg130_config SET  value = 'Nameless\'s Photo Gallery' WHERE name = 'gallery_name'
    [7] => UPDATE cpg130_config SET  value = 'The Photo Albums of Nameless' WHERE name = 'gallery_description'
    [8] => UPDATE cpg130_config SET  value = 'nameless@domain.com' WHERE name = 'gallery_admin_email'
    [9] => UPDATE cpg130_config SET  value = 'http://sub.domain.com/pics/' WHERE name = 'ecards_more_pic_target'
    [10] => UPDATE cpg130_config SET  value = '0' WHERE name = 'offline'
    [11] => UPDATE cpg130_config SET  value = '0' WHERE name = 'log_ecards'
    [12] => UPDATE cpg130_config SET  value = '1' WHERE name = 'enable_zipdownload'
    [13] => UPDATE cpg130_config SET  value = 'english' WHERE name = 'lang'
    [14] => UPDATE cpg130_config SET  value = 'howzit' WHERE name = 'theme'
    [15] => UPDATE cpg130_config SET  value = '0' WHERE name = 'language_list'
    [16] => UPDATE cpg130_config SET  value = '0' WHERE name = 'language_flags'
    [17] => UPDATE cpg130_config SET  value = '1' WHERE name = 'language_reset'
    [18] => UPDATE cpg130_config SET  value = '0' WHERE name = 'theme_list'
    [19] => UPDATE cpg130_config SET  value = '1' WHERE name = 'theme_reset'
    [20] => UPDATE cpg130_config SET  value = '0' WHERE name = 'display_faq'
    [21] => UPDATE cpg130_config SET  value = '1' WHERE name = 'show_bbcode_help'
    [22] => UPDATE cpg130_config SET  value = 'language file' WHERE name = 'charset'
    [23] => UPDATE cpg130_config SET  value = '95%' WHERE name = 'main_table_width'
    [24] => UPDATE cpg130_config SET  value = '2' WHERE name = 'subcat_level'
    [25] => UPDATE cpg130_config SET  value = '14' WHERE name = 'albums_per_page'
    [26] => UPDATE cpg130_config SET  value = '2' WHERE name = 'album_list_cols'
    [27] => UPDATE cpg130_config SET  value = '50' WHERE name = 'alb_list_thumb_size'
    [28] => UPDATE cpg130_config SET  value = 'breadcrumb/catlist/alblist/random,2/lastup,2' WHERE name = 'main_page_layout'
    [29] => UPDATE cpg130_config SET  value = '0' WHERE name = 'first_level'
    [30] => UPDATE cpg130_config SET  value = '3' WHERE name = 'thumbcols'
    [31] => UPDATE cpg130_config SET  value = '8' WHERE name = 'thumbrows'
    [32] => UPDATE cpg130_config SET  value = '12' WHERE name = 'max_tabs'
    [33] => UPDATE cpg130_config SET  value = '1' WHERE name = 'caption_in_thumbview'
    [34] => UPDATE cpg130_config SET  value = '0' WHERE name = 'views_in_thumbview'
    [35] => UPDATE cpg130_config SET  value = '0' WHERE name = 'display_comment_count'
    [36] => UPDATE cpg130_config SET  value = '0' WHERE name = 'display_uploader'
    [37] => UPDATE cpg130_config SET  value = 'na' WHERE name = 'default_sort_order'
    [38] => UPDATE cpg130_config SET  value = '1' WHERE name = 'min_votes_for_rating'
    [39] => UPDATE cpg130_config SET  value = '420' WHERE name = 'picture_table_width'
    [40] => UPDATE cpg130_config SET  value = '1' WHERE name = 'display_pic_info'
    [41] => UPDATE cpg130_config SET  value = '0' WHERE name = 'filter_bad_words'
    [42] => UPDATE cpg130_config SET  value = '1' WHERE name = 'enable_smilies'
    [43] => UPDATE cpg130_config SET  value = '0' WHERE name = 'disable_comment_flood_protect'
    [44] => UPDATE cpg130_config SET  value = '512' WHERE name = 'max_img_desc_length'
    [45] => UPDATE cpg130_config SET  value = '38' WHERE name = 'max_com_wlength'
    [46] => UPDATE cpg130_config SET  value = '10' WHERE name = 'max_com_lines'
    [47] => UPDATE cpg130_config SET  value = '512' WHERE name = 'max_com_size'
    [48] => UPDATE cpg130_config SET  value = '1' WHERE name = 'display_film_strip'
    [49] => UPDATE cpg130_config SET  value = '3' WHERE name = 'max_film_strip_items'
    [50] => UPDATE cpg130_config SET  value = '1' WHERE name = 'email_comment_notification'
    [51] => UPDATE cpg130_config SET  value = '5000' WHERE name = 'slideshow_interval'
    [52] => UPDATE cpg130_config SET  value = '100' WHERE name = 'jpeg_qual'
    [53] => UPDATE cpg130_config SET  value = '120' WHERE name = 'thumb_width'
    [54] => UPDATE cpg130_config SET  value = 'any' WHERE name = 'thumb_use'
    [55] => UPDATE cpg130_config SET  value = '1' WHERE name = 'make_intermediate'
    [56] => UPDATE cpg130_config SET  value = '420' WHERE name = 'picture_width'
    [57] => UPDATE cpg130_config SET  value = '5000' WHERE name = 'max_upl_size'
    [58] => UPDATE cpg130_config SET  value = '420' WHERE name = 'max_upl_width_height'
    [59] => UPDATE cpg130_config SET  value = '0' WHERE name = 'show_private'
    [60] => UPDATE cpg130_config SET  value = '$/\\\\:*?"\'<>|`' WHERE name = 'forbiden_fname_char'
    [61] => UPDATE cpg130_config SET  value = 'ALL' WHERE name = 'allowed_img_types'
    [62] => UPDATE cpg130_config SET  value = 'ALL' WHERE name = 'allowed_mov_types'
    [63] => UPDATE cpg130_config SET  value = 'ALL' WHERE name = 'allowed_snd_types'
    [64] => UPDATE cpg130_config SET  value = 'ALL' WHERE name = 'allowed_doc_types'
    [65] => UPDATE cpg130_config SET  value = 'im' WHERE name = 'thumb_method'
    [66] => UPDATE cpg130_config SET  value = '/usr/bin/X11/' WHERE name = 'impath'
    [67] => UPDATE cpg130_config SET  value = '-antialias' WHERE name = 'im_options'
    [68] => UPDATE cpg130_config SET  value = '1' WHERE name = 'read_exif_data'
    [69] => UPDATE cpg130_config SET  value = '1' WHERE name = 'read_iptc_data'
    [70] => UPDATE cpg130_config SET  value = 'albums/' WHERE name = 'fullpath'
    [71] => UPDATE cpg130_config SET  value = 'userpics/' WHERE name = 'userpics'
    [72] => UPDATE cpg130_config SET  value = 'normal_' WHERE name = 'normal_pfx'
    [73] => UPDATE cpg130_config SET  value = 'thumb_' WHERE name = 'thumb_pfx'
    [74] => UPDATE cpg130_config SET  value = '0777' WHERE name = 'default_dir_mode'
    [75] => UPDATE cpg130_config SET  value = '0666' WHERE name = 'default_file_mode'
    [76] => UPDATE cpg130_config SET  value = '1' WHERE name = 'allow_user_registration'
    [77] => UPDATE cpg130_config SET  value = '1' WHERE name = 'reg_requires_valid_email'
    [78] => UPDATE cpg130_config SET  value = '1' WHERE name = 'reg_notify_admin_email'
    [79] => UPDATE cpg130_config SET  value = '0' WHERE name = 'allow_duplicate_emails_addr'
    [80] => UPDATE cpg130_config SET  value = '1' WHERE name = 'allow_private_albums'
    [81] => UPDATE cpg130_config SET  value = '1' WHERE name = 'upl_notify_admin_email'
    [82] => UPDATE cpg130_config SET  value = '1' WHERE name = 'allow_memberlist'
    [83] => UPDATE cpg130_config SET  value = '' WHERE name = 'user_field1_name'
    [84] => UPDATE cpg130_config SET  value = '' WHERE name = 'user_field2_name'
    [85] => UPDATE cpg130_config SET  value = '' WHERE name = 'user_field3_name'
    [86] => UPDATE cpg130_config SET  value = '' WHERE name = 'user_field4_name'
    [87] => UPDATE cpg130_config SET  value = 'cpg130' WHERE name = 'cookie_name'
    [88] => UPDATE cpg130_config SET  value = '/' WHERE name = 'cookie_path'
    [89] => UPDATE cpg130_config SET  value = '2' WHERE name = 'debug_mode'
    [90] => UPDATE cpg130_config SET  value = '1' WHERE name = 'debug_notice'
)

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

==========================
POST :
------------------
Array
(
    [gallery_name] => Nameless Photo Gallery
    [gallery_description] => The Photo Albums of Nameless
    [gallery_admin_email] => admin@mydomain.com
    [ecards_more_pic_target] => http://sub.domain/pics/
    [offline] => 0
    [log_ecards] => 0
    [enable_zipdownload] => 1
    [lang] => english
    [theme] => howzit
    [language_list] => 0
    [language_flags] => 0
    [language_reset] => 1
    [theme_list] => 0
    [theme_reset] => 1
    [display_faq] => 0
    [show_bbcode_help] => 1
    [charset] => language file
    [main_table_width] => 95%
    [subcat_level] => 2
    [albums_per_page] => 14
    [album_list_cols] => 2
    [alb_list_thumb_size] => 50
    [main_page_layout] => breadcrumb/catlist/alblist/random,2/lastup,2
    [first_level] => 0
    [thumbcols] => 3
    [thumbrows] => 8
    [max_tabs] => 12
    [caption_in_thumbview] => 1
    [views_in_thumbview] => 0
    [display_comment_count] => 0
    [display_uploader] => 0
    [default_sort_order] => na
    [min_votes_for_rating] => 1
    [picture_table_width] => 420
    [display_pic_info] => 1
    [filter_bad_words] => 0
    [enable_smilies] => 1
    [disable_comment_flood_protect] => 0
    [max_img_desc_length] => 512
    [max_com_wlength] => 38
    [max_com_lines] => 10
    [max_com_size] => 512
    [display_film_strip] => 1
    [max_film_strip_items] => 3
    [email_comment_notification] => 1
    [slideshow_interval] => 5000
    [jpeg_qual] => 100
    [thumb_width] => 120
    [thumb_use] => any
    [make_intermediate] => 1
    [picture_width] => 420
    [max_upl_size] => 5000
    [max_upl_width_height] => 420
    [show_private] => 0
    [forbiden_fname_char] => $/\\:*?"'<>|`
    [allowed_img_types] => ALL
    [allowed_mov_types] => ALL
    [allowed_snd_types] => ALL
    [allowed_doc_types] => ALL
    [thumb_method] => im
    [impath] => /usr/bin/X11/
    [im_options] => -antialias
    [read_exif_data] => 1
    [read_iptc_data] => 1
    [fullpath] => albums/
    [userpics] => userpics/
    [normal_pfx] => normal_
    [thumb_pfx] => thumb_
    [default_dir_mode] => 0777
    [default_file_mode] => 0666
    [allow_user_registration] => 1
    [reg_requires_valid_email] => 1
    [reg_notify_admin_email] => 1
    [allow_duplicate_emails_addr] => 0
    [allow_private_albums] => 1
    [upl_notify_admin_email] => 1
    [allow_memberlist] => 1
    [user_field1_name] =>
    [user_field2_name] =>
    [user_field3_name] =>
    [user_field4_name] =>
    [cookie_name] => cpg130
    [cookie_path] => /
    [debug_mode] => 2
    [debug_notice] => 1
    [update_config] => Save new configuration
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.10 - OK
------------------
mySQL version: 4.0.22-standard
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 4.0.22
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
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
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 | 2M | 2M
post_max_size | 55M | 55M
==========================
Page generated in 0.054 seconds - 91 queries in 0.009 seconds - Album set : 

[Nibbler]

I need the actual mysql error message from the page that gave you the fatal error previously.

[nameless]

I never received a MySQL error message. All I received was the message below when I went back to the home page

Fatal error: Call to undefined function: reloadsettings() in /home/domain/public_html/nameless/pics/bridge/smf.inc.php on line 150

Also this below:

Notice: Undefined variable: user_link in /home/domain/public_html/nameless/pics/include/functions.inc.php on line 630

Notice: Undefined variable: user_link in /home/domain/public_html/nameless/pics/include/functions.inc.php on line 630

Notice: Undefined variable: user_link in /home/domain/public_html/nameless/pics/include/functions.inc.php on line 630

Notice: Undefined variable: user_link in /home/domain/public_html/nameless/pics/include/functions.inc.php on line 630

Notice: Undefined variable: user_link in /home/domain/public_html/nameless/pics/include/functions.inc.php on line 630

Notice: Undefined variable: user_link in /home/domain/public_html/nameless/pics/include/functions.inc.php on line 630

I'm not sure if this has anything to do with it but my tables for SMF are "yabbse_" because it was an upgrade not a clean install.

OK I was playing around with the settings and paths and I got this below. I think this is what you are looking for. Funny thing is, is that it's looking for the wrong db. That db is for a form page I use.

While executing query "
      SELECT variable, value
      FROM yabbse_settings" on 0

mySQL error: Table 'domain_namelessform.yabbse_settings' doesn't exist

[EliteRides]

Had a similar issue.  Found it though.  Could not delete this.  :-\\

[nameless]

Ummm, I'm not sure what you mean. Were you able to resolve your issue, if so what did you do

[Tranz]

It seems EliteRides found the solution and instead of trying to share the solution, wished to delete the post.  :-\\ Either way, it's not helpful to other users.

@EliteRides: we have a forum so users can learn from not just the developers, but other users.

[nameless]

It looks like me and kari are having the same issues. From this post.

My Coppermine and SMF db are on separate db as well. How do I get them on the same database?