Hi Emile and all others helping out :)
Here's tha sql log. I finally started mysqld with the --log parameter and it
worked. Anyhow, here it is.
(here's some of the code, $year = 2001)
$list_start = gmmktime(0,0,0,1,1,$year);
$list_stop = gmmktime (24,0,0,12,31,$year);
$article = mgd_list_topic_calendar_all($main_t->up, $list_start, $list_stop,
"date", "2");
returns "no article".
Mysql log: (tell me if you need a longer log).
Thanx
Tarjei
tail mail.log -n40
7 Query SELECT id FROM snippetdir WHERE (up=0 AND
name='hklc_adminsite_host') AND (snippetdir.sitegroup in (0,1))
7 Query SELECT id FROM snippetdir WHERE (up=7 AND
name='argv0') AND (snippetdir.sitegroup in (0,1))
7 Query SELECT id FROM snippetdir WHERE (up=8 AND
name='preview') AND (snippetdir.sitegroup in (0,1))
7 Query SELECT id FROM snippet WHERE (up=13 AND
name='preview_code') AND (sitegroup IN (0,1) OR 0<>0)
7 Query SELECT code,sitegroup FROM snippet WHERE
id=76 AND (sitegroup in (0, 1) OR 0<>0)
011007 12:38:35 6 Statistics
6 Query SELECT
id,style,root,info&1,Length(prefix),sitegroup FROM host WHERE
name='nu.mail.nu.no' AND port IN (0,80) AND
prefix=Left('/presse/',Length(prefix)) AND
IF(8>=Length(prefix),MID('/presse/',1+Length(prefix),1) IN ('','/'),0)=1 AND
online=1 ORDER BY prefix DESC, port DESC
6 Query SELECT info&2 FROM page WHERE id=87
6 Query SELECT name,value FROM pageelement WHERE
page=87 AND info&1=1
6 Query SELECT id,style,info&1,info&2 FROM page
WHERE up=87 AND name='presse'
6 Query SELECT name,value FROM pageelement WHERE
page=98 AND info&1=1
6 Query SELECT name,value FROM pageelement WHERE
page=98 AND info&1=0
6 Query SELECT title,content,author,style,info&1,up
FROM page WHERE id=98
6 Query SELECT CONCAT(firstname,' ',lastname) FROM
person WHERE id=4
6 Query SELECT type FROM style WHERE id=22
6 Query SELECT name,value FROM element WHERE
style=22
6 Query SELECT up FROM style WHERE id=22
6 Query SELECT
id,up,score,name,description,extra,owner,code,creator,Unix_timestamp(created) as
created,revisor,Unix_timestamp(revised) as revised,revision,sitegroup,sitegroup
FROM topic WHERE id=37 AND (sitegroup in (0, 1) OR 0<>0)
6 Query SELECT domain,name,value FROM
record_extension WHERE tablename='topic' AND oid=37
6 Query SELECT guid FROM repligard WHERE
realm='topic' AND id=37
6 Query SELECT id FROM snippetdir WHERE (up=0 AND
name='nusnip') AND (snippetdir.sitegroup in (0,1))
6 Query SELECT id FROM snippet WHERE (up=128 AND
name='NU_functions') AND (sitegroup IN (0,1) OR 0<>0)
6 Query SELECT code,sitegroup FROM snippet WHERE
id=594 AND (sitegroup in (0, 1) OR 0<>0)
6 Query SELECT id FROM snippetdir WHERE (up=0 AND
name='nusnip') AND (snippetdir.sitegroup in (0,1))
6 Query SELECT id FROM snippet WHERE (up=128 AND
name='NU_code_init') AND (sitegroup IN (0,1) OR 0<>0)
6 Query SELECT code,sitegroup FROM snippet WHERE
id=593 AND (sitegroup in (0, 1) OR 0<>0)
6 Query SELECT realm,id FROM repligard WHERE
(guid='742f6006319d7ecef613e8d59885cab6') AND (repligard.sitegroup in (0,1))
6 Query SELECT
id,up,score,name,description,extra,owner,code,creator,Unix_timestamp(created) as
created,revisor,Unix_timestamp(revised) as revised,revision,sitegroup,sitegroup
FROM topic WHERE id=37 AND (sitegroup in (0, 1) OR 0<>0)
6 Query SELECT domain,name,value FROM
record_extension WHERE tablename='topic' AND oid=37
6 Query SELECT id FROM snippetdir WHERE (up=0 AND
name='nusnip') AND (snippetdir.sitegroup in (0,1))
6 Query SELECT id FROM snippet WHERE (up=128 AND
name='NU_conf_array') AND (sitegroup IN (0,1) OR 0<>0)
6 Query SELECT code,sitegroup FROM snippet WHERE
id=644 AND (sitegroup in (0, 1) OR 0<>0)
6 Query SELECT id,name,port,online,root,style,info&1
AS auth,owner,prefix,Concat('http', If(host.port=443, 's',''), '://', host.name,
If(host.port=0 || host.port=443, '', Concat(':', host.port)),If(host.prefix='/',
'/', Concat(host.prefix, '/'))) AS hostname,sitegroup,sitegroup FROM host WHERE
id=9 AND (sitegroup in (0, 1) OR 0<>0)
6 Query SELECT domain,name,value FROM
record_extension WHERE tablename='host' AND oid=9
6 Query SELECT id,up FROM topic WHERE up=14 AND
(sitegroup in (0, 1) OR 0<>0) ORDER BY up,id
6 Query SELECT id,up FROM topic WHERE up IN
(15,16,17,18,19,20,21,22,37,43) AND (sitegroup in (0, 1) OR 0<>0) ORDER BY up,id
6 Query SELECT id,up FROM topic WHERE up IN
(25,26,27,28,29,30,32,39,40,41,42,23,31,66,67,70,74,75,85,94,95,24,33,34,52,53,54,55,86,56,57,58,59,60,69,98,99,100,101,102,103,104,148,61,62,63,87,36,65,88)
AND (sitegroup in (0, 1) OR 0<>0) ORDER BY up,id
6 Query SELECT id,up FROM topic WHERE up IN
(112,123,124,147,35,68,96,97,146,128,129,130,89,90,38,73,76,79,117,125,126,119,120,121,122,141,140,64)
AND (sitegroup in (0, 1) OR 0<>0) ORDER BY up,id
6 Query SELECT id,up FROM topic WHERE up=150 AND
(sitegroup in (0, 1) OR 0<>0) ORDER BY up,id
6 Query SELECT article.id AS id,article.name AS
name,title,abstract,content,author,Concat(firstname,If(firstname=''||lastname='','','
'),lastname) AS authorname,article.topic AS
topic,Date_format(article.created,'%d.%m.%Y') AS
date,Date_format(article.created,'%D %b. %Y') AS
adate,Date_format(article.created,'%D %M %Y') AS
aldate,url,icon,extra1,extra2,extra3,article.score AS
score,type,Unix_Timestamp(article.created) AS created,article.creator AS
creator,Unix_Timestamp(revised) AS
revised,revisor,revision,Unix_Timestamp(locked) AS
locked,locker,Unix_Timestamp(approved) AS
approved,approver,article.sitegroup,If(IsNull(calstart),'',If(caldays=0,Date_Format(calstart,'%d.%m.%Y'),Concat(Date_Format(calstart,If(Year(calstart)!=Year(From_Days(To_Days(calstart)+caldays)),'%d.%m.%Y',If(Month(calstart)!=Month(From_Days(To_Days(calstart)+caldays)),'%d.%m.','%d.'))),Date_Format(From_Days(To_Days(calstart)+caldays),'-%d.%m.%Y'))))
AS calendar,If(IsNull(calstart),'',If(caldays=0,Date_Format(calstart,'%D %b.
%Y'),Concat(Date_Format(calstart,If(Year(calstart)!=Year(From_Days(To_Days(calstart)+caldays)),'%D
%b. %Y',If(Month(calstart)!=Month(From_Days(To_Days(calstart)+caldays)),'%D
%b.','%D'))),Date_Format(From_Days(To_Days(calstart)+caldays),'-%D %b. %Y'))))
AS acalendar,If(IsNull(calstart),'',If(caldays=0,Date_Format(calstart,'%D %M
%Y'),Concat(Date_Format(calstart,If(Year(calstart)!=Year(From_Days(To_Days(calstart)+caldays)),'%D
%M %Y',If(Month(calstart)!=Month(From_Days(To_Days(calstart)+caldays)),'%D
%M','%D'))),Date_Format(From_Days(To_Days(calstart)+caldays),'-%D %M %Y')))) AS
alcalendar,Unix_Timestamp(calstart) AS
startdate,Unix_Timestamp(Date_Add(calstart, INTERVAL caldays DAY)) AS
enddate,caldays,Date_Format(calstart,'%d.%m.%Y') AS
calstart,Date_Format(From_Days(To_Days(calstart)+caldays),'%d.%m.%Y') As calstop
FROM article,person WHERE (article.type=2 AND article.topic IN
(14,15,25,35,26,27,68,96,97,146,28,29,128,129,130,30,89,150,90,32,39,40,41,42,16,23,112,123,124,147,31,66,67,70,74,75,85,94,95,17,24,33,38,73,76,79,117,125,126,34,52,119,120,121,122,141,53,54,55,86,18,56,57,19,58,59,60,20,69,98,99,100,101,102,103,104,148,21,61,62,140,63,64,87,22,36,65,88,37,43)
AND author=person.id AND article.up=0 AND Unix_Timestamp(calstart)>=978307200
AND 24*60*60-1+Unix_timestamp( Date_Add(calstart, INTERVAL caldays
DAY))<=1009843200) AND (article.sitegroup in (0,1) AND person.sitegroup in (0,
1)) ORDER BY article.created DESC
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
