Do all your db tables have the same charset and collation?
I would maybe try using the --tables option of migrateActors.php to do each
table one at a time to try and narrow down where the problem is.
--
Bawolff
On Wednesday, August 10, 2022, Xavier Humbert via MediaWiki-l <
mediawiki-l@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 :
>
> 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: yvdbog...@archixl.nl
>
> Afwezig op maandag
>
> On 10 Aug 2022, at 10:36, Xavier Humbert via MediaWiki-l <
> mediawiki-l@lists.wikimedia.org> 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@lists.wikimedia.org> 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@lists.wikimedia.org
> To unsubscribe send an email to mediawiki-l-le...@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@lists.wikimedia.org
> To unsubscribe send an email to mediawiki-l-le...@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@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
>
>
_______________________________________________
MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org
To unsubscribe send an email to mediawiki-l-le...@lists.wikimedia.org
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
