WBB4 -> WSC5 Import Error on User Groups

AndroidOS · April 26, 2023 at 6:12 PM

Hi all,

Currently trying to upgrade a WBB4 forum to WSC5, and I'm getting the following error when importing user groups:

Code

wcf\system\exception\ErrorException: Attempt to read property "groupID" on null in /var/www/site/forums/wsc/lib/system/WCF.class.php:341
Stack trace:
#0 /var/www/site/forums/wsc/lib/system/importer/UserGroupImporter.class.php(31): wcf\system\WCF::handleError()
#1 /var/www/site/forums/wsc/lib/system/exporter/WBB4xExporter.class.php(550): wcf\system\importer\UserGroupImporter->import()
#2 /var/www/site/forums/wsc/lib/system/exporter/AbstractExporter.class.php(175): wcf\system\exporter\WBB4xExporter->exportUserGroups()
#3 /var/www/siteforums/wsc/lib/system/worker/ImportWorker.class.php(140): wcf\system\exporter\AbstractExporter->exportData()
#4 /var/www/site/forums/wsc/lib/system/cli/command/WorkerCLICommand.class.php(160): wcf\system\worker\ImportWorker->execute()
#5 /var/www/site/forums/wsc/lib/system/cli/command/ImportCLICommand.class.php(193): wcf\system\cli\command\WorkerCLICommand->execute()
#6 /var/www/site/forums/wsc/lib/system/CLIWCF.class.php(336): wcf\system\cli\command\ImportCLICommand->execute()
#7 /var/www/site/forums/wsc/lib/system/CLIWCF.class.php(94): wcf\system\CLIWCF->initCommands()
#8 /var/www/site/forums/wsc/cli.php(21): wcf\system\CLIWCF->__construct()
#9 {main}

Display More

Not too sure what's going on here, so any help is much appreciated!

**Alexander Ebert** · April 26, 2023 at 6:20 PM Official Post

The import target is a fresh installation of the software or does it already contain data? Also, can you please check the values for wcfN_user_group.groupType in the source database, in particular look out for values that are less than 4. There should be only values in the range of 1, 2 and 3. Are there any other values present?

AndroidOS · April 26, 2023 at 9:16 PM

Thanks for the reply.

The target contains a small amount of data, but only a couple of test posts and users. Should I use a completely fresh install?

In the source table you asked for, there's one group each with 1, 2 or 3. The rest are all 4s.

**Alexander Ebert** · April 26, 2023 at 9:53 PM Official Post

Quote from AndroidOS

Should I use a completely fresh install?

No, that’s fine. Keep in mind that you need to wipe any test data before performing the actual import, otherwise all IDs will get shifted. This is not really an issue for a test run though, but I would still recommend it.

Quote from AndroidOS

In the source table you asked for, there's one group each with 1, 2 or 3. The rest are all 4s.

Okay, that is perfectly fine. Can you please check the target database too? The types 1, 2 and 3 should appear exactly one, all other groups should have a value of 4 or higher.

The error message that you’ve provided pointed to a mismatch of the group ids with a type of 1, 2 or 3 which in practice should never happen. These are builtin types that are part of the software’s inner workings.

AndroidOS · April 27, 2023 at 10:22 AM

Quote from Alexander Ebert

No, that’s fine. Keep in mind that you need to wipe any test data before performing the actual import, otherwise all IDs will get shifted. This is not really an issue for a test run though, but I would still recommend it.
Okay, that is perfectly fine. Can you please check the target database too? The types 1, 2 and 3 should appear exactly one, all other groups should have a value of 4 or higher.
The error message that you’ve provided pointed to a mismatch of the group ids with a type of 1, 2 or 3 which in practice should never happen. These are builtin types that are part of the software’s inner workings.

Ah, I think that might be the problem. There are no groups of type 1, 2 or 3 in the target DB. We had an issue a couple of days ago that caused the server to unexpectedly shutdown - I'm wondering if the database got corrupted in the process.

Would it be easiest just to start again with a fresh target install?

SoftCreatR · April 27, 2023 at 10:32 AM

Quote from AndroidOS

Would it be easiest just to start again with a fresh target install?

I'd recommend it, because the database seems to be in an unknown and probably inconsistent state.

**Tim Düsterhus** · April 27, 2023 at 10:42 AM Official Post

Hi

Quote from AndroidOS

I'm wondering if the database got corrupted in the process.

Correctly handling powerloss situations is a key feature of InnoDB and from my experience InnoDB either returns the correct data or actively detects corruption and intentionally crashes the MySQL server process to avoid making things worse.

I strongly recommend you check your logs and config, this type of silent data corruption must never happen and might indicate serious issues with your hardware or file system – unless you accidentally configured InnoDB in “eat my data” mode.

AndroidOS · April 28, 2023 at 5:17 PM

Thanks all for your help so far. I think we've tracked down the original fault that led to the data corruption and system failure to a fault drive which our host really should have picked up on earlier and notified us about.

I've since performed a new import on a new, completely clean WSC5 installation. That import completed without any issues, however I'm now getting a similar error when trying to rebuild the data (specifically, the post data).

Code

wcf\system\exception\ErrorException: Attempt to read property "groupType" on null in /var/www/new/forums/wsc/lib/system/WCF.class.php:341
Stack trace:
#0 /var/www/new/forums/wsc/lib/system/cache/builder/UserGroupPermissionCacheBuilder.class.php(76): wcf\system\WCF::handleError()
#1 /var/www/new/forums/wsc/lib/system/cache/builder/AbstractCacheBuilder.class.php(42): wcf\system\cache\builder\UserGroupPermissionCacheBuilder->rebuild()
#2 /var/www/new/forums/wsc/lib/system/worker/AbstractRebuildDataWorker.class.php(148): wcf\system\cache\builder\AbstractCacheBuilder->getData()
#3 /var/www/new/forums/lib/system/worker/PostRebuildDataWorker.class.php(156): wcf\system\worker\AbstractRebuildDataWorker->getBulkUserPermissions()
#4 /var/www/new/forums/wsc/lib/system/cli/command/WorkerCLICommand.class.php(160): wbb\system\worker\PostRebuildDataWorker->execute()
#5 /var/www/new/forums/wsc/lib/system/CLIWCF.class.php(336): wcf\system\cli\command\WorkerCLICommand->execute()
#6 /var/www/new/forums/wsc/lib/system/CLIWCF.class.php(94): wcf\system\CLIWCF->initCommands()
#7 /var/www/new/forums/wsc/cli.php(21): wcf\system\CLIWCF->__construct()
#8 {main}

Display More

I've already performed the same check Alexander suggested earlier - in the target DB (which now contains all of the imported data), there is one group each of 1, 2, 3 and 9. The rest are all 4s.

I'm unsure what could have gone wrong here - I believe I've done everything "by the book", and as I said there were no errors at all during the import process. Any help is much appreciated!

**Alexander Ebert** · April 28, 2023 at 6:08 PM Official Post

That’s odd, you shouldn’t be running into this issue in the latest release of 5.5.

It is caused by a cache issue with the CLI environment and does not imply any data corruption. You can reset the cache once through the admin panel and then start php cli.php again.

WBB4 -> WSC5 Import Error on User Groups

Participate now!

Similar Threads

Update: WoltLab Suite 5.5.6 / 5.4.24 / 5.3.25