We are trying to upgrade matomo from 3.14 to 4 Beta 1.
Our configuration is:
MySql: 8.0.18
PHP:7.4.1
We are trying to start the upgrade but we are getting the following error:
Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘?’ at line 1.
I went into the error and got the it is coming from core\DbHelper.php line no: 40 where it calls the mysql statement
SHOW TABLES LIKE ?
Below is the error log
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] Uncaught exception: C:\inetpub\wwwroot\matomo-4.0.0-b3\libs\Zend\Db\Statement\Mysqli.php(77): Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] Mysqli prepare error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?' at line 1
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] #0 C:\inetpub\wwwroot\matomo-4.0.0-b3\libs\Zend\Db\Statement.php(115): Zend_Db_Statement_Mysqli->_prepare()
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] #1 C:\inetpub\wwwroot\matomo-4.0.0-b3\libs\Zend\Db\Adapter\Mysqli.php(419): Zend_Db_Statement->__construct()
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] #2 C:\inetpub\wwwroot\matomo-4.0.0-b3\libs\Zend\Db\Adapter\Abstract.php(478): Zend_Db_Adapter_Mysqli->prepare()
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] #3 C:\inetpub\wwwroot\matomo-4.0.0-b3\core\DbHelper.php(40): Zend_Db_Adapter_Abstract->query()
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] #4 C:\inetpub\wwwroot\matomo-4.0.0-b3\plugins\Login\Auth.php(68): Piwik\DbHelper::tableExists()
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] #5 C:\inetpub\wwwroot\matomo-4.0.0-b3\core\Access.php(187): Piwik\Plugins\Login\Auth->authenticate()
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] #6 C:\inetpub\wwwroot\matomo-4.0.0-b3\core\FrontController.php(405): Piwik\Access->reloadAccess()
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] #7 C:\inetpub\wwwroot\matomo-4.0.0-b3\core\dispatch.php(31): Piwik\FrontController->init()
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] #8 C:\inetpub\wwwroot\matomo-4.0.0-b3\index.php(25): require_once('C:\\inetpub\\wwwr...')
ERROR Piwik\ExceptionHandler[2020-10-16 10:52:25 UTC] [60bf3] #9 {main}