Actions

Modèle

NewsActivity : Différence entre versions

De erg

Ligne 2 : Ligne 2 :
 
tables=News,_pageData
 
tables=News,_pageData
 
|join on=News._pageName=_pageData._pageName
 
|join on=News._pageName=_pageData._pageName
|fields=DATE_FORMAT(_pageData._creationDate, '%d %M %y')=publiée,_pageData._pageName=Page, DATE_FORMAT(News.Start, '%W %d %M %Y')=Start, DATE_FORMAT(News.End, '%W %d %M %Y')=End,DATEDIFF(NOW(),News.Start)=Ago,Image
+
|fields=DATE_FORMAT(_pageData._creationDate, '%d %M %y')=publiée,DATEDIFF(NOW(),_pageData._createDate)=Age,_pageData._pageName=Page, DATE_FORMAT(News.Start, '%W %d %M %Y')=Start, DATE_FORMAT(News.End, '%W %d %M %Y')=End,Image
 
|order by=_pageData._creationDate DESC
 
|order by=_pageData._creationDate DESC
 
|format=table
 
|format=table

Version du 10 avril 2018 à 10:13

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT DATE_FORMAT(`mw_cargo___pageData`.`_creationDate`, '%d %M %y') AS `publiée`,DATEDIFF(NOW(),`mw_cargo___pageData`.`_createDate`) AS `Age`,`mw_cargo___pageData`.`_pageName` AS `Page`,DATE_FORMAT(`mw_cargo__News`.`Start`, '%W %d %M %Y') AS `Start`,DATE_FORMAT(`mw_cargo__News`.`End`, '%W %d %M %Y') AS `End`,`Image` AS `Image` FROM `mw_cargo__News` LEFT OUTER JOIN `mw_cargo___pageData` ON ((`mw_cargo__News`.`_pageName`=`mw_cargo___pageData`.`_pageName`)) ORDER BY `mw_cargo___pageData`.`_creationDate` DESC LIMIT 100 Function: CargoSQLQuery::run Error: 1054 Unknown column 'mw_cargo___pageData._createDate' in 'field list' (localhost)