On Thu, Jul 19, 2001 at 07:35:31PM +0200, Emiliano wrote:
> Sergio Bruder wrote:
> > But I compiled *without* sitegroup support and I'm using 1.2.5 admin
> > site code. sitegroups now are the only option?
>
> Absolutely not. I now see you said earlier you compiled without, but
> since your samples seemed to imply SGs...
>
> User 'bruder' should work. The -6 is a bit of a surprise in this regard.
> If you have mysql logging turned on, I'd be most interested in what it
> says. It should look like
>
> SELECT id,password FROM person WHERE username="bruder"
>
> I'd also be interested what this query returns if you type it into mysql
> yourself.
>
> Emile
SELECT person.id,person.password FROM person,member
WHERE person.username='bruder' AND person.sitegroup=0 AND
member.uid = person.id AND member.gid=0
Empty set (0.01 sec)
HMmm. This 'member' table is new to me.
select * from member where member.uid=2;
+----+-----+-----+-------+------+-----------+
| id | uid | gid | extra | info | sitegroup |
+----+-----+-----+-------+------+-----------+
| 5 | 2 | 1 | | | 0 |
| 4 | 2 | 2 | | | 0 |
| 7 | 2 | 4 | | | 0 |
| 31 | 2 | 17 | | | 0 |
+----+-----+-----+-------+------+-----------+
4 rows in set (0.00 sec)
bruder account doenst have a row in member table with gid=0, that's
it.
Is that query correct for a non-sitegroup installation?
Sergio Bruder
--
Coordena��o de Desenvolvimento - Projetos Especiais, Conectiva
http://www.conectiva.com.br, http://sergio.bruder.net, http://pontobr.org
-----------------------------------------------------------------------------
pub 1024D/0C7D9F49 2000-05-26 Sergio Devojno Bruder <[EMAIL PROTECTED]>
Key fingerprint = 983F DBDF FB53 FE55 87DF 71CA 6B01 5E44 0C7D 9F49
sub 1024g/138DF93D 2000-05-26
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
