forum.coppermine-gallery.net

Support => Older/other versions => cpg1.2 PHPnuke/Postnuke Support => Topic started by: gtroll on November 06, 2003, 10:34:32 pm

Title: BUG in coppermine.sql RC1 & RC2
Post by: gtroll on November 06, 2003, 10:34:32 pm

Run this query in phpmyadmin:

Code: [Select]


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.

Title: BUG in coppermine.sql RC1 & RC2
Post by: rhydewithdis on November 08, 2003, 04:57:49 am

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

Title: BUG in coppermine.sql RC1 & RC2
Post by: DJMaze on November 08, 2003, 05:06:06 am

[list=1]

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

Title: still having permission problems
Post by: rhydewithdis on November 08, 2003, 04:57:54 pm

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?

Title: BUG in coppermine.sql RC1 & RC2
Post by: DJMaze on November 08, 2003, 07:10:12 pm

nice pictures 8)

donno i shall try to find the bug