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/
