Hello,
> OK, this is the origin of the problem. At this point, Midgard issues a
> query like:
>
> SELECT id,password FROM person WHERE username=<username> AND
> sitegroup=<sitegroupid>
>
> and appearantly it is getting an error or 0 results from the database,
> in which case it issues a NOTFOUND error.
[...]
> It'd be interesting to know what <sitegroupid> the query has in case of
> failure.
In the case of failure the mysql.log is as follows:
------------------------------------------------------------
020310 17:29:44 3 Connect midgard@localhost on midgard
3 Statistics
3 Query SELECT
id,style,root,info&1,Length(prefix),sitegroup FROM host WHERE
name='www.informed.hu' AND port IN (0,8001) AND
prefix=Left('/informed/felvitel/',Length(prefix)) AND
IF(19>=Length(prefix),MID('/informed/felvitel/',1+Length(prefix),1) IN
('','/'),0)=1 AND online=1 ORDER BY prefix DESC, port DESC
3 Query SELECT info&2 FROM page WHERE id=109
3 Query SELECT name,value FROM pageelement
WHERE page=109 AND info&1=1
3 Query SELECT id,style,info&1,info&2 FROM
page WHERE up=109 AND name='felvitel'
3 Query SELECT name,value FROM pageelement
WHERE page=150 AND info&1=1
3 Query SELECT name,value FROM pageelement
WHERE page=150 AND info&1=0
3 Query SELECT
title,content,author,style,info&1,up FROM page WHERE id=150
3 Query SELECT CONCAT(firstname,'
',lastname) FROM person WHERE id=10
3 Query SELECT type FROM style WHERE id=8
3 Query SELECT name,value FROM element WHERE
style=8
3 Query SELECT up FROM style WHERE id=8
4 Connect root@localhost on
4 Init DB informed
3 Query SELECT admingroup FROM sitegroup
WHERE id=0
3 Query SELECT person.id,person.password
FROM person,member WHERE person.username='author' AND person.sitegroup=0
AND member.uid = person.id AND member.gid=0
3 Query SELECT
id,up,score,name,description,extra,owner,code,creator,Unix_timestamp(created)
as created,revisor,Unix_timestamp(revised) as revised,revision FROM
topic WHERE up=0 AND name='informed' AND (sitegroup in (0, 0) OR 0<>0)
4 Quit
-------------------------------------------------------
In the case if success the last few rows are:
------------------------------------------------------------
5 Query SELECT admingroup FROM sitegroup
WHERE id=1
5 Query SELECT id,password FROM person WHERE
username='author' AND sitegroup=1
5 Query SELECT gid FROM member WHERE uid=9
AND sitegroup in (0, 1) ORDER BY gid DESC
5 Query SELECT
id,up,score,name,description,extra,owner,code,creator,Unix_timestamp(created)
as created,revisor,Unix_timestamp(revised) as revised,revision FROM
topic WHERE up=0 AND name='informed' AND (sitegroup in (0, 1) OR 0<>0)
7 Quit
------------------------------------------------------------
(And connection 5 is re-used from the previous session.)
Bye,
Circum
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
