[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Health] Health Specialty: Key (specialty)=(32) is not present in ta
From: |
Luis Falcon |
Subject: |
Re: [Health] Health Specialty: Key (specialty)=(32) is not present in table "gnuhealth_hp_specialty". |
Date: |
Tue, 06 Aug 2013 13:48:44 -0300 |
User-agent: |
Mozilla/5.0 (X11; Linux x86_64; rv:17.0) Gecko/20130701 Icedove/17.0.7 |
Hi Ronald !
On 06/08/2013 12:48, ronald munjoma wrote:
> 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
I think you're using the trunk development branch. This correspond to
health-dev mailing list.
Best,
> Traceback (most recent call last):
> File "./trytond", line 109, in <module>
> trytond.server.TrytonServer(options).run()
> File
> "/home/ronald/.local/lib/python2.7/site-packages/trytond/server.py",
> line 131, in run
> Pool(db_name).init(update=update, lang=lang)
> File
> "/home/ronald/.local/lib/python2.7/site-packages/trytond/pool.py", line
> 134, in init
> lang=lang)
> File
> "/home/ronald/.local/lib/python2.7/site-packages/trytond/modules/__init__.py",
> line 391, in load_modules
> load_module_graph(graph, pool, lang)
> File
> "/home/ronald/.local/lib/python2.7/site-packages/trytond/modules/__init__.py",
> line 229, in load_module_graph
> cls.__register__(module)
> File
> "/home/ronald/.local/lib/python2.7/site-packages/trytond/model/modelsql.py",
> line 151, in __register__
> table.add_fk(field_name, ref, field.ondelete)
> File
> "/home/ronald/.local/lib/python2.7/site-packages/trytond/backend/postgresql/table.py",
> line 301, in add_fk
> 'ON DELETE ' + on_delete)
> File
> "/home/ronald/.local/lib/python2.7/site-packages/trytond/backend/postgresql/database.py",
> 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
--
Luis Falcon
http://health.gnu.org