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?

[sonukilskanna]

It's look like your searchforms table corrupted.

Please Run AddedScripts on your database.

then it will work fine.

[nsid]

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

Thank you.

[sonukilskanna]

which version you are using at present??

[nsid]

My version is 3.1.2.

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

[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

[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?

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