I looked at thread :
viewtopic.php?f=13&t=2290&p=9587&hilit= ... wing#p9587
So I tried :
[root@~]# wget
https://raw.githubusercontent.com/mailw ... pgrade.php
[root@~]# sudo /usr/bin/php ./upgrade.php
MailWatch for MailScanner Database Upgrade to 1.2.3-dev
Have you done a full backup of your database? Type 'yes' to continue: yes
Testing connectivity to the database ................................. OK
Updating database schema:
- Convert database to utf8........................................... OK
- Drop `geoip_country` table......................................... ALREADY DROPPED
- Drop `spamscores` table............................................ ALREADY DROPPED
- Add autorelease table to `mailscanner` database.................... ALREADY EXIST
- Add mtalog_ids table to `mailscanner` database..................... ALREADY EXIST
- Add resetid, resetexpire and lastreset fields in `users` table..... ALREADY EXIST
- Add login_expiry and login_timeout fields in `users` table......... ALREADY EXIST
- Fix schema for username field in `audit_log` table................. OK
- Fix schema for id field in `blacklist` table....................... OK
- Fix schema for username field in `users` table..................... OK
- Fix schema for spamscore field in `users` table.................... OK
- Fix schema for highspamscore field in `users` table................ OK
- Fix schema for username field in `user_filters` table.............. OK
- Fix schema for username field in `whitelist` table................. OK
- Fix schema for timestamp field in `maillog` table.................. OK
- Fix schema for username field in `audit_log` table................. OK
- Fix schema for password field in `users` table..................... OK
- Fix schema for fullname field in `users` table..................... OK
- Fix schema for rule_desc field in `mcp_rules` table................ OK
- Cleanup orphaned user_filters...................................... ERROR
Database error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' - SQL = 'DELETE FROM `user_filters` WHERE `username` NOT IN (SELECT `username` FROM `users`)'
I get the above error ?