TLDR; what’s the SQL statement which Matomo 4 uses to create the “matomo_custom_dimensions” table?
Windows command prompt crashed while upgrading Matomo 3.14.1 to 4.4.1 via “console core:update”.
Running “console core:update” again successfully completed the upgrade, but I now have a missing table for the “CustomDimensions” plugin which causes the following error in the Web UI:
An exception has been thrown during the rendering of a template (“SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘matomo4.matomo_custom_dimensions’ doesn’t exist”).
in D:\Websites\matomo4\plugins\CoreHome\templates\getDefaultIndexView.twig line 7
I have deactivated the “CustomDimensions” plugin in the meantime. Re-activating it does not create the table, so I need to obtain the SQL command needed to do so.