Topic on Project:Support desk

duplicate actor entry upgrading from 1.32 -> 1.33

11
This post was hidden by 182.232.196.131 (history)
Malyacko (talkcontribs)

The output that you posted says "Did you forget to run your application's database schema updater after upgrading?". That's the first idea...?

Unibond (talkcontribs)

Thanks Malyacko, but I got that error whilst it was upgrading.

65.50.203.13 (talkcontribs)

This happens while running the application's database schema updater, as the topic states. It's happening also for me.

Ciencia Al Poder (talkcontribs)

I've created phab:T229092 for investigation. Any further information about how an actor ended up with an empty name would be greatly useful for resolving this problem. See also Topic:V467iyg07vqsrdwy

Unibond (talkcontribs)

If you would like any queries run please let me know.

Rmnguyen (talkcontribs)

Hi, I'm also experiencing the duplicate actor entry with MW1.33 after importing a MySQL dump from MW1.19. Update.php first complains about missing columns as described in T227662, for which I manually add the columns similarly to @Bttfvgo's workaround. Eventually I encounter the duplicate entry which I try deleting but the error repeats and the duplicate entry recreated.

Ciencia Al Poder (talkcontribs)

I guess for now the best solution is to set $wgActorTableSchemaMigrationStage = SCHEMA_COMPAT_OLD; in LocalSettings.php before running the update.php script until the bug is fixed.

Unibond (talkcontribs)

Thanks, I tried adding $wgActorTableSchemaMigrationStage = SCHEMA_COMPAT_OLD; in LocalSettings.php and the update then completed when run from the command line.

However when I then tried to access the wiki ...

A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT ipb_id,ipb_address,ipb_timestamp,ipb_auto,ipb_anon_only,ipb_create_account,ipb_enable_autoblock,ipb_expiry,ipb_deleted,ipb_block_email,ipb_allow_usertalk,ipb_parent_block_id,ipb_reason AS `ipb_reason_text`,NULL AS `ipb_reason_data`,NULL AS `ipb_reason_cid`,ipb_by,ipb_by_text,NULL AS `ipb_by_actor` FROM `ipblocks` WHERE ipb_address IN ('127.0.0.1','127.0.0.1') OR ((ipb_range_start LIKE '7F00%' ESCAPE '`' ) AND (ipb_range_start <= '7F000001') AND (ipb_range_end >= '7F000001'))

Function: Block::newLoad

Error: 1054 Unknown column 'ipb_reason' in 'field list' (127.0.0.1)


Ciencia Al Poder (talkcontribs)

Looks like you have an old MediaWiki extension installed, or an extension not compatible, because the ipb_reason column of the ipblocks table has been deleted in 1.33 and no code path should be accessing it.

Uninstall all extensions, try again, and enable them one by one until you find out which one is the correct one.

Another option may be that your database was upgraded to 1.33 but you rolled-back MediaWiki to 1.32. That's not supported and you'll get a broken wiki.

This post was hidden by Unibond (history)
Reply to "duplicate actor entry upgrading from 1.32 -> 1.33"