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. -- 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
