[Koha] Cannot edit public list

[Robin Sheat]

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