I get this server error:
...-conn8674-] Error: Ns_PgExec: result status: 7 message:
ERROR: Function 'nvl(varchar, varchar)' does not exist
Unable to identify a function that satisfies the given
argument types You may need to add explicit typecasts
...-conn8674-] Error: nsd.tcl: Database operation "1row" failed...
So I search thru www (openacs 3.2.2) and find all these
files that use the nvl function which it appears that
postgress doesn't support.
* Is there a workaround?
* How do I report this to the SDM? It appears
to me to be ONE "bug" in many files....
Here's the list:
grep -r nvl *
admin/bookmarks/edit-bookmark.tcl: "select nvl(local_title,
admin/bookmarks/one-user.tcl: nvl(local_title,
admin/comments/persistent-edit-2.tcl: "select ... nvl(page_title,
url_stub)
admin/conversion/sequence-update.tcl: "select nvl(max($column_name)
And more without detail shown:
admin/ecommerce/orders/
admin/links/delete-2.tcl
admin/links/delete.tcl
admin/links/edit.tcl
education/class/one.tcl
events/admin/spam/spam.tcl
homepage/index.tcl
homepage/mkdir-2.tcl
homepage/publish-2.tcl
homepage/publish-2.tcl
intranet/customers/view.tcl
survsimp/admin/one.tcl
wp/bulk-image-upload-2.tcl
I found this while in the admin pages trying to delete
a "bad" link that someone posted.
/admin/links/one-page.tcl?page_id=16
Thank you.
-Bob