Print

[Atari2600]

I can't seem to get the bridge working.  :\'(

Is the brifge that comes with 1.3.1 is correct. I can't get it to work for me. My forum is in the folder smf which is located in my home directory and named gallery. this  folder, with coppermine, is on the same level as smf so my path is $path = '../smf' When i comment out the bridge in the init.inc.php both the forum and gallery work fine as stand alone. But when I "turn on" the bridge I get this error:

Fatal error :

There was an error while processing a database query.
While executing query "
      SELECT variable, value
      FROM smf_settings" on 0

mySQL error: Table 'creativespirit_us_-_gallery.smf_settings' doesn't exist


any ideas what I'm doing wrong?

debug info:
USER:
------------------
Array
(
    [ID] => 6e89776a27a00be6f5e2b8247acae5f9
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => **********
    [user_password] => ********
    [user_lastvisit] => 2004-08-17 21:08:20
    [user_regdate] => 2004-08-17 21:07:37
    [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] => 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
    [groups] => Array
        (
            [1] => 1
        )

)

==========================
Queries:
------------------
Array
(
   

• => SELECT extension, mime, content FROM cpg131_filetypes;
[1] => SELECT * FROM cpg131_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'a6025d5ce666fc824c20f79249a60d78'
    [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 cpg131_usergroups WHERE group_id in (1)
    [3] => SELECT group_name FROM  cpg131_usergroups WHERE group_id= 1
    [4] => DELETE FROM cpg131_banned WHERE expiry < 1092795906
    [5] => SELECT * FROM cpg131_banned WHERE ip_addr='69.162.9.250' OR ip_addr='69.162.9.250' OR user_id=1
    [6] => UPDATE cpg131_config SET  value = 'Creative Spirit' WHERE name = 'gallery_name'
    [7] => UPDATE cpg131_config SET  value = 'Our online photo album' WHERE name = 'gallery_description'
    [8] => UPDATE cpg131_config SET  value = 'joezimmerman@heavensdesigns.com' WHERE name = 'gallery_admin_email'
    [9] => UPDATE cpg131_config SET  value = '

http://www.creativespirit.us/gallery/' WHERE name = 'ecards_more_pic_target'
    [10] => UPDATE cpg131_config SET  value = '0' WHERE name = 'offline'
    [11] => UPDATE cpg131_config SET  value = '0' WHERE name = 'log_ecards'
    [12] => UPDATE cpg131_config SET  value = '1' WHERE name = 'enable_zipdownload'
    [13] => UPDATE cpg131_config SET  value = 'english' WHERE name = 'lang'
    [14] => UPDATE cpg131_config SET  value = 'water_drop' WHERE name = 'theme'
    [15] => UPDATE cpg131_config SET  value = '0' WHERE name = 'language_list'
    [16] => UPDATE cpg131_config SET  value = '0' WHERE name = 'language_flags'
    [17] => UPDATE cpg131_config SET  value = '1' WHERE name = 'language_reset'
    [18] => UPDATE cpg131_config SET  value = '0' WHERE name = 'theme_list'
    [19] => UPDATE cpg131_config SET  value = '1' WHERE name = 'theme_reset'
    [20] => UPDATE cpg131_config SET  value = '0' WHERE name = 'display_faq'
    [21] => UPDATE cpg131_config SET  value = '1' WHERE name = 'show_bbcode_help'
    [22] => UPDATE cpg131_config SET  value = 'language file' WHERE name = 'charset'
    [23] => UPDATE cpg131_config SET  value = '100%' WHERE name = 'main_table_width'
    [24] => UPDATE cpg131_config SET  value = '2' WHERE name = 'subcat_level'
    [25] => UPDATE cpg131_config SET  value = '12' WHERE name = 'albums_per_page'
    [26] => UPDATE cpg131_config SET  value = '2' WHERE name = 'album_list_cols'
    [27] => UPDATE cpg131_config SET  value = '50' WHERE name = 'alb_list_thumb_size'
    [28] => UPDATE cpg131_config SET  value = 'breadcrumb/catlist/alblist/random,2/lastup,2' WHERE name = 'main_page_layout'
    [29] => UPDATE cpg131_config SET  value = '1' WHERE name = 'first_level'
    [30] => UPDATE cpg131_config SET  value = '4' WHERE name = 'thumbcols'
    [31] => UPDATE cpg131_config SET  value = '3' WHERE name = 'thumbrows'
    [32] => UPDATE cpg131_config SET  value = '12' WHERE name = 'max_tabs'
    [33] => UPDATE cpg131_config SET  value = '1' WHERE name = 'caption_in_thumbview'
    [34] => UPDATE cpg131_config SET  value = '1' WHERE name = 'views_in_thumbview'
    [35] => UPDATE cpg131_config SET  value = '0' WHERE name = 'display_comment_count'
    [36] => UPDATE cpg131_config SET  value = '0' WHERE name = 'display_uploader'
    [37] => UPDATE cpg131_config SET  value = 'na' WHERE name = 'default_sort_order'
    [38] => UPDATE cpg131_config SET  value = '1' WHERE name = 'min_votes_for_rating'
    [39] => UPDATE cpg131_config SET  value = '600' WHERE name = 'picture_table_width'
    [40] => UPDATE cpg131_config SET  value = '0' WHERE name = 'display_pic_info'
    [41] => UPDATE cpg131_config SET  value = '1' WHERE name = 'filter_bad_words'
    [42] => UPDATE cpg131_config SET  value = '1' WHERE name = 'enable_smilies'
    [43] => UPDATE cpg131_config SET  value = '0' WHERE name = 'disable_comment_flood_protect'
    [44] => UPDATE cpg131_config SET  value = '512' WHERE name = 'max_img_desc_length'
    [45] => UPDATE cpg131_config SET  value = '38' WHERE name = 'max_com_wlength'
    [46] => UPDATE cpg131_config SET  value = '10' WHERE name = 'max_com_lines'
    [47] => UPDATE cpg131_config SET  value = '512' WHERE name = 'max_com_size'
    [48] => UPDATE cpg131_config SET  value = '1' WHERE name = 'display_film_strip'
    [49] => UPDATE cpg131_config SET  value = '5' WHERE name = 'max_film_strip_items'
    [50] => UPDATE cpg131_config SET  value = '0' WHERE name = 'email_comment_notification'
    [51] => UPDATE cpg131_config SET  value = '5000' WHERE name = 'slideshow_interval'
    [52] => UPDATE cpg131_config SET  value = '80' WHERE name = 'jpeg_qual'
    [53] => UPDATE cpg131_config SET  value = '100' WHERE name = 'thumb_width'
    [54] => UPDATE cpg131_config SET  value = 'ht' WHERE name = 'thumb_use'
    [55] => UPDATE cpg131_config SET  value = '1' WHERE name = 'make_intermediate'
    [56] => UPDATE cpg131_config SET  value = '400' WHERE name = 'picture_width'
    [57] => UPDATE cpg131_config SET  value = '1024' WHERE name = 'max_upl_size'
    [58] => UPDATE cpg131_config SET  value = '2048' WHERE name = 'max_upl_width_height'
    [59] => UPDATE cpg131_config SET  value = '0' WHERE name = 'show_private'
    [60] => UPDATE cpg131_config SET  value = '$/\\\\:*?"\'<>|`' WHERE name = 'forbiden_fname_char'
    [61] => UPDATE cpg131_config SET  value = 'ALL' WHERE name = 'allowed_img_types'
    [62] => UPDATE cpg131_config SET  value = 'ALL' WHERE name = 'allowed_mov_types'
    [63] => UPDATE cpg131_config SET  value = 'ALL' WHERE name = 'allowed_snd_types'
    [64] => UPDATE cpg131_config SET  value = 'ALL' WHERE name = 'allowed_doc_types'
    [65] => UPDATE cpg131_config SET  value = 'gd2' WHERE name = 'thumb_method'
    [66] => UPDATE cpg131_config SET  value = '' WHERE name = 'impath'
    [67] => UPDATE cpg131_config SET  value = '-antialias' WHERE name = 'im_options'
    [68] => UPDATE cpg131_config SET  value = '0' WHERE name = 'read_exif_data'
    [69] => UPDATE cpg131_config SET  value = '0' WHERE name = 'read_iptc_data'
    [70] => UPDATE cpg131_config SET  value = 'albums/' WHERE name = 'fullpath'
    [71] => UPDATE cpg131_config SET  value = 'userpics/' WHERE name = 'userpics'
    [72] => UPDATE cpg131_config SET  value = 'normal_' WHERE name = 'normal_pfx'
    [73] => UPDATE cpg131_config SET  value = 'thumb_' WHERE name = 'thumb_pfx'
    [74] => UPDATE cpg131_config SET  value = '0777' WHERE name = 'default_dir_mode'
    [75] => UPDATE cpg131_config SET  value = '0666' WHERE name = 'default_file_mode'
    [76] => UPDATE cpg131_config SET  value = '1' WHERE name = 'allow_user_registration'
    [77] => UPDATE cpg131_config SET  value = '1' WHERE name = 'reg_requires_valid_email'
    [78] => UPDATE cpg131_config SET  value = '0' WHERE name = 'reg_notify_admin_email'
    [79] => UPDATE cpg131_config SET  value = '0' WHERE name = 'allow_duplicate_emails_addr'
    [80] => UPDATE cpg131_config SET  value = '0' WHERE name = 'allow_private_albums'
    [81] => UPDATE cpg131_config SET  value = '0' WHERE name = 'upl_notify_admin_email'
    [82] => UPDATE cpg131_config SET  value = '0' WHERE name = 'allow_memberlist'
    [83] => UPDATE cpg131_config SET  value = '' WHERE name = 'user_field1_name'
    [84] => UPDATE cpg131_config SET  value = '' WHERE name = 'user_field2_name'
    [85] => UPDATE cpg131_config SET  value = '' WHERE name = 'user_field3_name'
    [86] => UPDATE cpg131_config SET  value = '' WHERE name = 'user_field4_name'
    [87] => UPDATE cpg131_config SET  value = 'cpg131' WHERE name = 'cookie_name'
    [88] => UPDATE cpg131_config SET  value = '/' WHERE name = 'cookie_path'
    [89] => UPDATE cpg131_config SET  value = '2' WHERE name = 'debug_mode'
    [90] => UPDATE cpg131_config SET  value = '1' WHERE name = 'debug_notice'
)

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

==========================
POST :
------------------
Array
(
    [gallery_name] => Creative Spirit
    [gallery_description] => Our online photo album
    [gallery_admin_email] => joezimmerman@heavensdesigns.com
    [ecards_more_pic_target] => http://www.creativespirit.us/gallery/
    [offline] => 0
    [log_ecards] => 0
    [enable_zipdownload] => 1
    [lang] => english
    [theme] => water_drop
    [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] => 100%
    [subcat_level] => 2
    [albums_per_page] => 12
    [album_list_cols] => 2
    [alb_list_thumb_size] => 50
    [main_page_layout] => breadcrumb/catlist/alblist/random,2/lastup,2
    [first_level] => 1
    [thumbcols] => 4
    [thumbrows] => 3
    [max_tabs] => 12
    [caption_in_thumbview] => 1
    [views_in_thumbview] => 1
    [display_comment_count] => 0
    [display_uploader] => 0
    [default_sort_order] => na
    [min_votes_for_rating] => 1
    [picture_table_width] => 600
    [display_pic_info] => 0
    [filter_bad_words] => 1
    [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] => 5
    [email_comment_notification] => 0
    [slideshow_interval] => 5000
    [jpeg_qual] => 80
    [thumb_width] => 100
    [thumb_use] => ht
    [make_intermediate] => 1
    [picture_width] => 400
    [max_upl_size] => 1024
    [max_upl_width_height] => 2048
    [show_private] => 0
    [forbiden_fname_char] => $/\\:*?"'<>|`
    [allowed_img_types] => ALL
    [allowed_mov_types] => ALL
    [allowed_snd_types] => ALL
    [allowed_doc_types] => ALL
    [thumb_method] => gd2
    [impath] =>
    [im_options] => -antialias
    [read_exif_data] => 0
    [read_iptc_data] => 0
    [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] => 0
    [allow_duplicate_emails_addr] => 0
    [allow_private_albums] => 0
    [upl_notify_admin_email] => 0
    [allow_memberlist] => 0
    [user_field1_name] =>
    [user_field2_name] =>
    [user_field3_name] =>
    [user_field4_name] =>
    [cookie_name] => cpg131
    [cookie_path] => /
    [debug_mode] => 2
    [debug_notice] => 1
    [update_config] => Save new configuration
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.8 - OK
------------------
mySQL version: 3.23.58
------------------
Coppermine version: 1.3.1
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.23 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read 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 3.23.58
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.0.7
Linked Version 1.2.0.7
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | On | 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 | .:/php/includes:/usr/share/php | .:/php/includes:/usr/share/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 | 60 | 60
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.069 seconds - 91 queries in 0.012 seconds - Album set :

[kegobeer]

I don't understand your directory structure.  Is it like this?

gallery/coppermine
gallery/smf

[kegobeer]

Also, are they sharing the same db?  For example, db name=mydb, smf table prefix=smf_, coppermine table prefix=cpg130_

[Atari2600]

I've had SMF for awhile and just installed  Coppermine. I installed coppermine as though I didnt even have SMF (standalone) So they are seperate databases. I've used coppermine by itself for awhile also but when I moved servers I heard that a new version of the gallery was out and that a "bridge" was made for SMF and thought SWEET.

As far as directory structure:

mainwebsitedirectory/smf
mainwebsitedirectory/gallery

[kegobeer]

AFAIK, you need to share the same database in order for everything to work.  I'd move the coppermine tables to the db your SMF tables are in, update your coppermine settings to reflect the new db location, and then everything should work for you.

[Atari2600]

if i knew how to do that much i wouldn't be posting for help. doesn't the bridge create tables for coppermine in the smf database. I thought the bridge was to help the intergratioon I have nothing in the coppermine database. What if i just tell it the database is the smf database? Would coppermine just create the tables itself in the SMF database? Why does it not mention this in the instructions anywhere. I can't find anything in my instructions about this...............................

[Joachim Müller]

the instructions say you have to have both smf and coppermine up and running before starting integration, so you should have something in your coppermine database. If you haven't even installed coppermine yet, do so now, using the same database your smf install uses.

GauGau

[Atari2600]

well yeah there is my admin account, but I just meant it wasnt an active gallery yet ( fresh install). I guess what I didnt get was the database part. So what your saying is when I install it I put in the SMF databse and not create a new one. I guess I missed that part in the instructions.

[Atari2600]

Ok I  reran installer and told it to use the SMF database and the bridge works fine now.  The part that had me mixed up was when you said about installing them seperately. To me i thought that meant databases too.  Been pulling out whats left of my hair and all it was, was that little thing about using same database that had me all mixed up. Like i said before i thought when you actived the bridge, the bridge told the gallery to use the SMF database. Thats what I couldn't understand. Perhaps putting in bold font in the instructions to USE YOUR FORUM DATABASE WHEN YOU DO THE INSTALL would help some of us php beginners 

Also thanks to all who gave time to try and help me. Its appreciated

[subnet_rx]

thanks for this post, installing both in the same database worked perfectly for me also.