Hi Xavier,
No problem; but one more last question; did you do it on a clean upgrade?
In other words; you’ll need to do it on a clean upgrade; not after everything
is broken :-P
Hopefully you manage to sort it.
Youri.
> On 10 Aug 2022, at 11:15, 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 <mailto:yvdbog...@archixl.nl>
>>>
>>> Afwezig op maandag
>>>
>>>> On 10 Aug 2022, at 10:36, Xavier Humbert via MediaWiki-l
>>>> <mediawiki-l@lists.wikimedia.org <mailto: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
>>>>>>> <mailto: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
>>>>>>> <mailto:mediawiki-l@lists.wikimedia.org>
>>>>>>> To unsubscribe send an email to mediawiki-l-le...@lists.wikimedia.org
>>>>>>> <mailto:mediawiki-l-le...@lists.wikimedia.org>
>>>>>>> https://lists.wikimedia.org/postorius/lists/mediawiki-l.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
>>>> <mailto:mediawiki-l@lists.wikimedia.org>
>>>> To unsubscribe send an email to mediawiki-l-le...@lists.wikimedia.org
>>>> <mailto:mediawiki-l-le...@lists.wikimedia.org>
>>>> https://lists.wikimedia.org/postorius/lists/mediawiki-l.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
>> <mailto:mediawiki-l@lists.wikimedia.org>
>> To unsubscribe send an email to mediawiki-l-le...@lists.wikimedia.org
>> <mailto:mediawiki-l-le...@lists.wikimedia.org>
>> https://lists.wikimedia.org/postorius/lists/mediawiki-l.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/
_______________________________________________
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/
