bridging MYBB

thisizaremix · December 08, 2011, 11:30:03 AM

I have the following issue when trying to bridge coppermine and MYBB:
I have tried for hours to get this bridge to work but everytime I activate the bridge, I receive the following message:
While executing query 'SELECT u.uid, u.loginkey, additionalgroups
FROM `********`.8528_sessions AS s
INNER JOIN `********`.8528_users AS u ON u.uid = s.uid
WHERE sid = 'ea88dc66f74e7bf70e56a3096559e478'' in bridge/mybb.inc.php on line 132

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.8528_sessions AS s
INNER JOIN `********`.8528_users AS u ' at line 2

Coppermine install: http://www.xxxxxxwforum.com/cpg15x/
Bridging app install: http://www.xxxxxxwforum.com/
Coppermine version: cpg1.5.16
Bridging app version: MYBB v1.6.5
Test user account: testforum / testforum

BridgeManager settings:
Bridge app URL: http://www.xxxxxxwforum.com/
Relative path to your bridge app's config file: ../inc/
Cookie name or prefix: cpg15x
Use bridge app custom groups?: 0

USER:
------------------
Array
(
[ID] => 82904e34fd21a2bb1235c0d41a5aceef
[am] => 1
[lang] => english
)

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

=> 1
)

[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[can_post_comments] => 1
[can_upload_pictures] => 1
[can_create_albums] => 1
[has_admin_access] => 1
[access_level] => 3
[pub_upl_need_approval] => 0
[priv_upl_need_approval] => 0
[group_name] => Administrators
[can_create_public_albums] => 0
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
[allowed_albums] => Array
(
)

)

==========================
Queries:
------------------
Array
(
=> SELECT name, value FROM cpg15x_config [include/init.inc.php:181] (0 ms)
[1] => SELECT * FROM cpg15x_plugins ORDER BY priority [include/plugin_api.inc.php:54] (0 ms)
[2] => SELECT user_id, time FROM `*********`.cpg15x_sessions WHERE session_id = 'c7f81309fb4aca32672509c65f71f5b4' [bridge/coppermine.inc.php:264] (0 ms)
[3] => SELECT user_id, user_password FROM `*********`.cpg15x_users WHERE user_id = 1 [bridge/coppermine.inc.php:276] (0 ms)
[4] => SELECT u.user_id AS id, u.user_name AS username, user_password AS password, u.user_group AS group_id FROM `*********`.cpg15x_users AS u LEFT JOIN `*********`.cpg15x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' [bridge/udb_base.inc.php:70] (0 ms)
[5] => SELECT user_group_list FROM `*********`.cpg15x_users AS u WHERE user_id='1' AND user_group_list <> '' [bridge/coppermine.inc.php:202] (0 ms)
[6] => 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(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, MAX(access_level) AS access_level, MIN(pub_upl_need_approval) AS pub_upl_need_approval, MIN( priv_upl_need_approval) AS priv_upl_need_approval FROM cpg15x_usergroups WHERE group_id in (1) [bridge/udb_base.inc.php:323] (0 ms)
[7] => SELECT group_name FROM cpg15x_usergroups WHERE group_id= 1 [bridge/udb_base.inc.php:327] (0 ms)
[8] => SELECT COUNT(*) FROM cpg15x_categorymap WHERE group_id in (1) [bridge/udb_base.inc.php:340] (0 ms)
[9] => SELECT lang_id FROM cpg15x_languages WHERE enabled='YES' [include/init.inc.php:329] (0 ms)
[10] => SELECT user_favpics FROM cpg15x_favpics WHERE user_id = 1 [include/init.inc.php:387] (11 ms)
[11] => DELETE FROM cpg15x_banned WHERE expiry < '2011-12-08 04:17:38' [include/init.inc.php:443] (1 ms)
[12] => SELECT null FROM cpg15x_banned WHERE (user_id=1 OR '72.201.214.3' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (0 ms)
[13] => SELECT COUNT(*) FROM cpg15x_pictures WHERE approved = 'NO' [include/functions.inc.php:2438] (0 ms)
[14] => SELECT lang_id, abbr FROM cpg15x_languages WHERE available='YES' AND enabled='YES' [include/themes.inc.php:2316] (0 ms)
[15] => SELECT message FROM cpg15x_temp_messages WHERE message_id = '56a2cc9c7a4ccef1db9ecb53cae51ae3' LIMIT 1 [include/functions.inc.php:4915] (2 ms)
[16] => DELETE FROM cpg15x_temp_messages WHERE message_id = '56a2cc9c7a4ccef1db9ecb53cae51ae3' [include/functions.inc.php:4926] (0 ms)
[17] => DELETE FROM cpg15x_temp_messages WHERE time < 1323335858 [include/functions.inc.php:4947] (0 ms)
[18] => SELECT name, value FROM cpg15x_bridge [include/functions.inc.php:4441] (2 ms)
[19] => SELECT name, value FROM cpg15x_bridge [include/functions.inc.php:4441] (0 ms)
)

==========================
GET :
------------------
Array
(
[message_id] => 56a2cc9c7a4ccef1db9ecb53cae51ae3
[message_icon] => success
)

==========================
POST :
------------------
Array
(
)

==========================
COOKIE :
------------------
Array
(
[cpg15x_data] => YTozOntzOjI6IklEIjtzOjMyOiI4MjkwNGUzNGZkMjFhMmJiMTIzNWMwZDQxYTVhY2VlZiI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJlbmdsaXNoIjt9
[mybb] => Array
(
[lastvisit] => 1323339313
[lastactive] => 1323339320
)

[sid] => ea88dc66f74e7bf70e56a3096559e478
[loginattempts] => 1
[mybbuser] => 2_IkU7Rsg42mOcPX5fwecO9KpZexEAzVhZZ2wguk5jKvexMWryLp
[75d4efa7a4fa5f8f0e766dd2aeb0b860] => c46a38dba27bdd1f6b3df673929d6b5e
)

==========================
VERSION INFO :
------------------
PHP version 5.2.17 OK
MySQL version 5.0.92-community OK
Coppermine version 1.5.16 stable

==========================
Module: GD
------------------
Exact version 2.0.34
GD Version bundled (2.0.34 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

==========================
Key config settings
------------------
site_url http://www.xxxxxxwforum.com/cpg15x/
charset utf-8
allow_private_albums 1
cookie_name cpg15x
cookie_path /
impath /usr/bin/
lang english
main_page_layout breadcrumb/catlist/alblist/random,2/lastup,2
silly_safe_mode 0
smtp_host
theme curve
thumb_method gd2

==========================
Plugins
------------------

==========================
Server restrictions
------------------
safe_mode 1
safe_mode_exec_dir
safe_mode_gid 1
safe_mode_include_dir
sql.safe_mode
disable_functions posix_getpwuid,posix_getpwnam,exec,shell_exec
file_uploads 1
include_path .:/usr/lib/php:/usr/local/lib/php
open_basedir
allow_url_fopen
max_execution_time 30
max_input_time 60
upload_max_filesize 10M
post_max_size 10M
memory_limit 64M
suhosin.post.max_vars
suhosin.request.max_vars

==========================
Page (performance)
------------------
Parameter Current Peak
Memory usage 5.37 MiB 6.50 MiB
Page generation 158 ms 158 ms
Page query time 16 ms 16 ms
Page query count 20 20

==========================

thisizaremix · December 09, 2011, 10:07:51 AM

I figured out the problem after countless hours messing with this.
When I made my forum at the beginning of the year, I changed the prefix of my database tables to 8528_ from mybb_ for security reasons. I guess coppermine did not like this change...

coppermine-gallery.com/forum

News:

bridging MYBB

thisizaremix

thisizaremix