← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 841003] Re: Schedule meeting from applicant form gives "Integrity Error"

 

I found this in the log:

[2011-09-06 10:25:27,846][vnhr] INFO:web-service:successful login from 'admin' using database 'vnhr'
[2011-09-06 10:26:15,655][vnhr] ERROR:db.cursor:bad query: insert into "crm_meeting" (id,"allday","partner_address_id","fr","date","byday","duration","organizer","partner_id","user_id","tu","recurrency","week_list","day","recurrent_uid","state","location","th","su","we","description","end_date","class","section_id","edit_all","active","freq","categ_id","show_as","opportunity_id","count","end_type","name","date_deadline","mo","interval","recurrent_id","email_from","alarm_id","sa","rrule_type","select1",create_uid,create_date) values (33,E'False',NULL,E'False',E'2011-09-06 00:00:00',NULL,1.0,E'Administrator',NULL,1,E'False',E'False',NULL,0,0,E'open',NULL,E'False',E'False',E'False',NULL,NULL,E'public',NULL,E'False',E'True',E'None',NULL,E'busy',5,0,E'forever',E'zdfvxc',E'2011-09-06 01:00:00',E'False',1,NULL,NULL,NULL,E'False',E'none',E'date',1,now())
Traceback (most recent call last):
  File "/home/openerp/6.0/server/bin/sql_db.py", line 131, in execute
    res = self._obj.execute(query, params)
IntegrityError: insert or update on table "crm_meeting" violates foreign key constraint "crm_meeting_opportunity_id_fkey"
DETAIL:  Key (opportunity_id)=(5) is not present in table "crm_lead".


Running:
OpenERP - GTK Client - v6.0.2

I don't know how to find out which version of the server that I'm
actually running. Can you please advice?

BR
Øystein

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/841003

Title:
  Schedule meeting from applicant form gives "Integrity Error"

Status in OpenERP Modules (addons):
  Incomplete

Bug description:
  In applicants (ht_recruitment -> Human Resources/Recruitment/Applicants)
  - Click "Meeting", then select date etc, and click "Save"

  In GTK client it will give the following error:
  Integrity Error

  The operation cannot be completed, probably due to the following:
  - deletion: you may be trying to delete a record while other records still reference it
  - creation/update: a mandatory field is not correctly set

  [object with reference: Lead/Opportunity - crm.lead]

  
  I have not tried with webclient.

  Running from source

  bzr version-info:
  revision-id: launchpad_translations_on_behalf_of_openerp-20110711052527-rzbr0dornuwjiur4
  date: 2011-07-11 05:25:27 +0000
  build-date: 2011-09-04 20:25:09 +0700
  revno: 4703
  branch-nick: addons

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/841003/+subscriptions


References