Table doesn't exist

[fretzl]

Hi @linc, thanks for sharing this tool!

Trying to migrate Vanilla 3.3 (2021.012) to Flarum.
Managed to fix some database issues myself but now I'm stuck on a missing vanilla.gdn_userbadge table.
Indeed there's no such table present and I can't remember ever seeing one.
Any ideas ?
Thanks

Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'vanilla.gdn_userbadge' doesn't exist in /Applications/MAMP/htdocs/nitro-porter/src/Database/PdoDB.php:49 
Stack trace: 
#0 /Applications/MAMP/htdocs/nitro-porter/src/Database/PdoDB.php(49): PDO->query('select * from G...') 
#1 /Applications/MAMP/htdocs/nitro-porter/src/ExportModel.php(661): Porter\Database\PdoDB->query('select * from G...') 
#2 /Applications/MAMP/htdocs/nitro-porter/src/ExportModel.php(216): Porter\ExportModel->executeQuery('select * from G...') 
#3 /Applications/MAMP/htdocs/nitro-porter/src/Source/Vanilla2.php(97): Porter\ExportModel->export('UserBadge', 'select * from :...') 
#4 /Applications/MAMP/htdocs/nitro-porter/src/Source/Vanilla2.php(81): Porter\Source\Vanilla2->badges(Object(Porter\ExportModel)) 
#5 /Applications/MAMP/htdocs/nitro-porter/src/Controller.php(29): Porter\Source\Vanilla2->run(Object(Porter\ExportModel)) 
#6 /Applications/MAMP/htdocs/nitro-porter/src/Controller.php(118): Porter\Controller::doExport(Object(Porter\Source\Vanilla2), Object(Porter\ExportModel)) 
#7 /Applications/MAMP/htdocs/nitro-porter/index.php(12): Porter\Controller::run(Object(Porter\Request)) 
#8 {main} thrown in /Applications/MAMP/htdocs/nitro-porter/src/Database/PdoDB.php on line 49```

[linc]

@fretzl Were you using the YAGA plugin? Do you have a gdn_badge table?

[fretzl]

Thanks for responding @linc.
YAGA has not been used recently. It's not even present in the plugins or applications folder. I guess YAGA has been tried once when starting with Vanilla because there are still YAGA settings in the config.
Yes, I do have a GDN_Badge table.
FYI: this database started with bbPress (WP) in 2007 and was migrated to Vanilla in 2017. Now, due to Vanilla's development we're looking at Flarum.

[linc]

The code is looking for the existence of GDN_Badge as confirmation ALL badge features exist, which is why it's expecting GDN_UserBadge. I'll add a check for this edge case, but in the meantime renaming or deleting that table would fix your issue.

[fretzl]

Thank you so much! That got me going again :-)
Had to make some more database repairs and voilà, I have a forum again.