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

[Amy Schuler]

All,
I report SUCCESS!  Bernardo, thanks for clarifying the borrowing number.
 As you may have realized, I had been using my card number (I did not
realize the two numbers were different).  Using the borrowing number, the
command provided by Marcel worked perfectly.

I learned some things about my database and SQL.  That is the bright side
of having stupidly used root for various admin tasks in Koha!

Thanks again!

Amy Schuler


On Mon, Mar 24, 2014 at 5:54 PM, Bernardo Gonzalez Kriegel <
bgkriegel at gmail.com> wrote:

> 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
>>
>
>