Am Montag, 10. September 2007 15:03 schrieb Piotr Pokora:
> Andreas Flack <[EMAIL PROTECTED]> wrote:
> > Hi!
>
> Hi!
>
> > I removed the comments on a 1.8.4 site running the registrations code,
> > and it worked like a charm. Is this maybe a leftover from 1.7 or was it
> > just luck that it worked on my site?
>
> SQL please :)
Referring to #67, this code
<?php
$qb = midcom_baseclasses_database_article::new_query_builder();
$qb->add_order('topic.owner.username');
mgd_debug_start();
$results = $qb->execute();
mgd_debug_stop();
var_dump($results);
?>
produces this query:
midgard-php (pid:4331):(info): execute(...)
midgard-core (pid:4331):(DEBUG): query=SELECT article.guid,
article.sitegroup, article.metadata_creator,
NULLIF(article.metadata_created,'0000-00-00 00:00:00') AS metadata_created,
article.metadata_revisor, NULLIF(article.metadata_revised,'0000-00-00
00:00:00') AS metadata_revised, article.metadata_revision,
article.metadata_locker, NULLIF(article.metadata_locked,'0000-00-00
00:00:00') AS metadata_locked, article.metadata_approver,
NULLIF(article.metadata_approved,'0000-00-00 00:00:00') AS metadata_approved,
article.metadata_authors, article.metadata_owner,
NULLIF(article.metadata_schedule_start,'0000-00-00 00:00:00') AS
metadata_schedule_start, NULLIF(article.metadata_schedule_end,'0000-00-00
00:00:00') AS metadata_schedule_end, article.metadata_hidden,
article.metadata_nav_noentry, article.metadata_size,
article.metadata_published, NULLIF(article.metadata_exported,'0000-00-00
00:00:00') AS metadata_exported, NULLIF(article.metadata_imported,'0000-00-00
00:00:00') AS metadata_imported,article.metadata_deleted,
article.metadata_score, article.up AS up,article.topic AS topic,article.id AS
id, NULLIF(article.created,'0000-00-00 00:00:00') AS created, article.revisor
AS revisor, article.score AS score, article.locker AS locker, article.caldays
AS caldays, NULLIF(article.approved,'0000-00-00 00:00:00') AS approved,
NULLIF(article.calstart,'0000-00-00 00:00:00') AS calstart, article.icon AS
icon, article.type AS type, article.creator AS creator,
NULLIF(article.revised,'0000-00-00 00:00:00') AS revised, article.approver AS
approver, article.extra1 AS extra1, article.name AS name, article.author AS
author, article.print AS print, article.extra2 AS extra2, article.view AS
view, article.extra3 AS extra3, article.revision AS revision,
NULLIF(article.locked,'0000-00-00 00:00:00') AS locked, article_i.title AS
title, article_i.abstract AS abstract, article_i.lang AS lang,
article_i.content AS content, article_i.url AS url, article_i.author AS
contentauthor, NULLIF(article_i.created,'0000-00-00 00:00:00') AS
contentcreated, article_i.sid AS sid FROM article_i,article,person WHERE 1 =
1 AND article.id=article_i.sid AND article_i.lang IN (0, 0) AND topic.owner
= person.id AND article.sitegroup IN (0, 1) AND article.metadata_deleted =
FALSE ORDER BY person.username ASC
and zero results.
When I slightly modify it like this:
<?php
$qb = midcom_baseclasses_database_article::new_query_builder();
$qb->add_order('topic.owner.username');
$qb->add_order('topic.owner');
mgd_debug_start();
$results = $qb->execute();
mgd_debug_stop();
var_dump($results);
?>
I get
midgard-php (pid:4070):(info): execute(...)
midgard-core (pid:4070):(DEBUG): query=SELECT article.guid,
article.sitegroup, article.metadata_creator,
NULLIF(article.metadata_created,'0000-00-00 00:00:00') AS metadata_created,
article.metadata_revisor, NULLIF(article.metadata_revised,'0000-00-00
00:00:00') AS metadata_revised, article.metadata_revision,
article.metadata_locker, NULLIF(article.metadata_locked,'0000-00-00
00:00:00') AS metadata_locked, article.metadata_approver,
NULLIF(article.metadata_approved,'0000-00-00 00:00:00') AS metadata_approved,
article.metadata_authors, article.metadata_owner,
NULLIF(article.metadata_schedule_start,'0000-00-00 00:00:00') AS
metadata_schedule_start, NULLIF(article.metadata_schedule_end,'0000-00-00
00:00:00') AS metadata_schedule_end, article.metadata_hidden,
article.metadata_nav_noentry, article.metadata_size,
article.metadata_published, NULLIF(article.metadata_exported,'0000-00-00
00:00:00') AS metadata_exported, NULLIF(article.metadata_imported,'0000-00-00
00:00:00') AS metadata_imported,article.metadata_deleted,
article.metadata_score, article.up AS up,article.topic AS topic,article.id AS
id, NULLIF(article.created,'0000-00-00 00:00:00') AS created, article.revisor
AS revisor, article.score AS score, article.locker AS locker, article.caldays
AS caldays, NULLIF(article.approved,'0000-00-00 00:00:00') AS approved,
NULLIF(article.calstart,'0000-00-00 00:00:00') AS calstart, article.icon AS
icon, article.type AS type, article.creator AS creator,
NULLIF(article.revised,'0000-00-00 00:00:00') AS revised, article.approver AS
approver, article.extra1 AS extra1, article.name AS name, article.author AS
author, article.print AS print, article.extra2 AS extra2, article.view AS
view, article.extra3 AS extra3, article.revision AS revision,
NULLIF(article.locked,'0000-00-00 00:00:00') AS locked, article_i.title AS
title, article_i.abstract AS abstract, article_i.lang AS lang,
article_i.content AS content, article_i.url AS url, article_i.author AS
contentauthor, NULLIF(article_i.created,'0000-00-00 00:00:00') AS
contentcreated, article_i.sid AS sid FROM article_i,article,person,topic
WHERE 1 = 1 AND article.id=article_i.sid AND article_i.lang IN (0, 0) AND
topic.owner = person.id AND article.topic = topic.id AND article.sitegroup IN
(0, 1) AND article.metadata_deleted = FALSE ORDER BY person.username ASC,
topic.owner ASC
midgard-php (pid:4070):(info): mgd_is_guid(...)
midgard-php (pid:4070):(info): midgard_article(...)
midgard-core (pid:4070):(DEBUG): query=SELECT article.guid,
article.sitegroup, article.metadata_creator,
NULLIF(article.metadata_created,'0000-00-00 00:00:00') AS metadata_created,
article.metadata_revisor, NULLIF(article.metadata_revised,'0000-00-00
00:00:00') AS metadata_revised, article.metadata_revision,
article.metadata_locker, NULLIF(article.metadata_locked,'0000-00-00
00:00:00') AS metadata_locked, article.metadata_approver,
NULLIF(article.metadata_approved,'0000-00-00 00:00:00') AS metadata_approved,
article.metadata_authors, article.metadata_owner,
NULLIF(article.metadata_schedule_start,'0000-00-00 00:00:00') AS
metadata_schedule_start, NULLIF(article.metadata_schedule_end,'0000-00-00
00:00:00') AS metadata_schedule_end, article.metadata_hidden,
article.metadata_nav_noentry, article.metadata_size,
article.metadata_published, NULLIF(article.metadata_exported,'0000-00-00
00:00:00') AS metadata_exported, NULLIF(article.metadata_imported,'0000-00-00
00:00:00') AS metadata_imported,article.metadata_deleted,
article.metadata_score, article.up AS up,article.topic AS topic,article.id AS
id, NULLIF(article.created,'0000-00-00 00:00:00') AS created, article.revisor
AS revisor, article.score AS score, article.locker AS locker, article.caldays
AS caldays, NULLIF(article.approved,'0000-00-00 00:00:00') AS approved,
NULLIF(article.calstart,'0000-00-00 00:00:00') AS calstart, article.icon AS
icon, article.type AS type, article.creator AS creator,
NULLIF(article.revised,'0000-00-00 00:00:00') AS revised, article.approver AS
approver, article.extra1 AS extra1, article.name AS name, article.author AS
author, article.print AS print, article.extra2 AS extra2, article.view AS
view, article.extra3 AS extra3, article.revision AS revision,
NULLIF(article.locked,'0000-00-00 00:00:00') AS locked, article_i.title AS
title, article_i.abstract AS abstract, article_i.lang AS lang,
article_i.content AS content, article_i.url AS url, article_i.author AS
contentauthor, NULLIF(article_i.created,'0000-00-00 00:00:00') AS
contentcreated, article_i.sid AS sid FROM article_i,article WHERE
article.guid = '1dc339efdc96d02339e11dc8e3c91d5dd45cafbcafb' AND
article.id=article_i.sid AND article_i.lang IN (0, 0) AND article.sitegroup
IN (0, 1) AND article.metadata_deleted = FALSE
midgard-php (pid:4070):(info): mgd_is_guid(...)
midgard-php (pid:4070):(info): mgd_is_guid(...)
midgard-php (pid:4070):(info): midgard_article(...)
midgard-core (pid:4070):(DEBUG): query=SELECT article.guid,
article.sitegroup, article.metadata_creator,
NULLIF(article.metadata_created,'0000-00-00 00:00:00') AS metadata_created,
article.metadata_revisor, NULLIF(article.metadata_revised,'0000-00-00
00:00:00') AS metadata_revised, article.metadata_revision,
article.metadata_locker, NULLIF(article.metadata_locked,'0000-00-00
00:00:00') AS metadata_locked, article.metadata_approver,
NULLIF(article.metadata_approved,'0000-00-00 00:00:00') AS metadata_approved,
article.metadata_authors, article.metadata_owner,
NULLIF(article.metadata_schedule_start,'0000-00-00 00:00:00') AS
metadata_schedule_start, NULLIF(article.metadata_schedule_end,'0000-00-00
00:00:00') AS metadata_schedule_end, article.metadata_hidden,
article.metadata_nav_noentry, article.metadata_size,
article.metadata_published, NULLIF(article.metadata_exported,'0000-00-00
00:00:00') AS metadata_exported, NULLIF(article.metadata_imported,'0000-00-00
00:00:00') AS metadata_imported,article.metadata_deleted,
article.metadata_score, article.up AS up,article.topic AS topic,article.id AS
id, NULLIF(article.created,'0000-00-00 00:00:00') AS created, article.revisor
AS revisor, article.score AS score, article.locker AS locker, article.caldays
AS caldays, NULLIF(article.approved,'0000-00-00 00:00:00') AS approved,
NULLIF(article.calstart,'0000-00-00 00:00:00') AS calstart, article.icon AS
icon, article.type AS type, article.creator AS creator,
NULLIF(article.revised,'0000-00-00 00:00:00') AS revised, article.approver AS
approver, article.extra1 AS extra1, article.name AS name, article.author AS
author, article.print AS print, article.extra2 AS extra2, article.view AS
view, article.extra3 AS extra3, article.revision AS revision,
NULLIF(article.locked,'0000-00-00 00:00:00') AS locked, article_i.title AS
title, article_i.abstract AS abstract, article_i.lang AS lang,
article_i.content AS content, article_i.url AS url, article_i.author AS
contentauthor, NULLIF(article_i.created,'0000-00-00 00:00:00') AS
contentcreated, article_i.sid AS sid FROM article_i,article WHERE
article.guid = '1dc339efdca763e339e11dc8e3c91d5dd45cafbcafb' AND
article.id=article_i.sid AND article_i.lang IN (0, 0) AND article.sitegroup
IN (0, 1) AND article.metadata_deleted = FALSE
midgard-php (pid:4070):(info): mgd_is_guid(...)
midgard-php (pid:4070):(info): mgd_is_guid(...)
midgard-php (pid:4070):(info): midgard_article(...)
midgard-core (pid:4070):(DEBUG): query=SELECT article.guid,
article.sitegroup, article.metadata_creator,
NULLIF(article.metadata_created,'0000-00-00 00:00:00') AS metadata_created,
article.metadata_revisor, NULLIF(article.metadata_revised,'0000-00-00
00:00:00') AS metadata_revised, article.metadata_revision,
article.metadata_locker, NULLIF(article.metadata_locked,'0000-00-00
00:00:00') AS metadata_locked, article.metadata_approver,
NULLIF(article.metadata_approved,'0000-00-00 00:00:00') AS metadata_approved,
article.metadata_authors, article.metadata_owner,
NULLIF(article.metadata_schedule_start,'0000-00-00 00:00:00') AS
metadata_schedule_start, NULLIF(article.metadata_schedule_end,'0000-00-00
00:00:00') AS metadata_schedule_end, article.metadata_hidden,
article.metadata_nav_noentry, article.metadata_size,
article.metadata_published, NULLIF(article.metadata_exported,'0000-00-00
00:00:00') AS metadata_exported, NULLIF(article.metadata_imported,'0000-00-00
00:00:00') AS metadata_imported,article.metadata_deleted,
article.metadata_score, article.up AS up,article.topic AS topic,article.id AS
id, NULLIF(article.created,'0000-00-00 00:00:00') AS created, article.revisor
AS revisor, article.score AS score, article.locker AS locker, article.caldays
AS caldays, NULLIF(article.approved,'0000-00-00 00:00:00') AS approved,
NULLIF(article.calstart,'0000-00-00 00:00:00') AS calstart, article.icon AS
icon, article.type AS type, article.creator AS creator,
NULLIF(article.revised,'0000-00-00 00:00:00') AS revised, article.approver AS
approver, article.extra1 AS extra1, article.name AS name, article.author AS
author, article.print AS print, article.extra2 AS extra2, article.view AS
view, article.extra3 AS extra3, article.revision AS revision,
NULLIF(article.locked,'0000-00-00 00:00:00') AS locked, article_i.title AS
title, article_i.abstract AS abstract, article_i.lang AS lang,
article_i.content AS content, article_i.url AS url, article_i.author AS
contentauthor, NULLIF(article_i.created,'0000-00-00 00:00:00') AS
contentcreated, article_i.sid AS sid FROM article_i,article WHERE
article.guid = '1dc339efdcba6da339e11dc8e3c91d5dd45cafbcafb' AND
article.id=article_i.sid AND article_i.lang IN (0, 0) AND article.sitegroup
IN (0, 1) AND article.metadata_deleted = FALSE
midgard-php (pid:4070):(info): mgd_is_guid(...)
midgard-php (pid:4070):(info): mgd_is_guid(...)
midgard-php (pid:4070):(info): midgard_article(...)
midgard-core (pid:4070):(DEBUG): query=SELECT article.guid,
article.sitegroup, article.metadata_creator,
NULLIF(article.metadata_created,'0000-00-00 00:00:00') AS metadata_created,
article.metadata_revisor, NULLIF(article.metadata_revised,'0000-00-00
00:00:00') AS metadata_revised, article.metadata_revision,
article.metadata_locker, NULLIF(article.metadata_locked,'0000-00-00
00:00:00') AS metadata_locked, article.metadata_approver,
NULLIF(article.metadata_approved,'0000-00-00 00:00:00') AS metadata_approved,
article.metadata_authors, article.metadata_owner,
NULLIF(article.metadata_schedule_start,'0000-00-00 00:00:00') AS
metadata_schedule_start, NULLIF(article.metadata_schedule_end,'0000-00-00
00:00:00') AS metadata_schedule_end, article.metadata_hidden,
article.metadata_nav_noentry, article.metadata_size,
article.metadata_published, NULLIF(article.metadata_exported,'0000-00-00
00:00:00') AS metadata_exported, NULLIF(article.metadata_imported,'0000-00-00
00:00:00') AS metadata_imported,article.metadata_deleted,
article.metadata_score, article.up AS up,article.topic AS topic,article.id AS
id, NULLIF(article.created,'0000-00-00 00:00:00') AS created, article.revisor
AS revisor, article.score AS score, article.locker AS locker, article.caldays
AS caldays, NULLIF(article.approved,'0000-00-00 00:00:00') AS approved,
NULLIF(article.calstart,'0000-00-00 00:00:00') AS calstart, article.icon AS
icon, article.type AS type, article.creator AS creator,
NULLIF(article.revised,'0000-00-00 00:00:00') AS revised, article.approver AS
approver, article.extra1 AS extra1, article.name AS name, article.author AS
author, article.print AS print, article.extra2 AS extra2, article.view AS
view, article.extra3 AS extra3, article.revision AS revision,
NULLIF(article.locked,'0000-00-00 00:00:00') AS locked, article_i.title AS
title, article_i.abstract AS abstract, article_i.lang AS lang,
article_i.content AS content, article_i.url AS url, article_i.author AS
contentauthor, NULLIF(article_i.created,'0000-00-00 00:00:00') AS
contentcreated, article_i.sid AS sid FROM article_i,article WHERE
article.guid = '1dc339efdcc274a339e11dc8e3c91d5dd45cafbcafb' AND
article.id=article_i.sid AND article_i.lang IN (0, 0) AND article.sitegroup
IN (0, 1) AND article.metadata_deleted = FALSE
midgard-php (pid:4070):(info): mgd_is_guid(...)
midgard-php (pid:4070):(info): mgd_is_guid(...)
midgard-php (pid:4070):(info): midgard_article(...)
midgard-core (pid:4070):(DEBUG): query=SELECT article.guid,
article.sitegroup, article.metadata_creator,
NULLIF(article.metadata_created,'0000-00-00 00:00:00') AS metadata_created,
article.metadata_revisor, NULLIF(article.metadata_revised,'0000-00-00
00:00:00') AS metadata_revised, article.metadata_revision,
article.metadata_locker, NULLIF(article.metadata_locked,'0000-00-00
00:00:00') AS metadata_locked, article.metadata_approver,
NULLIF(article.metadata_approved,'0000-00-00 00:00:00') AS metadata_approved,
article.metadata_authors, article.metadata_owner,
NULLIF(article.metadata_schedule_start,'0000-00-00 00:00:00') AS
metadata_schedule_start, NULLIF(article.metadata_schedule_end,'0000-00-00
00:00:00') AS metadata_schedule_end, article.metadata_hidden,
article.metadata_nav_noentry, article.metadata_size,
article.metadata_published, NULLIF(article.metadata_exported,'0000-00-00
00:00:00') AS metadata_exported, NULLIF(article.metadata_imported,'0000-00-00
00:00:00') AS metadata_imported,article.metadata_deleted,
article.metadata_score, article.up AS up,article.topic AS topic,article.id AS
id, NULLIF(article.created,'0000-00-00 00:00:00') AS created, article.revisor
AS revisor, article.score AS score, article.locker AS locker, article.caldays
AS caldays, NULLIF(article.approved,'0000-00-00 00:00:00') AS approved,
NULLIF(article.calstart,'0000-00-00 00:00:00') AS calstart, article.icon AS
icon, article.type AS type, article.creator AS creator,
NULLIF(article.revised,'0000-00-00 00:00:00') AS revised, article.approver AS
approver, article.extra1 AS extra1, article.name AS name, article.author AS
author, article.print AS print, article.extra2 AS extra2, article.view AS
view, article.extra3 AS extra3, article.revision AS revision,
NULLIF(article.locked,'0000-00-00 00:00:00') AS locked, article_i.title AS
title, article_i.abstract AS abstract, article_i.lang AS lang,
article_i.content AS content, article_i.url AS url, article_i.author AS
contentauthor, NULLIF(article_i.created,'0000-00-00 00:00:00') AS
contentcreated, article_i.sid AS sid FROM article_i,article WHERE
article.guid = '1dc339efdcebe06339e11dc8e3c91d5dd45cafbcafb' AND
article.id=article_i.sid AND article_i.lang IN (0, 0) AND article.sitegroup
IN (0, 1) AND article.metadata_deleted = FALSE
midgard-php (pid:4070):(info): mgd_is_guid(...)
and a correct list of results
Regarding n.n.registrations, I get
midgard-php (pid:15201):(info): execute(...)
midgard-core (pid:15201):(DEBUG): query=SELECT eventmember.guid,
eventmember.sitegroup, eventmember.metadata_creator,
NULLIF(eventmember.metadata_created,'0000-00-00 00:00:00') AS
metadata_created, eventmember.metadata_revisor,
NULLIF(eventmember.metadata_revised,'0000-00-00 00:00:00') AS
metadata_revised, eventmember.metadata_revision, eventmember.metadata_locker,
NULLIF(eventmember.metadata_locked,'0000-00-00 00:00:00') AS metadata_locked,
eventmember.metadata_approver,
NULLIF(eventmember.metadata_approved,'0000-00-00 00:00:00') AS
metadata_approved, eventmember.metadata_authors, eventmember.metadata_owner,
NULLIF(eventmember.metadata_schedule_start,'0000-00-00 00:00:00') AS
metadata_schedule_start, NULLIF(eventmember.metadata_schedule_end,'0000-00-00
00:00:00') AS metadata_schedule_end, eventmember.metadata_hidden,
eventmember.metadata_nav_noentry, eventmember.metadata_size,
eventmember.metadata_published,
NULLIF(eventmember.metadata_exported,'0000-00-00 00:00:00') AS
metadata_exported, NULLIF(eventmember.metadata_imported,'0000-00-00
00:00:00') AS metadata_imported,eventmember.metadata_deleted,
eventmember.metadata_score, eventmember.eid AS eid,eventmember.id AS id,
eventmember.period AS period, eventmember.count AS count, eventmember.uid AS
uid, eventmember.extra AS extra FROM eventmember,person WHERE eventmember.eid
= 3 AND eventmember.uid = person.id AND eventmember.uid = person.id AND
eventmember.sitegroup IN (0, 1) AND eventmember.metadata_deleted = FALSE
ORDER BY person.lastname ASC, person.firstname ASC
after commenting out the two add_order commands and also a correct list of
registrations.
Bye,
Andreas
>
> Piotras
> _______________________________________________
> user mailing list
> [email protected]
> http://lists.midgard-project.org/mailman/listinfo/user
_______________________________________________
user mailing list
[email protected]
http://lists.midgard-project.org/mailman/listinfo/user
