Advanced search  

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]

Pages: [1]   Go Down

Author Topic: BUG in coppermine.sql RC1 & RC2  (Read 6009 times)

0 Members and 1 Guest are viewing this topic.

gtroll

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 618
    • CPG-Nuke
BUG in coppermine.sql RC1 & RC2
« 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.

rhydewithdis

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 33
    • http://www.vivrant.com
BUG in coppermine.sql RC1 & RC2
« Reply #1 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
Logged

DJMaze

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 831
    • Dragonfly CMS
BUG in coppermine.sql RC1 & RC2
« Reply #2 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]
Logged
There are 2 kinds of users in this world: satisfied and complainers.
Why do we never hear something from the satisfied users?
http://coppermine-gallery.net/forum/index.php?topic=24315.0

rhydewithdis

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 33
    • http://www.vivrant.com
still having permission problems
« Reply #3 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?
Logged

DJMaze

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 831
    • Dragonfly CMS
BUG in coppermine.sql RC1 & RC2
« Reply #4 on: November 08, 2003, 07:10:12 pm »

nice pictures 8)

donno i shall try to find the bug
Logged
There are 2 kinds of users in this world: satisfied and complainers.
Why do we never hear something from the satisfied users?
http://coppermine-gallery.net/forum/index.php?topic=24315.0
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.