[Solved]: SMF bridge problems [Solved]: SMF bridge problems
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

[Solved]: SMF bridge problems

Started by Atari2600, August 18, 2004, 04:08:52 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

Atari2600

August 18, 2004, 04:08:52 AM Last Edit: August 21, 2004, 04:12:56 AM by GauGau
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

#1
August 18, 2004, 06:03:13 AM
I don't understand your directory structure.  Is it like this?

gallery/coppermine
gallery/smf
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

kegobeer

#2
August 18, 2004, 06:15:06 AM
Also, are they sharing the same db?  For example, db name=mydb, smf table prefix=smf_, coppermine table prefix=cpg130_
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Atari2600

#3
August 19, 2004, 12:26:28 AM
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

#4
August 19, 2004, 05:32:22 AM
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.
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

Atari2600

#5
August 20, 2004, 02:45:16 AM
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

#6
August 20, 2004, 08:19:45 AM Last Edit: August 21, 2004, 04:11:35 AM by GauGau
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

#7
August 20, 2004, 06:47:51 PM
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

#8
August 21, 2004, 12:54:00 AM
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  :P

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

subnet_rx

#9
May 10, 2005, 11:16:33 PM
thanks for this post, installing both in the same database worked perfectly for me also.
Print
Go Up Pages1
User actions