IntegrityError : Error when saving a query.

[efotopoulou]

When the user does the following combination of steps happens the following integrity Error

1. user creates a query with query designer and saves it
2. the user does a minor change to sparql of saved query and saves it again as plain text query
3. now user without closing the query designer tab does some changes via the query designer. When he tries to save it with the design then gets the following exception.

(In order to save it i had to manually delete the created row to query_designer_design table)

IntegrityError at /query-builder/save/134/ (1452, 'Cannot add or update a child row: a foreign key constraint fails (linda.linda_app_query, CONSTRAINT linda_a_design_id_4b2be2122269c688_fk_builder_advanced_design_id FOREIGN KEY (design_id) REFERENCES builder_advanced_design (id))') Request Method: POST Request URL: http://localhost:8000/query-builder/save/134/ Django Version: 1.7 Python Executable: /usr/bin/python Python Version: 2.7.4 Python Path: ['/home/eleni/IdeaProjects/LindaWorkbench/linda', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-x86_64-linux-gnu', '/usr/lib/python2.7/lib-tk',

[dipapaspyros]

I understand that a different message should be presented, but when a query is saved as plain text the design is dropped, so the user can not make changes via the Query Designer at that particular query in the future.