User Manager time out (problems with previous fix)

[taiofmine]

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.

[Αndré]

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 Expand

                = "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 Expand

                $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'";