Hi Youri, Non, I didn't, I'll give a try Thanks, Xavier Le 8/10/22 10:10, Youri van den Bogert a écrit :

Hi Xavier, Our upgrade process was:  - Run createAndPromote with a temporary user  - Then run migrate-actors.bash (see attached file, run with userid of temporary user)  - Then cleanupUsersWithNoId (with —force and —prefix *)  - Then migrateActors (with —force)  - Then update.php -- *Youri van den Bogert* T: + 31 6 38 76 69 23 E: yvdbogert(a)archixl.nl Afwezig op maandag

On 10 Aug 2022, at 11:15, Xavier Humbert via MediaWiki-l <mediawiki-l(a)lists.wikimedia.org> wrote: Grrr : # php maintenance/createAndPromote.php --sysop temp-admin *** => OK # ./migrate-actors.bash.txt -db pole -dbp mw_pole_ -s debserver -u *** -p *** -i 42 => OK # php maintenance/cleanupUsersWithNoId.php --prefix mw_pole_ --force => OK # php maintenance/migrateActors.php Query: INSERT INTO `mw_pole_actor` (actor_name) VALUES ('') Function: MigrateActors::addActorsForRows Error: 1062 Duplicate entry '' for key 'actor_name' (dbserver) I'm fed up, give up for now, I fear my database is corrupt beyond repair... I think about exporting all pages, and the reimporting in a fresh, empty wiki Many thanks anyway ! Xavier Le 8/10/22 10:47, Xavier Humbert via MediaWiki-l a écrit : Xavier Humbert CRT Supervision et Exploitation de Niveau 1 Rectorat de Nancy-Metz 03 83 86 27 39 _______________________________________________ MediaWiki-l mailing list -- mediawiki-l(a)lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave(a)lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/

Grrr : # php maintenance/createAndPromote.php --sysop temp-admin *** => OK # ./migrate-actors.bash.txt -db pole -dbp mw_pole_ -s debserver -u *** -p *** -i 42 => OK # php maintenance/cleanupUsersWithNoId.php --prefix mw_pole_ --force => OK # php maintenance/migrateActors.php Query: INSERT INTO `mw_pole_actor` (actor_name) VALUES ('') Function: MigrateActors::addActorsForRows Error: 1062 Duplicate entry '' for key 'actor_name' (dbserver) I'm fed up, give up for now, I fear my database is corrupt beyond repair... I think about exporting all pages, and the reimporting in a fresh, empty wiki Many thanks anyway ! Xavier Le 8/10/22 10:47, Xavier Humbert via MediaWiki-l a écrit : Hi Youri Thanks for your help, I'll try that Xavier Le 8/10/22 10:44, Youri van den Bogert a écrit : Hi Xavier, Our upgrade process was: - Run createAndPromote with a temporary user - Then run migrate-actors.bash (see attached file, run with userid of temporary user) - Then cleanupUsersWithNoId (with —force and —prefix *) - Then migrateActors (with —force) - Then update.php -- *Youri van den Bogert* T: + 31 6 38 76 69 23 E: yvdbogert(a)archixl.nl Afwezig op maandag On 10 Aug 2022, at 10:36, Xavier Humbert via MediaWiki-l < mediawiki-l(a)lists.wikimedia.org&gt; wrote: Unfortunately I've been hit by the infamous "User name "XXX" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation" Unfortunately, cleanupUsersWithNoId.php runs, report no error, and does not correct the problem. It is an already reported behavior And now, I know that the table prefix_actor is **crucial**, since without valid actor, the page is lost forever Xavier Le 8/10/22 10:11, Xavier Humbert via MediaWiki-l a écrit : Hi Youri, Non, I didn't, I'll give a try Thanks, Xavier Le 8/10/22 10:10, Youri van den Bogert a écrit : Hi Xavier, Did you run migrateActors before upgrading? We had similar issues; and the reason was that the user created the page was deleted. MigrateActors fixed the problem for us. Greets, Youri. On 10 Aug 2022, at 10:02, Xavier Humbert via MediaWiki-l < mediawiki-l(a)lists.wikimedia.org&gt; wrote: Hi, I've been asked to upgrade a very, very old wiki : it was version 1.25.6. I decided to do it step by step, ie release by release. I carefully backup-ed the database between each iteration, and ran maintenance/update.php Everything went fine until 1.34.4, when the vast majority of links were broken (Page does not exist yet) There were some stopper between 1.33 and 1.34 ? I read the release notes, update.php is intended to do the right job Thanks for help, Cheers, Xavier -- Xavier Humbert CRT Supervision et Exploitation de Niveau 1 Rectorat de Nancy-Metz 03 83 86 27 39 _______________________________________________ MediaWiki-l mailing list -- mediawiki-l(a)lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave(a)lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l. lists.wikimedia.org/ -- Xavier Humbert CRT Supervision et Exploitation de Niveau 1 Rectorat de Nancy-Metz 03 83 86 27 39 _______________________________________________ MediaWiki-l mailing list -- mediawiki-l(a)lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave(a)lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l. lists.wikimedia.org/ -- Xavier Humbert CRT Supervision et Exploitation de Niveau 1 Rectorat de Nancy-Metz 03 83 86 27 39 _______________________________________________ MediaWiki-l mailing list -- mediawiki-l(a)lists.wikimedia.org To unsubscribe send an email to mediawiki-l-leave@lists.wikimedia.orghttps://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/ -- Xavier Humbert CRT Supervision et Exploitation de Niveau 1 Rectorat de Nancy-Metz 03 83 86 27 39