koha 3.0.4 + cannot delete extra libraries with their names
Hi, i want to delete some extra libraries from my koha system. Then, i could delete three from GUI; Koha-> Administration-> Libraries & Groups. But, there are more two including default "My library". Then i went to mysql an tried to delete those two library names, which are as sub-branch; but, i cannot delete those. Error shows: * mysql + #1451 - Cannot delete or update a parent row: a foreign key constraint fails* -- Best, Zico
You can't delete a branch that has any items or users (and possibly other data) associated with it. Edit or delete those first. --Joe 2009/12/3 Zico <mailzico@gmail.com>
Hi, i want to delete some extra libraries from my koha system. Then, i could delete three from GUI; Koha-> Administration-> Libraries & Groups. But, there are more two including default "My library". Then i went to mysql an tried to delete those two library names, which are as sub-branch; but, i cannot delete those. Error shows: * mysql + #1451 - Cannot delete or update a parent row: a foreign key constraint fails*
On Thu, Dec 3, 2009 at 9:30 PM, Joe Atzberger <ohiocore@gmail.com> wrote:
You can't delete a branch that has any items or users (and possibly other data) associated with it. Edit or delete those first.
Actually, i don`t have any patrons there in this system. Patron is null there. -- Best, Zico
So? The point is that *somewhere* you have keys referencing the branches table for that value. That's why you can't delete it. The data could be in *any* table w/ a branches foreign key. --joe On Thu, Dec 3, 2009 at 12:02 PM, Zico <mailzico@gmail.com> wrote:
On Thu, Dec 3, 2009 at 9:30 PM, Joe Atzberger <ohiocore@gmail.com> wrote:
You can't delete a branch that has any items or users (and possibly other data) associated with it. Edit or delete those first.
Actually, i don`t have any patrons there in this system. Patron is null there.
-- Best, Zico
On Fri, Dec 4, 2009 at 2:42 AM, Joe Atzberger <ohiocore@gmail.com> wrote:
So? The point is that *somewhere* you have keys referencing the branches table for that value. That's why you can't delete it. The data could be in *any* table w/ a branches foreign key.
I got it. But, the point is, i don`t have any patrons in my koha.. and i cannot delete libraries from mysql branches for error. So, what should i do now? I mean, i cannot see any patrons there in my system; but i must have to delete branches. How can i do that? Waiting for your reply. -- Best, Zico
2009/12/3 Zico <mailzico@gmail.com>
On Fri, Dec 4, 2009 at 2:42 AM, Joe Atzberger <ohiocore@gmail.com> wrote:
So? The point is that *somewhere* you have keys referencing the branches table for that value. That's why you can't delete it. The data could be in *any* table w/ a branches foreign key.
I got it. But, the point is, i don`t have any patrons in my koha.. and i cannot delete libraries from mysql branches for error. So, what should i do now? I mean, i cannot see any patrons there in my system; but i must have to delete branches. How can i do that?
Waiting for your reply.
-- Best, Zico
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
What Joe means is that other tables refer to the libraries in your system; any items, budgets, issuing rules, etc. Look through your settings to see if you have anything set up for this library. -- Jesse Weaver
participants (3)
-
Jesse -
Joe Atzberger -
Zico