Use of "addfirstcategorydate" triggers SQL error
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	• bzimport
	Nov 8 2006, 10:06 PM

Description

Author: michael.axelrod

Description:
Mediawiki 1.8.2 wirth DPL2 version 0.7.7 - recreated on a windows system and a
Unix system.

The following code generates a MySQL error.

<DPL>
category=news
addfirstcategorydate=true
</DPL>

The error generated is:

Database error
A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was:

(SQL query hidden)

from within function "". MySQL returned error "1109: Unknown table 'c1' in field
list (localhost)".

This have to have something to do with the code around line 708 in
DynamicPageList2.php

$sSqlCl_timestamp = ", DATE_FORMAT(c1.cl_timestamp, '%Y%m%d%H%i%s') AS

cl_timestamp";

Version: unspecified
Severity: normal

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:24 PM

• bzimport set Reference to bz7847.

• bzimport added a subscriber: Unknown Object (MLST).

cyril.dangerville wrote:

Indeed, 'c1' should have been replaced by 'cl0'. Mea culpa.
This is now fixed on subversion.

robchur wrote:

That's r17510.