Actions

Modèle

« NewsActivity » : différence entre les versions

De erg

← Modification précédenteModification suivante →
Aucun résumé des modifications
Aucun résumé des modifications
Ligne 6 : Ligne 6 :
|format=table
|format=table
|limit=5
|limit=5
|where=DATEDIFF(Date,NOW()) <= -14
|where=DATEDIFF(_pageData._createDate,NOW()) <= -14
|more results text=
|more results text=
}}
}}

Version du 20 mars 2018 à 13:13

Error 1054: Unknown column '_pageData._createDate' in 'WHERE'

Function: CargoSQLQuery::run Query: SELECT `_pageData`.`_pageID` AS `cargo_backlink_page_id__pageData`,`News`.`_pageID` AS `cargo_backlink_page_id_News`,`_pageData`.`_pageName` AS `Page`,`News`.`Image` AS `Image`,`News`.`Start` AS `Start`,`News`.`End` AS `End`,`News`.`Start__precision` AS `Start__precision`,`News`.`End__precision` AS `End__precision` FROM `mw_cargo__News` `News` LEFT OUTER JOIN `mw_cargo___pageData` `_pageData` ON ((`News`.`_pageName`=`_pageData`.`_pageName`)) WHERE DATEDIFF(`_pageData`.`_createDate`,NOW()) <= -14 ORDER BY `_pageData`.`_creationDate` DESC LIMIT 100