Bug Tracker item #3299508, was opened at 2011-05-09 17:24 Message generated for change (Comment added) made by matamoros You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3299508&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: None Group: v3.9.1 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Colin Brace (matamoros) Assigned to: Nobody/Anonymous (nobody) Summary: db init scripts broken with MySQL v5.5 Initial Comment: With MySQL 5.5, the scripts in /usr/local/share/examples/dspam/mysql/mysql_objects are broken. For example: /usr/local/share/examples/dspam/mysql]# mysql -uroot -p********* dspam < mysql_objects-4.1.sql ERROR 1064 (42000) at line 3: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=MyISAM PACK_KEYS=1' at line ---------------------------------------------------------------------- >Comment By: Colin Brace (matamoros) Date: 2011-05-09 22:12 Message: The fix turned out to be straightforward. These three files work with MySQL v5.5. ---------------------------------------------------------------------- Comment By: Colin Brace (matamoros) Date: 2011-05-09 20:52 Message: I posted a query about this issue on the forum at mysql.com. Perhaps someone there will help us out. http://forums.mysql.com/read.php?10,419192,419192 ---------------------------------------------------------------------- Comment By: Colin Brace (matamoros) Date: 2011-05-09 20:20 Message: I don't know enough about MySQL to be able to fix on my own, but I would be happy to ask around in various fora to see if some MySQL guru knows how to fix this. If I have any success, I will report back. ---------------------------------------------------------------------- Comment By: Stevan Bajic (sbajic) Date: 2011-05-09 17:39 Message: Thanks for the error report. Since I don't have MySQL >= 5.5 ... would it be possible for you to participate in the DSPAM COMMUNITY project and submit a proper SQL file for MySQL >= 5.5? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1126467&aid=3299508&group_id=250683 ------------------------------------------------------------------------------ WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd _______________________________________________ Dspam-devel mailing list Dspam-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-devel
