Fatal error: Sql-error-satus: PGSQL_EMPTY_QUERY SQL: SELECT hdsacms.getWebPagePrepared($dn19873$/page/home$dn19873$) AS functionname LIMIT 1;; ERROR: syntax error at or near "COALESCE" LINE 3: COALESCE(NULLIF(regexp_replace($2, '^\/?pag... ^ QUERY: PREPARE getPage2(text,text, text, text, text, text) AS WITH match(sfilename, sfull) AS ( SELECT '%'||regexp_replace($2, '^\/?page(:?\/.*)?\/', '') COALESCE(NULLIF(regexp_replace($2, '^\/?page\/', ''), ''), '/') ) SELECT 'page/'||pathname AS pathname, url AS filename, title, description, keywords, contenthtml, changedate, EXTRACT(EPOCH FROM changedate) AS epochchangedate FROM web.vPublished AS c, match as m WHERE NULLIF(c.publish, 0) IS NOT NULL AND (URL LIKE sfull OR (URL LIKE sfilename AND URL NOT IN (SELECT URL FROM web.vPublished))) ORDER BY contentid LIMIT 1 CONTEXT: PL/pgSQL function hdsacms.getwebpageprepared(text) line 19 at EXECUTE in /opt/dn2.dev/includes/gdbi/Postgres.inc.php on line 387