SQL-Fejl: Incorrect DATETIME value: '0000-00-00 00:00:00'
SQL:
SELECT
page.id,
page.title,
page.template,
page.parentpage AS parent,
page.haschilds,
page.active,
page.breadcrumb_active,
page.pubdate,
page.removedate,
cms_page_langinfo.htmltitle AS htmltitle,
cms_page_langinfo.menutitle AS menutitle,
cms_page_langinfo.graphictitle AS graphictitle,
cms_page_langinfo.path AS path,
page.lastedited,
page.editedby,
page.created,
page.createdby,
page.protected,
page.pageimage AS pageimage,
page.precedence,
page.searchable,
page.pubdate,
page.removedate,
page.languageid,
page.type,
page.config
FROM
page
LEFT JOIN
cms_page_langinfo
ON
cms_page_langinfo.pageid = page.id
AND
cms_page_langinfo.languageid = '2'
WHERE
(
type = 'page'
OR
type = 'url'
OR
type = 'url_blank'
OR
type = 'website'
OR
type = 'facebook'
OR
type = 'mobile'
)
AND
(
(
now() >= pubdate
AND
now() <= removedate
)
OR
(
now() >= pubdate
AND
removedate = '0000-00-00 00:00:00'
)
OR
(
pubdate = '0000-00-00 00:00:00'
AND
now() <= removedate
)
OR
(
pubdate = '0000-00-00 00:00:00'
AND
removedate = '0000-00-00 00:00:00'
)
)
AND
versionactive = 'true'
AND parentpage = '33' AND active = 'true'
ORDER BY
precedence