Hello,
> > I use the mgd_get_topic_by_name() function with constant parameters, and
> > sometimes it returns with 'object does not exist', sometimes it finds
> > the topic, which is never deleted. Weird...
>
> You'll have to turn on mysql logging to see what is being asked and see
> if the request differs. MMP + midgard-lib (latest CVS) have facilities
Unfortunately now it fails at 50%. YES, I have found difference in the
SQL statement; it identifies the sitegroup badly. The company which the
page belongs to, is placed in sitegroup 1.
Here, I copy the whole log-part for a bad query, and (after pushing
simply a few refresh to the browser) a good query.
BAD:
------------------------------------------------------------
020302 18:50:09 73 Init DB midgard
73 Statistics
73 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
73 Query SELECT info&2 FROM page WHERE id=109
73 Query SELECT name,value FROM pageelement
WHERE page=109 AND info&1=1
73 Query SELECT id,style,info&1,info&2 FROM
page WHERE up=109 AND name='felvitel'
73 Query SELECT name,value FROM pageelement
WHERE page=150 AND info&1=1
73 Query SELECT name,value FROM pageelement
WHERE page=150 AND info&1=0
73 Query SELECT
title,content,author,style,info&1,up FROM page WHERE id=150
73 Query SELECT CONCAT(firstname,'
',lastname) FROM person WHERE id=10
73 Query SELECT type FROM style WHERE id=8
73 Query SELECT name,value FROM element WHERE
style=8
73 Query SELECT up FROM style WHERE id=8
243 Connect root@localhost on
243 Init DB informed
73 Query SELECT admingroup FROM sitegroup
WHERE id=0
73 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
73 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)
243 Quit
BAD:
-------------------------------------------------
020302 18:51:23 75 Statistics
75 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
75 Query SELECT info&2 FROM page WHERE id=109
75 Query SELECT name,value FROM pageelement
WHERE page=109 AND info&1=1
75 Query SELECT id,style,info&1,info&2 FROM
page WHERE up=109 AND name='felvitel'
75 Query SELECT name,value FROM pageelement
WHERE page=150 AND info&1=1
75 Query SELECT name,value FROM pageelement
WHERE page=150 AND info&1=0
75 Query SELECT
title,content,author,style,info&1,up FROM page WHERE id=150
75 Query SELECT CONCAT(firstname,'
',lastname) FROM person WHERE id=10
75 Query SELECT type FROM style WHERE id=8
75 Query SELECT name,value FROM element WHERE
style=8
75 Query SELECT up FROM style WHERE id=8
248 Connect root@localhost on
248 Init DB informed
75 Query SELECT admingroup FROM sitegroup
WHERE id=1
75 Query SELECT id,password FROM person WHERE
username='author' AND sitegroup=1
75 Query SELECT gid FROM member WHERE uid=9
AND sitegroup in (0, 1) ORDER BY gid DESC
75 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)
248 Quit
------------------------------------------------
And the relevant code:
[...]
mgd_auth_midgard("author","x",0);
$mgd=mgd_get_midgard();
$t=mgd_get_topic_by_name(0,"informed");
Accepting any help:
Circum
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
