Registered Users Can't upload after Bridging... Registered Users Can't upload after Bridging...
 

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]

Main Menu

Registered Users Can't upload after Bridging...

Started by CaptainDon, November 25, 2011, 07:13:29 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

CaptainDon

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

My Registered Users on my forum cannot upload photos. I had to change the Admin Group Id from (5) to (1617) in "bridge/phpbb3.inc.php"

From the Debug mode I am thinking the problem is coppermine thinks my "Registered group" ID is (1714) but it is infact (1614) but I cannot find where to change this...

Admin can Upload Photos... My Bridge app might be from an old coppermine version and I didn't install it if it doesn't come with phpbb 3.0.9 and I don't know where to get an updated version...


Coppermine install: http://www.michiganoutdoorsman.com/MOPhoto
Bridging app install: http://www.michiganoutdoorsman.com/Forum
Coppermine version: 5.2.17
Bridging app version: (Not Sure)
Test user account: PhotoTester / Test123

BridgeManager settings:(Not Sure)
Bridge app URL:  http://www.michiganoutdoorsman.com/Forum
Relative path to your bridge app's config file:  ../
Cookie name or prefix:  phpbb2mysql
Use bridge app custom groups?:  1

Debug Info:
USER:
------------------
Array
(
    [ID] => ffa6b45bd571c31981397fb9a9867a00
    [am] => 1
    [lang] => english
    [liv] => Array
        (
        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 2226
    [user_name] => PhotoTester
    [groups] => Array
        (
            [0] => 1714
        )

    [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] => 0
    [access_level] => 3
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => REGISTERED
    [can_create_public_albums] => 0
    [group_quota] => 0
    [can_see_all_albums] => 0
    [group_id] => 1714
    [allowed_albums] => Array
        (
        )

)

==========================
Queries:
------------------
Array
(
    [0] => 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 name, value FROM cpg15x_bridge [include/functions.inc.php:4441] (0 ms)
    [3] => SELECT user_id, user_password, group_id FROM `michiga3_monew`.phpbb_sessions INNER JOIN `michiga3_monew`.phpbb_users ON session_user_id = user_id WHERE session_id = '9db311beb030d558313653aad5c4cdad' [bridge/phpbb3.inc.php:131] (0 ms)
    [4] => SELECT u.user_id AS id, u.username AS username, user_password AS password, ug.group_id AS group_id FROM `michiga3_monew`.phpbb_users AS u, `michiga3_monew`.phpbb_user_group AS ug WHERE u.user_id=ug.user_id AND u.user_id='2226' [bridge/udb_base.inc.php:70] (0 ms)
    [5] => SELECT group_id FROM `michiga3_monew`.phpbb_user_group WHERE user_id = 2226 [bridge/phpbb3.inc.php:165] (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 (1714) [bridge/udb_base.inc.php:323] (0 ms)
    [7] => SELECT group_name FROM cpg15x_usergroups WHERE group_id= 1714 [bridge/udb_base.inc.php:327] (0 ms)
    [8] => SELECT COUNT(*) FROM cpg15x_categorymap WHERE group_id in (1714) [bridge/udb_base.inc.php:340] (0 ms)
    [9] => SELECT aid FROM cpg15x_albums WHERE moderator_group IN (1714) [include/init.inc.php:271] (0 ms)
    [10] => SELECT lang_id FROM cpg15x_languages WHERE enabled='YES' [include/init.inc.php:329] (0 ms)
    [11] => SELECT user_favpics FROM cpg15x_favpics WHERE user_id = 2226 [include/init.inc.php:387] (1 ms)
    [12] => DELETE FROM cpg15x_banned WHERE expiry < '2011-11-24 22:39:17' [include/init.inc.php:443] (0 ms)
    [13] => SELECT null FROM cpg15x_banned WHERE (user_id=2226 OR '67.142.162.30' LIKE ip_addr OR '' LIKE ip_addr ) AND brute_force=0 LIMIT 1 [include/init.inc.php:459] (0 ms)
    [14] => SELECT aid, title, cid, name FROM cpg15x_albums INNER JOIN cpg15x_categories ON cid = category WHERE category < 10000 AND ((uploads='YES' AND (visibility = '0' OR visibility IN (1714) OR alb_password != '')) OR (owner=2226)) [upload.php:575] (2 ms)
    [15] => SELECT aid, title FROM cpg15x_albums WHERE category = 0 AND ((uploads='YES' AND (visibility = '0' OR visibility IN (1714) OR alb_password != '')) OR (owner=2226)) [upload.php:577] (1 ms)
    [16] => SELECT aid, title FROM cpg15x_albums WHERE category='12226' ORDER BY title [upload.php:599] (1 ms)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
COOKIE :
------------------
Array
(
    [cpg15x_data] => YTo0OntzOjI6IklEIjtzOjMyOiJmZmE2YjQ1YmQ1NzFjMzE5ODEzOTdmYjlhOTg2N2EwMCI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJlbmdsaXNoIjtzOjM6ImxpdiI7YTowOnt9fQ==
    [0636717c57795649750f088cbb77df88] => b33586d8796c904339c319372c6c2905
    [cpg131_data] => YToyOntzOjI6IklEIjtzOjMyOiI1YWJhZWM2NzYyN2JmYzk1ZTY2MDkyMjZkNzMxMTNmOCI7czoyOiJhbSI7aToxO30=
    [ae8b3f86d862fe4e5baf53ea272a8194] => 4bc1f863c769fd8a7c6915e594ad387b
    [phpbb2mysql_sid] => 9db311beb030d558313653aad5c4cdad
    [phpbb2mysql_u] => 2226
    [phpbb2mysql_k] => fd16e1d3b8769b64
)

==========================
               

Αndré

Afaik Coppermine automatically adds +100 to the group IDs for its internal use, so that should be correct. Have you assigned upload privileges to the "Registered" group in Coppermine's group manager? If so, try to create a new user, assign him only to that "Registered" group and try again.

CaptainDon

Yes I've Done that... I even added a new group to the coppermine Groups called " Registered users" because that's how the group name is in the phpbb Forums...

How do I find which bridge app I have in my phpbb 3.0.9 or is that something that comes with the phpbb3 and thus already the most up to date?

Also I still have an old photo album at http://www.michiganoutdoorsman.com/photo that is still up and running and Bridged can that be causing an issue? If so I cannot access admin on that one because I did not create it and didn't ever know the password and the person that helped me make that gallery has disappeared thus why I am going at this new gallery myself so I know how it works and can fix and update it...

Αndré

The group name is irrelevant, as Coppermine just uses the group IDs. Also it doesn't matter if you have a second gallery bridged, as the bridging is done 100% within Coppermine, so the board isn't aware of that nor is Coppermine aware if another gallery is bridged to the board.


I successfully uploaded a picture to your gallery: http://www.michiganoutdoorsman.com/MOPhoto/displayimage.php?pid=7 - so everything works as expected imo?!

CaptainDon

yes and the reason you were able to do this is because I was researching and found this and was in the process of changing album properties....

THIS NEEDS TO BE MORE CLEAR IN THE DOCUMENTATION ABOUT BRIDGING...DROVE ME NUTS FOR HOURS!!!!

QuoteHi Joanne,

you just need to change the album properties.  Login in admin mode, then click on the 'properties' button, next to the album thumbnail.  Change 'visitors can upload pictures' to YES.
This only allows others who are in a group with permission to upload, not all visitors.

Αndré

Instead of shouting you should read the documentation more thoroughly. If you want to allow "visitors" (which in this aspect are all people, which aren't in the admin group) to upload pictures to already existing albums you need to enable that option. But that don't apply to my test upload to your gallery. I created an album myself and was able to upload to that album without any changes in the album's properties.


Your issue doesn't apply only to bridging, but applies for unbridged galleries as well: regular users aren't allowed to upload to public albums (or create albums in public categories) unless you give them (= its user group) the permissions in the album (respectively category) properties. I'm sure this is mentioned somewhere in the docs, so I don't see any reason why we should add it to the bridging docs, as you have to read that parts of the docs anyway.

CaptainDon

Ok then it needs to be explained better like you just explained it...

I am serious I spent almost 10 hours on such a minor fix...

Thanks for your help!