Re: Cannot upgrade past 1.33.4

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: [email protected]
>>
>> Afwezig op maandag
>>
>>> On 10 Aug 2022, at 10:36, Xavier Humbert via MediaWiki-l 
>>> <[email protected]> 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 
>>>>>> <[email protected]> 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 -- [email protected]
>>>>>> To unsubscribe send an email to [email protected]
>>>>>> 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 -- [email protected]
>>> To unsubscribe send an email to [email protected]
>>> 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 [email protected]
> To unsubscribe send an email [email protected]
> 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 -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/