Centric CRM 4.1 (Stable and Released)

Core Team

PUBLIC PROFILE

Assignment

Priority:
Assigned To: unassigned

Ticket # 164

This ticket is open
Severity: Normal
Category: Functionality
Entered by: Claudio Tranchina 9/20/2007, 12:23 PM
Last modified: Claudio Tranchina 9/20/2007, 12:23 PM

Description

Using the search function under the account menu, narrowing the search with the "Asset Serial Number" field and checking the "Include Contacts" checkbox, I get the following error:

Please report the following error to Centric CRM

You may be able to hit the back button on your browser, review your selection, and try your request again.

The actual error is:

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: FUNCTION centric.lower does not exist
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2934)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1616)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1708)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3255)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1293)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1428)
at org.aspcfs.modules.contacts.base.ContactList.buildList(Unknown Source)
at org.aspcfs.modules.accounts.actions.Accounts.executeCommandSearch(Unknown Source)
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(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:595)

Solution

A solution hasn't been entered

File Attachments

There are no file attachments

Ticket Activity

Date	Event
Claudio Tranchina 9/20/2007, 12:23 PM	[ Ticket Opened ]
Claudio Tranchina 9/20/2007, 12:23 PM	[ Ticket is unassigned ]
Claudio Tranchina 9/20/2007, 12:23 PM	[ Severity set to Normal ]

Distribution List
Claudio T.