Sidebar Filters (Facets) Issue

classic Classic list List threaded Threaded
9 messages Options
Reply | Threaded
Open this post in threaded view
|

Sidebar Filters (Facets) Issue

nsid
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?
Reply | Threaded
Open this post in threaded view
|

Re: Sidebar Filters (Facets) Issue

sonukilskanna
It's look like your searchforms table corrupted.

Please Run AddedScripts on your database.

then it will work fine.
Reply | Threaded
Open this post in threaded view
|

Re: Sidebar Filters (Facets) Issue

nsid
Could you please inform me, how I can do this?

Thank you.
Reply | Threaded
Open this post in threaded view
|

Re: Sidebar Filters (Facets) Issue

sonukilskanna
which version you are using at present??
Reply | Threaded
Open this post in threaded view
|

Re: Sidebar Filters (Facets) Issue

nsid
My version is 3.1.2.
Reply | Threaded
Open this post in threaded view
|

Re: Sidebar Filters (Facets) Issue

sonukilskanna
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.
Reply | Threaded
Open this post in threaded view
|

Re: Sidebar Filters (Facets) Issue

nsid
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


Reply | Threaded
Open this post in threaded view
|

Re: Sidebar Filters (Facets) Issue

sonukilskanna
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?
Reply | Threaded
Open this post in threaded view
|

Re: Sidebar Filters (Facets) Issue

nsid
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.