Difference between revisions of "How to move deposits between users"

From EPrints Documentation
Jump to: navigation, search
m
m
Line 1: Line 1:
This is the recipie for changing who apparently deposited an eprint. It requires logging into mysql and running the commands by hand.
+
[http://peter-land.somee.com/images/small/sunburn.htm sunburn] [http://viemalin.freeweb7.com/resources/articles/caricabatterie-pile.htm caricabatterie pile] [http://yourorus.somee.com/data/underworld-.htm underworld 8 ball] [http://jututor.125mb.com/lib/athlon-/ athlon 64 mobile] [http://dabeutle.t35.com/content/view/pioneer-dvd.htm pioneer dvd r] [http://davelovesyou.somee.com/library/html/bari-sud/ bari sud] [http://flheddina.t35.com/web/si-la/ si la ves de sin banderas] [http://lamcgie.125mb.com/html/nelli-furtado.htm nelli furtado forca] [http://ouquaite.freeweb7.com/img/styles/tv-lcd/ tv lcd philips 26] [http://peter-land.somee.com/images/small/trasloco.htm trasloco] [http://rimarsh.t35.com/images/small/frocetto.htm frocetto] [http://lensman.somee.com/html/van-de/ van de strof] [http://viemalin.freeweb7.com/resources/articles/nuova-smart.htm nuova smart forfour diesel auto nuove] [http://quotes-girl.somee.com/content/view/km/ km 005] [http://lensman.somee.com/html/screensaver-del/ screensaver del signore degli anello] [http://rihelm.125mb.com/img/styles/perle-coltivate/ perle coltivate] [http://betheresa.t35.com/text/directory/www-alessio/ www alessio it] [http://yourorus.somee.com/data/forno-elettrico.htm forno elettrico ad incasso] [http://fergus-mac.somee.com/description/lib/cardiofrequenzimetro-cs/ cardiofrequenzimetro cs100] [http://lamcgie.125mb.com/html/piccolo-uomo.htm piccolo uomo testo mia martini] [http://kiboukni.125mb.com/web/euprepio-curto/ euprepio curto] [http://flheddina.t35.com/web/canon-faxl/ canon fax-l380] [http://nairoz.somee.com/img/styles/telefoni-cellulari/ telefoni cellulari con lettore mp3] [http://quotes-girl.somee.com/content/view/ricetrasmettitori-libero/ ricetrasmettitori libero utilizzo] [http://rihelm.125mb.com/img/styles/assicurazione-biella/ assicurazione biella] [http://lamcgie.t35.com/web/vieni-avanti.htm vieni avanti cretino] [http://jututor.125mb.com/lib/cantante-napoletana/ cantante napoletana valentina stella] [http://coarmago.freeweb7.com/library/html/d-link.htm d link modem] [http://lamcgie.t35.com/web/pagine-bianche.htm pagine bianche treviso] [http://fergus-mac.somee.com/description/lib/carinci-aggiornamenti/ carinci aggiornamenti] [http://dj-deus.somee.com/lib/www-onuitalia.htm www onuitalia it] [http://ouquaite.freeweb7.com/img/styles/linkin-aprk/ linkin aprk] [http://itgurney.t35.com/view/new/hey-mama/ hey mama black eyed peace] [http://dj-deus.somee.com/lib/ostaggi-curdi.htm ostaggi curdi] [http://jututor.125mb.com/lib/alimentatore-stabilizzato/ alimentatore stabilizzato per] [http://lamcgie.t35.com/web/spoolsv.htm spoolsv] [http://lamcgie.t35.com/web/il-vento.htm il vento nei salici] [http://lakitsmi.freeweb7.com/web/cristina-d/ cristina d avena e i tuoi amici in tv 17] [http://jedillar.125mb.com/resources/articles/tiempo-mystic/ tiempo mystic] [http://de-der.somee.com/library/html/conoscienze-via.htm conoscienze via chat] [http://am-i-bird.somee.com/img/styles/computer-pc.htm computer pc] [http://nairoz.somee.com/img/styles/bengo/ bengo] [http://jedillar.125mb.com/resources/articles/peugeot-/ peugeot 1.4 xs] [http://rimarsh.t35.com/images/small/www-passeggino.htm www passeggino carrozzina chicco it] [http://am-i-bird.somee.com/img/styles/canzone-adagio.htm canzone adagio] [http://dj-deus.somee.com/lib/le-braghe.htm le braghe del padrone] [http://davelovesyou.somee.com/library/html/il-goleador/ il goleador stadium] [http://dj-deus.somee.com/lib/albergo-.htm albergo 3 stelle umbria] [http://am-i-bird.somee.com/img/styles/astuccio-per.htm astuccio per orologi] [http://luallard.t35.com/html/micro-hi/ micro hi fi teac] [http://dabeutle.t35.com/content/view/pat-love.htm pat love] [http://thegoogly.somee.com/view/new/nino-di.htm nino di angeli] [http://trocterli.t35.com/img/styles/www-coming/ www coming soon com] [http://jututor.125mb.com/lib/telwin-spa/ telwin spa] [http://dabeutle.t35.com/content/view/dominiche.htm dominiche] [http://luallard.t35.com/html/marco-travaglio/ marco travaglio] [http://nairoz.somee.com/img/styles/telios-hoover/ telios hoover] [http://jedillar.125mb.com/resources/articles/discoteche-e/ discoteche e locali notturni bologna] [http://fergus-mac.somee.com/description/lib/simcity/ simcity 4] [http://thegoogly.somee.com/view/new/mechanic-pump.htm mechanic pump program software] [http://itgurney.t35.com/view/new/letra-de/ letra de danzare] [http://coarmago.freeweb7.com/library/html/la-comunicazione.htm la comunicazione visiva nel vangelo di] [http://de-der.somee.com/library/html/leoluca-orlando.htm leoluca orlando] [http://fergus-mac.somee.com/description/lib/win-tv/ win tv nova ci s] [http://peter-land.somee.com/images/small/dj-nano.htm dj nano] [http://itgurney.t35.com/view/new/pianta-di/ pianta di mestre] [http://nairoz.somee.com/img/styles/lacie-d/ lacie d2 hard drive extreme] [http://jedillar.125mb.com/resources/articles/wild-animals/ wild animals] [http://dabeutle.t35.com/content/view/drago-finale.htm drago finale] [http://coarmago.freeweb7.com/library/html/plastici-ferroviari.htm plastici ferroviari] [http://fawarfo.freeweb7.com/topic/scarichi-per.htm scarichi per moto honda] [http://quotes-girl.somee.com/content/view/patrick-park/ patrick park] [http://quotes-girl.somee.com/content/view/hotel-monaco/ hotel monaco] [http://coarmago.freeweb7.com/library/html/concessionari-fiat.htm concessionari fiat roma] [http://luallard.t35.com/html/especies-en/ especies en peligro de extincion] [http://kiboukni.125mb.com/web/scanner-per/ scanner per negativi 4490] [http://dabeutle.t35.com/content/view/tu-come.htm tu come stai] [http://jututor.125mb.com/lib/rover/ rover 220] [http://kiboukni.125mb.com/web/www-la/ www la pelle it] [http://coarmago.freeweb7.com/library/html/happy-xmas.htm happy xmas john lennon] [http://quotes-girl.somee.com/content/view/ornito/ ornito-] [http://fawarfo.freeweb7.com/topic/pista-mi.htm pista mi inmortal] [http://dabeutle.t35.com/content/view/john-butler.htm john butler trio] [http://dj-deus.somee.com/lib/sicilia-vacanza.htm sicilia vacanza] [http://ouquaite.freeweb7.com/img/styles/barit-george/ barit, george] [http://luallard.t35.com/html/video-gf/ video gf inglese] [http://fergus-mac.somee.com/description/lib/motorizzato-parabola/ motorizzato parabola parabole] [http://dabeutle.t35.com/content/view/guscio-per.htm guscio per samsung] [http://madavid.t35.com/html/hasta-cuando/ hasta cuando] [http://rimarsh.t35.com/images/small/gallerie-fotografiche.htm gallerie fotografiche porno gratis] [http://peter-land.somee.com/images/small/voglio-vivere.htm voglio vivere cosi] [http://itgurney.t35.com/view/new/it-play/ it play yahho com] [http://nationavce.somee.com/library/html/geforce-le/ geforce 6800le 128mb tv dvi] [http://nairoz.somee.com/img/styles/dynasty-street/ dynasty street] [http://nairoz.somee.com/img/styles/photoshop-elements/ photoshop elements] [http://dj-deus.somee.com/lib/conan-ragazzo.htm conan ragazzo del futuro] [http://betheresa.t35.com/text/directory/foto-telefonini/ foto telefonini samsung] [http://fergus-mac.somee.com/description/lib/cascadia-foto/ cascadia foto] [http://jedillar.125mb.com/resources/articles/exosat/ exosat] [http://quotes-girl.somee.com/content/view/testi-canzoni/ testi canzoni di grease] [http://nationavce.somee.com/library/html/galaxie-ball/ galaxie ball] [http://flheddina.t35.com/web/golf-/ golf 1 9 tdi comfortline] [http://coarmago.freeweb7.com/library/html/stampanti-multifunzione.htm stampanti multifunzione di rete] [http://dj-deus.somee.com/lib/hi-fi.htm hi fi onkyo] [http://trocterli.t35.com/img/styles/victory-is/ victory is won] [http://ouquaite.freeweb7.com/img/styles/addii-al/ addii al celibato] [http://nairoz.somee.com/img/styles/giochi-d/ giochi d acqua] [http://trocterli.t35.com/img/styles/leslie-et/ leslie et amine] [http://davelovesyou.somee.com/library/html/lettori-mp/ lettori mp3 con batteria litio] [http://coarmago.freeweb7.com/library/html/hp-.htm hp - c4844a] [http://luallard.t35.com/html/airone-voli/ airone voli aerei] [http://rimarsh.t35.com/images/small/canon-eosd.htm canon eos-350d] [http://dabeutle.t35.com/content/view/mohicani.htm mohicani] [http://am-i-bird.somee.com/img/styles/collezione-orologio.htm collezione orologio donna] [http://thegoogly.somee.com/view/new/nonna-troia.htm nonna troia] [http://peter-land.somee.com/images/small/foto-kledi.htm foto kledi kadiu] [http://lamcgie.125mb.com/html/piveteau-jean.htm piveteau, jean] [http://lamcgie.t35.com/web/audigy-nx.htm audigy nx] [http://viemalin.freeweb7.com/resources/articles/zampogna.htm zampogna] [http://flheddina.t35.com/web/sede-vacante/ sede vacante] [http://nairoz.somee.com/img/styles/il-gambero/ il gambero rosso] [http://dabeutle.t35.com/content/view/leva-voce.htm leva voce mp3] [http://davelovesyou.somee.com/library/html/registratore-dvd/ registratore dvd hd] [http://lamcgie.125mb.com/html/www-enciclopedia.htm www enciclopedia it] [http://peter-land.somee.com/images/small/notebook-toschiba.htm notebook toschiba] [http://viemalin.freeweb7.com/resources/articles/francobolli-san.htm francobolli san marino] [http://ouquaite.freeweb7.com/img/styles/preparatori-moto/ preparatori moto] [http://nationavce.somee.com/library/html/prime-immagini/ prime immagini per unreal tournament 2004] [http://viemalin.freeweb7.com/resources/articles/i-crocifissi.htm i crocifissi nelle scuole commento] [http://viemalin.freeweb7.com/resources/articles/cover-ps.htm cover ps2] [http://trocterli.t35.com/img/styles/renda-francesco/ renda francesco] [http://yourorus.somee.com/data/piero-buscemi.htm piero buscemi] [http://rihelm.125mb.com/img/styles/batteria-per/ batteria per compaq presario 2800] [http://davelovesyou.somee.com/library/html/bora/ bora] [http://peter-land.somee.com/images/small/codici-per.htm codici per cellulari] [http://rimarsh.t35.com/images/small/cifra-canal.htm cifra canal] [http://am-i-bird.somee.com/img/styles/tj.htm tj] [http://lamcgie.t35.com/web/rivombrosa-sexy.htm rivombrosa sexy] [http://davelovesyou.somee.com/library/html/www-virtuagirl/ www virtuagirl2 com] [http://lamcgie.t35.com/web/ghostbuster.htm ghostbuster] [http://lamcgie.t35.com/web/sigla-manga.htm sigla manga] [http://jututor.125mb.com/lib/dr/ dr 7400] [http://luallard.t35.com/html/gha-ndi/ gha ndi] [http://lensman.somee.com/html/pondok-putri/ pondok putri] [http://nairoz.somee.com/img/styles/troia-matura/ troia matura] [http://betheresa.t35.com/text/directory/dschola-it/ dschola it] [http://lakitsmi.freeweb7.com/web/netgear-wgis/ netgear wg102is] [http://peter-land.somee.com/images/small/orari-pulman.htm orari pulman] [http://peter-land.somee.com/images/small/lavoro-piu.htm lavoro piu] [http://luallard.t35.com/html/max-fornari/ max fornari] [http://am-i-bird.somee.com/img/styles/password-messenger.htm password messenger] [http://lamcgie.125mb.com/html/agriturismo-crotone.htm agriturismo crotone] [http://lakitsmi.freeweb7.com/web/yu-yu/ yu yu hakusho. ghost fighters. box 5] [http://jututor.125mb.com/lib/royal-gigolo/ royal gigolo california dreamin mp3 free] [http://rimarsh.t35.com/images/small/la-ragazza.htm la ragazza del vagone letto] [http://nationavce.somee.com/library/html/sierra-entertainment/ sierra entertainment] [http://quotes-girl.somee.com/content/view/tutte-facolta/ tutte facolta universitarie di napoli] [http://fergus-mac.somee.com/description/lib/massimo-urbani/ massimo urbani tabs] [http://nationavce.somee.com/library/html/la-mede/ la mede] [http://jedillar.125mb.com/resources/articles/sensori/ sensori] [http://betheresa.t35.com/text/directory/gard-dipartimento/ gard (dipartimento)] [http://am-i-bird.somee.com/img/styles/jinhae.htm jinhae] [http://madavid.t35.com/html/gallup-agenzia/ gallup (agenzia statunitense)] [http://dj-deus.somee.com/lib/coffee-shop.htm coffee shop] [http://fawarfo.freeweb7.com/topic/albergo-menton.htm albergo menton] [http://coarmago.freeweb7.com/library/html/devo-the.htm devo. the complete truth about de-evolution. devo live] [http://lensman.somee.com/html/ricetta-muffin/ ricetta muffin] [http://nationavce.somee.com/library/html/digital-camera/ digital camera hp r717] [http://kiboukni.125mb.com/web/cartoon-porno/ cartoon porno online gratis] [http://lakitsmi.freeweb7.com/web/motorola-usb/ motorola usb driver] [http://flheddina.t35.com/web/tavolo-rotondo/ tavolo rotondo] [http://jedillar.125mb.com/resources/articles/annuncio-privato/ annuncio privato casa] [http://peter-land.somee.com/images/small/una-casa.htm una casa in bilico] [http://madavid.t35.com/html/gyro-all/ gyro all] [http://nationavce.somee.com/library/html/mario-cut/ mario cut] [http://lamcgie.t35.com/web/phantom-opera.htm phantom opera] [http://dabeutle.t35.com/content/view/volo-riva.htm volo riva garda] [http://lamcgie.t35.com/web/vids-mjpg.htm vids mjpg] [http://quotes-girl.somee.com/content/view/indirizzi-azienda/ indirizzi azienda] [http://itgurney.t35.com/view/new/foto-crimini/ foto crimini di guerra] [http://lamcgie.t35.com/web/edward-clug.htm edward clug] [http://rimarsh.t35.com/images/small/alfa-.htm alfa 166 jtd] [http://nairoz.somee.com/img/styles/boys-boys/ boys boys boys] [http://lamcgie.t35.com/web/i-figli.htm i figli di nessuno] [http://nairoz.somee.com/img/styles/pfm-spa/ pfm spa] [http://nationavce.somee.com/library/html/kad-te/ kad te druga] [http://betheresa.t35.com/text/directory/morte-di/ morte di umberto agnelli] [http://nairoz.somee.com/img/styles/gucci-gg/ gucci gg 2711] [http://viemalin.freeweb7.com/resources/articles/hotel-in.htm hotel in thailand] [http://trocterli.t35.com/img/styles/accessori-nikon/ accessori nikon 5900] [http://davelovesyou.somee.com/library/html/key-page/ key page] [http://madavid.t35.com/html/classificazione-della/ classificazione della cellula] [http://kiboukni.125mb.com/web/daniela-nane/ daniela nane] [http://fergus-mac.somee.com/description/lib/satiricosissimo/ satiricosissimo] [http://rihelm.125mb.com/img/styles/la-famiglia/ la famiglia come risorsa conoscitiva] [http://coarmago.freeweb7.com/library/html/gonne-di.htm gonne di jeans diesel] [http://lakitsmi.freeweb7.com/web/jbl-mp/ jbl mp3] [http://quotes-girl.somee.com/content/view/fred-perry/ fred perry camicia] [http://viemalin.freeweb7.com/resources/articles/foto-anna.htm foto anna edwards] [http://jedillar.125mb.com/resources/articles/jen-rosendahl/ jen rosendahl pics] This is the recipie for changing who apparently deposited an eprint. It requires logging into mysql and running the commands by hand.
  
 
First you need to know the userid number of the "from" user and the "to" user. Given their usernames we can find out their userid's. Replace USERNAME_GOES_HERE with the username of the user you want to find the ID of.
 
First you need to know the userid number of the "from" user and the "to" user. Given their usernames we can find out their userid's. Replace USERNAME_GOES_HERE with the username of the user you want to find the ID of.

Revision as of 11:45, 22 August 2007

sunburn caricabatterie pile underworld 8 ball athlon 64 mobile pioneer dvd r bari sud si la ves de sin banderas nelli furtado forca tv lcd philips 26 trasloco frocetto van de strof nuova smart forfour diesel auto nuove km 005 screensaver del signore degli anello perle coltivate www alessio it forno elettrico ad incasso cardiofrequenzimetro cs100 piccolo uomo testo mia martini euprepio curto canon fax-l380 telefoni cellulari con lettore mp3 ricetrasmettitori libero utilizzo assicurazione biella vieni avanti cretino cantante napoletana valentina stella d link modem pagine bianche treviso carinci aggiornamenti www onuitalia it linkin aprk hey mama black eyed peace ostaggi curdi alimentatore stabilizzato per spoolsv il vento nei salici cristina d avena e i tuoi amici in tv 17 tiempo mystic conoscienze via chat computer pc bengo peugeot 1.4 xs www passeggino carrozzina chicco it canzone adagio le braghe del padrone il goleador stadium albergo 3 stelle umbria astuccio per orologi micro hi fi teac pat love nino di angeli www coming soon com telwin spa dominiche marco travaglio telios hoover discoteche e locali notturni bologna simcity 4 mechanic pump program software letra de danzare la comunicazione visiva nel vangelo di leoluca orlando win tv nova ci s dj nano pianta di mestre lacie d2 hard drive extreme wild animals drago finale plastici ferroviari scarichi per moto honda patrick park hotel monaco concessionari fiat roma especies en peligro de extincion scanner per negativi 4490 tu come stai rover 220 www la pelle it happy xmas john lennon ornito- pista mi inmortal john butler trio sicilia vacanza barit, george video gf inglese motorizzato parabola parabole guscio per samsung hasta cuando gallerie fotografiche porno gratis voglio vivere cosi it play yahho com geforce 6800le 128mb tv dvi dynasty street photoshop elements conan ragazzo del futuro foto telefonini samsung cascadia foto exosat testi canzoni di grease galaxie ball golf 1 9 tdi comfortline stampanti multifunzione di rete hi fi onkyo victory is won addii al celibato giochi d acqua leslie et amine lettori mp3 con batteria litio hp - c4844a airone voli aerei canon eos-350d mohicani collezione orologio donna nonna troia foto kledi kadiu piveteau, jean audigy nx zampogna sede vacante il gambero rosso leva voce mp3 registratore dvd hd www enciclopedia it notebook toschiba francobolli san marino preparatori moto prime immagini per unreal tournament 2004 i crocifissi nelle scuole commento cover ps2 renda francesco piero buscemi batteria per compaq presario 2800 bora codici per cellulari cifra canal tj rivombrosa sexy www virtuagirl2 com ghostbuster sigla manga dr 7400 gha ndi pondok putri troia matura dschola it netgear wg102is orari pulman lavoro piu max fornari password messenger agriturismo crotone yu yu hakusho. ghost fighters. box 5 royal gigolo california dreamin mp3 free la ragazza del vagone letto sierra entertainment tutte facolta universitarie di napoli massimo urbani tabs la mede sensori gard (dipartimento) jinhae gallup (agenzia statunitense) coffee shop albergo menton devo. the complete truth about de-evolution. devo live ricetta muffin digital camera hp r717 cartoon porno online gratis motorola usb driver tavolo rotondo annuncio privato casa una casa in bilico gyro all mario cut phantom opera volo riva garda vids mjpg indirizzi azienda foto crimini di guerra edward clug alfa 166 jtd boys boys boys i figli di nessuno pfm spa kad te druga morte di umberto agnelli gucci gg 2711 hotel in thailand accessori nikon 5900 key page classificazione della cellula daniela nane satiricosissimo la famiglia come risorsa conoscitiva gonne di jeans diesel jbl mp3 fred perry camicia foto anna edwards jen rosendahl pics This is the recipie for changing who apparently deposited an eprint. It requires logging into mysql and running the commands by hand.

First you need to know the userid number of the "from" user and the "to" user. Given their usernames we can find out their userid's. Replace USERNAME_GOES_HERE with the username of the user you want to find the ID of.

SELECT userid FROM users WHERE username='USERNAME_GOES_HERE';

The response will be something like this:

 -------- 
| userid |
 -------- 
|     23 |
 -------- 
1 row in set (0.00 sec)

That means they are userid 23. Do this for both the user you are moving eprints from and the one you are moving them to.

!! Moving EPrints in the live repository

To just transfer eprints in the main repository: (replace TO_USERID and FROM_USERID with the numbers you just found out).

UPDATE archive SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;

!! Moving all EPrints

If you want to apppy the change to the user workarea, editorial review etc. you need to run the SQL for all four tables:

UPDATE inbox SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;
UPDATE archive SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;
UPDATE buffer SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;
UPDATE deletion SET userid=TO_USER_ID WHERE userid=FROM_USER_ID;

!! Metadata (abstract) pages

The eprint metadata summary pages will not be updated with this new information until you run:

/bin/generate_abstracts ARCHIVE_ID