MB DB function failed with error number 1525 Incorrect DATE value: '0000-00-00' SQL=SELECT p.*
FROM jos_pollsxt AS p WHERE p.id='3'AND p.published=1
AND (p.datefrom < '2024-07-27' OR p.datefrom='0000-00-00' OR (p.datefrom = '2024-07-27' AND p.timefrom <= '01:26:42') )
AND (p.dateto > '2024-07-27' OR p.dateto='0000-00-00' OR (p.dateto = '2024-07-27' AND p.timeto >= '01:26:42') )
AND p.logon=0
AND (p.type = '2'
OR p.type = '0')
ORDER BY p.ordering SQL =
SELECT p.*
FROM jos_pollsxt AS p WHERE p.id='3'AND p.published=1
AND (p.datefrom < '2024-07-27' OR p.datefrom='0000-00-00' OR (p.datefrom = '2024-07-27' AND p.timefrom <= '01:26:42') )
AND (p.dateto > '2024-07-27' OR p.dateto='0000-00-00' OR (p.dateto = '2024-07-27' AND p.timeto >= '01:26:42') )
AND p.logon=0
AND (p.type = '2'
OR p.type = '0')
ORDER BY p.ordering