On Mon, 9 May 2011 21:08:19 +0200 Sebastian Töpfer <sebastian.toep...@onlinehome.de> wrote:
> Hello, > Hello Sebastian, > -----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. > hmmm... I usually use ENGINE all the time. Don't know why this TYPE is there? Anyway.... from my experience I know that ENGINE works since loooooong time. So changing everything to ENGINE instead of TYPE is easy. Will just do that right now. > But I don't have any Mysql 5.5 at time, so I can not test it :( > Me neither and I am lazy to install now somewhere a 5.5.x version :) > > > ------------------------------------------------------------------------------ > 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 ------------------------------------------------------------------------------ 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
