User Details
- User Since
- Jan 8 2018, 12:38 AM (328 w, 5 d)
- Availability
- Available
- LDAP User
- Unknown
- MediaWiki User
- Iowajason [ Global Accounts ]
Jul 22 2019
maintenance/migrateActors.php running after following SQL commands executed against MySQL DB:
Wiki working once migrateComments issue remediated. maintenance/migrateActors.php still failing, but not preventing wiki from functioning. MigrateActors previously did a lengthy step on "Beginning migration of revision.rev_user and revision.rev_user_text to revision_actor_temp.revactor_actor". Now, I see:
c:\localpath\maintenance>php migrateactors.php
Creating actor entries for all registered users
... 1 - 1
Completed actor creation, added 0 new actor(s)
Beginning migration of revision.rev_user and revision.rev_user_text to revision_actor_temp.revactor_actor
Completed migration, updated 0 row(s) with 0 new actor(s), 0 error(s)
Beginning migration of archive.ar_user and archive.ar_user_text to archive.ar_actor
[4a72608562cbb816c1e72081] [no req] Wikimedia\Rdbms\DBQueryError from line 1587 of C:\Users\Public\Documents\website\RTWWiki\includes\libs\rdbms\database\Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT ar_id,ar_user,ar_user_text,CASE WHEN ar_user = 0 OR ar_user IS NULL THEN (SELECT actor_id FROM actor WHERE (ar_user_text = actor_name) ) ELSE (SELECT actor_id FROM actor WHERE (ar_user = actor_user) ) END AS actor_id FROM archive WHERE ar_actor = '0' AND (1=1) ORDER BY ar_id LIMIT 100
Function: MigrateActors::migrate
Error: 1054 Unknown column 'ar_actor' in 'where clause' (localhost)
Jul 11 2019
Added requested details on support desk page.
Jul 10 2019
Similar problem with 1.32.x to 1.33 upgrade of migrateComments script, except on column 'pt_reason_id'. Checked MySQL schema and column does not exist in database. DB is MySQL Community 8.0.16. No settings in LocalSettings that seem to be migration related.