Advanced search  

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

Pages: [1]   Go Down

Author Topic: bridging MYBB  (Read 7069 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.034 seconds with 19 queries.