Re: Cannot upgrade past 1.33.4

Youri,

I did it on what was given to me. A running, even broken database.
I started from the last good (err...) backup

Hence the envy to export it all.

Cheers,

Xavier

Le 8/10/22 11:22, Youri van den Bogert a écrit :
> 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 
>> <[email protected]> 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: [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/
>
-- 
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/