Error
struct
DeMoronize
function DeMoronize
Arguments:
NameRequiredTypeDefault
textOptionalany
Return Type:
Roles:
cfcatch
struct
column1
datasourceCNVCLIVEPG
detailDatabase reported: ERROR: function instr(character varying, unknown) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 34
errorcodeerrorCode.sqlError
errorlogfile/opt/openbd/bluedragon/work/temp/rtelogs/bderror-2023-02-08-182036_6156873695891196568.html
extendedinfo[empty string]
line6
messageGeneral SQL Error
nativeerrorcode0
queryErrorERROR: function instr(character varying, unknown) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 34
sqlselect distinct(substr( name, 0, instr(name, ' '))) as genus from taxon where syn is null order by genus asc
sqlstate42883
tagcontext
array
1
struct
column1
idCFQUERY
line6
template/web/apps/cnvc/public_html/nomenclature.cfm
tagnameCFQUERY
template/web/apps/cnvc/public_html/nomenclature.cfm
typeDatabase
cferror
struct
browserCCBot/2.0 (https://commoncrawl.org/faq/)
datetime{ts '2023-02-08 18:20:36'}
diagnosticsQuery Error: ERROR: function instr(character varying, unknown) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 34 Datasource: CNVCLIVEPG Native Error Code: 0 SQL State: 42883 Executing SQL: select distinct(substr( name, 0, instr(name, ' '))) as genus from taxon where syn is null order by genus asc Error occurred while processing element (CFQUERY) on line 6 column 1 in template file "/web/apps/cnvc/public_html/nomenclature.cfm"
errorlogfile/opt/openbd/bluedragon/work/temp/rtelogs/bderror-2023-02-08-182036_6156873695891196568.html
generatedcontent <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="SHORTCUT ICON" href="favicon.ico" /> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta content="Boks - 0.2.3" name="generator" /> <meta name="msapplication-navbutton-color" content="#859199" /> <!-- Framework CSS --> <link rel="stylesheet" href="css/screen.css" type="text/css" media="screen, projection" /> <link rel="stylesheet" href="css/print.css" type="text/css" media="print" /> <!--[if IE]><link rel="stylesheet" href="css/ie.css" type="text/css" media="screen, projection"><![endif]--> <!--[if lt IE 8]> <style type="text/css"> img, div, a { behavior: url(./css/iepngfix.htc) } </style> <![endif]--> <link rel="stylesheet" href="css/cnvc.css" type="text/css" media="screen, projection" /> <!-- apple touch icons --> <!-- For non-Retina iPhone, iPod Touch, and Android 2.1+ devices: --> <link rel="apple-touch-icon-precomposed" href="apple-touch-icon-precomposed.png"> <!-- For first- and second-generation iPad: --> <link rel="apple-touch-icon-precomposed" sizes="72x72" href="apple-touch-icon-72x72-precomposed.png"> <!-- For iPhone with high-resolution Retina display: --> <link rel="apple-touch-icon-precomposed" sizes="114x114" href="apple-touch-icon-114x114-precomposed.png"> <!-- For third-generation iPad with high-resolution Retina display: --> <link rel="apple-touch-icon-precomposed" sizes="144x144" href="apple-touch-icon-144x144-precomposed.png"> <title>Nomenclature Search</title></head> <body > <a name="top"></a> <div class="container"> <div class="span-21 top-border left-border right-border last" id="banner"> <div class="span-5" id="logo"> <a href="index.cfm" style="display: block; width: 100%; height: 100%"> <img src="images/pic.png" alt="CNVC Logo" /> </a> </div> <div class="span-16 last" id="title"> <a href="index.cfm" style="display: block; width: 100%; height: 100%"> </a> </div> </div> <div class="span-21 left-border right-border last" id="body"> <div class="clear span-5" id="leftNav"> <ul class="navParent"> <li> <ul class="navChild"> <li class="last"><a href="language.cfm">Français</a></li> <li class="last"><a href="index.cfm">Home</a></li> <li class="last"><a href="search.cfm">Explore the Classification</a></li> <li class="last"><a href="page.cfm?page=2228">CNVC Overview</a></li> <li class="last"><a href="nomenclature.cfm">Botanical Nomenclature</a></li> <li class="last"><a href="page.cfm?page=2274">About</a></li> <li class="last"><a href="page.cfm?page=3">Glossary</a></li> <li class="last"><a href="page.cfm?page=6">Links</a></li> <li class="last"><a href="page.cfm?page=2306">Vegetation Zones of Canada</a></li> <li class="last"><a href="page.cfm?page=212">Updates</a></li> </ul> </li> </ul> </div> <div class="span-16 last" id="main"> <div class="clear span-16 last" id="content">
httpreferer[empty string]
mailto[empty string]
messageGeneral SQL Error
querystring[empty string]
remoteAddress35.175.119.198
tagcontext
array
1
struct
column1
idCFQUERY
line6
template/web/apps/cnvc/public_html/nomenclature.cfm
template/nomenclature.cfm
typeDatabase
cleanhtml
function cleanhtml
Arguments:
NameRequiredTypeDefault
htmlOptionalany
Return Type:
Roles:
error
struct
browserCCBot/2.0 (https://commoncrawl.org/faq/)
datetime{ts '2023-02-08 18:20:36'}
diagnosticsQuery Error: ERROR: function instr(character varying, unknown) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 34 Datasource: CNVCLIVEPG Native Error Code: 0 SQL State: 42883 Executing SQL: select distinct(substr( name, 0, instr(name, ' '))) as genus from taxon where syn is null order by genus asc Error occurred while processing element (CFQUERY) on line 6 column 1 in template file "/web/apps/cnvc/public_html/nomenclature.cfm"
errorlogfile/opt/openbd/bluedragon/work/temp/rtelogs/bderror-2023-02-08-182036_6156873695891196568.html
generatedcontent <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xml:lang="en" lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <link rel="SHORTCUT ICON" href="favicon.ico" /> <meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta content="Boks - 0.2.3" name="generator" /> <meta name="msapplication-navbutton-color" content="#859199" /> <!-- Framework CSS --> <link rel="stylesheet" href="css/screen.css" type="text/css" media="screen, projection" /> <link rel="stylesheet" href="css/print.css" type="text/css" media="print" /> <!--[if IE]><link rel="stylesheet" href="css/ie.css" type="text/css" media="screen, projection"><![endif]--> <!--[if lt IE 8]> <style type="text/css"> img, div, a { behavior: url(./css/iepngfix.htc) } </style> <![endif]--> <link rel="stylesheet" href="css/cnvc.css" type="text/css" media="screen, projection" /> <!-- apple touch icons --> <!-- For non-Retina iPhone, iPod Touch, and Android 2.1+ devices: --> <link rel="apple-touch-icon-precomposed" href="apple-touch-icon-precomposed.png"> <!-- For first- and second-generation iPad: --> <link rel="apple-touch-icon-precomposed" sizes="72x72" href="apple-touch-icon-72x72-precomposed.png"> <!-- For iPhone with high-resolution Retina display: --> <link rel="apple-touch-icon-precomposed" sizes="114x114" href="apple-touch-icon-114x114-precomposed.png"> <!-- For third-generation iPad with high-resolution Retina display: --> <link rel="apple-touch-icon-precomposed" sizes="144x144" href="apple-touch-icon-144x144-precomposed.png"> <title>Nomenclature Search</title></head> <body > <a name="top"></a> <div class="container"> <div class="span-21 top-border left-border right-border last" id="banner"> <div class="span-5" id="logo"> <a href="index.cfm" style="display: block; width: 100%; height: 100%"> <img src="images/pic.png" alt="CNVC Logo" /> </a> </div> <div class="span-16 last" id="title"> <a href="index.cfm" style="display: block; width: 100%; height: 100%"> </a> </div> </div> <div class="span-21 left-border right-border last" id="body"> <div class="clear span-5" id="leftNav"> <ul class="navParent"> <li> <ul class="navChild"> <li class="last"><a href="language.cfm">Français</a></li> <li class="last"><a href="index.cfm">Home</a></li> <li class="last"><a href="search.cfm">Explore the Classification</a></li> <li class="last"><a href="page.cfm?page=2228">CNVC Overview</a></li> <li class="last"><a href="nomenclature.cfm">Botanical Nomenclature</a></li> <li class="last"><a href="page.cfm?page=2274">About</a></li> <li class="last"><a href="page.cfm?page=3">Glossary</a></li> <li class="last"><a href="page.cfm?page=6">Links</a></li> <li class="last"><a href="page.cfm?page=2306">Vegetation Zones of Canada</a></li> <li class="last"><a href="page.cfm?page=212">Updates</a></li> </ul> </li> </ul> </div> <div class="span-16 last" id="main"> <div class="clear span-16 last" id="content">
httpreferer[empty string]
mailto[empty string]
messageGeneral SQL Error
querystring[empty string]
remoteAddress35.175.119.198
tagcontext
array
1
struct
column1
idCFQUERY
line6
template/web/apps/cnvc/public_html/nomenclature.cfm
template/nomenclature.cfm
typeDatabase
filter
function filter
Arguments:
NameRequiredTypeDefault
htmlOptionalany
Return Type:
Roles:
jtidy
function jtidy
Arguments:
NameRequiredTypeDefault
htmlOptionalany
Return Type:
Roles:
striphtml
function striphtml
Arguments:
NameRequiredTypeDefault
htmlOptionalany
Return Type:
Roles: