forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 miscellaneous => Topic started by: taiofmine on January 30, 2011, 11:59:50 pm

Title: User Manager time out (problems with previous fix)
Post by: taiofmine 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.
Title: Re: User Manager time out (problems with previous fix)
Post by: Αndré 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'";