Customer login  |   Contact us
Home Company Products Support Purchase
Forum Home » Survey software » Opinio plugins

Topic: Custom SurveyAttribute. How set SurveyAttributeId?
Replies: 0   Pages: 1  


Back to Topic List Back to Topic List
Replies: 0   Pages: 1  
daviwebTMT

Posts: 3
Registered: Apr 10, 2009
Custom SurveyAttribute. How set SurveyAttributeId?
Posted: Apr 17, 2009 3:50 PM
  Reply

I need to set some custom attribute for each survey.

I found method "setAttribute" of Survey Object.
I will use this method ASAP...

Meanwhile, I try to set manually some attribute. I added some row in table OPS_SurveyAttribute (http://www.objectplanet.com/opinio/doc/db/database.htm#OPS_SurveyAttribute).

SurveyAttributeId is not autoincrement, so I use the greter value +1: it's works.



Now, while I'm surfing the opinio's admin interface, I found some error in file opinio.log:

ERROR -- SurveyDB.storeSurveyAttributes(): java.sql.SQLException: Duplicate key or integrity constraint violation message from server: "Duplicate entry '347706' for key 1"


Which may be the problem?
How assign/calculate value for SurveyAttributeId?
Why isn't it autoincrement?



© 1998-2013 ObjectPlanet, Inc. Øvre Slottsgate 5, 0157 Oslo, Norway Tel (+47) 2233 3360 | Fax (+47) 2233 3361