[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Health-dev] Health Specialty: Key (specialty)=(32) is not present in ta

From: ronald munjoma
Subject: [Health-dev] Health Specialty: Key (specialty)=(32) is not present in table "gnuhealth_hp_specialty".
Date: Wed, 7 Aug 2013 12:18:16 +0200

Dear All,

I tried to update my local install to test the GNU Health professional auto fill functionality and I am getting the below trace back

[Tue Aug 06 15:43:13 2013] ERROR:sql:Wrong SQL: ALTER TABLE "gnuhealth_physician" ADD FOREIGN KEY ("specialty") REFERENCES "gnuhealth_hp_specialty" ON DELETE SET NULL
Traceback (most recent call last):
  File "./trytond", line 109, in <module>
  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/", line 131, in run
    Pool(db_name).init(update=update, lang=lang)
  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/", line 134, in init
  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/modules/", line 391, in load_modules
    load_module_graph(graph, pool, lang)
  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/modules/", line 229, in load_module_graph
  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/model/", line 151, in __register__
    table.add_fk(field_name, ref, field.ondelete)
  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/backend/postgresql/", line 301, in add_fk
    'ON DELETE ' + on_delete)
  File "/home/ronald/.local/lib/python2.7/site-packages/trytond/backend/postgresql/", line 308, in execute
    res = self.cursor.execute(sql)
psycopg2.IntegrityError: insert or update on table "gnuhealth_physician" violates foreign key constraint "gnuhealth_physician_specialty_fkey"
DETAIL:  Key (specialty)=(32) is not present in table "gnuhealth_hp_specialty".

Thanks and Regards
Ronald Munjoma

reply via email to

[Prev in Thread] Current Thread [Next in Thread]