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
This is a weird regression. The MySQL docs says BOOL/BOOLEAN is a synonym for TINYINT(1), and TRUE and FALSE are aliases for 1 and 0, respectively. Also, looking at Piwik's schema, visitor returning is "TINYINT(1) NOT NULL". I would have expected PHP's type conversion to yield 1 for true.
<?php var_dump( true == 1);
Well... I'm ok with the change. I assume other TINYINT columns are affected?
/core/Tracker/Db/Pdo/Mysql.php#L170 with out of the box MySQL 5.5.9 throws
This happens because $parameters(3) is a bool variable and 'visitor_returning' is a tinyint(1) field.
One of the places this value is set is in /core/Tracker/Visit.php#L437.
Updating
to
suppresses the exception and confirms the issue.
What is the best way to go from here ?
The text was updated successfully, but these errors were encountered: