BUG in coppermine.sql RC1 & RC2

[gtroll]

Run this query in phpmyadmin:

Code Select Expand


UPDATE cpg_usergroups SET has_admin_access= 0 WHERE group_id=3

if you don't use cpg_ as your table name adjust accordingly
We will have a RC2 shortly with this fix in it.

[rhydewithdis]

Hey - thanks for the update of this bug - I actually helped DJMaze identify this one - I'm not too familiary with phpMyAdmin - could you give alittle more information on how to run this query in phpmyadmin.  I can get to the phpmyadmin page and also into my DB but I'm not sure how to exactly run the query.  Thanks

[DJMaze]

[list=1]

• Choose the correct database
• Then in right frame click on SQL tab.
• Paste above code in there and execute
[/list:o]

[rhydewithdis]

DJMaze - I ran that query just now - here was the result:
UPDATE cpg11d_usergroups SET has_admin_access = 0 WHERE group_id = 3

(note my DB for usergroups is listed as cpg11d_usergroups....)

However the permissions still aren't working correctly (i.e. albums under "registered users only" still show up to visitors who have not registered).

Note: Content of this link may be inappropriate to minors:
http://www.vivrant.com/modules.php?name=coppermine&cat=7

Maze - what you think?

[DJMaze]

nice pictures

donno i shall try to find the bug