Page MenuHomeMiraheze

Cargo table errors
Closed, ResolvedPublic

Description

My wiki is https://umbranet.miraheze.org/wiki/Main_Page.

I've recently been getting errors with the Cargo extension.

On https://umbranet.miraheze.org/wiki/Special:CargoTables, I get the following error:

Internal error
[8572bfd5b26f306eabaeeee4] 2021-07-06 02:16:07: Fatal exception of type "Error"

On https://umbranet.miraheze.org/wiki/Special:CargoTables/Missions, I get the following error:

Database error
A database query error has occurred. This may indicate a bug in the software.
[2312da2dec79f6073f8759bb] 2021-07-06 02:16:57: Fatal exception of type "Wikimedia\Rdbms\DBQueryError"

For the second, I found this: https://www.mediawiki.org/wiki/Topic:U26n1a1pgo0078tt which indicated a need to run updatephp. I'm not sure how to do that, however.

Event Timeline

One of the issues is due to a bug with PageForms. It has been fixed upstream on master but not REL1_36. We will likely move back to master.

@Dtietze It looks like you disabled the Cargo extension?

Yes. I'm testing with some users if we can go forward without it since it's bugged.

Yes. I'm testing with some users if we can go forward without it since it's bugged.

Unfortunately since the issue is only on your wiki, we can't debug or fix the error unless it's enabled.

My mistake. I re enabled it. Sorry. I misunderstood where the issue was.

Error 1054: Unknown column 'Mission_Number' in 'field list' (db12.miraheze.org)
Function: CargoSQLQuery::run
Query: SELECT  `_pageName` AS `Page`,`Mission_Number` AS `Mission Number`,`Game_Master` AS `Game Master`,`Johnson` AS `Johnson`,`Objective` AS `Objective`,`Difficulty` AS `Difficulty`,`Information` AS `Information`,`Payout` AS `Payout`,`Character_Rating` AS `Character Rating`,`Runners__full` AS `Runners`,`Related_Events__full` AS `Related Events`  FROM `cargo__Missions`     ORDER BY `_pageName`,`Mission_Number`,`Game_Master`,`Johnson`,`Objective` LIMIT 100

It seems cargo__Missions is completely empty in the database. I could delete the cargo table if you want? But other then that I am not sure what we can do.

cargoRecreateData.php:

Table "Missions" is not declared in any template; skipping.
> SELECT * FROM cargo__Missions;
Query OK, 0 row(s) affected

Both indicate the table is empty, so deleting it will likely not have any negative effect, but I can not 100% guarantee that. Please let me know how you want to proceed. Thanks!

Universal_Omega claimed this task.

No response. Please re-open if you still wish this to be fixed, and if I can delete the table as mentioned above.

Thank you. Please delete the cargo tables and I can re-add them.

Thank you. Please delete the cargo tables and I can re-add them.

Thank you for you response. I will do that hopefully shortly (within the next two days probably)

I've deleted the two malfunctioning Cargo tables, so you should now be able to re-create them. Please feel free to reopen this task if you encounter any additional issues.

I've deleted the two malfunctioning Cargo tables, so you should now be able to re-create them. Please feel free to reopen this task if you encounter any additional issues.

Thank you for doing that. I apologize for my delay.