Soldatini on Line

MB DB function failed with error number 1525
Incorrect DATE value: '0000-00-00' SQL=SELECT p.* FROM jos_pollxt_menu AS pm, jos_pollsxt AS p WHERE (pm.menuid='61' OR pm.menuid='0') AND p.id=pm.pollid 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:38:05') ) AND (p.dateto > '2024-07-27' OR p.dateto='0000-00-00' OR (p.dateto = '2024-07-27' AND p.timeto >= '01:38:05') ) AND p.logon=0 AND (p.type = '2' OR p.type = '0') ORDER BY p.ordering
SQL =

SELECT p.*
FROM jos_pollxt_menu AS pm, jos_pollsxt AS p
WHERE (pm.menuid='61' OR pm.menuid='0') AND p.id=pm.pollid 
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:38:05') )
AND (p.dateto > '2024-07-27' OR p.dateto='0000-00-00' OR (p.dateto = '2024-07-27' AND p.timeto >= '01:38:05') ) 
AND p.logon=0
AND (p.type = '2'
OR p.type = '0')
ORDER BY p.ordering

I sondaggi di SoL