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: User Manager time out (problems with previous fix)  (Read 1736 times)

0 Members and 1 Guest are viewing this topic.

taiofmine

  • Coppermine newbie
  • Offline Offline
  • Posts: 14
User Manager time out (problems with previous fix)
« on: January 30, 2011, 11:59:50 pm »

I've been having problems accessing my user manager for quite some time now. When I click it, it just times out.

I found <A HREF="http://forum.coppermine-gallery.net/index.php/topic,27540.msg129081.html#msg129081">this</A> fix... the thread says it does work with 1.5.x, but when I tried it, I got this error:

<I>Parse error: syntax error, unexpected '=' in /home/allantmn/all-antm.net/bridge/udb_base.inc.php on line 61</I>

I just upgraded, so I'm using the most recent version of Coppermine. I attached a txt document with what my udb_base.inc.php looks like now. I'm not sure what '=' is messing things up....

Thanks in advance.
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: User Manager time out (problems with previous fix)
« Reply #1 on: January 31, 2011, 02:43:56 pm »

You removed the needed variable $sql in front of the equal sign in line 61. Open bridge/udb_base.inc.php file, find
Code: [Select]
                = "SELECT u.{$f['user_id']} AS id, u.{$f['username']} AS username, {$f['password']} AS password, ug.{$f['usertbl_group_id']} AS group_id "
                        . "FROM {$this->usertable} AS u, {$this->usergroupstable} AS ug "
                        . "WHERE u.{$f['user_id']}=ug.{$f['user_id']} AND u.{$f['user_id']}='$id'";
and replace with
Code: [Select]
                $sql = "SELECT u.{$f['user_id']} AS id, u.{$f['username']} AS username, {$f['password']} AS password, ug.{$f['usertbl_group_id']} AS group_id "
                        . "FROM {$this->usertable} AS u, {$this->usergroupstable} AS ug "
                        . "WHERE u.{$f['user_id']}=ug.{$f['user_id']} AND u.{$f['user_id']}='$id'";
Logged
Pages: [1]   Go Up
 

Page created in 0.018 seconds with 19 queries.