[Koha-bugs] [Bug 3309] Deleting authorized values when data exists

[bugzilla-daemon]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309

Jonathan Druart  changed:

   What|Removed |Added

   See Also||https://bugs.koha-community
   ||.org/bugzilla3/show_bug.cgi
   ||?id=21466

--- Comment #5 from Jonathan Druart  
---
(In reply to Katrin Fischer from comment #4)
> Authorised values are used in so many places and can be user defined too -
> it seems impossible to introduce a reliable check here.
;..
For AVs linked to biblio frameworks I added a test to the "search for
inconsistencies" script, see bug 21466.

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 3309] Deleting authorized values when data exists

[bugzilla-daemon]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309

--- Comment #4 from Katrin Fischer  ---
Authorised values are used in so many places and can be user defined too - it
seems impossible to introduce a reliable check here.

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 3309] Deleting authorized values when data exists

[bugzilla-daemon]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309

Patrick Robitaille  changed:

   What|Removed |Added

 CC||patrick.robitai...@ccsr.qc.
   ||ca

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 3309] Deleting authorized values when data exists

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309

Marjorie Barry-Vila marjorie.barry-v...@ccsr.qc.ca changed:

   What|Removed |Added

 CC||marjorie.barry-v...@ccsr.qc
   ||.ca

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 3309] Deleting authorized values when data exists

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309

Jonathan Druart jonathan.dru...@biblibre.com changed:

   What|Removed |Added

 CC||jonathan.dru...@biblibre.co
   ||m

--- Comment #3 from Jonathan Druart jonathan.dru...@biblibre.com ---
(In reply to Mirko Tietgen from comment #1)
 Two things happen:
 - DBD::mysql::st execute failed: Unknown column 'id' in 'where clause' at
 /home/mirko/koha/admin/authorised_values.pl line 228.
 - value is deleted, field shows '-5'
 
 So there is no routine to check if the value is used and there is something
 wrong with the deletion. The line in referenced in the error message is
 
 $sth = $dbh-prepare(DELETE FROM authorised_values_branches WHERE id = ?);
 
 authorised_values_branches does not have a column called 'id', it is called
 'av_id'

This is fixed by bug 9272, not related to the main problem.

(In reply to Owen Leonard from comment #2)
 (In reply to Mirko Tietgen from comment #1)
  This seems to still be valid. To reproduce I
  - added a value to NOT_LOAN: '-5' with value 'fish'
  - set an item to use that value
  - deleted the authorizes value.
 
 I find that this is still the case -- I'm not blocked from deleting an
 authorized value which is in use by an item. However I see no related errors
 in the log.

Not sure how we could fix this problem.
We will need to check all items, it will be time consuming.
But we could imagine a check function to know if the AV is used (category
linked to a framework and value in the DB field).

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 3309] Deleting authorized values when data exists

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309

Owen Leonard oleon...@myacpl.org changed:

   What|Removed |Added

   Hardware|PC  |All
Version|rel_3_0 |master

--- Comment #2 from Owen Leonard oleon...@myacpl.org ---
(In reply to Mirko Tietgen from comment #1)
 This seems to still be valid. To reproduce I
 - added a value to NOT_LOAN: '-5' with value 'fish'
 - set an item to use that value
 - deleted the authorizes value.

I find that this is still the case -- I'm not blocked from deleting an
authorized value which is in use by an item. However I see no related errors in
the log.

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 3309] Deleting authorized values when data exists

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309

Katrin Fischer katrin.fisc...@bsz-bw.de changed:

   What|Removed |Added

 CC||katrin.fisc...@bsz-bw.de
 Depends on||9272

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

[Koha-bugs] [Bug 3309] Deleting authorized values when data exists

[bugzilla-daemon]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3309

Mirko Tietgen mi...@abunchofthings.net changed:

   What|Removed |Added

 CC||mi...@abunchofthings.net

--- Comment #1 from Mirko Tietgen mi...@abunchofthings.net ---
This seems to still be valid. To reproduce I
- added a value to NOT_LOAN: '-5' with value 'fish'
- set an item to use that value
- deleted the authorizes value.

Two things happen:
- DBD::mysql::st execute failed: Unknown column 'id' in 'where clause' at
/home/mirko/koha/admin/authorised_values.pl line 228.
- value is deleted, field shows '-5'

So there is no routine to check if the value is used and there is something
wrong with the deletion. The line in referenced in the error message is

$sth = $dbh-prepare(DELETE FROM authorised_values_branches WHERE id = ?);

authorised_values_branches does not have a column called 'id', it is called
'av_id'

-- 
You are receiving this mail because:
You are watching all bug changes.
___
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/