EPrints Technical Mailing List Archive

Message: #02579


< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

[EP-tech] Re: Restored users do not sort properly


Hi Florian,

Perhaps your ordering issue relates to the following issue: https://github.com/eprints/eprints/issues/48

About exporting passwords: perhaps you can patch the relevant code in EPrints for the duration of your export (MetaField::Secret::to_sax presumably).

When you INSERT'ed the missing users, did you also INSERT data into the aux. tables (user_roles etc)?

Seb.


On 31/01/14 13:35, Florian Heß wrote:
Hello everyone,

After removing a number of users by accident using the EPrints 3.3.10
API, I restored them from our backup via piping INSERT INTO `users`
commands into mysql database. That worked, but when I navigate  to the
list of all users in the web interface (Manage Records > Users) and
click there on the username column, the list is reordered to whatever
except by username. I tried the other columns, they fail to sort
properly either. What did I miss?

- epadmin reorder $repo user
- epadmin recommit $repo user
- epadmin cleanup_cachemaps $repo
- epadmin reindex $repo user
- epadmin reorder $repo user
- epadmin rehash $repo user

All these were to no avail.

Now I would try reimporting all users with XML, but I hesitate because
in the XML output file the password hashes are missing. How to include
them? Had a glance into the sources and infered from
EPrints::MetaField::Secret::to_sax() that --arg show_secrets=1 to the
XML export would do, but apparently I was wrong:
"Plugin Export::XML does not accept argument show_secrets"

Appreciate your help very much!

Kind regards
Florian