You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When a Mysql user does not have PROCESS privilege, when a DB error occurs, Piwik will trigger another exception and original exception message is hidden.
Following error can be triggered:
SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
For example during archiving:
Error: Got invalid response from API request: http://example.com/index.php?module=API&method=API.get&idSite=3&period=day&date=last2&format=php&token_auth=removed&segment=entryPageUrl%3D%3Dhttp%253A%252F%252Fwww.x4&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:141:"SQLSTATE[42000]: Syntax error or access violation: 1227 Access denied; you need (at least one of) the PROCESS privilege(s) for this operation";}
When a Mysql user does not have
PROCESS
privilege, when a DB error occurs, Piwik will trigger another exception and original exception message is hidden.Following error can be triggered:
For example during archiving:
It's triggered here: https://github.com/piwik/piwik/blob/2.15.0-b14/core/Db.php#L709-L718
Steps:
SHOW ENGINE
returns an exception 1227 (or maybe any), and catch it and don't display this error but bubble original exception.The text was updated successfully, but these errors were encountered: