PEAR: Query failed
Error message: DB Error: unknown error
SELECT p.*, v.*, v.id AS vid, p.id AS pid, v.name AS vname, f.name AS name, f.value FROM sntweb_pages p INNER JOIN sntweb_versions v ON p.id=v.page_id INNER JOIN sntweb_fields f ON v.id=f.version_id WHERE p.id='2147' AND v.flowstatus=10 AND '2010-07-30' >= v.publish_at AND ('2010-07-30' <= v.unpublish_at OR v.unpublish_at='0000-01-01') [nativecode=ORA-01840: input value not long enough for date format]