Mediawiki, PHP, Database, Help

[Sin_Stalker]

Hi. So I thought I'd post this here as a last ditch effort before I try dealing with complete strangers on guru or upwork. It is CoH related.

 

Back when CoH was live, I was part of a group called the CCC (CoH Comic Creators). We had a site, cohcomicindex.com, which became mmocomicindex.com when some of them started making comics with other MMO games. It is a mediawiki site. There was a lot of information on there that we still use. 

 

Well, of course as soon as I am getting ready to start working on my own CoH comic again, I am informed that the mmocomicindex is down. I first found that there was an issue with the company I have the url registered with. I fix that and get the following error:

 

Searching, I found a few references to updating mediawiki and the extension Cite. That removed the top error. After hours, I then find out my host had changed PHP versions to one that wasn't compatible. It gets changed but something may have broken during the original updating I attempted.

 

I tried putting the original Mediawiki files back and I get a blank screen. I tried running wm-config file through the browser. At first it would be a blank white page. I then got it to go through the update process, where it is "updating" to 1.25 (what it was before all this mess happened). It wants to update the database to 1.25 and says it completes. However the process doesn't continue past that. I click continue and it just re-updates the database again.

 

If I try updating to 1.37, it now gets to the update database to 1.37 portion, but I get the following error:

 

Quote

...collations up-to-date.
...index rc_name_type_patrolled_timestamp already set on recentchanges table.
...rev_page_id index already non-unique.
...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.
...have el_index_60 field in externallinks table.
...ug_user_group key doesn't exist.
...have ug_expiry field in user_groups 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.
...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 field does not exist in image table, skipping modify field patch.
...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.
...have img_description_id field in image table.
...index PRIMARY already set on l10n_cache table.
...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.
...change_tag.ct_rc_id 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.
Changing 'revision.rev_text_id' default value.
...table site_stats already modified by patch patch-site_stats-modify.sql.
...index rc_namespace_title_timestamp already set on recentchanges table.
...change_tag_def table already exists.
Running maintenance/deduplicateArchiveRevId.php...
...Update 'DeduplicateArchiveRevId' already logged as completed. Use --force to run it again.
done.
...have ct_tag_id field in change_tag table.
...index ar_revid_uniq already set on archive table.
...index log_type_action already set on logging table.
...type_action key doesn't exist.
...index PRIMARY already set on interwiki table.
...index PRIMARY already set on page_props table.
...index PRIMARY already set on protected_titles table.
...index PRIMARY already set on site_identifiers table.
...index rc_this_oldid already set on recentchanges table.
...transcache doesn't exist.
Running maintenance/populateChangeTagDef.php...
...Update 'PopulateChangeTagDef' already logged as completed. Use --force to run it again.
done.
...change_tag_rc_tag key doesn't exist.
...have ipb_sitewide field in ipblocks table.
...ipblocks_restrictions table already exists.
...change_tag table does not contain ct_tag field.
...valid_tag doesn't exist.
...tag_summary doesn't exist.
...archive table does not contain ar_comment field.
...ipblocks table does not contain ipb_reason field.
...image table does not contain img_description field.
...oldimage table does not contain oi_description field.
...filearchive table does not contain fa_description field.
...recentchanges table does not contain rc_comment field.
...logging table does not contain log_comment field.
...protected_titles table does not contain pt_reason field.
...table job already modified by patch patch-job-params-mediumblob.sql.
...ar_usertext_timestamp key doesn't exist.
...usertext_timestamp key doesn't exist.
...archive table does not contain ar_user field.
...ipblocks table does not contain ip_by field.
...img_user_timestamp key doesn't exist.
...image table does not contain img_user field.
...oldimage table does not contain oi_user field.
...filearchive table does not contain fa_user field.
...recentchanges table does not contain rc_user field.
...logging table does not contain log_user field.
...index un_user_ip already set on user_newtalk table.
...watchlist_expiry table already exists.
...page_restrictions in table page already modified by patch patch-page_restrictions-null.sql.
...index ipb_address_unique already set on ipblocks table.
...have rev_actor field in revision table.
Table archive contains ar_text_id field. Dropping ...
An error occurred:
Error 1091: Can't DROP COLUMN `ar_content_model`; check that it exists (localhost)
Function: Wikimedia\Rdbms\Database::sourceFile( /home/jkcomi5/public_html/mmocomicindex.com/comicindex/maintenance/archives/patch-archive-MCR.sql )
Query: ALTER TABLE `archive`
 DROP COLUMN ar_text_id,
 DROP COLUMN ar_content_model,
 DROP COLUMN ar_content_format

 

 

That is as far as I have been able to get. People on upwork and guru want to charge be $300 to $500 to fix this and I can not currently afford this (freshly graduated college with no job yet and a wife that is a teacher). 

 

If there is someone here who can help, I can pay something on the order of $50 to $100 or ingame currency, or buy them something on steam or similar. The CoH community has had a few wikis over the years, like paragonwiki and now the HC wiki. So hoping someone can help.

 

Apologies if this is posted in the wrong spot. Thought it couldn't hurt to ask.

Edited January 31, 2022 by Sin_Stalker

[Shenanigunner]

I run a very complex, customized MediaWiki installation. It can be a headache when it gets out of date.

 

I suggest you do a clean, working installation of MW and all plugins, and then carefully load your old data into the new databases. Trying to update an old, broken installation from backups is... well, what you've found.

[Sin_Stalker]

6 hours ago, Shenanigunner said:

I run a very complex, customized MediaWiki installation. It can be a headache when it gets out of date.

 

I suggest you do a clean, working installation of MW and all plugins, and then carefully load your old data into the new databases. Trying to update an old, broken installation from backups is... well, what you've found.

 

When you say load the old data into the new database, do you mean manually or is there an automated way? I'm told that the current database is quite large. I wouldn't be able to manually recreate each page.

[Shenanigunner]

14 hours ago, Sin_Stalker said:

When you say load the old data into the new database, do you mean manually or is there an automated way? I'm told that the current database is quite large. I wouldn't be able to manually recreate each page.

 

Haven't been under the hood on MW for a while (I maintain sites of all kinds) but I think the basic process is do a clean new install, use whatever tools or scripts are available to update the old database, and import it. The version/update log should tell you everything you need to know to get from your version to what's current.

 

Make sure you server is using whatever versions of PHP, SQL etc. the app demands.

[Sin_Stalker]

3 hours ago, Shenanigunner said:

 

Haven't been under the hood on MW for a while (I maintain sites of all kinds) but I think the basic process is do a clean new install, use whatever tools or scripts are available to update the old database, and import it. The version/update log should tell you everything you need to know to get from your version to what's current.

 

Make sure you server is using whatever versions of PHP, SQL etc. the app demands.

 

Well I can't even setup a new wiki apparently. I am getting an error with a fresh database.

[Shenanigunner]

Verify that your host (and your account) are using the most current versions of PHP etc. (On my host, I can choose older versions but it's a bad idea.) Make sure you have an account/site/database slot available from your host.

 

Clean it all out and start with a fresh install. Can't do anything until the basic platform comes up working.

[Sin_Stalker]

1 hour ago, Shenanigunner said:

Verify that your host (and your account) are using the most current versions of PHP etc. (On my host, I can choose older versions but it's a bad idea.) Make sure you have an account/site/database slot available from your host.

 

Clean it all out and start with a fresh install. Can't do anything until the basic platform comes up working.

Found what I was doing wrong with that setup. Setup says it completed and put the local settings file that was generated. But now it is just the white screen of death. I even add in the code show to the errors and it all remains white. http://mmocomicindex.com/comicindex/

 

Current php version is 8.something. Well past the 7.4.3.

 

I have gotten a fresh installation working. I have no clue about MySQL. What tools or scripts do you use for your database?

 

Edited February 1, 2022 by Sin_Stalker

[Shenanigunner]

See if MediaWiki has an update utility, or if someone has written one. I know they exist for most other database-driven apps. It's either a matter of running such a simple tool... or some deep-dive SQL rewriting. 😛

[Sin_Stalker]

I don't think that would work. It has been the upgrading the database to 1.37 which has been getting the errors. 

[Sin_Stalker]

2 hours ago, Shenanigunner said:

See if MediaWiki has an update utility, or if someone has written one. I know they exist for most other database-driven apps. It's either a matter of running such a simple tool... or some deep-dive SQL rewriting. 😛

 

Either I am not following what you are saying to do, or it isn't working. The wiki breaks once I import the old database.

[Sin_Stalker]

Actually, it may have worked. I just cant seem to log in.

 

Edited February 2, 2022 by Sin_Stalker

[Shenanigunner]

 

These installations are simple IF everything is in step. For each version of MW (and WordPress, and the like) the version, the support software (PHP version, mostly) and the database structure have to match. IIRC, I had a bear of a time with one update to my MW installation because there was a change to the database structure.

 

A clean, on-time update will do all these things for you, but if you miss a major revision or let the site 'rot' a while, it can be a bitch.

 

I think the problem is that you database is out of sync with what the newer versions of the platform want, even though it's importing it.

 

Try this: clean it all out. Find and install the last version of MW you had working. (You will probably have to change host settings to older versions of PHP, etc.) Import your database... and with luck, it will all work.

 

Then IMMEDIATELY start the update process. Read the change notes, update PHP etc., do database conversions, etc. until it's all both working and up to date.

 

No other way without some deep code/PHP/host skilz. (Even I'm shaky on those.)