Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
Hi there,
Searching in the webOPAC, the sidebar filters area is broken, showing these errors. Expression MTFacet is undefined on line 356, column 55 in Search.ftl. The problematic instruction: ---------- ==> if (MTFacet?size>0) || (BibFacet?size>0) [on line 356, column 49 in Search.ftl] ---------- Java backtrace for programmers: ---------- freemarker.core.InvalidReferenceException: Expression MTFacet is undefined on line 356, column 55 in Search.ftl. at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:125) at freemarker.core.TemplateObject.invalidTypeException(TemplateObject.java:135) at freemarker.core.BuiltIn$sizeBI._getAsTemplateModel(BuiltIn.java:700) at freemarker.core.Expression.getAsTemplateModel(Expression.java:89) at freemarker.core.ComparisonExpression.isTrue(ComparisonExpression.java:111) at freemarker.core.ParentheticalExpression.isTrue(ParentheticalExpression.java:66) at freemarker.core.OrExpression.isTrue(OrExpression.java:68) at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:77) at freemarker.core.Environment.visit(Environment.java:221) at freemarker.core.MixedContent.accept(MixedContent.java:92) at freemarker.core.Environment.visit(Environment.java:221) at freemarker.core.Environment.process(Environment.java:199) at freemarker.template.Template.process(Template.java:237) at opac2.SearchServlet.processRequest(SearchServlet.java:469) at opac2.SearchServlet.doGet(SearchServlet.java:520) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) at java.lang.Thread.run(Thread.java:662) Any ideas? |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
It's look like your searchforms table corrupted.
Please Run AddedScripts on your database. then it will work fine. |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
Could you please inform me, how I can do this?
Thank you. |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
which version you are using at present??
|
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
My version is 3.1.2.
|
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
Ok
In installation folder you can find 2 sql files named AddedScripts.sql and V31AddedScripts.sql which are located at 1)C:\InstallNGL3.1\scripts\AddedScripts.sql 2)C:\InstallNGL3.1\upgrade303\V31AddedScripts.sql Run these 2 files on your database. |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
No luck...
Firsto of all I don't have C:\InstallNGL3.1 but C:\InstallNGL3.0 So, running the script C:\InstallNGL3.0\scripts\AddedScripts.sql I get this error message: WARNING: nonstandard use of escape in a string literal LINE 113: ...library_id,gen_oo,gen_html,gen_text) values (1,59,'Reference... ^ HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. ERROR: column "status" of relation "cat_volume" already exists ********** Error ********** ERROR: column "status" of relation "cat_volume" already exists SQL state: 42701 and running the script C:\InstallNGL3.0\upgrade303\V303AddedScripts.sql I get this error message: ERROR: column "p_course_id" of relation "course" already exists ********** Error ********** ERROR: column "p_course_id" of relation "course" already exists SQL state: 42701 |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
if you are using 3,1,2 then you must have latest installation file.
and those error will occure while running the sql files. did you check the opac again after run these files? |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
I have 3.1.2 but not the specific folders.
Furthermore, the update to the latest version was done by NGL team. I will have to send them an email, I guess. |
Free forum by Nabble | Edit this page |