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)