Cannot edit public list
Hello All, In Koha admin interface, I am unable to add a record to a public list that I created, using same user/password combo that I used to log in to Koha admin. I am able to view this public list (it still exists; was not deleted), and I can edit my private list, but cannot edit the public list. Through the OPAC interface I have the same problem --- cannot add anything to public list even though I can view its contents. Details: When I am viewing a record, in either admin interface or OPAC, I click on the "Add To" arrow and select LIST. Where it says, "select an existing list" -- there is no option. If I am logged in under my personal account, then I can add to my private list but there is still no public list option. Note that I have tried adding to the public list using both my personal and admin logins, and yes, my personal login does have superlibrarian permissions ( I double checked this). I searched bugzilla and see no known bugs. I am running Koha v.3.10.04.000 Any ideas are appreciated. Thanks! Amy Schuler Cary Institute of Ecosystem Studies Millbrook, NY schulera@caryinstitute.org
Amy, You are not encouraged to create public lists with the special Koha admin user. Are you able to create a public list in staff, set the appropriate permissions on it, and add some items (logged in as a superlibrarian in staff) ? Marcel ________________________________________ Van: koha-bounces@lists.katipo.co.nz [koha-bounces@lists.katipo.co.nz] namens Amy Schuler [schulera@caryinstitute.org] Verzonden: dinsdag 25 februari 2014 22:02 Aan: koha@lists.katipo.co.nz Onderwerp: [Koha] Cannot edit public list Hello All, In Koha admin interface, I am unable to add a record to a public list that I created, using same user/password combo that I used to log in to Koha admin. I am able to view this public list (it still exists; was not deleted), and I can edit my private list, but cannot edit the public list. Through the OPAC interface I have the same problem --- cannot add anything to public list even though I can view its contents. Details: When I am viewing a record, in either admin interface or OPAC, I click on the "Add To" arrow and select LIST. Where it says, "select an existing list" -- there is no option. If I am logged in under my personal account, then I can add to my private list but there is still no public list option. Note that I have tried adding to the public list using both my personal and admin logins, and yes, my personal login does have superlibrarian permissions ( I double checked this). I searched bugzilla and see no known bugs. I am running Koha v.3.10.04.000 Any ideas are appreciated. Thanks! Amy Schuler Cary Institute of Ecosystem Studies Millbrook, NY schulera@caryinstitute.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Marcel and All, Thanks for the comments and advice. There was a time when I used the koha admin user for things like creating the public list, *before* I started seeing the dire warnings upon login about creating another staff user for things of that nature. However, there was definitely a time when there was no such warning, and I did use koha admin user to create that public list. For some time now I have used a different login for admin purposes. But now that the damage is done - does anyone have follow-up advice as to how I can delete that public list? I cannot edit or delete items using any login. If I can clear that out, I will recreate using my alternate staff login. Thanks again! Amy On Wed, Feb 26, 2014 at 7:25 AM, Marcel de Rooy <M.de.Rooy@rijksmuseum.nl>wrote:
Amy, You are not encouraged to create public lists with the special Koha admin user. Are you able to create a public list in staff, set the appropriate permissions on it, and add some items (logged in as a superlibrarian in staff) ?
Marcel ________________________________________ Van: koha-bounces@lists.katipo.co.nz [koha-bounces@lists.katipo.co.nz] namens Amy Schuler [schulera@caryinstitute.org] Verzonden: dinsdag 25 februari 2014 22:02 Aan: koha@lists.katipo.co.nz Onderwerp: [Koha] Cannot edit public list
Hello All,
In Koha admin interface, I am unable to add a record to a public list that I created, using same user/password combo that I used to log in to Koha admin. I am able to view this public list (it still exists; was not deleted), and I can edit my private list, but cannot edit the public list. Through the OPAC interface I have the same problem --- cannot add anything to public list even though I can view its contents.
Details: When I am viewing a record, in either admin interface or OPAC, I click on the "Add To" arrow and select LIST. Where it says, "select an existing list" -- there is no option. If I am logged in under my personal account, then I can add to my private list but there is still no public list option. Note that I have tried adding to the public list using both my personal and admin logins, and yes, my personal login does have superlibrarian permissions ( I double checked this).
I searched bugzilla and see no known bugs.
I am running Koha v.3.10.04.000
Any ideas are appreciated. Thanks!
Amy Schuler Cary Institute of Ecosystem Studies Millbrook, NY schulera@caryinstitute.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Amy Schuler schreef op do 27-02-2014 om 09:56 [-0500]:
But now that the damage is done - does anyone have follow-up advice as to how I can delete that public list? I cannot edit or delete items using any login. If I can clear that out, I will recreate using my alternate staff login.
This is untested, but if you're comfortable poking at the database, something like this might work. Do it on a test copy first, of course. First, figure out the borrower number that you want to take ownership of the lists, e.g. your own. UPDATE virtualshelves SET owner=**your number** WHERE owner IS NULL; The assumption I'm making here is that the owner is null when the list is created by the database user. You can verify this with: SELECT * FROM virtualshelves WHERE owner IS NULL; If it returns nothing, then my assumption isn't correct, if it returns the problematic lists, then it should work fine. If it works, then those lists are now yours and you can do what you like with them. It might also be worth filing a bug, as well as having warnings, we probably should disable functions that we _know_ will break, like this, when logged in as the database user. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
Robin, As far as I'm aware of the main task of the database user is to create user accounts (superlibrarians). Are there other tasks inside the staff client that should / must be done by the database user? Maybe we could turn off _all_ but such functions? Marc Am 27.02.2014 23:07, schrieb Robin Sheat:
we probably should disable functions that we _know_ will break, like this, when logged in as the database user.
Marc Véron schreef op vr 28-02-2014 om 08:05 [+0100]:
As far as I'm aware of the main task of the database user is to create user accounts (superlibrarians). Are there other tasks inside the staff client that should / must be done by the database user?
Maybe we could turn off _all_ but such functions?
From a service provider point of view, the database user is very handy. We use it to log in and look at things when we need to figure out why something is working the way it is or to change a configuration option, and we don't always have our own regular login to use. We could create one, but we don't like to if we don't have to, as it has the potential to confuse reports and such. This would get a lot harder if most options were blocked.
There is a big warning at the top when you're logged in as the db user, this ought to be enough (though the particular case here pre-dates that warning.) I'm not averse to disabling known-bad things though, like lists, and probably circulation. Or making the warning more prominent perhaps. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF
See bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8262 Kohaadmin cannot create lists and should not create lists. But the error from the log does not reach the interface. It is still on my list. Will work on lists this week. Marcel -----Oorspronkelijk bericht----- Van: koha-bounces@lists.katipo.co.nz [mailto:koha-bounces@lists.katipo.co.nz] Namens Robin Sheat Verzonden: zondag 2 maart 2014 23:05 Aan: koha Onderwerp: Re: [Koha] Cannot edit public list Marc Véron schreef op vr 28-02-2014 om 08:05 [+0100]:
As far as I'm aware of the main task of the database user is to create user accounts (superlibrarians). Are there other tasks inside the staff client that should / must be done by the database user?
Maybe we could turn off _all_ but such functions?
From a service provider point of view, the database user is very handy. We use it to log in and look at things when we need to figure out why something is working the way it is or to change a configuration option, and we don't always have our own regular login to use. We could create one, but we don't like to if we don't have to, as it has the potential to confuse reports and such. This would get a lot harder if most options were blocked. There is a big warning at the top when you're logged in as the db user, this ought to be enough (though the particular case here pre-dates that warning.) I'm not averse to disabling known-bad things though, like lists, and probably circulation. Or making the warning more prominent perhaps. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Have you checked your System preferences? Administration preferences > Interface options> virtual shelves. I just tested our one public list and it seems to accept new records. We're using 3.14.2 On Tue, Feb 25, 2014 at 9:02 PM, Amy Schuler <schulera@caryinstitute.org>wrote:
Hello All,
In Koha admin interface, I am unable to add a record to a public list that I created, using same user/password combo that I used to log in to Koha admin. I am able to view this public list (it still exists; was not deleted), and I can edit my private list, but cannot edit the public list. Through the OPAC interface I have the same problem --- cannot add anything to public list even though I can view its contents.
Details: When I am viewing a record, in either admin interface or OPAC, I click on the "Add To" arrow and select LIST. Where it says, "select an existing list" -- there is no option. If I am logged in under my personal account, then I can add to my private list but there is still no public list option. Note that I have tried adding to the public list using both my personal and admin logins, and yes, my personal login does have superlibrarian permissions ( I double checked this).
I searched bugzilla and see no known bugs.
I am running Koha v.3.10.04.000
Any ideas are appreciated. Thanks!
Amy Schuler Cary Institute of Ecosystem Studies Millbrook, NY schulera@caryinstitute.org _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
participants (5)
-
Amy Schuler -
Elaine Bradtke -
Marc Véron -
Marcel de Rooy -
Robin Sheat