<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal">Hello All, <o:p></o:p></p>
<p><span style="font-family:"Calibri","sans-serif"">We are looking for some help with a persistent error message. When viewing the resource record at the resource (collection) level we receive this message:
<o:p></o:p></span></p>
<p><span style="color:#00B050">An error occurred loading this form.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New";color:#00B050">Server Error<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Courier New""><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt">Our Out log shows the following error (the log is attached for reference):<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#00B050">ERROR -- :<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#00B050">Java::ComMysqlJdbcExceptionsJdbc4::MySQLSyntaxErrorException: Unknown column 'jsonmodel_type' in 'where clause'<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#00B050">java.lang.reflect.Constructor.newInstance(java/lang/reflect/Constructor.java:526)<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">What is the relevant query that is failing according to these logs? Is there anything in the database that we can edit that would clear this error up? We can provide more logs if that will help. The problem started with one of our collections
and has now expanded to others. If we can’t get into our collections then we can’t edit locations and other information.
<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Thanks for any help you can provide!<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Jenna Edwards<o:p></o:p></p>
<p class="MsoNormal">Supervisory Technical Information Specialist<o:p></o:p></p>
<p class="MsoNormal">USDA/APHIS/WS National Wildlife Research Center<o:p></o:p></p>
<p class="MsoNormal">4101 LaPorte Avenue<o:p></o:p></p>
<p class="MsoNormal">Fort Collins, CO 80521<o:p></o:p></p>
<p class="MsoNormal">PH: 970-266-6023 <o:p></o:p></p>
<p class="MsoNormal"><a href="Jennifer.M.Edwards@aphis.usda.gov"><span style="color:windowtext">Jennifer.M.Edwards@aphis.usda.gov</span></a><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</body>
</html>