批注 2022-08-03 094310.png - ConcourseSuite Support image

ConcourseSuite Support

Support
http://concursive.com/help/en_us/
Corporate
PUBLIC PROFILE

Back to topics

Discuss Administration

Error creating a Group in Communications module

You need to be logged in to post messages

Error creating a Group in Communications module

1/23/2008 3:20 PM EST
Default user photo

By Jason Maas

Hello,

I'm seeing an error with ConcourseSuite Community Edition downloaded late last week. The system is a Debian "testing" system runing Sun JVM 1.6.0-b105, Tomcat 5.5.25 and PostgreSQL 8.2.6.

The problem occurs when I try to add a new group in the Communications module. After I name the group, select a contact, and click "Save" then I get a java stack trace and error message delivered on a web page within the Centric UI. Looks like maybe the database schema wasn't setup properly...? Can anybody help me decipher this one? Here's what it says:

An Error Has Occurred
Please report the following error to Concourse Suite Community Edition

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

The actual error is:

java.sql.SQLException: ERROR: column "source" of relation "saved_criterialist" does not exist
at org.aspcfs.modules.communications.base.SearchCriteriaList.insert(Unknown Source)
at org.aspcfs.modules.communications.actions.CampaignManagerGroup.executeCommandInsert(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:597)
at com.darkhorseventures.framework.servlets.ControllerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
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:213)
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:874)
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:689)
at java.lang.Thread.run(Thread.java:619)

Thanks for your help!

Jason

1. 1/24/2008 12:45 AM EST
Default user photo

By Lorraine Bittner

This was reported as a bug in the enterprise edition as well. The listed resolution was renaming the column to "source", but it seems like that could potentially break other functionality since the table has had the contact_source column since version 2.0. I'll try to check subversion for more information.

- Lorraine

2. 1/24/2008 10:18 AM EST
Default user photo

By Jason Maas

Hi Lorraine,

Thanks again for your quick response! That's good to know that it's a known bug that's been worked on. Thank you very much for looking into the final resolution, I really appreciate it. We'll tentatively try that out while we await further word.

Is there any way that I can see the Enterprise Edition bug tracker? The Project for the Enterprise Edition doesn't appear to have any Tickets associated with it.

Thanks!

Jason

3. 1/25/2008 12:49 AM EST
Lorraine B. photo

By Lorraine Bittner

We are moving things around, so the enterprise tickets might not be viewable through the project right now. But the column name change is correct, it was changed last July in update scripts but the change was missing from the new_campaign.sql script that is run when installdb is used.

The update script is:
src/sql/postgresql/upgrade/2007-07-24-script-vitalii.sql

And can be run with:
psql -f $/src/sql/postgresql/upgrade/2007-07-24-script-vitalii.sql $

4. 1/25/2008 11:27 AM EST
Default user photo

By Jason Maas

Hi Lorraine,

Thanks so much for the update, that's good to know! I've tried out that change and renaming the column in the DB does indeed allow me to create groups. Should one of us create a Ticket for the Community Edition project about this one to make sure that it gets fixed? Would you like me to do that?

Jason

4 results found