Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: BUG in coppermine.sql RC1 & RC2  (Read 6364 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.022 seconds with 19 queries.