On Mon, 9 May 2011 17:02:11 -0700 Bradley Giesbrecht <bradley.giesbre...@gmail.com> wrote:
> > On May 9, 2011, at 1:57 PM, Stevan Bajić wrote: > > > 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 :) > > This is just a create database script, right? > > Tonight I will install mysql 5.5, replace "type" with "engine" and load the > mysql_objects-4.1.sql script. > Better would be to try the latest GIT or use the files from here: http://dspam.git.sourceforge.net/git/gitweb.cgi?p=dspam/dspam;a=tree;f=src/tools.mysql_drv;hb=HEAD > -- > Brad ------------------------------------------------------------------------------ Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Dspam-user mailing list Dspam-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspam-user
