The resurrection of atari-wiki.com

[exxos]

A quick AI created script later to delete the spam entries and clear up all tables relating to those entries... That saved me several hours work alone..

s1.PNG

s2.PNG

[exxos]

Right so new script to look for broken pages.. Thankfully there does not seem to be that many. Some of these could potentially still be spam anyway.

Code: Select all

Number 57327 found in page_latest, but not in rev_id.
Number 57327 found in page_latest, but no matches found in other tables.
Number 5533370 found in page_latest, but not in rev_id.
Number 5533370 found in page_latest, but no matches found in other tables.
Number 5533362 found in page_latest, but not in rev_id.
Number 5533362 found in page_latest, but no matches found in other tables.
Number 5533366 found in page_latest, but not in rev_id.
Number 5533366 found in page_latest, but no matches found in other tables.
Number 18612 found in page_latest, but not in rev_id.
Number 18612 found in page_latest, but no matches found in other tables.
Number 4934269 found in page_latest, but not in rev_id.
Number 4934269 found in page_latest, but no matches found in other tables.
Number 5533360 found in page_latest, but not in rev_id.
Number 5533360 found in page_latest, but no matches found in other tables.
Number 52221 found in page_latest, but not in rev_id.
Number 52221 found in page_latest, but no matches found in other tables.

I know 52221 is @troed's STE scanlines article :hide: not sure what the other ones yet but they still exist in the original database,so I will see how I can copy them back over.

[exxos]

That took some figuring out. It does not help that the original database is in a previous version of the wiki , the database is completely different structure wise , so I can't simply copy database entries over :(

Capture.PNG

So next to see what the other IDs actually are...

[exxos]

I seem to be going down the rabbit hole a bit now :roll:

The compact is listing page was missing. Though on temlib there was a edit in 2012. However in the database I got, last entry was actually 2006. So some entries have been completely deleted from the database (not by me) whereas the later copy actually exists on temlib.

So I am going through the database I have and then temlib to try and find whatever is the latest version.

Capture.PNG

I'm finding the quickest method is just to rename that page such as Automation999999999 because then the wiki will let me create a new page in that name. That way I can just simply copy and paste whatever copy seems to be the latest. Then just delete the renamed page.

So the top row is now the new entry and all the others are older ones. Slightly annoying as a timestamp seems to be missing from a lot of them.

2.PNG

EDIT:

So that *should* be other discrepancies found by the script sorted out. I'm still waiting for the log database to clear out :roll:

[exxos]

So everything seems fine as far as I can tell running version 25. Updating to 35 resulted in the same problem that half the pages disappeared :(

I have updated to version 27, but this ran incredibly quick so I don't think it really did anything.

Now I am waiting for version 30 to update to see if that breaks it or not. Though it seems to hung for several mins maxing out the CPU. So no idea what its doing. Will just leave it for a few hours and see what happens...

I still have the original database on my second server. Though that one hasn't even been updated to version 25 yet. So currently that script is running to update that. Then I will try updating to version 35 on the second server to see it is something I have messed up or the original database is more trashed than I thought..

Looking around the Internet some people claim using the web interface works differently than using the command line. So I may give that a try as well.

EDIT:

mediawiki-1.30.2 just finished and it seems fine also.
mediawiki-1.31.16 completed in a couple of seconds and also seems fine.
mediawiki-1.32.6 is doing a bunch of stuff...Done in 11 min 46 s... also seems fine...
mediawiki-1.33.1 next...and its broke while doing the below...

Code: Select all

MediaWiki 1.33.1 Updater

Your composer.lock file is up to date with current dependencies!
Going to run database updates for wiki
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds (skip this countdown with --quick) ... 0
Turning off Content Handler DB fields for this part of upgrade.
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...already have interwiki table
...indexes seem up to 20031107 standards.
...have rc_type field in recentchanges table.
...index new_name_timestamp already set on recentchanges table.
...have user_real_name field in user table.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...have pagelinks; skipping old links table updates
...il_from OK
...have rc_ip field in recentchanges table.
...index PRIMARY already set on image table.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...logging table already exists.
...have user_token field in user table.
...have wl_notificationtimestamp field in watchlist table.
...watchlist talk page rows already present.
...user table does not contain user_emailauthenticationtimestamp field.
...page table already exists.
...have log_params field in logging table.
...logging table has correct log_title encoding.
...have ar_rev_id field in archive table.
...have page_len field in page table.
...revision table does not contain inverse_timestamp field.
...have rev_text_id field in revision table.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...have user_email_token field in user table.
...have ar_text_id field in archive table.
...page_namespace is already a full int (int).
...ar_namespace is already a full int (int).
...rc_namespace is already a full int (int).
...wl_namespace is already a full int (int).
...qc_namespace is already a full int (int).
...log_namespace is already a full int (int).
...have img_media_type field in image table.
...already have pagelinks table.
...image table does not contain img_type field.
...already have unique user_name index.
...user_groups table exists and is in current format.
...have ss_total_pages field in site_stats table.
...user_newtalk table already exists.
...have iw_trans field in interwiki table.
...wl_notificationtimestamp is already nullable.
...index times already set on logging table.
...have ipb_range_start field in ipblocks table.
...no page_random rows needed to be set
...have user_registration field in user table.
...templatelinks table already exists
...externallinks table already exists.
...job table already exists.
...have ss_images field in site_stats table.
...langlinks table already exists.
...querycache_info table already exists.
...filearchive table already exists.
...have ipb_anon_only field in ipblocks table.
...index rc_ns_usertext already set on recentchanges table.
...index rc_user_text already set on recentchanges table.
...have user_newpass_time field in user table.
...redirect table already exists.
...querycachetwo table already exists.
...have ipb_enable_autoblock field in ipblocks table.
...index pl_namespace on table pagelinks includes field pl_from.
...index tl_namespace on table templatelinks includes field tl_from.
...index il_to on table imagelinks includes field il_from.
...have rc_old_len field in recentchanges table.
...have user_editcount field in user table.
...page_restrictions table already exists.
...have log_id field in logging table.
...have rev_parent_id field in revision table.
...have pr_id field in page_restrictions table.
...have rev_len field in revision table.
...have rc_deleted field in recentchanges table.
...have log_deleted field in logging table.
...have ar_deleted field in archive table.
...have ipb_deleted field in ipblocks table.
...have fa_deleted field in filearchive table.
...have ar_len field in archive table.
...have ipb_block_email field in ipblocks table.
...index cl_sortkey on table categorylinks includes field cl_from.
...have oi_metadata field in oldimage table.
...index usertext_timestamp already set on archive table.
...index img_usertext_timestamp already set on image table.
...index oi_usertext_timestamp already set on oldimage table.
...have ar_page_id field in archive table.
...have img_sha1 field in image table.
...protected_titles table already exists.
...have ipb_by_text field in ipblocks table.
...page_props table already exists.
...updatelog table already exists.
...category table already exists.
...category table already populated.
...have ar_parent_id field in archive table.
...have user_last_timestamp field in user_newtalk table.
...protected_titles table has correct pt_title encoding.
...have ss_active_users field in site_stats table.
...ss_active_users user count set...
...have ipb_allow_usertalk field in ipblocks table.
...change_tag table already exists.
...user_properties table already exists.
...log_search table already exists.
...have log_user_text field in logging table.
...l10n_cache table already exists.
...ct_rc_id key doesn't exist.
...have rd_interwiki field in redirect table.
...*_mime_minor fields are already long enough.
...iwlinks table already exists.
...index iwl_prefix_title_from already set on iwlinks table.
...have ul_value field in updatelog table.
...have iw_api field in interwiki table.
...iwl_prefix key doesn't exist.
...have cl_collation field in categorylinks table.
...categorylinks up-to-date.
...module_deps table already exists.
...ar_page_revid key doesn't exist.
...skipping index ar_revid because index ar_revid_uniq already set on archive table.
...ll_lang is up-to-date.
...user_last_timestamp is already nullable.
...index user_email already set on user table.
...up_property in table user_properties already modified by patch patch-up_property.sql.
...uploadstash table already exists.
...user_former_groups table already exists.
...have rev_sha1 field in revision table.
...batch conversion of user_options: nothing to migrate. done.
...user table does not contain user_options field.
...have ar_sha1 field in archive table.
...index page_redirect_namespace_len already set on page table.
...have us_chunk_inx field in uploadstash table.
...have job_timestamp field in job table.
...index page_user_timestamp already set on revision table.
...have ipb_parent_block_id field in ipblocks table.
...index ipb_parent_block_id already set on ipblocks table.
...category table does not contain cat_hidden field.
...have rev_content_format field in revision table.
...have rev_content_model field in revision table.
...have ar_content_format field in archive table.
...have ar_content_model field in archive table.
...have page_content_model field in page table.
Content Handler DB fields should be usable now.
...site_stats table does not contain ss_admins field.
...recentchanges table does not contain rc_moved_to_title field.
...sites table already exists.
...have fa_sha1 field in filearchive table.
...have job_token field in job table.
...have job_attempts field in job table.
...have us_props field in uploadstash table.
...ug_group in table user_groups already modified by patch patch-ug_group-length-increase-255.sql.
...ufg_group in table user_former_groups already modified by patch patch-ufg_group-length-increase-255.sql.
...index pp_propname_page already set on page_props table.
...index img_media_mime already set on image table.
...iwl_prefix_title_from index is already non-UNIQUE.
...index iwl_prefix_from_title already set on iwlinks table.
...have ar_id field in archive table.
...have el_id field in externallinks table.
...have rc_source field in recentchanges table.
...index log_user_text_type_time already set on logging table.
...index log_user_text_time already set on logging table.
...have page_links_updated field in page table.
...have user_password_expires field in user table.
...have pp_sortkey field in page_props table.
...recentchanges table does not contain rc_cur_time field.
...index wl_user_notificationtimestamp already set on watchlist table.
...have page_lang field in page table.
...have pl_from_namespace field in pagelinks table.
...have tl_from_namespace field in templatelinks table.
...have il_from_namespace field in imagelinks table.
...img_major_mime in table image already modified by patch patch-img_major_mime-chemical.sql.
...oi_major_mime in table oldimage already modified by patch patch-oi_major_mime-chemical.sql.
...fa_major_mime in table filearchive already modified by patch patch-fa_major_mime-chemical.sql.
...comment fields are up to date.
...hitcounter doesn't exist.
...site_stats table does not contain ss_total_views field.
...page table does not contain page_counter field.
...msg_resource_links doesn't exist.
...msg_resource doesn't exist.
...bot_passwords table already exists.
...have wl_id field in watchlist table.
...cl_collation key doesn't exist.
...index cl_collation_ext already set on categorylinks table.
...collations up-to-date.
...index rc_name_type_patrolled_timestamp already set on recentchanges table.
...rev_page_id index not found on revision.
...pl_namespace, tl_namespace, il_to indices are already non-UNIQUE.
...have ct_id field in change_tag table.
...rc_ip in table recentchanges already modified by patch patch-rc_ip_modify.sql.
...index usertext_timestamp already set on archive table.
...have el_index_60 field in externallinks table.
...ug_user_group key doesn't exist.
...have ug_expiry field in user_groups table.
...index img_user_timestamp already set on image table.
...img_media_type in table image already modified by patch patch-add-3d.sql.
...ip_changes table already exists.
...index PRIMARY already set on categorylinks table.
...index PRIMARY already set on templatelinks table.
...index PRIMARY already set on pagelinks table.
...index PRIMARY already set on text table.
...WARNING: old_id still exists, despite it has been renamed into PRIMARY (which also exists).
            old_id should be manually removed if not needed anymore.
...index PRIMARY already set on imagelinks table.
...index PRIMARY already set on iwlinks table.
...index PRIMARY already set on langlinks table.
...index PRIMARY already set on log_search table.
...index PRIMARY already set on module_deps table.
...index PRIMARY already set on objectcache table.
...index PRIMARY already set on querycache_info table.
...index PRIMARY already set on site_stats table.
...index PRIMARY already set on user_former_groups table.
...index PRIMARY already set on user_properties table.
...comment table already exists.
...revision_comment_temp table already exists.
...have ar_comment_id field in archive table.
...have fa_description_id field in filearchive table.
...img_description in table image already modified by patch patch-image-img_description-default.sql.
...have ipb_reason_id field in ipblocks table.
...have log_comment_id field in logging table.
...have oi_description_id field in oldimage table.
...have pt_reason_id field in protected_titles table.
...have rc_comment_id field in recentchanges table.
...rev_comment in table revision already modified by patch patch-revision-rev_comment-default.sql.
...have img_description_id field in image table.
Migrating comments to the 'comments' table, printing progress markers. For large
databases, you may want to hit Ctrl-C and do this manually with
maintenance/migrateComments.php.
Beginning migration of revision.rev_comment to revision_comment_temp.revcomment_comment_id
... 101
... 202
... 3099
... 3205
... 3333
... 3434
... 3534
... 3634
... 3734
... 3837
... 3937
... 4037
... 4139
... 4261
... 4362

Later...

Code: Select all

... 16800
... 16900
... 17000
... 17100
... 17200
... 5533435
... 1000000006
Completed migration, updated 4119 row(s) with 2242 new comment(s)
Beginning migration of archive.ar_comment to archive.ar_comment_id
... 100
... 200
... 300
... 400
... 500
... 600
... 700
... 800
... 900
... 1001
... 1102
... 1208
... 1324
... 1426

.......

Code: Select all

... 6407
... 6507
... 6607
... 6650
Completed migration, updated 6343 row(s) with 153 new comment(s)
Beginning migration of ipblocks.ipb_reason to ipblocks.ipb_reason_id
... 236
... 3593
... 4312
Completed migration, updated 284 row(s) with 12 new comment(s)
Beginning migration of image.img_description to image.img_description_id
... AVR-Pro-16-05.jpg
... CLAB_Falcon_MKX_Case_(4).jpg
... Expose_Digitiser_Titan_Designs_(2).jpg
... Happy_computers_discovery_cartridge_option_2_external_top.jpg
... Multiboard_ST_00.jpg
... ROM28.GIF
... Sm124.jpg
... U14.jpg
... Zipjr2.gif
Completed migration, updated 872 row(s) with 17 new comment(s)
Beginning migration of oldimage.oi_description to oldimage.oi_description_id
... ST_Motherboard_C070789-001_Rev_C_exxos2.jpg 20080927121714
... Ym2149.png 20060913135635
Completed migration, updated 144 row(s) with 9 new comment(s)
Beginning migration of filearchive.fa_deleted_reason to filearchive.fa_deleted_reason_id
... 32
Completed migration, updated 29 row(s) with 13 new comment(s)
Beginning migration of filearchive.fa_description to filearchive.fa_description_id
... 32
Completed migration, updated 29 row(s) with 3 new comment(s)
Beginning migration of recentchanges.rc_comment to recentchanges.rc_comment_id
... 7352200
... 7352268
Completed migration, updated 168 row(s) with 0 new comment(s)
Beginning migration of logging.log_comment to logging.log_comment_id
... 100
... 200
... 300
... 400
... 500
... 600
... 700
... 800
... 900
... 1000
... 1100
... 1200
... 1300
... 1400
... 1500
... 1600

..............

Code: Select all

... 5000
... 5100
... 5200
... 5300
... 1826694
... 1826794
... 1826848
Completed migration, updated 5554 row(s) with 215 new comment(s)
Beginning migration of protected_titles.pt_reason to protected_titles.pt_reason_id
Completed migration, updated 0 row(s) with 0 new comment(s)
done.
...index PRIMARY already set on l10n_cache table.
...bot_passwords.bp_user is already unsigned int.
...change_tag.ct_log_id is already unsigned int.
...change_tag.ct_rev_id is already unsigned int.
...page_restrictions.pr_user is already unsigned int.
...user_newtalk.user_id is already unsigned int.
...user_properties.up_user is already unsigned int.
...slots table already exists.
...have slot_origin field in slots table.
...content table already exists.
...slot_roles table already exists.
...content_models table already exists.
...actor table already exists.
...revision_actor_temp table already exists.
...have ar_actor field in archive table.
...have ipb_by_actor field in ipblocks table.
...have img_actor field in image table.
...have oi_actor field in oldimage table.
...have fa_actor field in filearchive table.
...have rc_actor field in recentchanges table.
...have log_actor field in logging table.
Migrating actors to the 'actor' table, printing progress markers. For large
databases, you may want to hit Ctrl-C and do this manually with
maintenance/migrateActors.php.
Creating actor entries for all registered users
... 1 - 101
... 102 - 202
... 203 - 303
... 304 - 404
... 405 - 505
... 506 - 606
... 607 - 707
... 708 - 808
... 809 - 909
... 910 - 1010
... 1011 - 1111
... 1112 - 1212
... 1213 - 1313
... 1314 - 1414
... 1415 - 1515
... 1516 - 1616
... 1617 - 1717
... 1718 - 1818
... 1819 - 1919
... 1920 - 2020
... 2021 - 2121
... 2122 - 2222
... 2223 - 2323
... 2324 - 2424
... 2425 - 2525

Anyway... So it broke right at the start doing something... but what though...

[exxos]

So looking around https://www.mediawiki.org/wiki/MediaWik ... own_issues which came from https://www.mediawiki.org/wiki/Topic:V35dno671xsssdgs

task T232273 Imported revisions of pages may disappear after the update. This can be worked around by running the maintenance script cleanupUsersWithNoId.php followed by migrateActors.php.

So I will try that when its restored my backup and updated to 1.33 again...

EDIT
So this didn't do much..

Code: Select all

php maintenance/cleanupUsersWithNoId.php --prefix '*' --table revision
Beginning cleanup of revision
... rev_timestamp=20200116224534 rev_id=52221
Completed cleanup, assigned 0 and prefixed 22 row(s)

Code: Select all

php maintenance/migrateActors.php

Did a load of stuff and ended with this..

Code: Select all

User name "Panthen10" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Magikgimp" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Ragnar76" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

... log_id=1826688
... log_id=1826696
Completed migration, updated 0 row(s) with 0 new actor(s), 3108 error(s)
Beginning migration of log_search
Completed migration, inserted 0 row(s) with 0 new actor(s), 0 error(s)

But I just ran maintenance/cleanupUsersWithNoId.php :roll:

On this page
https://www.mediawiki.org/wiki/Topic:Vy4x2pb18ebrvqix

It says..

81.174.133.236 (talkcontribs)
I had a very similar problem and this thread was very helpful, thank you. I was able to resolve with this SQL:

INSERT INTO revision_actor_temp (revactor_rev, revactor_actor, revactor_timestamp, revactor_page) SELECT rev_id, 1 as actor, rev_timestamp, rev_page FROM revision WHERE rev_id NOT IN (SELECT revactor_rev FROM revision_actor_temp);
I was not concerned with correctly matching up the actors (and indeed think this data is lost), so replaced all of them with actor 1 (Administrator on my wiki). All of the page revisions are now accessible again. The missing actors were old now non-existent users that must have been lost in the 1.31 to 1.35 migration somewhere.

Reply3 years ago
81.174.133.236 (talkcontribs)
I should add I needed to run php maintenance/update.php afterwards as well.

Reply

Oddly random pages display now but not the mainpage. But I don't know what fixes the other pages. So I will have to restore my DB and start again and see what happens at what point this time around...

[exxos]

Right, so V25 database restored. V33 wiki again.

Running update.php resulted in the main page and pretty much every random page clicked on is blank...

Capture.PNG

Code: Select all

php maintenance/cleanupUsersWithNoId.php --prefix '*' --table revision --force
Beginning cleanup of revision
... rev_timestamp=20200116224534 rev_id=52221
Completed cleanup, assigned 0 and prefixed 0 row(s)

So did nothing then.

Code: Select all

php maintenance/migrateActors.php

Did a bunch of stuff..

Code: Select all

User name "Exxos" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

... log_id=5041
... log_id=5141
User name "Adolobe" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

... log_id=5241
User name "Dazarz" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Tin" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Docrv" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Rockyone" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Rainwarrior" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Steelz" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Bikerbob" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Bigclaw" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Tomh" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Panthen10" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Magikgimp" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Ragnar76" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

... log_id=1826688
... log_id=1826696
Completed migration, updated 0 row(s) with 0 new actor(s), 3108 error(s)
Beginning migration of log_search
Completed migration, inserted 0 row(s) with 0 new actor(s), 0 error(s)

But still stuff broken.

At this point there is a belated updated script in which someone patched
gist.github.com/ciencia/7cbe63b8520d4816ec36733454a2cb9a

Code: Select all

PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228
PHP Notice:  Undefined variable: id in /var/www/html/mediawiki-1.33.1/maintenance/cleanupUsersWithNoId2.php on line 228

So I guess that did not work either.

running this 4949 rows before and 12489 after.

Code: Select all

INSERT INTO revision_actor_temp (revactor_rev, revactor_actor, revactor_timestamp, revactor_page) SELECT rev_id, 1 as actor, rev_timestamp, rev_page FROM revision WHERE rev_id NOT IN (SELECT revactor_rev FROM revision_actor_temp);

Now I clicked random pages about 20 times and they all seem to be loading now. Though the Aranym page still doesn't nor the mainpage.

running update.php again had now change..

But I guess it does give me a possible lead into what's wrong I guess :shrug:

Oddly now clicking EDIT page in the wiki and saving changes resulted in the pages now showing! So maybe there is finally some light at the end of the tunnel!

EDIT:

So running update.php again...

Code: Select all

User name "1632" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Krupkaj" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Catmando" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

So running cleanupUsersWithNoId.php ..

Code: Select all

php maintenance/cleanupUsersWithNoId.php --prefix '*' --table revision --force
Beginning cleanup of revision
... rev_timestamp=20070430003339 rev_id=8338
... rev_timestamp=20070903113920 rev_id=8660
... rev_timestamp=20080111174202 rev_id=8911
... rev_timestamp=20080706082724 rev_id=9082
... rev_timestamp=20081220014134 rev_id=9454
... rev_timestamp=20090502163515 rev_id=9602
... rev_timestamp=20090502184205 rev_id=9702
... rev_timestamp=20090503084152 rev_id=9804
... rev_timestamp=20090503092454 rev_id=9904
... rev_timestamp=20090503101440 rev_id=10004
... rev_timestamp=20090503204938 rev_id=10106
... rev_timestamp=20110410015859 rev_id=10245
... rev_timestamp=20110412115647 rev_id=10350
... rev_timestamp=20110414141726 rev_id=10456
... rev_timestamp=20110515111649 rev_id=10566
... rev_timestamp=20110516152634 rev_id=10669
... rev_timestamp=20110517121249 rev_id=10770
... rev_timestamp=20110520001021 rev_id=10870
... rev_timestamp=20110628234847 rev_id=10975
... rev_timestamp=20110712132633 rev_id=11080
... rev_timestamp=20110721125419 rev_id=11184
... rev_timestamp=20110728121556 rev_id=11285
... rev_timestamp=20110814155155 rev_id=11387
... rev_timestamp=20110829143409 rev_id=11510
... rev_timestamp=20110901000428 rev_id=11612
... rev_timestamp=20110906142642 rev_id=11712
... rev_timestamp=20111009050220 rev_id=11813
... rev_timestamp=20111011115301 rev_id=11914
... rev_timestamp=20111011144720 rev_id=12015
... rev_timestamp=20111012122600 rev_id=12115
... rev_timestamp=20111012142352 rev_id=12215
... rev_timestamp=20111012153237 rev_id=12316
... rev_timestamp=20111013122505 rev_id=12417
... rev_timestamp=20111015100127 rev_id=12522
... rev_timestamp=20111021121640 rev_id=12626
... rev_timestamp=20111129152420 rev_id=12727
... rev_timestamp=20111205153657 rev_id=12831
... rev_timestamp=20111208004248 rev_id=12931
... rev_timestamp=20120128163808 rev_id=13074
... rev_timestamp=20120219035745 rev_id=13174
... rev_timestamp=20120407092023 rev_id=13275
... rev_timestamp=20120517102721 rev_id=13391
... rev_timestamp=20120824220757 rev_id=13500
... rev_timestamp=20130308023355 rev_id=13602
... rev_timestamp=20140618195718 rev_id=13730
... rev_timestamp=20150304194047 rev_id=13832
... rev_timestamp=20150307185739 rev_id=13932
... rev_timestamp=20150312130240 rev_id=14032
... rev_timestamp=20150402090640 rev_id=14132
... rev_timestamp=20150430174952 rev_id=14232
... rev_timestamp=20150717230909 rev_id=14334
... rev_timestamp=20151019203701 rev_id=14434
... rev_timestamp=20151206233214 rev_id=14534
... rev_timestamp=20160114174234 rev_id=14694
... rev_timestamp=20160227184800 rev_id=14794
... rev_timestamp=20160228114841 rev_id=14894
... rev_timestamp=20160228170916 rev_id=14994
... rev_timestamp=20160229195448 rev_id=15094
... rev_timestamp=20160301231407 rev_id=15194
... rev_timestamp=20160303225431 rev_id=15294
... rev_timestamp=20160307194902 rev_id=15394
... rev_timestamp=20160310071437 rev_id=15494
... rev_timestamp=20160312141716 rev_id=15594
... rev_timestamp=20160313143012 rev_id=15694
... rev_timestamp=20160314230309 rev_id=15794
... rev_timestamp=20160320165034 rev_id=15894
... rev_timestamp=20160325195135 rev_id=15994
... rev_timestamp=20160327220205 rev_id=16094
... rev_timestamp=20160419170712 rev_id=16194
... rev_timestamp=20160423115751 rev_id=16294
... rev_timestamp=20160522184216 rev_id=16394
... rev_timestamp=20160605114207 rev_id=16494
... rev_timestamp=20160622212513 rev_id=16594
... rev_timestamp=20161028100355 rev_id=16696
... rev_timestamp=20190728070225 rev_id=17117
... rev_timestamp=20231114150904 rev_id=5533357
... rev_timestamp=20231114160306 rev_id=5533372
Completed cleanup, assigned 0 and prefixed 0 row(s)

Then running update.php again..

Same crap still..

Code: Select all

User name "Bikerbob" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Bigclaw" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Tomh" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Panthen10" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Magikgimp" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

User name "Ragnar76" is usable, cannot create an anonymous actor for it. Run maintenance/cleanupUsersWithNoId.php to fix this situation.

[exxos]

Seems after the V31 update 99% of the images have "vanished" now :roll: The actualy images are in the images folder and I can see them if I do a direct link to it from the browser. All the image info seems fine in the database. Just they not showing.

Capture.PNG

I think something is fundamentally broken with mediawiki in versions over 30 :roll:

One image which does work

Code: Select all

<img alt="AW3p20.PNG" src="/mediawiki-1.33.1/images/1/17/AW3p20.PNG" decoding="async" width="582" height="866">

Then one which doesn't..

Code: Select all

<a href="/mediawiki-1.33.1/index.php?title=Special:Upload&amp;wpDestFile=ST_system_3.jpg" class="new" title="File:ST system 3.jpg">File:ST system 3.jpg</a>

Bizzare..

[exxos]

I've admitted defeat and asked for help on the media wiki forum
https://www.mediawiki.org/wiki/Topic:Xucnucrmef7260ve

As people know I really despise going outside of this form and asking for help elsewhere because it always ends up me wishing I had not bothered for one reason or another. But there is really no alternative at this point :(

It really needs one of the developers to figure this out because I really don't want to spend the next six months reverse engineering the update script to work out what broke and why. Also considering some other people have reported the same issues with the same version it is not just me who is having this problem.

It seems to circle around the "actor" table (which I never touched) as they fix someone else posted seems to fix the majority of the missing pages. However there also seems to be some screwy path related problem with the images because 99% of them have "vanished". They are on the server and I can access them via direct URL.

It is pretty much my pet in having to reverse engineers someone else's software (or hardware!). It always seems to be the case :( I was pretty much ready to "go live" with the wiki and now I seem to be in a worse state than when I started. Though the wiki was working perfectly fine up until version 32. So I'm not sure this is related to anything I have done. Indeed I have not touched anything to do with the images etc. all the information still seems present in the database from what I can tell. So something is broken with the wiki engine itself I think somewhere.

Some I'm afraid this wiki project is going to be stalled until I can figure out why the updates are not working. :cry:

[troed]

No worries - I'm sure it's solvable. There's plenty of us here ready to step in so you don't need to feel all the burden on getting it to work is on you.