Bridge error: error processing database query

[Donaldini]

I have the following issue when trying to bridge coppermine and phpbb:

After setup I got this error message: Critical error: There was an error while processing a database query


I can't login either, cause I get redirected to the following url (that doesn't excist): http://gidsen.donaldini.be/forum/login.php?redirect=../album/

Coppermine install: http://gidsen.donaldini.be/album
Forum install: http://gidsen.donaldini.be/forum
Coppermine version: cpg1.4.19
Forum version: phpBB 3.0.2
Test user account: coppermine won't let me

BridgeManager settings:
Forum URL:  http://gidsen.donaldini.be/forum
Relative path to your BBS's config file:  ../forum/
Use post-based groups?:  0? can't remember, I chose the recomended option
Cookie name/preifx (if applicable) also standard value

I googled for solutions aswel on this forum, but came up with nothing useful other that the fact that all posts required a debug_mode return, so here it is:

USER:
------------------
Array
(
    [ID] => 6d15d08165aa7a4a27c80670d87e5609
    [am] => 1
    [lang] => dutch
    [liv] => Array
        (
           

• => 168
              [1] => 167
              [2] => 152
              [3] => 187
              [4] => 198
          )
  
      [name] => Donald
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_name] => Donaldini
      [groups] => Array
          (
             
• => 1
          )
  
      [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
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM album_gidsen_filetypes; (0s)
      [1] => select * from album_gidsen_plugins order by priority asc; (0s)
      [2] => delete from `Donaldini`.album_gidsen_sessions where time<1226398737 and remember=0; (0s)
      [3] => delete from `Donaldini`.album_gidsen_sessions where time<1225192737; (0s)
      [4] => select user_id from `Donaldini`.album_gidsen_sessions where session_id = 'e6056b235e7b175ab62e848aea837f3f' (0s)
      [5] => select user_id as id, user_password as password from `Donaldini`.album_gidsen_users where user_id=1 (0s)
      [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `Donaldini`.album_gidsen_users AS u INNER JOIN `Donaldini`.album_gidsen_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
      [7] => SELECT user_group_list FROM `Donaldini`.album_gidsen_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
      [8] => 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 album_gidsen_usergroups WHERE group_id in (1) (0s)
      [9] => SELECT group_name FROM  album_gidsen_usergroups WHERE group_id= 1 (0s)
      [10] => update `Donaldini`.album_gidsen_sessions set time='1226402337' where session_id = 'e6056b235e7b175ab62e848aea837f3f' (0s)
      [11] => SELECT user_favpics FROM album_gidsen_favpics WHERE user_id = 1 (0s)
      [12] => DELETE FROM album_gidsen_banned WHERE expiry < '2008-11-11 11:18:57' (0s)
      [13] => SELECT * FROM album_gidsen_banned WHERE (ip_addr='81.83.126.102' OR ip_addr='81.83.126.102' OR user_id=1) AND brute_force=0 (0s)
      [14] => SELECT COUNT(*) FROM album_gidsen_pictures WHERE approved = 'NO' (0s)
      [15] => SELECT * FROM album_gidsen_bridge (0s)
      [16] => UPDATE album_gidsen_config SET value = '1' WHERE name = 'bridge_enable' (0s)
      [17] => SELECT * FROM album_gidsen_bridge (0s)
      [18] => SELECT * FROM album_gidsen_config (0s)
      [19] => SELECT * FROM `Donaldini`.phpbb_forum_Gidsen_groups WHERE group_single_user = 0 (0s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 5.1.6 - OK
  ------------------
  mySQL version: 5.0.22
  ------------------
  Coppermine version: 1.4.19(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 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:
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 5.0.22
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /var/lib/mysql/mysql.sock
  MYSQL_INCLUDE -I/usr/include/mysql
  MYSQL_LIBS -L/usr/lib64/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Stream Wrapper support compress.zlib://
  Stream Filter support zlib.inflate, zlib.deflate
  Compiled Version 1.2.3
  Linked Version 1.2.3
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | On
  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 | .: | .:
  open_basedir | /var/www/vhosts/donaldini.be/subdomains/gidsen/httpdocs:/tmp | 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 | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.55 seconds - 20 queries in 0 seconds - Album set : ; Meta set: ;

[Nibbler]

Use the phpbb3 bridge when bridging to phpbb3.

[Donaldini]

And how exactly do I do that? Cause I can't see the v3 version phpbb.

[Nibbler]

It's too new to be in the released package. Get it from http://forum.coppermine-gallery.net/index.php/topic,53678.0.html

[Donaldini]

Fantastic, the error is gone now.

But either it's not working, or i'm not getting the basic Idea behind this all.
The point behind the whole bridging thing is that registered FORUM users, can login with their phpBB login in the coppermine?
Or that when they login in coppermine, they get redirected to the phpbb for loging in, so they can return to coppermine logged in with their phpBB login (which is now used by coppermine?)

Cause in my case, I cannot seem to login in coppermine?
Should I create you a test account on the forum?

[Joachim Müller]

Should I create you a test account on the forum?

yep

[Donaldini]

http://gidsen.donaldini.be/forum
User: testaccount
pass: testaccount

There you go, hope it helps

[Nibbler]

You need to enter the correct cookie prefix in the bridge manager. Your cookie prefix is "phpbb3_b6idp"

[Donaldini]

wow, this is an extremely late response from my side :-)

Do you mean that the wrong cookie i set is that one, or that one is the right one?

[Nibbler]

That's the correct one.

[Donaldini]

This might be a silly question, but where can I change the bridgemanagers settings once again?

[Donaldini]

Ah nevermind, I found it in the forum elsewhere. I should've searched first :-)
Nevertheless you helped me, cause it was your post :p

But it works, i'm gonna try it out with another forum username to double check, but it seems to look good!
Thanks for the help!