Difference between revisions of "Calc/To-Dos/Performance"
(nottitlematch=Calc/To-Dos/Performance => not *this* page if included) |
(IssueTracker query for open spreadsheet performance issues) |
||
| Line 10: | Line 10: | ||
order = descending | order = descending | ||
</DPL> | </DPL> | ||
| + | |||
| + | * IssueTracker [http://qa.openoffice.org/issues/buglist.cgi?component=Spreadsheet&issue_status=UNCONFIRMED&issue_status=NEW&issue_status=STARTED&issue_status=REOPENED&keywords=performance query for open spreadsheet performance issues]. | ||
<noinclude> | <noinclude> | ||
Latest revision as of 15:00, 29 April 2009
The DPL extension (version 2.3.0) produced a SQL statement which lead to a Database error.
The reason may be an internal error of DPL or an error which you made,
especially when using DPL options like titleregexp.
Query text is:
SELECT DISTINCT `page`.page_namespace AS page_namespace,`page`.page_title AS page_title,`page`.page_id AS page_id, rev_user, rev_user_text, rev_comment, rev_timestamp FROM `revision` AS rev, `page` INNER JOIN `categorylinks` AS cl0 ON `page`.page_id=cl0.cl_from AND (cl0.cl_to='Calc') INNER JOIN `categorylinks` AS cl1 ON `page`.page_id=cl1.cl_from AND (cl1.cl_to='To-Do') INNER JOIN `categorylinks` AS cl2 ON `page`.page_id=cl2.cl_from AND (cl2.cl_to='Performance') WHERE 1=1 AND NOT (`page`.page_title LIKE 'Calc/To-Dos/Performance') AND `page`.page_is_redirect=0 AND `page`.page_id=rev.rev_page AND rev.rev_timestamp=( SELECT MAX(rev_aux.rev_timestamp) FROM `revision` AS rev_aux WHERE rev_aux.rev_page=rev.rev_page ) ORDER BY rev_timestamp DESC LIMIT 500 OFFSET 0
Error message is:
Unknown column 'rev_user' in 'field list' (127.0.0.1)
- IssueTracker query for open spreadsheet performance issues.
