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
mattab opened this issue
Jul 20, 2008
· 3 comments
Labels
BugFor errors / faults / flaws / inconsistencies etc.MajorIndicates the severity or impact or benefit of an issue is much higher than normal but not critical.
I get the following error on the piwik.php logging script:
```
Uncaught exception: ‘Error query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (ascii_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation ’=’’
More information
In /Users/netmon/Sites/piwik/modules/LogStats/Db.php on line 201
Backtrace:
(In 1011) – fixed #310 When database collation is not the default, mysql error “Illegal mix of collations”
now all tables are created with utf8 charset
(In 1014) – cleaning up the search engine parsing code, adding tests, recording UTF8 keywords in the DB rather than encoded (as tables are now utf8, refs #5730)
- adding tests in url.test.php and fixed double encoding in some edge cases
- fixed #589 Piwik fails to properly decode and store some chinese keywords (eg. from baidu.com)
- fixed #435 Exotic encoded keywords should be stored as utf-8 in the DB
- refs #575 hopefully fixed, will give it a few days of tests on piwik.org
BugFor errors / faults / flaws / inconsistencies etc.MajorIndicates the severity or impact or benefit of an issue is much higher than normal but not critical.
I am using us_ascii as the default character set.
I get the following error on the piwik.php logging script:
```
Uncaught exception: ‘Error query: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (ascii_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation ’=’’
More information
In /Users/netmon/Sites/piwik/modules/LogStats/Db.php on line 201
Backtrace:
You can get help from http://piwik.org (give us the full error message + your PHP and Mysql version)
```
Possible solution: Create the piwik tables with a specific character set for all the application, scripts etc.
The text was updated successfully, but these errors were encountered: