Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: bridging MYBB  (Read 6281 times)

0 Members and 1 Guest are viewing this topic.

thisizaremix

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
bridging MYBB
« on: 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     


==========================
                 
« Last Edit: December 10, 2011, 11:12:37 am by lurkalot »
Logged

thisizaremix

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Re: bridging MYBB
« Reply #1 on: 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...
Logged
Pages: [1]   Go Up
 

Page created in 0.026 seconds with 19 queries.