[Solved]: SMF bridge problems

Atari2600 · August 18, 2004, 04:08:52 AM

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 · August 18, 2004, 06:03:13 AM

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

gallery/coppermine
gallery/smf

kegobeer · 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_

Atari2600 · 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 · 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.

Atari2600 · 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 · August 20, 2004, 08:19:45 AM

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 · 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 · 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

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

subnet_rx · May 10, 2005, 11:16:33 PM

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

coppermine-gallery.com/forum

News:

[Solved]: SMF bridge problems

Atari2600

kegobeer

kegobeer

Atari2600

kegobeer

Atari2600

Joachim Müller

Atari2600

Atari2600

subnet_rx