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:
QuoteUSER:
------------------
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: ;
Use the phpbb3 bridge when bridging to phpbb3.
And how exactly do I do that? Cause I can't see the v3 version phpbb.
It's too new to be in the released package. Get it from http://forum.coppermine-gallery.net/index.php/topic,53678.0.html
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?
http://gidsen.donaldini.be/forum
User: testaccount
pass: testaccount
There you go, hope it helps
You need to enter the correct cookie prefix in the bridge manager. Your cookie prefix is "phpbb3_b6idp"
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?
That's the correct one.
This might be a silly question, but where can I change the bridgemanagers settings once again?
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!