Hello, -----Ursprüngliche Nachricht----- From: Stevan Bajić Sent: Monday, May 09, 2011 10:05 AM To: dspam-user@lists.sourceforge.net Subject: Re: [Dspam-user] mysql error initializing database
On Sun, 08 May 2011 15:33:53 +0200, Colin Brace wrote: > Hi all, > Hello, > I have installed v3.9.0 under FreeBSD with MySQL v5.5.11 > > Initializing the database, I get a MySQL error: > > /usr/local/share/examples/dspam/mysql]# mysql -uroot -pxxxxxxxxx > 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 7. > > Anyone have any idea what is going wrong here? > some of the SQL commands used in DSPAM are NOT working with >= MySQL 5.5.0 Think I've found a solution: http://bugs.mysql.com/bug.php?id=59288 replace TYPE with ENGINE in the sql scripts. But I don't have any Mysql 5.5 at time, so I can not test it :( ------------------------------------------------------------------------------ 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-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
