Bug Tracker item #2990523, was opened at 2010-04-21 19:47 Message generated for change (Comment added) made by sbajic You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2990523&group_id=250683
Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: contrib/thunderbird Group: v3.9.0 Status: Open Resolution: None Priority: 5 Private: No Submitted By: interfaSys () >Assigned to: Stevan Bajic (sbajic) Summary: Issue with SQL purge script Initial Comment: I tried the following command /usr/local/bin/dspam_maintenance.sh --logdays=30 --signatures=30 --unused=60 --with-sql-optimization --with-sql-autoupdate --verbose But it looks like the purge script is having problems Running MySQL storage driver data cleanup ERROR 1271 (HY000) at line 59: Illegal mix of collations for operation ' IN ' MySQL purge script returned error code 1 I'm using MySQL 5.1 and the Dspam tables are using InnoDB ---------------------------------------------------------------------- >Comment By: Stevan Bajic (sbajic) Date: 2010-04-21 20:01 Message: Hallo Oliver, can you post here the output you get when executing the following command in a MySQL shell: ---------------------------- show create table dspam_preferences\G; show create table dspam_signature_data\G; show create table dspam_stats\G; show create table dspam_token_data\G; show create table dspam_virtual_uids\G; ---------------------------- Could you as well try to run once without "--with-sql-autoupdate"? Do you get the error then as well? And how about without "--with-sql-optimization" and without "--with-sql-autoupdate"? Do you get the error then as well? Stevan ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=2990523&group_id=250683 ------------------------------------------------------------------------------ _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
