<br />
<b>Notice</b>:  Undefined index: HTTP_ACCEPT_LANGUAGE in <b>/opt/dn2.dev/includes/cms/dn_content.inc.php</b> on line <b>59</b><br />
<br />
<b>Fatal error</b>:  Sql-error-satus: PGSQL_EMPTY_QUERY
SQL: SELECT hdsacms.getWebPagePrepared($dn3082$/page/home$dn3082$) 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 <b>/opt/dn2.dev/includes/gdbi/Postgres.inc.php</b> on line <b>387</b><br />