[Koha] cannot edit public list, follow-up/part 2

[Bernardo Gonzalez Kriegel]

Amy,

It seems that the borrowernumer you are trying to use is wrong.

I created a list, then set its owner to NULL,

Next if I try to update the table to some nonexistent
borrowernumber, I got the same message than you

If I do the update to a valid borrowernumber, it's done
without problem

Please go to Adminstration > Patrons, search your patron,
go to it's page and look the number at the end of the URL,
cgi-bin/koha/members/moremember.pl?borrowernumber=NNN

That's the number you need to use in your UPDATE line


Bernardo



-- 
Bernardo Gonzalez Kriegel
bgkriegel at gmail.com


On Mon, Mar 24, 2014 at 5:57 PM, Amy Schuler <schulera at caryinstitute.org>wrote:

> Dear All
>
> Awhile back I posted that I had inadvertently done some things in root that
> I should not have done.  Specifically, creating a public list that I am now
> unable to edit or delete.  See original thread
> http://lists.katipo.co.nz/pipermail/koha/2014-February/038728.html.
>
> Following Robin Sheat's advice (thanks Robin!), I attempted to take
> ownership of that list according to the instructions here,
> http://lists.katipo.co.nz/pipermail/koha/2014-February/038751.html.  As
> suggested in these instructions, I did first confirm that the list owner is
> null.  However, upon trying Robin's instructions to take over the list, I
> got the following error:
>
> mysql> UPDATE virtualshelves SET owner=1082 WHERE owner IS NULL;
> ERROR 1452 (23000): Cannot add or update a child row: a foreign key
> constraint fails (`koha_library`.`virtualshelves`, CONSTRAINT
> `virtualshelves_ibfk_1` FOREIGN KEY (`owner`) REFERENCES `borrowers`
> (`borrowernumber`) ON DELETE SET NULL ON UPDATE SET NULL)
>
> Of course I have googled the error, but am not familiar enough with mySQL
> or database structure generally to make much sense of it.  Can anyone
> translate this and tell me how to get past this error and achieve my
> ultimate goal of taking ownership of that list?
>
> I am running Koha 3.10.04.000, mySQL v. 14.14.  Let me know if you need
> more info or details about the structure of my database.  Please be
> explicit in your advice.  Note that it took me a few weeks just to get to
> this point with Robin's instructions : )
>
> Thanks to everyone,
>
> Amy Schuler
> Cary Institute of Ecosystem Studies
> schulera at caryinstitute.org
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>