cannot edit public list, follow-up/part 2
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@caryinstitute.org
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@gmail.com On Mon, Mar 24, 2014 at 5:57 PM, Amy Schuler <schulera@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@caryinstitute.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
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@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@gmail.com
On Mon, Mar 24, 2014 at 5:57 PM, Amy Schuler <schulera@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@caryinstitute.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Amy Schuler -
Bernardo Gonzalez Kriegel