Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#109 2016-11-16 09:59:28
Re: mdn_count
Merci Nicolas
To make mdn_count work i had to change line 46 like this:
$q[] = $andor.' (Posted <= now() and (now() <= Expires or Expires is null))';Offline
#110 2016-11-16 11:02:45
Re: mdn_count
Dragondz wrote #302935:
Unknown column ‘NULLDATETIME’
Here’s the plugin fix from a post the other day.
I added
define('NULLDATETIME', '\'0000-00-00 00:00:00\'');...to the plugin and the error vanished.
Not advisable. The reason it was removed is because MySQL and its various forks are starting to remove support for zero dates. Results are undefined if you use them and vary from version to version. If you feel you must use it, this is better:
define('NULLDATETIME', '\'1970-01-01 12:00:00\'');But changing the code as you’ve done to use IS NULL is far better.
The smd plugin menagerie — for when you need one more gribble of power from Textpattern. Bleeding-edge code available on GitHub.
Txp Builders – finely-crafted code, design and Txp
Offline
#111 2016-11-16 12:02:20
Re: mdn_count
Thanks Stef.
Offline