bridging MYBB

[thisizaremix]

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]

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