Hi,
I am getting an error when i click on Edit Categories in Admin>Configure Modules>Asset>Categories
org.postgresql.util.PSQLException: The column name entered was not found in this ResultSet.
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.findColumn(AbstractJdbc2ResultSet.java:2465)
at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getTimestamp(AbstractJdbc2ResultSet.java:2367)
at org.aspcfs.modules.troubletickets.base.TicketCategoryDraft.buildRecord(TicketCategoryDraft.java:670)
at org.aspcfs.modules.troubletickets.base.TicketCategoryDraft.(TicketCategoryDraft.java:86)
at org.aspcfs.modules.troubletickets.base.TicketCategoryDraftList.buildList(TicketCategoryDraftList.java:571)
at org.aspcfs.modules.admin.base.CategoryEditor.build(CategoryEditor.java:561)
at org.aspcfs.controller.SystemStatus.getCategoryEditor(SystemStatus.java:326)
at org.aspcfs.modules.admin.actions.AdminCategories.executeCommandViewActive(AdminCategories.java:614)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.darkhorseventures.framework.servlets.ControllerServlet.service(ControllerServlet.java:548)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)

I assume this is because the Asset_category_draft table does not have th "entered" and "modified" fields where as they are being expected in the class "TicketCategoryDraft.java" in the buildRecord method.

Can anyone please help me out in a solution to this? I would just add the two columns but i do not understand the inconsistency/purpose of this change required....

Any help is appreciated...