Hi Thomas, I’m using Mysqli. Regards Ralf

Hi Thomas, I don’t find it! Here my Config: ; <?php exit; ?> DO NOT REMOVE THIS LINE ; file automatically generated or modified by Matomo; you can manually override the default values in global.ini.php by redefining them in this file. [database] host = "mysql.localhost" username = „xxxxxxx" password = "xxxxxxx" dbname = "xxxxxxx" tables_prefix = "piwik_" adapter = "MYSQLI" [General] assume_secure_protocol = 1 proxy_client_headers[] = "HTTP_X_FORWARDED_FOR" salt = „xxxxxxxxxxx" trusted_hosts[] = "www.wavelogo.de" force_ssl = 1 [PluginsInstalled] PluginsInstalled[] = "Diagnostics" PluginsInstalled[] = "Login" PluginsInstalled[] = "CoreAdminHome" PluginsInstalled[] = "UsersManager" PluginsInstalled[] = "SitesManager" PluginsInstalled[] = "Installation" PluginsInstalled[] = "Monolog" PluginsInstalled[] = "Intl" PluginsInstalled[] = "CorePluginsAdmin" PluginsInstalled[] = "CoreHome" PluginsInstalled[] = "WebsiteMeasurable" PluginsInstalled[] = "IntranetMeasurable" PluginsInstalled[] = "CoreVisualizations" PluginsInstalled[] = "Proxy" PluginsInstalled[] = "API" PluginsInstalled[] = "ExamplePlugin" PluginsInstalled[] = "Widgetize" PluginsInstalled[] = "Transitions" PluginsInstalled[] = "LanguagesManager" PluginsInstalled[] = "Actions" PluginsInstalled[] = "Dashboard" PluginsInstalled[] = "MultiSites" PluginsInstalled[] = "Referrers" PluginsInstalled[] = "UserLanguage" PluginsInstalled[] = "DevicesDetection" PluginsInstalled[] = "Goals" PluginsInstalled[] = "Ecommerce" PluginsInstalled[] = "SEO" PluginsInstalled[] = "Events" PluginsInstalled[] = "UserCountry" PluginsInstalled[] = "GeoIp2" PluginsInstalled[] = "VisitsSummary" PluginsInstalled[] = "VisitFrequency" PluginsInstalled[] = "VisitTime" PluginsInstalled[] = "VisitorInterest" PluginsInstalled[] = "ExampleAPI" PluginsInstalled[] = "RssWidget" PluginsInstalled[] = "Feedback" PluginsInstalled[] = "TwoFactorAuth" PluginsInstalled[] = "CoreUpdater" PluginsInstalled[] = "CoreConsole" PluginsInstalled[] = "ScheduledReports" PluginsInstalled[] = "UserCountryMap" PluginsInstalled[] = "Live" PluginsInstalled[] = "CustomVariables" PluginsInstalled[] = "PrivacyManager" PluginsInstalled[] = "ImageGraph" PluginsInstalled[] = "Annotations" PluginsInstalled[] = "MobileMessaging" PluginsInstalled[] = "Overlay" PluginsInstalled[] = "SegmentEditor" PluginsInstalled[] = "Insights" PluginsInstalled[] = "Morpheus" PluginsInstalled[] = "Contents" PluginsInstalled[] = "BulkTracking" PluginsInstalled[] = "Resolution" PluginsInstalled[] = "DevicePlugins" PluginsInstalled[] = "Heartbeat" PluginsInstalled[] = "Marketplace" PluginsInstalled[] = "ProfessionalServices" PluginsInstalled[] = "UserId" PluginsInstalled[] = "CustomPiwikJs" PluginsInstalled[] = "Tour"

Hi Thomas, this is the line in my Mysqli.php: $_isConnected = @mysqli_real_connect( $this->_connection, $this->_config['host'], $this->_config['username'], $this->_config['password'], $this->_config['dbname'], $port, $socket = null, $enable_ssl ? $flags : null ); should I change to: $socket = !empty($this->_config['unix_socket']) ? $this->_config['unix_socket'] : null; // Suppress connection warnings here. // Throw an exception instead. $_isConnected = @mysqli_real_connect( $this->_connection, $this->_config['host'], $this->_config['username'], $this->_config['password'], $this->_config['dbname'], $port, $socket = null, $socket, $enable_ssl ? $flags : null ); I will have not really time the next days to check this, because I have o install a dummy version with 3.12. with a copy of the database because downgrading I need to change back some parameters in Database. Now It’s working fine after downgrading to 3.11.! Perhaps beginning of next week I can check this out! Thanks Ralf

Hi Thomas, so success. I tried with a upgrade to 3.13. with a dummy database….get the das error: Access denied for user ‘dbxxxxxx’@’%’ to database ‘dbxxxxxx’ - in plugin Goals It’s only working with version 13.11. after upgrade not…. Have a nice Day Ralf

Hi Thomas, this is confusing me. You wrote "@Solaris42 <https://github.com/Solaris42> I'm quite certain this is due to missing 'create temporary table' permission on your mysql user. Have a look at #15237 <#15237>“ But this feature will be removed soon from MySQL….. I contact my web host to get the information about the mysql permission. As I understand matomo changed the database handling with update to 3.12.? Because with version 3.11. all is working well. If not, my logic tell me, its seems to be a bug…... Regards Ralf

Hi Thomas, so my web host changed this database setup to 'create temporary table' permission on your mysql user. It’s not standard setup. But since this change all is working fine! So perhaps you shout give more clear informations about such deep changes in future. Usually I trust blind the updates… But anyway , it’s working now! Thanks for your help! Ralf