pathCast
Log in

Difference between revisions of "testpage"

From pathCast
Line 6: Line 6:
 
,pathCast.title
 
,pathCast.title
 
,pathCastFiles._pageTitle
 
,pathCastFiles._pageTitle
|where=hide=0 AND pathCastFiles.filetype='banner'  
+
|where=where=DATEDIFF(pathCast.date,NOW()) >= +1 AND hide=0 AND pathCastFiles.filetype='banner'  
 
|order by=pathCast.date ASC
 
|order by=pathCast.date ASC
 
|limit=1
 
|limit=1
 
|more results text=
 
|more results text=
 
|}}
 
|}}

Revision as of 11:36, 31 December 2020

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

Query: SELECT `cargo__pathCast`.`_pageName` AS `_pageName`,`cargo__pathCast`.`title` AS `title`,`cargo__pathCastFiles`.`_pageTitle` AS `_pageTitle` FROM `cargo__pathCast` LEFT OUTER JOIN `cargo__pathCastFiles` ON ((`cargo__pathCast`.`_pageName`=`cargo__pathCastFiles`.`pathCast`)) WHERE where=DATEDIFF(`cargo__pathCast`.`date`,NOW()) >= +1 AND hide=0 AND `cargo__pathCastFiles`.`filetype`='banner' ORDER BY `cargo__pathCast`.`date` LIMIT 1 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where=DATEDIFF(`cargo__pathCast`.`date`,NOW()) >= +1 AND hide=0 AND `cargo__path' at line 1 (localhost)